Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.
Closed-won customer export with clean revenue figures
Every argument about the ideal customer ends in opinion unless someone has the real list of who paid, how much and for how long. Pulling every closed-won customer from the CRM and the billing system into one sheet, with first deal value, current annual revenue, start date and any churn date, gives you the evidence base the rest of this area depends on.
First tasks
- Export all closed-won deals from the CRM for the last three years
- Pull invoice totals and cancellation dates from the billing system
- Merge the two exports into one row per customer account
- Ask finance to check the revenue total against their own figure
Ten best customers you would clone
Ask a sales team to describe its ideal customer and you usually get the biggest logo or the friendliest contact. Ranking customers on three plain measures, deal size, speed to close and how long they stayed, and picking the ten that score well on all three gives a short list you can study in detail instead of arguing in general.
First tasks
- Add sales cycle days and tenure in months to the customer sheet
- Rank customers separately on revenue, cycle length and tenure
- Combine the three ranks and mark the top ten accounts
- Ask support or delivery which of the ten are easiest to serve
Firmographic pattern in the best accounts
Once the top ten are known, the question is what they share that you could search for: industry, headcount, revenue band, region, ownership model and growth stage. Coding those attributes for the best customers and for everyone else shows which traits genuinely separate winners from the average and which are coincidence.
First tasks
- Add columns for industry, headcount band, revenue band, region and ownership
- Fill the columns from company websites and public company registries
- Count how often each value appears in the top ten and in the rest
- Highlight the traits at least twice as common among the best accounts