FREE AFFILIATE TRACKING RESOURCE
Free Affiliate Campaign Tracking Template
Affiliate marketing gets much easier to improve when every campaign is measured the same way. This simple tracking template helps you see which traffic sources, pages and offers are producing clicks, leads and sales—and which ones are only consuming time or money.
What to track for every campaign
Create one row for each campaign or promotion and use these columns:
- Date: when the campaign started.
- Campaign name: a short label you can recognize later.
- Traffic source: Google organic, email, social, referral, paid ads or another source.
- Landing page: the page visitors reach first.
- Offer: the product, service or lead magnet being promoted.
- Spend: any direct advertising or placement cost.
- Impressions: how often the promotion was shown when that data is available.
- Clicks: visits or outbound clicks.
- Leads: signups, trials or other meaningful conversions.
- Sales: confirmed purchases.
- Commission: total affiliate revenue earned.
- Notes: headline, creative, audience or other important test details.
Useful formulas
Click-through rate (CTR) = clicks ÷ impressions × 100. This helps you judge whether the headline, snippet or creative is attracting attention.
Lead conversion rate = leads ÷ clicks × 100. This shows how well the landing page turns visitors into prospects.
Sales conversion rate = sales ÷ clicks × 100. This helps you compare offers and traffic quality.
Earnings per click (EPC) = commission ÷ clicks. EPC is useful when comparing campaigns with different traffic volumes.
Return on ad spend (ROAS) = commission ÷ ad spend. If you spent AU$100 and earned AU$150 in attributable commission, ROAS is 1.5.
The template
Copy the headings below into a new Google Sheets or Excel file, one heading per column. The example row uses the figures from the next section so you can check your formulas.
| Date | Campaign | Traffic source | Landing page | Offer | Spend (AU$) | Impressions | Clicks | Leads | Sales | Commission (AU$) | CTR % | Lead rate % | Sale rate % | EPC (AU$) | ROAS | Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-10-01 | Beginner guide email | /beginner-guide | Planner | 0 | 2000 | 500 | 40 | 8 | 240 | 25.0 | 8.0 | 1.6 | 0.48 | n/a | Subject line A |
Copy-ready version
Paste this into cell A1 of a blank sheet, then use Data → Split text to columns (Google Sheets) or Data → Text to Columns (Excel) with comma as the separator.
Date,Campaign,Traffic source,Landing page,Offer,Spend (AU$),Impressions,Clicks,Leads,Sales,Commission (AU$),CTR %,Lead rate %,Sale rate %,EPC (AU$),ROAS,Notes 2026-10-01,Beginner guide email,Email,/beginner-guide,Planner,0,2000,500,40,8,240,25.0,8.0,1.6,0.48,n/a,Subject line A
Spreadsheet formulas for row 2
If your columns are in the order above (Spend in F, Impressions in G, Clicks in H, Leads in I, Sales in J, Commission in K), these formulas fill the calculated columns automatically. Copy them down for each new campaign.
- CTR % (L2):
=IFERROR(H2/G2*100,"") - Lead rate % (M2):
=IFERROR(I2/H2*100,"") - Sale rate % (N2):
=IFERROR(J2/H2*100,"") - EPC (O2):
=IFERROR(K2/H2,"") - ROAS (P2):
=IF(F2>0,K2/F2,"n/a")
Leave Spend at 0 for free traffic such as organic search or your own email list. ROAS then shows n/a, and EPC becomes the main number to compare.
Example tracking row
Imagine you publish a beginner guide, send 500 visitors from an email campaign, collect 40 leads and generate 8 sales worth AU$240 in commission. Recording those figures gives you a baseline. When you test a new subject line or landing page, you can compare results instead of relying on memory.
How often should you review the numbers?
For small campaigns, a weekly review is usually enough. Daily checking can lead to overreacting to tiny changes. Review the same metrics at the same interval, then look for patterns: pages gaining impressions, traffic sources producing low-quality clicks, or offers that convert much better than others.
What to change when results are weak
- Impressions but few clicks: improve the headline, title, snippet or hook.
- Clicks but few leads: improve message match, page clarity and the call to action.
- Leads but few sales: review follow-up, trust, offer fit and the buying experience.
- Sales but poor profit: reduce traffic cost, improve EPC or test a stronger offer.
Keep tests simple
Change one meaningful variable at a time and write down what changed. A tracker is most useful when it becomes the history of your campaign. Over time, that history can show which topics, traffic sources, hooks and offers repeatedly perform best.
For the complete month-long workflow, follow the 30-day affiliate marketing action plan. You can also use the affiliate marketing checklist for a quick daily routine. New to affiliate marketing? Start with affiliate marketing for beginners.