Promo Code Revenue Tracker
Add a row for each creator and their promo code, enter orders, revenue, flat fee and commission rate, and get totals, commission owed and ROI per creator. Download everything as a CSV.
| Creator | Code | Orders | Revenue ($) | Flat fee ($) | Commission % |
|---|
Your rows are saved in this browser only, so you can come back and update them.
| Creator | Code | Revenue | Commission | Total cost | ROI |
|---|
For tracking only. Check payout amounts against your agreements. Not tax or financial advice.
For each promo code: commission = revenue × commission %; total cost = flat fee + commission; ROI = (revenue − total cost) ÷ total cost × 100. Add the rows for campaign totals. Unique codes per creator are the simplest way to attribute sales, though they miss buyers who forget to use the code and can leak to coupon sites.
How to use the Promo Code Revenue tracker
- Add a row for each creator and their unique promo code.
- Enter orders and revenue for each code from your store’s discount report.
- Enter the flat fee you paid and the commission rate you agreed.
- Check commission owed and ROI per creator, then download the CSV for payouts and reporting.
How it is calculated
Total cost = flat fee + commission
ROI = (revenue − total cost) ÷ total cost × 100
Worked example: Creator 1: $2,940 revenue × 10% = $294 commission + $500 fee = $794 cost → ROI = (2,940 − 794) ÷ 794 × 100 = 270.3%. Across the three example rows: $8,985 revenue, 125 orders, $2,742.25 total cost → overall ROI 227.7%.
How do you track influencer sales with promo codes?
Give every creator a unique discount code, then pull orders and revenue per code from your store’s discount or sales report at the end of each period. Enter those numbers here to see what each creator brought in and what you owe them.
Use codes that are easy to say and remember, such as the creator’s name plus the discount. Set an end date if the deal is time-limited.
Pair codes with tracked links where you can. Links capture people who click but forget the code; codes capture people who heard about you and bought later.
What are the limits of promo code tracking?
Promo codes under-count some sales and over-count others. Buyers who forget the code are missed, while codes shared on coupon sites can be used by people who never saw the creator.
- Check where code orders come from if one code suddenly spikes.
- Use a lower discount or single-use codes if leakage is a problem.
- Report code revenue as “tracked” revenue, not total impact.
For a full campaign view, feed the totals into the ROI calculator with your other costs.
Frequently asked questions
How do I calculate commission on promo code sales?
Multiply the revenue from that creator’s code by the agreed commission rate. Check whether your agreement uses revenue before or after discounts and refunds.
Should revenue include tax and shipping?
Usually not. Most agreements pay commission on net product revenue, but follow what your contract says.
Where is my data saved?
Only in this browser’s local storage. Nothing is sent to a server, and you can download a CSV at any time.
Can I use this for affiliate links too?
Yes. Enter the link name in the code column and the orders and revenue from your affiliate dashboard.
Why does a creator show negative ROI?
Their flat fee and commission cost more than the revenue their code drove. Look at whether the code was promoted clearly before judging the creator.