Skip to content

How to calculate EPC and conversion rate

Novaxnetwork explains how to calculate EPC and conversion rate from three inputs: counted clicks, the conversions you want to measure, and the commission attributed to those conversions. Divide commission by clicks for EPC. Divide conversions by clicks and multiply by 100 for conversion rate.

The arithmetic is simple; matching the inputs takes more care. A form submission and an approved lead are different events. Before opening a calculator, decide which event, click definition, earnings status, and reporting period your result will describe.

Start with the two formulas

EPC per click = affiliate commission ÷ counted clicks

Conversion rate (%) = specified conversions ÷ counted clicks × 100

impact.com’s reporting definitions describe EPC as action earnings divided by clicks, and conversion rate as actions divided by clicks. Check the definition of the specific field you export because reporting views can count different events.

EPC is a monetary amount; conversion rate is a percentage. The explanation of EPC in affiliate marketing covers how to interpret the metric. This guide focuses on producing calculations you can reproduce and check.

Step 1: define what belongs in the calculation

Write a short measurement note before exporting data. For example: “Approved lead conversions and their commission, attributed to total referred clicks from the selected campaign group.”

Keep these choices explicit:

  • Conversion event: Submitted form, confirmed registration, approved lead, purchase, or another specified action.
  • Click count: Total referrals, unique referrals, incoming ad clicks, or another defined measure.
  • Earnings: The corresponding affiliate commission, with the included statuses recorded.
  • Scope: Campaigns, traffic sources, currency, timezone, date basis, and observation period.

Allow time for delayed conversions and approvals. The attribution window in affiliate marketing helps explain why an eligible action can be credited after its original referral.

Decide whether you are calculating a period summary or following a particular group of clicks through its later earnings. Those approaches answer different questions. Keep the chosen approach consistent when comparing results.

Step 2: prepare the source data

Export the counts and commission amounts rather than copying only the displayed rates. Retain campaign labels and conversion statuses so you can trace a surprising result back to its source.

Where event-level reconciliation is needed, click IDs in affiliate tracking help connect referrals with subsequent activity. Review identifiers and counting rules before treating repeated records as additional conversions or deleting them as duplicates.

The worked example below uses three hypothetical segments with a fixed $5 commission per approved lead. Each submitted form is counted once, and all stated approvals have completed review.

Segment Referred clicks Submitted forms Approved leads Approved commission
A 1,000 80 60 $300
B 500 60 30 $150
C 1,500 90 45 $225
Total 3,000 230 135 $675

These figures demonstrate the calculations. They are not Novaxnetwork performance results, offer rates, or market benchmarks.

How to calculate EPC and conversion rate
Start with the two formulas

Step 3: calculate the conversion rate you need

For Segment A, the form submission rate is:

80 ÷ 1,000 × 100 = 8%

The approved-lead conversion rate uses the same clicks but a different event:

60 ÷ 1,000 × 100 = 6%

Its approval rate uses submissions as the denominator:

60 ÷ 80 × 100 = 75%

These three percentages describe different stages. Calling all of them “conversion rate” without a label makes the report difficult to interpret.

The relationship is useful for checking the funnel: 8% submission rate × 75% approval rate = 6% approved-lead conversion rate. In decimal form, that is 0.08 × 0.75 = 0.06.

If submissions and approvals differ unexpectedly, review the process described in lead scrubbing in affiliate marketing. Separate pending reviews from completed rejections before evaluating the final approval rate.

Step 4: calculate EPC from the matching commission

Segment A generated $300 in approved commission from 1,000 referred clicks:

$300 ÷ 1,000 = $0.30 approved EPC

The fixed payout provides a second check:

6% approved conversion rate × $5 payout = $0.30 EPC

Use 0.06 when entering the percentage as a decimal. Multiplying 6 by $5 would produce the wrong result.

For variable commissions, sum the actual amounts first. As a separate example, 50 approved conversions earning $4 each and 20 earning $7 each produce $340. Across 1,000 clicks, EPC is $0.34. The average commission per approved conversion is $340 ÷ 70, approximately $4.86.

Do not multiply every conversion by the largest advertised payout when the actual credited amounts differ.

How to calculate EPC and conversion rate
Step 4: calculate EPC from the matching commission

Step 5: combine segments using their totals

The example’s overall approved-lead conversion rate is:

135 ÷ 3,000 × 100 = 4.5%

The total form submission rate is 230 ÷ 3,000 × 100, approximately 7.67%. The total approval rate is 135 ÷ 230 × 100, approximately 58.70%. Use the unrounded values when checking that submission rate multiplied by approval rate reconciles to the 4.5% approved conversion rate.

Its overall approved EPC is:

$675 ÷ 3,000 = $0.225

Simply averaging Segment A’s 6%, Segment B’s 6%, and Segment C’s 3% would give 5%. That overstates the combined rate because the segments have different click volumes.

The same problem affects EPC. Averaging $0.30, $0.30, and $0.15 gives $0.25; the correct combined EPC is $0.225. Sum commission and clicks before dividing.

Use sub-ID tracking in affiliate marketing to preserve useful segment labels. You can calculate the correct total while still investigating why a particular placement performs differently.

Reproduce the calculation in Excel or Google Sheets

