Customer activation scoring

The problem

Customer exports mixed usage, payment flags, and contact information. A useful prioritization model needed to keep those meanings separate and preserve missing evidence.

My contribution

• Designed explicit scoring components for observed usage, dated intent, and reported role.
• Created deterministic ranks and review groups while retaining original records.
• Kept consumption separate from payment and contact availability separate from permission to contact.

Evidence & scope

Reconciled source and output counts, compared original fields row by row, and checked score bounds, arithmetic, unique identities, and ordering.

What came out of it

Turned a large customer dataset into clear review priorities, with traceable scoring rules and source fields preserved.

Delivered scored datasets and a documented decision model. Scores remained evidence-based review priorities rather than an automatic declaration of sales readiness.