Calculation guide
Returns are measured by order value, not order count. Commission is earned on retained eligible merchandise value, excluding tax and shipping. Enter direct campaign expenses for the same period.
Inputs
Eligible referred sales
Example entry 50000 (in the selected currency).
Returned share of sales value
Example entry 12 %. Allowed range 0 to 100.
Affiliate commission rate
Example entry 8 %. Allowed range 0 to 100.
Direct campaign expenses
Example entry 520 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Eligible referred sales | 50,000 |
| Returned share of sales value | 12% |
| Affiliate commission rate | 8% |
| Direct campaign expenses | 520 |
| Result | Value |
|---|---|
| Profit · Affiliate income after costs | 3,000 |
| Earned commission | 3,520 |
| Commission lost to returns | 480 |
Calculation steps
Net affiliate earnings = ((((Eligible referred sales × (1 − (Returned share of sales value ÷ 100))) × Affiliate commission rate) ÷ 100) − Direct campaign expenses)
((((50,000 × (1 − (12 ÷ 100))) × 8) ÷ 100) − 520) = 3,000
Earned commission = (((Eligible referred sales × (1 − (Returned share of sales value ÷ 100))) × Affiliate commission rate) ÷ 100)
(((50,000 × (1 − (12 ÷ 100))) × 8) ÷ 100) = 3,520
Commission lost to returns = ((((Eligible referred sales × Returned share of sales value) ÷ 100) × Affiliate commission rate) ÷ 100)
((((50,000 × 12) ÷ 100) × 8) ÷ 100) = 480
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Eligible referred sales | 50,000 | 55,000 | Profit · Affiliate income after costs | 3,000 | 3,352 |
| Returned share of sales value | 12% | 13% | Profit · Affiliate income after costs | 3,000 | 2,960 |
| Affiliate commission rate | 8% | 9% | Profit · Affiliate income after costs | 3,000 | 3,440 |
| Direct campaign expenses | 520 | 572 | Profit · Affiliate income after costs | 3,000 | 2,948 |
