Ad platforms
Campaign, channel and date
Marketing spendFRESHBI · ONE SHARED SALES MODEL
From campaign data to a decision.
All channels · 3 sample campaigns
Start with three connected inputs.
Bring spend, sales and margins into the same campaign context.
Orders
Product, campaign and order date
Observed sales · USDProduct mix margins
Gross margin for each campaign's mix
Applied to sales above baselineMatch the keys. Keep the context.
The same channel selection follows every input into one shared model.
CampaignLink spend to sales
Product mixApply the campaign's margin
DateCompare the same period
| Campaign | Category | Mix margin |
|---|
Margins reflect each campaign's product mix, so rates can differ within a category. The baseline is assumed.
Does the extra revenue cover the spend?
Compare observed sales with the assumed baseline, then apply margin.
Sales above baselineObserved minus assumed sales
Marketing spendCampaign cost in this period
Contribution after spendExtra gross profit minus spend