Affiliate earnings per click with returns
Calculate what a referral click earns after reversals.
The scenario
A guide sends 800 clicks and earns $540 before $100 in reversals.
Net earnings per click are $440 ÷ 800, or $0.55. Gross EPC of $0.675 overstates what this cohort actually paid.
Apply it to your own work
Group clicks by referral date and wait until their reversal window closes. Keep pending and paid balances separate and compare each guide on the same cohort basis.
Make a two-cohort worksheet
Keep referral month, tracked clicks, gross commission, reversals, approved commission, and payout status as separate columns. Use the same network timezone and count scope on every row.
A second cohort with 400 clicks and $260 approved earnings has a $0.65 EPC. Together the cohorts earned $700 across 1,200 clicks, or about $0.58 per click. The simple average of $0.55 and $0.65 would overweight the smaller cohort.
What to watch for
A network's EPC definition may use a different click or time basis. Confirm its denominator before comparing it with your calculation.
Separate payout status from click performance
For each placement, save tracked clicks, gross commission, reversals, and payout status at a fixed review date. If reversals arrive later, keep the first estimate and publish a settled figure for comparison.
Calculate aggregate EPC from total dollars and clicks. A guide with 100 clicks and $90 earned should not carry the same weight as one with 900 clicks and $450 earned. Together they earned $540 across 1,000 clicks, or $0.54 per click.
Try a related tool
Measure earnings per tracked referral click after refunds and reversals. Use counts and commissions from the same cohort.
