Break-Even ROAS for COD in Pakistan: A Copy-Paste Calculator Sheet for Your Meta and TikTok Ads (With a Rs Example)

Why the break-even ROAS in Ads Manager lies to a COD seller

Break-even ROAS is the number every ads guide tells you to know: the return on ad spend at which a campaign stops losing money. The usual formula is price divided by profit per order. For a card-paying store in another country that is close enough. For a Pakistani COD store it is badly wrong, because Ads Manager counts an order the moment the buyer presses the button, while you only get paid when a rider hands over the parcel and the courier releases the cash.

Between those two moments, three things eat the order. Some orders are cancelled before dispatch because the buyer cannot be reached or did not mean it. Some shipped parcels come back, and you pay shipping both ways. And on the parcels that are delivered, the courier deducts tax from the cash it collects. This post gives you a calculator sheet you can copy into Google Sheets in ten minutes, a worked Rs example, and a table showing how fast your allowed ad cost falls as your delivery rate drops.

What the public numbers say about the gap between placed and paid orders

There is little public data on this in Pakistan, but a June 2026 OrderNation study of one large Pakistani online retailer, covering about 127,000 COD parcels shipped between July 2025 and June 2026, gives a sense of scale. These are one retailer's figures, not a national average.

Read together, these say that a large share of what an ads dashboard calls a purchase never becomes cash, and that traffic from social media returned more often than traffic from search. That is why a Meta or TikTok campaign needs its own break-even line, built from your delivery rate and not from the purchase count.

The courier also takes tax. Under Section 6A of the Income Tax Ordinance, 2001, couriers collecting cash on delivery for digitally ordered goods withhold 2% of the gross amount received, according to a summary by Taxation PK, which also notes a separate 2% sales tax collected by couriers on digitally ordered goods. Your rate depends on your tax status, so check with your accountant and put your own figure in the sheet.

The template: copy this break-even ROAS calculator into Google Sheets

Open a new sheet. Type the labels in column A and your numbers in column B, exactly in these rows, so the formulas below work without changes.

Now add the outputs. Type the label in column A and the formula in column B.

B13 and B15 are the two numbers to compare with your dashboard every day, because they are in the same units the dashboard uses: cost per purchase and purchase ROAS. B17 and B18 are the same numbers with your profit target built in.

The sheet makes three assumptions. Orders cancelled before dispatch cost you nothing except the ad that bought them. Returned products go back into stock; if many come back damaged, add the average loss to B6. And the product cost of a returned parcel is not lost, only the shipping and packaging.

Example: break-even ROAS for a Rs 3,000 product

Example (illustrative numbers, not real courier rates or store data). Price collected Rs 3,000, product cost Rs 1,100, packaging Rs 50, forward shipping Rs 250, return charge Rs 250, courier tax 2%, delivery rate 80%, dispatch rate 80% (so 125 placed orders become 100 shipped parcels), target profit Rs 300 per delivered order.

So you can spend up to Rs 112,200 in ads to get those 125 placed orders and still break even. That is Rs 1,122 per shipped parcel (B12), Rs 898 per purchase in Ads Manager (B13) and Rs 1,403 per delivered order (B14).

Ads Manager would report 125 purchases worth Rs 375,000. Your break-even ROAS on that reported value is 375,000 divided by 112,200, about 3.34 (B15). The simple formula most guides give, price divided by margin per order, would say about 1.9 for this product, because Rs 3,000 minus Rs 1,100 product cost minus Rs 300 shipping and packaging leaves Rs 1,600 per order. A campaign showing ROAS 2.5 looks profitable by the simple formula, and is losing money by the real one.

With the Rs 300 profit target, the allowed ad spend falls to Rs 88,200 per 100 shipped parcels: Rs 706 per purchase (B17), or a target ROAS of about 4.25 (B18).

How much does a lower delivery rate cut your allowed ad cost?

Keep everything from the example the same and change only the delivery rate. This is the table to show anyone who says a 10-point drop in delivery is a small thing.

Going from 80% to 70% delivery cuts what you can pay per purchase by about Rs 168, roughly a fifth. That is why cutting returns often helps profit more than finding a cheaper audience. The dispatch rate works the same way: if you confirm orders better and fewer get cancelled, each purchase in Ads Manager is worth more and your allowed cost per purchase rises.

How to use the sheet every week

1. Fill B8 and B9 from a month that has settled. In the OrderNation study a failed COD delivery took a median of 21.7 days to show up in the seller's books, so last week's orders will make your delivery rate look better than it is.
2. Make one copy of the sheet per traffic source, or per product if prices differ. Social traffic and search traffic had different return rates in the study, so they deserve different break-even lines.
3. Each day, compare each campaign's cost per purchase in Ads Manager with B13. Above B13, the campaign loses money on every order. Between B17 and B13, it pays for itself but misses your target. Below B17, it earns your target.
4. Before you cut a campaign, check whether its delivery rate is worse than the store average. A campaign with a higher cost per purchase but much better delivery can still be the best one. RabbitROI shows net profit per ad campaign after returns, ad spend, product cost and shipping, which saves you doing this by hand.
5. When courier rates, product cost or your tax status change, update B3 to B7 the same day. A Rs 50 rise in shipping each way moves the break-even line more than most people expect.

Mistakes that make the break-even number wrong

• Using placed orders as delivered. If your delivery rate is not in the formula, your break-even ROAS is too low.
• Forgetting return shipping. You pay to send the parcel and to bring it back, plus the packaging you usually cannot reuse.
• Leaving out courier tax. On Rs 240,000 of collected cash, 2% is Rs 4,800 in the example, more than the return charges.
• Mixing bundles and single units. If a third of buyers take a 2-pack, use the average amount collected per order in B2 and the average cost in B3.
• Judging a campaign on three days. Delivery results arrive weeks later, so set the decision rule in advance and stick to it.
• Letting the pixel double-count. If the same purchase is counted by browser and server, the dashboard ROAS looks better than reality. RabbitROI's pixels deduplicate the Purchase event between browser and server for Meta, TikTok, Snapchat, Google and Pinterest.

FAQ