Where should next month's ad budget go?
Every platform says it earned the sale. The budget meeting turns into an argument about whose roas is right, and the spreadsheet that settles it takes half a day to build.
The same job, twice.
The old way
5 steps- 1Export last month's campaign report from Google Ads, then the same from Meta Ads Manager.
- 2Export the store's orders for the same dates, refunds included.
- 3Line the three files up in a spreadsheet: date formats, currencies, campaign names that don't match.
- 4Work out a roas per channel, and find it disagrees with both platforms.
- 5Argue it out in the meeting, then move the budget on a hunch.
With broch
3 steps- 1Open Brainwaves and pick Where is the ad money going?, or ask the same question from Claude.
- 2Read spend per channel against the revenue the store took, with each platform's claim beside it.
- 3Move the budget. The working is on the screen if anyone asks.
Why it's faster.
Nothing to export.
Spend and orders land in the loch every day, so the month is already there when you ask.
Nothing to line up.
Dates, currencies and campaign names were matched once, when the loch was built. Nobody redoes it each month.
Last year comes with it.
The same month a year ago arrives with the answer. No second round of exports.
Why it's more accurate.
One roas, written down.
Revenue means what the store took, refunds out, every order counted once. Your team agreed it, and the AI reads the same definition you do.
Each platform's claim sits beside the record.
Google and Meta both count the same order. The answer shows what each one claims and what the store took, so the gap is there to read and nobody has to argue it.
The odd weeks are flagged.
A tracking outage or a bot spike is recorded as a data note, and the answer mentions it before anyone reads a dip as a trend.
The prompt.
The words we typed. Paste them into Brainwaves, or Claude connected to your broch over MCP.
Where is the ad money going? For last month, show spend by channel against the revenue the store took, refunds out, with each platform's own claimed revenue beside it. Compare with the month before and the same month last year. Flag any data notes that affect the period, then tell me what you would shift and why.
Run this play on your own numbers.
Tell us which channels you run and where the data lives. We'll tell you what it takes to run this on them, starting with a free one-hour discovery call.