Pin-Code Profiling for RTO: Which Zones Are Bleeding Your Margins?

RTO is not uniformly distributed across India, or even across a single city. It clusters. Hard. The pattern, repeated across hundreds of D2C brands: roughly 20% of pin codes generate 60% of RTO volume. The top 5 pin codes alone, in many cases, account for 40% of total losses.

If you don't know which 5 pin codes those are for your brand, this exercise takes about 20 minutes to find out.

Step 1 — Export 90 days of order + NDR data

From your shipping aggregator (Shiprocket, Pickrr, ClickPost, etc.), export the last 90 days of orders. You need at minimum:

• Order ID
• Delivery pin code
• COD or prepaid
• Final status (delivered or RTO)

If your aggregator only gives you 30 days, do 30 days. The pattern holds at any window.

Step 2 — Pivot by pin code

In Excel or Google Sheets:

• Pivot table: rows = pin code, columns = status, values = count of order ID
• Add a calculated field: RTO % = RTO count ÷ total orders
• Filter to pin codes with at least 20 orders (so you're not flagging statistical noise)
• Sort descending by RTO %

Step 3 — Find the loss leaders

You're now looking at a sorted list. The top 10 rows are usually striking:

• 5–8 pin codes with RTO above 40%
• 2–3 pin codes with RTO above 50%
• Often one outlier pin code with RTO above 60% — usually a remote zone or a new tier-3 town

Multiply RTO count × ₹200 (typical all-in RTO cost) for each. The top 5 will usually total ₹1.5–4 lakh per month, depending on your scale.

Step 4 — Decide what to do per zone

Three responses, picked per pin code:

Block COD entirely. For pin codes with RTO above 50%, the math says to refuse COD orders. Yes, you'll lose conversion. Yes, the math is still positive — you're losing money on those orders today.

Add a COD fee. ₹50 COD fee in pin codes with 35–50% RTO. Customers with high intent prepay or pay the fee. Customers without intent self-filter. Conversion drops 10–20%, RTO drops 30–40%, net result is positive.

Switch courier in zone. For pin codes with RTO 30–40%, often the issue is a single underperforming courier. Test routing the zone to a second carrier for 30 days. If RTO drops 10+ points, the courier was the problem.

Step 5 — Re-run monthly

Pin code RTO is not static. New residential developments, courier route changes, festival surge — all of these shift the picture. Re-run this exercise monthly. The list of "top 5 loss leaders" rotates more than founders expect.

The deeper fix

Pin-code profiling is a defensive tool — it stops the bleeding in your worst zones. It doesn't reduce your overall RTO baseline. For that you need either checkout-stage interventions (verification, prepaid push) or a different last-mile architecture entirely.

For brands operating in a single city like Pune, switching the entire local volume to hyperlocal dispatch + locker pickup eliminates the pin-code-by-pin-code triage problem altogether. That's the model NanoHub runs on.