Affiliate Reporting: Explain the Total Behind Every Share

A campaign can account for half of a filtered report and a much smaller share of the overall business at the same time. In performance marketing media buying, both numbers can be correct. The reporting problem begins when a share is presented without its denominator. This proposed quality check helps affiliates and advertisers make share-of-total tables interpretable.

Write the metric as a sentence

Before calculating a share, define what is being divided by what. For example: approved commission for one campaign divided by approved commission for all campaigns in the selected market and date range. Include the status, currency basis, and reporting period. A generic column named revenue share leaves too much to interpretation.

This is a composition metric. It does not measure conversion rate, commission rate, or the campaign's profitability. Keep those questions in separate columns with their own definitions.

Use one example to expose the filter choice

Consider a hypothetical dataset with approved commission of 120 for campaign A, 80 for campaign B, and 200 for campaign C, all on the same currency and reporting basis. Campaign A represents 120 / 400 = 30% of the complete dataset. If a view includes only A and B, it represents 120 / 200 = 60% of that selected subset.

Label the first value as share of all campaigns and the second as share within the selected subset. The underlying commission for A has not changed. Presenting the shift from 30% to 60% as growth would confuse a reporting choice with a business result.

Decide what hidden rows mean

• If rows are hidden for readability, retain the full denominator and include an Other row or explain the omitted share.
• If filters intentionally define a smaller population, name that population in the table title.
• If a search box narrows displayed rows without changing calculations, state that behavior.
• If exports differ from the dashboard, verify the denominator in each before reconciling percentages.

Do not automatically rescale every visible table to 100%. That can conceal how much activity sits outside the displayed campaigns. Conversely, a table explicitly describing a selected subset should not silently use an unrelated global total.

Check the edge cases before using the chart

For a zero denominator, report the share as undefined rather than assigning a percentage. If negative adjustments are included, explain that signed amounts can produce negative shares or values above 100%; a conventional pie chart may obscure that meaning. Small differences from 100% can also arise from display rounding, so verify the underlying values before changing them.

Teams working on media buying for affiliates can keep the denominator definition beside each saved report. Before discussing CPS offer scaling, confirm whether a changing share reflects a campaign result, movement elsewhere in the portfolio, or a changed filter. A larger share alone is not a reason to increase spend.