Campaign Analytics Agent
Reports ROAS and acquisition cost by campaign.
- Industry
- Oil & Gas
- Department
- Marketing
- Team
- Demand Generation
- Kind
- Investigator
- Approver
- Head of Fuels Marketing
- Code
- MKT-09
It reports return on ad spend and acquisition cost by campaign for retail fuel, loyalty, fuel cards and lubricants, attributing station visits, card sign-ups and lubricant orders. When results move away from target it works out why: seasonality, pump price moves, competitor offers, tracking or creative. **The problem it solves:** Why campaign results moved away from target: which campaigns and product lines, by how much, since when, and what changed in prices, competitors, seasons, tracking or creative.
How it works
6 steps, and a person signs off before step 6.
- 01Looks it up
Finds the record the request is about in the CRM and the loyalty and fuel card database: campaign-attributed sign-ups, accounts, loyalty redemptions and the margin from attributed station and card transactions for the period..
- 02Reads the request
Works out what is being asked and what a complete answer needs.
- 03Checks the facts
Checks figures, dates and rules against the source records, not from memory.
- 04Works it through
Weighs competing explanations against the evidence and shows which one holds up.
- 05Asks a person
Hands the work to Head of Fuels Marketing with its reasoning before anything goes out.
- 06Acts
Once approved, it acts in the marketing reporting workspace: it publishes the campaign report to the named audience. and records what was done.
What it works with
Your knowledge, your systems, your people.
Knows
The marketing measurement standard: the attribution model, how station visits and loyalty redemptions are matched to campaigns, margin per litre by fuel, targets by product line and the report audiences.
Reads from
the CRM and the loyalty and fuel card database: campaign-attributed sign-ups, accounts, loyalty redemptions and the margin from attributed station and card transactions for the period.
Acts in
the marketing reporting workspace: it publishes the campaign report to the named audience.
Hands back
An object with totals (spend_usd, margin_usd, roas and cac_usd), campaigns (a list, each with name, product_line, spend_usd, roas, cac_usd and vs_target), variances (a list, each with campaign, metric, change_percent and cause), causes (a ranked list with cause, evidence and confidence) and recommendations (a list).
Asks a person when
The report recommends cutting or pausing spend, the platform and CRM disagree by more than 20 percent, or the report goes to executives or partners.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Attribution model | position-based | How credit is shared across touches. |
| Target return on ad spend | 3.5 | Attributed gross margin per dollar of spend. |
| Target cost per fuel card customer (USD) | 120 | Acquisition cost a new fuel card account should not exceed. |
| Variance that needs explaining (%) | 15 | A result this far from target or last period is explained. |
| Platform and CRM gap that is a tracking issue (%) | 20 | When the ad platform and CRM disagree by more than this, tracking is checked first. |
Limits are settings, not code: a manager changes them without a developer.
Rules it always follows
- Report spend, margin, ROAS against 3.5 and fuel card acquisition cost against 120 using the position-based model.
- Explain any result 15 percent from target or last period, weighing seasonality, pump price moves against competitors, competitor promotions, tracking and creative.
- When the platform and CRM disagree by more than 20 percent, check tracking before blaming the campaign.
- Use margin, not litres or revenue, for ROAS, because pump price moves inflate revenue.
- Never present a cause as certain; give the evidence and how to confirm it.
See the Campaign Analytics Agent agent on your own work.
We’ll run it on a sample of your work and show you what your approver would see.