There is a companion piece to this one that makes the case for why a customer is a stream, not a job, and why that number should drive your ad budget. This guide is the other half: how to actually work it out from your own numbers. If you have already pulled your sales history, you have everything you need.

Do not have the file yet? Start with how to export your sales history from your CRM, then come back here.

Step 1: group by the type of customer, not the customer

Open your export and sort it by the plan or work code. You are not trying to rank individual customers. You are trying to see what each kind of customer is worth: quarterly general pest, mosquito, termite renewal, one-time rodent, and so on. Each of those is really a different little business wearing the same logo, and they behave nothing alike.

This is why the service-line grain matters so much when you pull the file. If your services are bundled into one combined line, you cannot make these groups, and the rest of the exercise falls apart.

Step 2: work out value for each group

Lifetime value is not complicated math. For each group, it is three numbers:

  • Average revenue per year from a customer of that type
  • How many years that kind of customer tends to stay (this is why you pulled two to three years, so renewals and churn are visible)
  • Minus what it costs to serve them

Multiply the first two, subtract the third, and you have a real value per group. When you do it, the spread is almost always bigger than owners expect. A recurring quarterly customer who renews for years and a one-time job that never comes back are not close. One funds your next decade. The other pays this month's fuel bill.

Step 3: grade it on real paying customers

One rule keeps this clean: count customers who actually booked and paid, not clicks or leads or form fills. Your CRM already knows who paid and stayed, which is exactly why it is the right source. A lead that never converted is worth nothing, and a cheap lead that churned in one season can be worth less than nothing once you count the cost to serve it. Value is measured on the money that landed and stuck, not on activity at the top of the funnel.

Step 4: break it down by area

Here is the part almost nobody does. Run the same math by ZIP. Two areas that look identical on a map can produce customers worth very different amounts, because one renews and refers and the other churns after the first season. Same service, same truck, same price, very different value.

Once you can see value by area, your map stops being a coverage map and becomes a spending map. You put dollars where the valuable customers cluster and pull back where they do not. That single move usually does more for growth than any change to the ads themselves.

What you do with the answer

The point of all this is not a tidy spreadsheet. It is to change the question you ask. It stops being "how do I spend less on marketing" and becomes "how much can I profitably spend to win more of the customers who are actually worth it." That is a growth question, and it is the right one. You do not need to spend less. You need to spend on purpose, and now you can, because you know what a customer is worth by service and by area.