Automated Northbeam Weekly ROAS Scorecard
Every Monday morning, WebRun opens Northbeam, reads last week's attributed revenue, spend, and ROAS for every marketing channel, exports a dated row per channel to a Google Sheet, and drafts a short recap email in Gmail ranking channels by performance, leaving it in your drafts folder for leadership to review and send.
How do I get a weekly ROAS scorecard from my Northbeam attribution data?
WebRun reads last week's channel level ROAS and spend in Northbeam every Monday, exports a dated row per channel to a Google Sheet, and drafts a ranked recap email in Gmail. Leadership gets a clear read on which channels earned their spend, ready to send, without anyone pulling numbers out of Northbeam by hand.
- Leadership gets a ranked channel scorecard every Monday without asking for one
- A running spreadsheet history builds automatically for trend review
- The weakest performing channel gets flagged before more budget goes to it
Built for Performance marketing teams · E-commerce brands · Media buyers · Marketing leadership
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
northbeam.ioin a real browser with your saved login - no setup, no API keys. -
1
Northbeam - read last week's channel attribution
- Open Northbeam and read last week's attributed revenue and spend by channel
- Calculate ROAS for each channel
- Rank channels from best to worst performing
Done when Every active channel has last week's revenue, spend, and ROAS.
-
2
Google Sheets - export the numbers
google.com
WebRun opens Google Sheets to export the numbers. - Append a new row for each channel with the week's date and figures
- Keep prior weeks' rows untouched below
- Highlight the top and bottom performing channels
Done when This week's row is added for every channel.
-
3
Gmail - draft the recap email
gmail.com
WebRun opens Gmail to draft the recap email. - Draft a recap email ranking channels by ROAS
- Call out the biggest gainer and the weakest performer
- Leave the email as a draft. Never send it without review
Done when A recap email is waiting in Gmail drafts for leadership.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Will the recap email go out without anyone reviewing it?
No. WebRun only drafts it in Gmail. Nothing reaches leadership's inbox until someone reviews and sends it.
Does WebRun change our Northbeam attribution model?
No. It only reads the ROAS and revenue numbers Northbeam already calculates. Attribution settings and models are never touched.
Can we track more channels than the default ones?
Yes. Point WebRun at every channel you track in Northbeam and it exports all of them into the same weekly sheet.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.