Affiliate Reporting: Verify How Percentages Are Stored

Prevent hundredfold reporting errors by checking whether affiliate rate fields store fractions, percentage numbers, or formatted text.

A familiar label can hide different units

An affiliate report may label a column conversion rate while storing its values in several ways. One export might use 0.025, another 2.5, and another the text 2.5%. Those values can all describe the same rate under different conventions. Before a media buyer uses the column to compare ecommerce CPS or virtual-product campaigns, the import process needs an explicit unit rule.

Rebuild one rate from counts

Use a row with a known numerator and denominator under the same date range and event definition. In a hypothetical example, 5 conversions from 200 clicks gives 5 divided by 200, or 0.025, which is 2.5%. Compare that result with the raw exported value and the displayed cell. This is a storage and formatting check, not evidence that the hypothetical performance is representative.

Distinguish numeric values from appearance

Inspect the underlying value and data type in the analysis tool. Applying a percentage display to the numeric value 2.5 may display 250%, even if the source intended 2.5%. Conversely, treating 0.025 as an already scaled percentage would understate the intended rate. Text that includes a percent sign requires deliberate parsing. Keep an untouched source export and a documented conversion rule so a later reviewer can reconstruct the transformation.

Check more than one row

Include a zero row, a low nonzero rate, and a larger rate. Missing values should remain distinguishable from zero. Do not infer the storage convention solely because all observed values are below one: a campaign can legitimately have a percentage below 1%. When counts are available, calculate the rate from those counts and investigate disagreement instead of silently adjusting individual cells until they look plausible.

Protect budget decisions from unit errors

For recurring reports, record the source field, raw unit, target unit, and display format alongside the import mapping. Recheck the mapping when an export format changes. Keep rate calculations separate from money fields and avoid averaging campaign rates without their denominators. A clean percentage column makes comparisons interpretable, but it does not validate attribution, order approval, or profitability. Those require their own evidence before a budget increase.

Visit BlueFriday's media buyer page for the broader performance marketing context.