Affiliate Reporting: Why Daily Unique Visitors Do Not Add Up

A daily report can be accurate in every row and still produce a misleading weekly total. This happens when an affiliate team adds distinct visitor counts across days and calls the result unique weekly visitors. The same measured visitor may appear on several days. This proposed reporting check helps media buyers and publishers distinguish activity across days from reach across a reporting period.

Define what is being counted

First identify the measurement unit: a reported user identifier, a browser identifier, an account or another documented unit. A distinct identifier is not automatically a distinct person. Keep the platform's definition alongside the number, including any known coverage limits, rather than silently renaming the metric as people reached.

Next identify the deduplication window. Daily uniqueness means an identifier is counted once within a day. Weekly uniqueness requires deduplication across the entire week. These are different operations even when the underlying records are identical.

Use a small overlap example

In a hypothetical dataset, Monday contains identifiers A, B and C. Tuesday contains B, C and D. Each day has three distinct identifiers, so the sum of daily distinct counts is six. Across both days, the union is A, B, C and D: four distinct identifiers. The total of six describes the sum of daily counts, not two-day unique reach.

If the export contains only the numbers three and three, the overlap cannot be reconstructed from those totals alone. For these two days, the combined distinct count could range from three to six. Do not select a value within that range by assumption and report it as measured reach.

Choose a defensible reporting route

• Use a whole-period distinct metric from the same measurement system when its definition and filters are documented.
• If authorized data already includes a suitable identifier, calculate distinct counts over the full period using consistent inclusion rules.
• If only daily aggregates are available, label their sum as a sum of daily unique counts and leave period-level reach unavailable.

Do not collect additional personal data merely to make a reporting table look complete. A clearly labeled missing metric is more useful than an unsupported precision claim.

Protect downstream rates

A ratio inherits the meaning of its denominator. Orders divided by the sum of daily unique visitor counts should not be labeled a weekly visitor conversion rate. Even a whole-period distinct visitor denominator does not prove that the numerator counts converting visitors: one visitor may place multiple orders. Name the ratio according to the units actually measured.

For media buying reviews, keep spend, orders, clicks and distinct identifiers in separately defined columns. This makes performance marketing media buying discussions easier to audit without implying that the metrics share the same attribution or counting rules.

Make the report reproducible

Record the date range, time zone, filters, identifier definition and deduplication window. Include a short note wherever daily distinct counts are summed. The same principle applies when combining device, placement or geographic rows that may overlap. Correct period-level counting supports clearer comparisons; it does not, by itself, demonstrate incremental reach or campaign profitability.