Measuring barter ROI when the order is ₹0
A ₹0 barter order still costs money and still returns something. A simple spreadsheet model for per-creator and per-batch ROI, attribution, RTOs and a monthly review.
Part of the complete guide to barter & creator order operations on Shopify.
The order total says ₹0, so the program looks free. It is not. Every parcel you send a creator has a cost you can count and a return you can estimate. The gap between the two is the number your founder or client actually wants, and it fits in a spreadsheet.
What a ₹0 order really costs
The 100% discount removes the price. It does not remove anything else. When a barter order ships, four things leave the building:
- Product at cost. Not the MRP, the landed cost of goods. A ₹1,499 skincare set that costs ₹380 to make is a ₹380 line, not a ₹1,499 one. Using MRP here is the single most common way brands make barter look more expensive than it is.
- Packaging. Box, filler, insert card, tape. Often ₹30 to ₹80 for a standard parcel, more if you use a special creator kit.
- Outbound shipping. Whatever your courier partner charges for that weight slab to that PIN code. Prepaid rates, since there is no COD on a ₹0 order.
- Ops time. Placing the order, checking the address, chasing the creator for content, logging the deliverable. At 2 to 3 minutes to place and another 10 to 15 minutes of follow-up across the month, that is 15 minutes or so per creator. The hidden cost post goes deeper on this line.
Add these and a typical D2C barter parcel in India lands somewhere between ₹400 and ₹1,200 all-in. That is the number to put against the return, and it is a real number even though the order shows zero.
What comes back
The return side is messier because most of it is not cash. Count five things, and be honest about which ones you can actually observe:
- Content pieces. Reels, story sets, static posts, written reviews. This is the most reliable return because you can count it and you know roughly what it would cost to buy.
- Reach. Views on that content. Useful as context, dangerous as a value. Reach is what the creator reports, and it does not turn into money on its own.
- Code redemptions.Orders placed with the creator's unique discount code. This is your only hard revenue signal, so it deserves its own column.
- Follower lift.Your own account's follower change in the days after the content goes live. Noisy, but worth noting for the top creators.
- UGC reuse. Content you got rights to and reused in ads, on product pages or in your own feed. When a barter reel becomes your best-performing ad creative, that is a return that dwarfs the parcel.
The model
Build it as one sheet with one row per creator, grouped by batch (the month, or the campaign tag on the order). The columns are the table below. Everything on the left is typed in or pulled from your order export; everything on the right is a formula.
| Column | Type | Where it comes from | Formula in words |
|---|---|---|---|
| Product cost | Cost input | Your COGS sheet, per SKU, times quantity | Sum of (unit cost × qty) for each line on the order |
| Packaging | Cost input | Flat rate per parcel type | Lookup by parcel type |
| Shipping | Cost input | Courier invoice or rate card | Actual charge, or rate card by weight slab and zone |
| Ops time | Cost input | Estimated minutes × hourly rate | Minutes ÷ 60 × hourly cost of the person doing it |
| Parcel cost | Formula | Product cost + packaging + shipping + ops time (+ return shipping if RTO) | |
| Content pieces | Return input | Your collab tracker, by type | Count per type: reels, stories, posts, reviews |
| Content value | Formula | Rate card you set once | Sum of (pieces of each type × what you would pay for that type) |
| Attributed orders | Return input | Shopify orders using the creator's code in the window | Count of orders with that code, content-live date to +45 days |
| Attributed margin | Formula | Attributed net revenue × your gross margin % | |
| Return | Formula | Content value + attributed margin (+ UGC reuse value if licensed) | |
| ROI | Formula | (Return − parcel cost) ÷ parcel cost |
Setting the content rate card
The content value column is where people argue, so decide it once and stop. The rate is what you would pay to get the same piece another way: what a freelance videographer charges for a product reel, what a paid micro-creator quotes for a story set. Use quotes you have actually received, write them at the top of the sheet, and apply them to every creator equally. If you have never paid for content, use conservative figures and label them as estimates.
Do not price content by follower count. You are valuing the asset, not the person. A creator with 8,000 followers who sends a clean, reusable reel gave you more than one with 200,000 who posted a blurry story for six hours.
A worked example
One creator, one parcel. Product cost ₹420, packaging ₹50, shipping ₹90, ops time 15 minutes at ₹400 an hour which is ₹100. Parcel cost ₹660. She delivers one reel and a set of three stories. Your rate card says a product reel is worth ₹2,000 and a story set ₹500, so content value is ₹2,500. Her code was used on four orders totalling ₹5,600 net, and your gross margin is 55%, so attributed margin is ₹3,080.
Now the same batch has 40 creators. Twelve never posted, three parcels came back as RTO, and the rest look roughly like her. The batch ROI is what you report; the per-creator ROI is what you act on. Both come from the same sheet.
Attribution: codes, links and the window
You cannot attribute what you did not set up before the parcel shipped. Each creator row needs a unique discount code and a unique link, created and recorded at the same time as the order. Reusing one generic “CREATOR10” code across 40 people gives you a batch number and no per-creator signal.
Codes are the reliable signal because they sit on the Shopify order. Links are weaker: people watch a reel, search your brand later, and buy without clicking anything. Treat link clicks as context and code redemptions as the number.
Fix the attribution window in advance and apply it to everyone. Thirty to sixty days from the date the content goes live is a sensible range for most D2C categories. Longer windows inflate small creators with noise; shorter ones punish anyone whose audience buys on payday.
The lag between shipping and content
A barter order placed on the 3rd typically ships by the 5th, arrives by the 9th, and the content appears somewhere between the 12th and the 30th, if it appears at all. Then the attribution window runs for another 45 days. This means the ROI for an August batch is not knowable until mid-October.
Two practical consequences. First, report on batches by ship month, but close them two months later. An “open” batch shows cost only; a “closed” one shows ROI. Second, track the content-live date per creator, not the ship date, because the attribution clock starts from content. Keep that column in your collab tracker, keyed to the order's reference tag so it lines up with the export. The glossary has the vocabulary if your team is not yet using these terms consistently.
How to treat RTO'd barter orders
Returns to origin are the ugliest line in barter. The parcel went out, it came back, you paid outbound and return shipping, the creator got nothing, and no content will ever arrive. In the model, an RTO row has full parcel cost plus return shipping and a return of zero. Do not delete these rows; they are the whole reason the batch ROI is lower than the per-creator average.
Tag them so you can see the pattern. If RTOs cluster around one courier partner, one PIN code range, or addresses that came in through DMs without a phone number, that is a fix on the ops side, not a creator problem. If you re-ship, tag the second order as a replacement so the same creator does not look like two collabs, and give it a distinct program tag rather than a note nobody filters on.
If you regularly re-ship after RTO, decide up front whether the re-ship cost belongs to the original creator row (it does, for per-creator ROI) or to an “ops losses” line (cleaner for the batch view). Either is fine; mixing them month to month is not.
A monthly review template
The sheet is only useful if someone reads it. Once a month, close the batch from two months ago and walk through five questions:
- Batch ROI and trend.This month's closed batch against the previous three. Is content value per parcel going up or down? Is parcel cost creeping because SKUs got heavier or shipping rates changed?
- Delivery rate. What share of creators posted anything at all? A batch where 30% never post is a sourcing problem. A batch where 30% RTO is a logistics problem. They need different owners.
- Top ten and bottom ten. Sort by ROI. The top ten are candidates for a paid collab or a repeat parcel. The bottom ten who did post are done. The ones who never posted go on a do-not-resend list.
- Reuse pipeline. Which pieces did you get rights to, and which are actually running in ads or on the site? Unused UGC is return you counted but did not collect.
- Cost per content piece. Total parcel cost divided by total pieces received. This single number, tracked over time, is the one most useful to show a founder or a client, because it compares directly with what paid content costs.
Agencies running this for several brands should keep one sheet per brand with the same column layout, so a client-level summary is a copy-paste. The agency playbook has the rest of that operating structure.
Most of the inputs on the cost side come straight from a tagged order export, so the model is only as good as the orders behind it; if placing and tagging those orders is where your time goes, you can try it free and start the month with the export already clean.
Frequently asked questions
How do you calculate ROI on a barter collaboration?+
Add up the real cost of the parcel: product at cost, packaging, outbound shipping, and a share of the ops time to place and chase it. Then value what came back: content pieces at what you would have paid for them, plus any tracked revenue from the creator's code or link. ROI is return minus cost, divided by cost.
What does a ₹0 Shopify order actually cost the brand?+
The discount only removes the price. The product still leaves inventory at cost, the courier still charges for shipping, the box and insert still cost money, and someone spent time placing the order and following up. For a typical D2C parcel in India that is often ₹400 to ₹1,200 all-in before any content arrives.
How do you attribute sales to a barter creator?+
Give each creator a unique discount code and a unique link, and record both against their row before the parcel ships. Code redemptions are the reliable signal; link clicks are noisier. Count orders using the code within a fixed window, usually 30 to 60 days after their content goes live, not after shipping.
Should RTO barter orders count in ROI?+
Yes, as cost with zero return. An RTO'd barter parcel cost you outbound shipping, return shipping and handling, and the creator received nothing, so no content follows. Track them separately so you can see whether the loss comes from bad addresses, a specific courier partner, or specific PIN codes.
What is a good ROI for influencer barter?+
There is no universal benchmark, and anyone quoting one is guessing. A useful rule of thumb: if the content alone is worth more than the parcel cost at the rate you would pay a freelancer for similar pieces, the program pays for itself before counting any sales. Anything attributed on top is upside.