Campaign ROI reporting without perfect tracking

A campaign report exists to support a decision: scale, hold, or stop. That framing changes what you measure. If the decision is whether to increase budget, you need incremental contribution, not a dashboard of impressions.

Perfect attribution is not available and not required. What is required is a method whose assumptions are stated, a result with a confidence label, and a decision rule agreed before the campaign starts.

Write the decision rule down before the campaign starts: what result would make you increase spend, what would make you pause, and what would make you stop. Retrospective rules tend to justify the spend already committed.

Measurement methods differ in what they can support. Put the strongest available evidence first and say which one produced the number.

Do not present platform-attributed revenue as if it were incremental. The two answer different questions, and mixing them produces confident decisions on weak evidence.

Platform attribution overlaps because the same order can be credited to a search ad, a social view, and an email click. The overlap is not a platform error; it is a consequence of asking each platform to report its own contribution.

Marketing efficiency ratio = total revenue / total marketing spend. Customer acquisition cost = acquisition spend / new customers. Contribution after marketing = gross profit - marketing spend.

Blended metrics are honest about the whole budget but hide channel differences. Use them for the total, and use channel-level tests for reallocation. Never compare a blended figure with a platform figure and call the difference waste.

Marginal cost per acquisition is more useful than average cost when a channel is being scaled, because the next thousand customers usually cost more than the last thousand. Blended metrics also give a sanity check on platform claims: if platform-attributed revenue exceeds total revenue, the attribution is double counting, and the report needs a reconciliation line.

When tracking is incomplete, compare a test group with a control group. A matched region, a holdout postcode, or a paused audience can provide the counterfactual. If none is possible, compare the campaign period with the same weeks in prior periods and adjust for seasonality explicitly.

Adjust for any change in price, promotion, or distribution between the test and control. A control region is only useful if the only meaningful difference is the campaign.

Suppose a test region grows 8 per cent while a matched control grows 2 per cent. The estimated incremental lift is 6 points. On a baseline of 200,000 that is 12,000 of revenue, or 4,800 of contribution at a 40 per cent margin. Against 20,000 of spend, the campaign did not pay back.

One row per campaign: spend, attributed revenue, measured incremental revenue where available, contribution, ratio, payback period, and evidence level. Totals should reconcile to the finance ledger.

A worked report might show spend of 20,000, attributed revenue of 60,000, measured incremental revenue of 12,000, contribution of 4,800, and an evidence level of matched region. The attributed figure and the incremental figure tell different stories, and both belong on the page.

Write the decision rule next to the number it applies to, so the meeting debates the input rather than the conclusion.

Record the hypothesis, the dates, the spend, the control, and the result. Without a log, teams repeat the same test, forget why a channel was paused, and treat a seasonal dip as a permanent finding.

Review the log quarterly and retire assumptions that no longer hold. The goal is not a perfect model; it is a chain of decisions that can be explained and defended.

Date every assumption and note who approved it. When a result is questioned later, the log shows whether the method changed or the market did.