Geo waste hides in your pincode map (stop paying for RTO)
Chinmay Raibagkar · has cut spend and grown deliveries🗺️ with a delivered-CAC overlay, not a lecturePublished September 6, 2026
The 60-second version
- Click geography flatters; cheap CPCs hide 2–3x RTO rates that erase the entire click-cost advantage.
- Delivered CAC is the only ranking: spend divided by delivered-paid orders per region — everything else is commentary.
- The fix: exclude, restrict, fix, or expand per geo — then re-audit quarterly before stale exclusions rot.
Two states deliver 40% of your orders at 28% of your ad spend. Six others consume 35% of spend for 9% of delivered revenue — and three of those six are not even serviceable at your promised timelines. Nobody chose this allocation; it accreted, state by state, because geo reports show clicks while the delivery failures happen in a different system nobody joined to the ads.
Geo waste is spend directed at places structurally unlikely to convert into delivered, paid revenue: unserviceable pincodes, COD-refusal clusters, regions with chronic courier failure. clicks lie, deliveries don't This post overlays delivery reality on geo performance and builds the exclusion list.
Clicks are not delivered orders
The Geo Overlay
Data JourneyAd platform geo
Where impressions served and clicks happened. Looks efficient in states with cheap clicks — the classic trap.
Delivery reality
Where orders actually deliver and pay. Cheap-click regions often carry 2–3x the RTO rate, erasing the CPC advantage.
Delivered CAC by geo
Spend divided by delivered-paid orders per region. The only geo metric that decides budgets — everything else is commentary.
Delivered CAC per geo is the entire method in one ratio:
Geo delivered CAC = Geo ad spend ÷ Geo delivered-paid orders
A state with half the CPC and triple the RTO rate is not cheap traffic — it is expensive failure subsidised by cheap clicks. The overlay exists to make that arithmetic unavoidable.
Clicks look cheap
Platform geo shows impressions and clicks. Cheap-CPC states look efficient — the classic trap, measured before delivery exists.
Deliveries tell truth
RTO, refusal, and service gaps live in another system. Cheap-click regions often carry 2–3x the RTO rate.
Delivered CAC decides
Spend divided by delivered-paid orders per region. The only geo ranking that moves budgets — the rest is commentary.
Optimise geos on delivered outcomes, never on click costs. CPC, CTR and even conversion rate (order-placed) all flatter regions where orders are placed lightly and refused heavily. Only delivered-paid orders clear the bar — the RTO post's core lesson, applied per pincode.
🖱️ Click geography
Looks efficient where clicks are cheap. CPC, CTR, even order-placed rate all flatter regions that refuse heavily.
- Bihar: ₹11 CPC, great CTR
- Spend flows to cheap clicks
- Failures invisible here
📦 Delivery geography
Ranks by what survived. Cheap-click regions carry 2–3x RTO — the CPC advantage reverses on delivery.
- Bihar: 41% RTO vs 19% average
- 3.1x the delivered CAC
- This ranking moves budgets
Building the overlay in SQL
Three states, three verdicts
Twice the average cost per delivered order. Restrict to prepaid or higher minimums first.
Exclude, restrict, fix, expand
Four Geo Verdicts
Reporting HierarchyExclude
Structurally unprofitable: unserviceable, fraud-heavy, or RTO rates no margin survives. Geo exclusion in platforms; pincode block at checkout.
Restrict
Profitable under conditions: prepaid-only, higher minimum order value, longer promise dates. Keep the revenue, shed the failure mode.
Fix operations
Mid-tier geos where logistics (partner coverage, COD limits, confirmation calls) moves RTO materially. A courier problem wearing a media mask.
Expand
Low delivered CAC with headroom: raise budgets, localise creative, extend service promises. Growth capital goes here first.
Exclusions decay. Logistics coverage expands, RTO patterns migrate, new courier partners change the map. Review the exclusion list quarterly against fresh overlay data — a pincode excluded in January can be your cheapest growth by October. Stale exclusions are just waste with the sign flipped.
Quarterly Geo Review
Process FlowRefresh the overlay on 60 matured days
Delivered outcomes need RTO maturity — 60 days ending 2+ weeks ago. Fresh-window geo reads misrank COD-heavy regions.
Apply the four verdicts
Exclude, restrict, fix, expand — each with the delivered-CAC number that justifies it. No verdict without a number.
Push exclusions to platforms and checkout
Geo exclusions in Google/Meta plus pincode rules at checkout. Platform-only exclusion still pays for the click; checkout rules prevent the doomed order.
Re-audit last quarter's exclusions
Coverage and RTO drift. Every exclusion needs re-justification or release — waste with the sign flipped is still waste.
Ship the exclusion list without regret cheapest test first
- Rank by delivered CAC first — 60 matured days ending 2+ weeks ago, COD regions need RTO maturity.
- Exclude the structural failures — unserviceable or fraud-heavy at 3x average, no fix available.
- Restrict before you cut — prepaid-only and threshold rules keep the revenue, shed the failure mode.
- Re-audit quarterly — every exclusion needs re-justification or release.
Quick gut-check
One question on the Bihar trap. ₹11 clicks, ₹1,240 customers!
A state shows ₹11 CPC with great CTR but 41% RTO against a 19% average. Delivered CAC runs 3.1x average. Verdict?
Frequently Asked Questions
Won't excluding regions hurt brand growth and reach?
Unprofitable reach is not growth — it is subsidised failure. Excluded spend redeploys into geos with headroom, where the same rupees buy delivered customers. Track total delivered orders, not total impressions: the overlay quarter in the example grew deliveries while cutting spend.
Should this apply to lead-gen, not just D2C?
Yes, with close-rate replacing delivery: some geos produce cheap leads that never pick up the phone. Overlay sales outcomes (qualification, close) on lead geo exactly as above — junk-lead geography is the B2B twin of RTO geography.
How granular should geo go — state, city, pincode?
Decide by volume: state level for budget splits (stable, readable), city/pincode for exclusions (surgical). Pincode verdicts need hundreds of orders to be stable — aggregate sparse pincodes into courier-zone clusters rather than acting on eleven-order samples.
Summary & Next Steps
Click geography flatters; delivery geography tells the truth. Overlaying RTO and delivered outcomes on geo spend ranks every region by delivered CAC — and the bottom of that ranking is a funded growth plan wearing an exclusion list's clothes.
- Use RTO-overlaid geo to find structural waste no CPC report shows.
- Use channel CAC per geo to set region-differentiated targets.
- Use blended CAC to confirm the exclusions compound into business-level efficiency.
Takeaways for your next report
- Click geography flatters; delivery geography tells the truth — rank every region by delivered CAC.
- Cheap CPCs with 2–3x RTO are expensive failure subsidised by cheap clicks.
- Exclude, restrict, fix, or expand — each verdict needs its delivered-CAC number attached.
- Exclusions decay: re-audit quarterly or stale lists become waste with the sign flipped.
Blended CAC Calculator
Total spend across every channel, divided by total new customers — the acquisition cost number that reconciles with what you actually spent.
Chinmay Raibagkar
About author →Founder of DataLens AI. He helps non-technical teams read their ad and database numbers with confidence — which number to trust, what to do next, and what to ignore.