- Google Ads
- Meta Ads
- Shopify
Where should next month's ad budget go?
Every platform says it earned the sale, and the spreadsheet that settles it takes half a day.
old way
half a day (4 hours)with broch
15 minutes
The same job, twice.
The old way
half a day (4 hours)What you need
- Supermetrics or Dataslayera paid connection for every channel
- Power BI or Looker Studioa dashboard someone builds and keeps working
- Google Sheetswhere the numbers get lined up
- A data engineer or analystto stitch it all together
What you do
- 1Pay for a connection to each channel: Google Ads, Meta Ads, Shopify.
- 2Pull all three into a sheet or a dashboard.
- 3Get an analyst to match the dates, currencies and campaign names.
- 4Work out roas per channel. It disagrees with both platforms.
- 5Argue it out in the meeting. Move the budget on a hunch.
With broch
15 minutesWhat you need
- Your brochevery channel already in it
What you do
- 1Open Brainwaves and pick Where is the ad money going? Or ask Claude.
- 2Read spend per channel against what the store took.
- 3Move the budget. The working is there if anyone asks.
Why it's faster.
- Nothing to export. Spend and orders land in the loch every day.
- Nothing to line up. Dates, currencies and campaign names were matched once, at the build.
- Last year comes with it. No second round of exports.
Why it's more accurate.
- One roas, written down. Revenue is what the store took, refunds out. Your team and the AI read the same definition.
- Each platform's claim sits beside the record. Google and Meta both count the same order. You see the gap.
- The odd weeks are flagged. A tracking outage or a bot spike shows as a note before anyone reads it as a trend.
The prompt.
Paste it 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. We'll tell you what it takes.