Deduplicating affiliate conversions

A duplicate conversion is one of the quietest ways an affiliate program leaks money. Nothing looks broken — the conversions are real — but the same sale gets counted twice, and you pay twice. Deduplication is the unglamorous discipline of making sure one purchase produces exactly one credited conversion, no matter how many times it's reported.

Why do duplicate conversions happen?

Duplicate conversions happen when the same sale gets reported to your tracker more than once, usually from harmless mechanics rather than fraud. A network retry resends a postback, a user refreshes the confirmation page and re-fires a pixel, or two tracking systems both claim the same order. The intent is innocent; the effect is double credit.

• Retries: a postback times out, the sender retries, and the conversion is recorded twice.
• Page reloads: a client-side conversion fires again when the thank-you page is refreshed.
• Multiple tags: more than one tracking script on the conversion page each report the sale.
• Channel overlap: an affiliate conversion and a separate marketing channel both claim the same order.

How do duplicate conversions hurt you?

They hurt you twice: they inflate payouts and they poison your data. Every double-counted conversion is commission paid on a sale that earned it once, and a metric — conversion rate, partner ranking, ROI — quietly skewed. Decisions made on inflated data compound the loss beyond the duplicated payout itself.

What is the best way to deduplicate conversions?

The best defense is order-key idempotency: require a unique order reference on every conversion and refuse to credit the same reference twice. If your tracker sees an order ID it has already recorded, it ignores the repeat. This single rule kills the most common duplicates — retries, reloads, and double tags — because they all carry the same order key.

1. Order-key idempotency: include a unique order reference in every conversion event and dedupe on it. First report wins; repeats are dropped.
2. Time-window dedupe: as a backstop, collapse near-identical conversions for the same user within a short window.
3. Channel priority: when affiliate and another channel both claim an order, define which wins so it's credited once, deliberately.
4. Refund reconciliation: ensure a refunded-and-rebought order doesn't double-count across the reversal.

Dedup isn't about catching liars — it's about counting honestly. The same true sale reported five times is still one sale, and one sale is what you should pay for.

Afflio's cookieless S2S postbacks carry an order reference with every conversion, so the tracker can enforce order-key idempotency natively: the same order can't be credited twice no matter how many times it's reported. Combined with the clearing window before payout, this means duplicates are dropped at ingestion and never reach a commission.