Most affiliates track exactly one number — monthly commission total — and it tells them almost nothing. It cannot say which article earned the money, which program underpays for the traffic you send it, or whether last month’s growth came from better content or a lucky feature in someone’s newsletter. Flying blind, they scale the wrong things. This guide builds the measurement system that fixes it.
The Four Metrics That Actually Matter
1. EPC — Earnings Per Click
Total commissions from a program divided by the clicks you sent it. EPC is the great equalizer: it lets you compare a 40% one-time program against a 20% recurring one on a single axis. Two programs with identical commission rates routinely differ 3–5x in real EPC because of landing page quality, pricing friction, and cookie duration. Calculate it per program, monthly.
2. RPV — Revenue Per Visitor (by page)
Commission attributed to a page divided by its visitors. This is how you discover that a modest tutorial with 800 monthly visits out-earns a “big” listicle with 8,000 — and therefore which content template deserves to be cloned. RPV by page is the single most actionable number an affiliate can track.
3. CTR to Merchant
What share of a page’s readers click an affiliate link at all. Low CTR with good traffic means a page problem (placement, CTA copy, intent mismatch). Good CTR with low conversions means a merchant problem. Separating the two tells you what to fix — and whether it is even yours to fix.
4. Effective Hourly Rate
Revenue per content cluster divided by hours invested in it. Brutal and clarifying: some content types will pay you ten times more per hour of work. You cannot know which until you track both sides.
The Tracking Stack (Simple Version First)
- Link management: a redirect-based link manager on your site (ThirstyAffiliates, Pretty Links, or Lasso) gives you click counts per link and page, plus the ability to swap destinations site-wide in one edit.
- Analytics events: configure your analytics tool (GA4 or a privacy-first alternative like Plausible) to record outbound affiliate clicks as events. Now clicks connect to pages, sources, and behavior.
- SubID tracking: most serious networks (Impact, PartnerStack, ShareASale) accept a SubID parameter on your links. Pass the page slug as the SubID and the network’s reporting will tell you exactly which article generated each commission. This one habit turns attribution from guesswork into bookkeeping.
- The spreadsheet: one monthly sheet — rows are programs and top pages, columns are clicks, commissions, EPC, and RPV. Thirty minutes a month; total visibility.
Understand Attribution Before You Trust Any Number
Affiliate attribution is almost always last-click with a cookie window: the final affiliate link clicked before purchase gets full credit, within the cookie’s lifetime. Three consequences worth internalizing:
- Your top-of-funnel tutorials are systematically undercredited — they start journeys that a review finishes. Judge them by assisted behavior (email signups, internal clicks to money pages), not raw commissions.
- Short cookies (24–72 hours) punish considered purchases. Factor cookie duration into which programs you feature for expensive products.
- Cross-device journeys leak: a reader who researches on mobile and buys on desktop often escapes attribution entirely. Your true impact is somewhat higher than your dashboards show — in every program.
From Measurement to Decisions
- Clone your winners: find your top-RPV pages and produce more content with the same structure and intent.
- Renegotiate or replace: programs with persistently weak EPC despite good traffic either get a commission-bump request (volume gives you leverage) or get swapped for the competitor — our list of high-paying programs is the shortlist.
- Fix pages surgically: low CTR pages get placement and CTA work using the patterns from reviews that convert; low-converting merchants get demoted regardless of how nice their program manager is.
- Review quarterly: EPC and RPV trends over three months tell you where next quarter’s writing hours should go.
The affiliates who compound are not the ones who write the most — they are the ones who know, with numbers, what to write next. Build the spreadsheet this month; it will pay for itself by the next one.
Your Monthly Dashboard, Concretely
Here is the exact structure of a dashboard that takes thirty minutes a month to maintain. Sheet one, Programs: one row per program; columns for clicks sent, conversions, commissions, EPC, and a three-month EPC trend arrow. Sheet two, Pages: one row per monetized page; columns for sessions, affiliate clicks, CTR, attributed commissions (from SubIDs), and RPV. Sheet three, Decisions: a running log of what you changed and when — swapped a program, moved a CTA, refreshed a review — so next month’s numbers have context. The Decisions sheet is the one everyone skips and the one that turns data into learning; without it you will re-run the same experiments forever.
Benchmarks: What “Good” Looks Like
Numbers vary wildly by niche, but rough orientation helps a beginner know whether to celebrate or investigate. Affiliate CTR on genuine review pages commonly lands between 8% and 20% of readers; on tutorials, 2–5% is normal because intent is earlier. Merchant-side conversion on clicked traffic typically runs 1–5% for SaaS trials and higher for low-friction free tiers. EPC below $0.10 on meaningful volume usually signals a program problem; above $1.00 signals a page worth cloning. Treat these as compass bearings, not grades — your own month-over-month trend beats any external benchmark.
When to Graduate to Dedicated Tracking Software
The spreadsheet system scales further than most expect, but three signals say it is time for consolidated tracking tools (Affilimate-style dashboards or self-hosted alternatives): you manage more than five programs and reconciliation eats hours; you need revenue attribution by page automatically rather than via manual SubID exports; or you are A/B testing placements and need click data at the per-link position level. Until then, the manual system’s thirty minutes buys you something software cannot: forced monthly contact with your own numbers.
Frequently Asked Questions
How do I attribute a commission when the network shows no SubID?
Some conversions will always arrive unattributed — cross-device journeys, stripped parameters, direct returns to the merchant. Assign them proportionally to that program’s attributed clicks for the month and move on; chasing perfect attribution costs more than the precision is worth.
Is Google Analytics enough for affiliate tracking?
It covers half the picture: traffic and outbound clicks. It cannot see what happens after the click — conversions and commissions live in your program dashboards. The SubID bridge described above is what joins the two halves into actual ROI.
How soon should a new site start tracking all this?
Instrument from day one — link manager, click events, SubIDs — because retrofitting attribution is painful. But do not analyze until there is signal: below a few hundred affiliate clicks a month, EPC differences are noise. Collect early, judge late.