Retail media performance analytics: sales and spend

Retail media performance analytics compares campaign spend with attributed sales and the margin those sales leave. Reconcile the campaign file, state the attribution rules and calculate contribution alongside revenue return. A campaign can have a higher revenue return while leaving less after advertising because its product margin is lower.

Start with comparable campaign exports

Keep retailer, campaign ID, campaign dates, extraction date, currency, spend, attributed units, attributed sales, returns and attribution method. Add the eligible SKU list and the source's treatment of click-through purchases, view-through purchases and related products. Export the invoice detail and a finance-approved revenue and cost mapping alongside the campaign file.

Use the same completed attribution window when comparing campaigns. The IAB/MRC Retail Media Measurement Guidelines call for disclosed attribution windows and distinguish attribution from the causal question of incrementality. A credited purchase can be valid under the reporting rules without proving that advertising created the sale.

If your question concerns choosing tools rather than checking campaign economics, use retail media AI analytics for that separate evaluation.

Align retailer sales with the brand's margin

A retailer's shopper sales are not automatically the revenue a CPG brand recognizes. Do not multiply shelf-price sales by a wholesale gross margin and call the result brand profit. Ask finance to map the attributed units to the brand's revenue and cost basis, including returns and applicable allowances.

Keep retailer-reported return on advertising spend in its original column. Add a separately labeled brand revenue return only when that mapping is available. If the mapping is missing, report sales and spend together and leave the margin calculation incomplete. Gross profit margin explains the revenue and cost definitions behind that calculation.

Work the campaign economics

An illustrative US packaged-food brand compares two campaigns with a completed 14-day, click-only attribution window. Each covers its advertised SKUs only. Finance has supplied the attributed brand revenue equivalents and matching product costs below; those amounts are after trade allowances but before the separately displayed returns. Spend includes the campaign media and service fees being evaluated.

Place this input table in A1:E3. Campaign labels include the retailer; all amounts are USD.

In F2, calculate net attributed brand revenue:

=C2-D2

In G2, calculate brand revenue return:

=IF(B2=0,"",F2/B2)

In H2, calculate gross profit:

=F2-E2

In I2, calculate contribution after advertising:

=H2-B2

Fill down to row 3. A blank return ratio for zero spend needs a note rather than an invented result. The figures are:

Revenue return is net attributed brand revenue divided by spend, displayed to two decimals. North is $28,000 / $6,000 = 4.67x. Its $8,400 gross profit less $6,000 advertising leaves $2,400. South's higher 5.00x revenue return leaves nothing after advertising because $20,000 − $16,000 − $4,000 = $0.

North's gross margin is $8,400 / $28,000 = 30.0%; South's is $4,000 / $20,000 = 20.0%. The margin difference explains why the revenue-return ranking does not match the contribution ranking. This contribution excludes any costs not listed in the table and does not establish incremental profit.

Reconcile before ranking campaigns

The input controls are $6,000 + $4,000 = $10,000 spend, $30,000 + $24,000 = $54,000 revenue before returns, $2,000 + $4,000 = $6,000 returns, and $19,600 + $16,000 = $35,600 COGS. The output proof is $54,000 − $6,000 − $35,600 − $10,000 = $2,400.

Use totals for the combined revenue return:

=SUM(F2:F3)/SUM(B2:B3)

That is $48,000 / $10,000 = 4.80x. Do not average campaign ratios. For a larger file, retain retailer in column J, then summarize net revenue for the retailer named in L2:

=SUMIFS($F$2:$F$1000,$J$2:$J$1000,L2)

Microsoft's SUMIFS documentation explains the criteria-based sum used here. Use the same criteria for spend and cost, and check that retailer summaries reproduce the control totals. Covirage is not affiliated with Microsoft.

Match spend with invoices and finance's revenue mapping with the underlying attributed product totals. Attributed revenue is a subset or reporting allocation; it should not be added to total company sales as extra revenue. Retail customer analytics addresses the separate question of customer behavior beyond the campaign attribution rules.

Where it goes wrong

• Unlike attribution rules. A longer lookback, view-through credit or broader product scope can change credited sales. Preserve those differences instead of hiding them in one ranking.
• Immature campaigns. Purchases can continue arriving within the stated window. Record when the file was extracted.
• Revenue and margin on different bases. Shopper spending and supplier revenue need a documented bridge before calculating brand contribution.
• Duplicate credit. The same purchase may appear in multiple campaign reports. Sum only mutually exclusive allocations or label the aggregate as potentially overlapping.
• Attributed called incremental. This arithmetic checks reported economics. A causal budget claim requires separate evidence about what would have happened without the advertising.

Check your campaign files in Covirage

Bring a sample of your own campaign export, spend records and finance-approved revenue and cost summary to Covirage. Covirage maps the columns, its tools compute and check the figures, and the external AI model explains the result with every figure traced to its rows. Create a free Covirage account, then set up your business and bring your files.

See Covirage for CPG brands for the supporting industry approach.