Plot First, Spend Second: The Last-50 Customer Map That Tightens Your Ad Radius
Photo: Gage Skidmore from Surprise, AZ, United States of America, CC BY-SA 2.0, via Wikimedia Commons
Most local businesses buy reach the way people buy gym memberships in January: broadly, optimistically, and with a vague plan to sort it out later. The ad account gets set to a whole metro. The referral ask goes out to everyone. The van drives wherever the phone rings. It feels like growth because the map is big. But a big map is not a strategy. It is usually just a more expensive way to be forgettable.
There is a cheaper corrective sitting in your transaction history. Take your last 50 customers, plot them by ZIP code or neighborhood, and look at where the pins actually land. You are not looking for a perfect circle. You are looking for the places where your business already works — and then asking why your marketing is pointed somewhere else.
Start with the list, not the software
You do not need a data team for this. Export the last 50 completed jobs or orders from your point-of-sale, booking system, or even a well-kept spreadsheet. Include the address or ZIP code, the date, the revenue, and — if you have it — how the customer found you. Add one more column: drive time from your shop or base. Not miles. Drive time. In most US metros, five miles can mean eight minutes or thirty-five, and your schedule cares about the difference.
If your last 50 customers include a few outliers from a one-off campaign or a friend-of-a-friend referral, keep them. Outliers are useful. They show you what a bad-fit job costs you in windshield time, scheduling friction, and follow-up. But do not let them set the strategy.
Put pins on a map you can actually read
Drop the addresses into Google My Maps or any mapping tool that lets you color-code pins. Color by revenue tier or service type. A $300 job and a $3,000 job should not look the same on the screen. Then draw a 10-minute drive-time shape around your base — not a perfect radius, because traffic, rivers, and highway exits do not care about geometry.
What you are looking for is density. Are there three neighborhoods that account for half the list? Is there a corridor where jobs cluster on certain days? Do your best customers live closer than your ads suggest? That cluster is your real service area. The rest of the map is not necessarily wrong. It is just not the place to start.
Compare the pins to the money
Now put your ad targeting next to the map. Open the geo settings in your ad platforms and look at the ZIP codes, cities, or radius you are paying for. If your last 50 customers are concentrated in four ZIP codes but your ads run across the entire metro, you are paying to reach people who are unlikely to become efficient customers. That is not reach. That is scatter.
The same comparison works for referrals. Pull up the last 20 referral asks you sent. Were they aimed at customers in the dense cluster, or spread across every friendly contact you have? Word of mouth travels best when it has a short distance to travel. A customer in your busiest neighborhood is more likely to know another nearby homeowner, parent, or office manager who fits the same profile. Make it easy for them to think of a neighbor, not just a contact.
Build a tighter offer around the cluster
A dense map gives you permission to make a specific offer. Not a generic discount. A route-density offer. Maybe it is Tuesday service in three ZIP codes, with a priority window and a small break on the trip charge. Maybe it is a neighborhood bundle for two nearby businesses. Maybe it is a local landing page that says, in plain language, that you serve this part of town every week.
The economics are simple: if you can serve more customers in less drive time, you can afford to be more competitive without gutting your margin. You are not cutting reach. You are trading scattershot reach for repeatable reach — the kind that lets a customer see your van twice a week and remember your name.
Retarget the ads, not just the budget
This is where founders often make the wrong move. They see the map, get nervous, and cut the ad budget by 30 percent. That can work, but it is not the first move. The first move is to narrow the geography and keep the spend steady for a test period. Point the ads at the dense cluster. Use ZIP-level targeting where the platform allows it. Build a separate campaign for the cluster instead of forcing one campaign to cover the whole metro.
Then watch cost per booked job, not cost per click. A tighter radius often raises your frequency in the areas that matter, which can improve response even as your total impressions fall. You may also find that a smaller budget in the core cluster plus a small, deliberate test outside it beats one broad campaign.
Make the route density visible to your team
A map is only useful if it changes the schedule. If your dense cluster is on the north side, your Tuesday and Thursday routes should reflect that. If you run service calls, batch them. If you deliver, set cutoffs by neighborhood. If you have a storefront, plan the referral asks and local partnerships around the streets people already travel.
This is unglamorous work. It rarely makes a good social post. But it is the kind of operational detail that quietly lowers your cost to serve while making marketing feel less like a lottery ticket.
A quarterly ritual, not a one-time project
Refresh the last-50 map every quarter. Customer patterns shift. A new housing development opens. A competitor closes. A referral source dries up. The map will tell you before your gut does.
Keep three numbers next to it: cost per booked job by cluster, average drive time, and referral rate inside the cluster. If a campaign is pulling jobs from outside the dense area but the drive time is eating the margin, you have your answer. If a small ZIP-code test is producing repeat customers, you have your next expansion.
The point is not to shrink your business. It is to stop paying for distance you do not need. Your last 50 customers have already drawn the circle. Plot them, compare the pins to your spend, and let the dense parts of the map set the next move.