For a compact worksheet, place segment names in column A, clicks in B, approved conversions in C, and approved commission in D. Enter Segments A, B, and C in rows 2 through 4.

Use column E for approved conversion rate and F for approved EPC. In row 2, enter:

E2: =IF(B2=0,"",C2/B2)
F2: =IF(B2=0,"",D2/B2)

Format column E as a percentage and column F as currency with enough decimal places to show the difference between nearby values. Copy the formulas down through row 4.

The percentage formula returns 0.06 for Segment A. Percentage formatting displays that as 6%. Do not also multiply the formula by 100 when using percentage formatting.

For the total in row 5:

B5: =SUM(B2:B4)
C5: =SUM(C2:C4)
D5: =SUM(D2:D4)
E5: =IF(B5=0,"",C5/B5)
F5: =IF(B5=0,"",D5/B5)

The results should be 3,000 clicks, 135 approved conversions, $675 commission, 4.5% conversion rate, and $0.225 EPC. The examples use commas between function arguments; some spreadsheet locales use semicolons.

The IF checks leave a zero-click ratio blank. A row with no clicks and positive commission needs investigation: it may contain later earnings from earlier referrals or a different date basis. Entering zero as its EPC would conceal that distinction.

How to calculate EPC and conversion rate
Reproduce the calculation in Excel or Google Sheets

Check units, statuses, and rounding

Confirm whether the source displays earnings per click or per 100 clicks. The example’s $0.225 per click equals $22.50 per 100 clicks. Normalize the units before comparing reports.

Keep full precision in intermediate calculations. Rounding $0.225 to $0.23 and multiplying by 3,000 produces $690, which is $15 above the actual $675. Round for presentation while retaining the underlying values for further calculations.

Also use matching earnings and conversion statuses. If approved conversions generate $675 but a report adds $100 in pending commission, its EPC including pending amounts becomes approximately $0.2583. Multiplying the approved conversion rate by the approved payout would still give $0.225 because it uses a different earnings set.

Reconcile differences through the underlying amounts rather than changing formulas until two dashboard figures happen to agree.

Update both counts and money when statuses change. Suppose 10 previously approved leads in the example are later reversed, each removing a $5 commission. Approved conversions fall from 135 to 125, and approved commission falls from $675 to $625.

With clicks unchanged at 3,000, the revised approved conversion rate is approximately 4.17%, and revised EPC is approximately $0.2083. Changing only the earnings cell would leave the approved conversion count inconsistent with the new status.

Retain the date and reason for each reporting adjustment where available. This lets you distinguish a genuine change in campaign outcomes from a difference in when two exports were produced.

Calculate changes without confusing percentages

When comparing periods, distinguish percentage points from relative percentage change. Moving from a 4.5% conversion rate to 5.4% is an increase of 0.9 percentage points.

Relative increase = (5.4% − 4.5%) ÷ 4.5% × 100 = 20%

At an unchanged $5 payout, a 5.4% approved conversion rate corresponds to $0.27 EPC. Moving from $0.225 to $0.27 is an increase of $0.045 per click, also a 20% relative increase.

State the baseline and comparison period with the result. Similar arithmetic does not prove that a page change caused the improvement; traffic mix, offer conditions, and approval maturity still need to be comparable.

Use the result to evaluate acquisition costs

Return to the original dataset, before the separate reversal example. Assume the three segments together cost $585 in advertising. Their $675 approved commission leaves $90 before operating expenses and later adjustments.

Advertising spend per referred click is $585 ÷ 3,000 = $0.195. On that same click basis, $0.225 EPC minus $0.195 leaves $0.03 per referred click. Multiplying by 3,000 reconciles to the same $90 contribution.

This cost per referred click may differ from the CPC reported by the advertising platform. Incoming ad clicks can include visitors who never continue to the offer. Reconcile total spend and commission across the full journey before setting a spending limit.

Run a final calculation check

Before using the figures to change a campaign, verify that:

  • The conversion event and included statuses are clearly labeled.
  • Earnings and clicks describe the intended traffic group and date basis.
  • Segment totals reconcile to the source export.
  • Percentages and EPC use summed counts in the total row.
  • Currency, per-click units, and decimal precision are consistent.

Then consider how mature the results are. Correct arithmetic can still describe an early sample with few completed approvals. Keep the counts beside the rates when judging how much evidence supports a spending decision.

How to calculate EPC and conversion rate
Run a final calculation check

Frequently asked questions

Should I use submitted or approved conversions?

Use the event that answers your question and label it. Submitted conversions help assess form completion; approved conversions help assess payable outcomes. Keep each rate connected to its corresponding commission and denominator.

Can conversion rate exceed 100%?

It can when the measurement counts multiple conversion actions per interaction. Check whether the numerator represents actions, unique converters, or another definition before treating a value above 100% as a calculation error.

Why does my spreadsheet differ from the network?

Compare filters, dates, click definitions, conversion statuses, earnings components, and rounding. Start with the exported counts and amounts. A matching column label does not guarantee matching inputs.

Can I estimate EPC from conversion rate alone?

You also need commission per conversion. With a fixed payout, multiply the matching conversion rate by that payout. With variable commissions, use actual total commission or a properly calculated average for the same conversion set.