A cash-on-delivery campaign can show a low cost per lead and still lose money. It can show positive media return and still fail to cover the creative, tracking, fulfillment support, and time used to run it. It can also earn a commission on paper while the affiliate runs short of cash waiting for settlement.
Those outcomes are different, so one dashboard number cannot answer every financial question. A useful COD report keeps unit economics, campaign result, and cash flow distinct, then reconciles them using the offer’s actual payable event and status definitions.
Choose the event before calculating revenue
Write down what the network or advertiser counts as payable for the exact offer. A submitted order, confirmed lead, collected parcel, approved commission, payable balance, and bank receipt can be separate events. Terms and status names vary by account and offer, so use the current offer rules and account reporting. The public DR.CASH terms PDF is labeled version 22.06; it describes remuneration and lead statistics under its agreement, but it is a dated document. Confirm the active offer and current account terms before using its language as your reporting definition. (DR.CASH Terms of Service).
Build each report around a defined population. Keep the click or order cohort, offer, GEO, traffic source, time zone, currency, and event maturity visible. Revenue from leads that have had time to progress should not be compared with media spend from a different date range without explaining the attribution method. Pending, rejected, reversed, approved, payable, and paid statuses should remain distinguishable wherever the source data allows.
Keep four financial views separate
A report can answer four questions, each with its own cost base:
- Unit economics: what does one click, submitted lead, or payable event cost or earn?
- Media contribution: does revenue assigned to the campaign exceed its paid traffic spend?
- Campaign result: does the campaign cover its direct and variable operating costs?
- Fully loaded result and cash flow: what remains after the chosen shared-cost and labor allocations, and when does money actually arrive?
DR.CASH’s published affiliate guide gives a useful dated explanation of ROI as income less expenses, divided by expenses. It also says its expense view includes preparation and campaign costs such as creative work, translation, hosting, and traffic. That definition is broader than a media-only calculation. The guide was published June 30, 2023; state your own cost base and accounting rule instead of assuming every network, tracker, or operator uses “ROI” identically. (Traffic Sources in Affiliate Marketing).
Use formulas with labeled denominators
Use a consistent event and period in each numerator and denominator:
- Media CPL = media spend ÷ submitted leads.
- Media cost per payable event = media spend ÷ payable events.
- Revenue per click (RPC) = payable-event revenue ÷ tracked clicks.
- ROAS = campaign-attributed revenue ÷ media spend.
- Media contribution = campaign-attributed revenue − media spend.
- Media ROI = (campaign-attributed revenue − media spend) ÷ media spend × 100.
- Fully loaded campaign result = campaign-attributed revenue − all costs under the stated allocation policy.
- Fully loaded ROI = fully loaded campaign result ÷ the same fully loaded cost base × 100.
ROAS expresses revenue relative to media spend; ROI expresses net return relative to a named cost base. For a media ROI, the base is media spend. For a fully loaded ROI, it includes every campaign cost you chose to allocate. A percentage called simply “ROI” is ambiguous if the reader cannot see which version produced it.
A worked example with three answers
Imagine a hypothetical, fully matured campaign in a single currency. It records 1,000 tracked clicks and 160 submitted orders. Eighty orders become payable at a hypothetical $30 commission each. Assume there are no later reversals in this teaching example.
- Payable-event revenue: 80 × $30 = $2,400.
- Media spend: $1,000.
- Media CPL: $1,000 ÷ 160 = $6.25.
- Media cost per payable event: $1,000 ÷ 80 = $12.50.
- RPC: $2,400 ÷ 1,000 = $2.40.
- Media ROAS: $2,400 ÷ $1,000 = 2.4×.
- Media contribution: $2,400 − $1,000 = $1,400.
- Media ROI: ($2,400 − $1,000) ÷ $1,000 = 140%.
The media view is positive, but it is not the complete campaign result. Suppose direct campaign costs are $450, a consistently allocated share of operating costs is $250, and the operator assigns $200 of imputed labor to the work. The fully loaded cost base is $1,900. The result is $500; fully loaded ROI on that stated cost base is $500 ÷ $1,900, or 26.3%.
This example is entirely hypothetical. It excludes taxes, financing costs, and any unlisted expenses; it is not a market benchmark or a DR.CASH outcome. Change the allocation policy and the fully loaded result changes, so a report should show the policy beside the figure.
Make cost allocation visible
Before adding a cost to the report, label it consistently:
- Direct or shared: can the cost be tied to this campaign, offer, GEO, or creative?
- Variable or fixed: does it move with campaign volume during the period you are measuring?
- Cash or imputed: did money leave the business, or are you assigning a value to owner time?
- Allocation level: campaign, source, offer, creative, or portfolio?
A one-off translation may be direct to a GEO. A tracker subscription may serve several offers. Reused creative may support multiple campaigns. The owner’s time may matter for economic comparison even though it is not a cash payment. Define a reasonable allocation once and apply it consistently across the campaigns you compare.
Do not subtract failed or rejected leads a second time as though they were a separate expense after media spend is already in the calculation. Their effect is reflected in fewer payable events and a higher cost per payable outcome. Use rejection and delivery statuses to diagnose the funnel; count a separate financial cost only when a distinct expense actually occurred.
Reconcile attribution and late statuses
A network-to-tracker postback can move a later event into a reporting system, but the event must remain attached to the original click or order. DR.CASH’s public postback tutorial describes a network-to-tracker chain and gives a Keitaro example; it is dated December 22, 2022, so verify current parameters, status mapping, and account setup before relying on its steps. A successful request does not alone prove that the correct click received the correct commission or that the event is final. (How to set up postback in an affiliate network and in a tracker).
For a monthly close, compare at least three records: traffic-source spend, tracker click and status data, and the network’s current lead or commission report. Match by the identifiers and time rules each system supports. Log missing identifiers, duplicates, delayed updates, reversals, currency differences, and reporting cutoffs. If the systems disagree, preserve the discrepancy until it is reconciled instead of silently selecting the number that makes the campaign look better.
Report conversion rates on comparable cohorts. A group of leads acquired yesterday may contain orders that are still being confirmed or delivered. If you put those leads in the denominator before the expected process has matured, the rate looks artificially weak; if you count all submitted leads as paid, revenue looks artificially high. State the cohort start, latest status date, unresolved share, and payable-event rule.
Track earned revenue separately from cash received
A commission can be approved or payable before it appears in the affiliate’s bank account. Record the amount earned, amount pending, scheduled or expected settlement, actual receipt date, fees, and reversals separately. The network agreement and the active account determine how payment is processed; the dated public DR.CASH terms should be checked against current conditions.
A cash forecast should show opening balance, media and operating payments by date, expected receipts by date and confidence, and a reserve for unresolved orders or reversals. The gap between campaign spend and cash receipt is working capital the business must fund. A positive campaign result does not mean that all revenue is already available to spend again.
A review sequence that leads to a decision
At each campaign review, ask these questions in order:
- What is the exact offer-defined payable event, and how many events are mature enough to count?
- Does the click, spend, and status data reconcile across the source, tracker, and network report?
- What are the media contribution and media ROI using a named date range and attribution rule?
- What changes after direct costs, shared-cost allocations, and any imputed labor are included?
- How much earned commission is still pending, and can the cash balance fund the next campaign period?
- Which segment can you act on—offer, GEO, source, angle, or creative—and what evidence supports that decision?
Use public CPL, EPC, approval-rate, or ROI figures only as context. They may refer to different offers, event definitions, traffic mixes, cost policies, and cohort ages. Your most useful baseline is your own reconciled, mature data under consistent definitions. If a report cannot show its event, denominator, cost base, and timing, it is not ready to justify a scale decision.
