Reconcile Megaphone ad revenue for you
Every Monday, WebRun opens Megaphone, pulls impressions delivered, fill rate, and revenue for last week's ad campaigns, logs each as a row in Google Sheets, and updates your Notion content calendar with what carried an ad.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I reconcile Megaphone ad campaign delivery and revenue?
WebRun pulls each ad campaign's fill rate and revenue from Megaphone every Monday, reconciling delivered impressions against what was booked. It logs the numbers as rows in Google Sheets and updates your Notion content calendar to show which episodes carried which campaigns, so under-delivery gets caught the week it happens instead of at month-end reporting.
- Under-delivering campaigns get caught the same week
- Ad revenue is reconciled without exporting reports by hand
- The content calendar always shows what actually carried an ad
Built for podcast networks · ad ops teams · media companies · podcast sales
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
megaphone.fmin a real browser with your saved login - no setup, no API keys. -
1
Megaphone - pull ad campaign performance
megaphone.fm
WebRun opens Megaphone to pull ad campaign performance. - Open Megaphone and list ad campaigns that ran last week
- Capture impressions delivered, fill rate, and revenue per show
- Note any campaign that under-delivered against its booking
Done when Every campaign that ran last week has its delivery and revenue captured.
-
2
Google Sheets - reconcile fill rate and revenue
google.com How to Automate Google Sheets
WebRun opens Google Sheets to reconcile fill rate and revenue. - Log each campaign's impressions, fill rate, and revenue as a row
- Flag campaigns that under-delivered against booking
- Update the running monthly revenue total
Done when Last week's ad performance is reconciled in Google Sheets.
-
3
Notion - update the content calendar
notion.so How to Automate Notion
WebRun opens Notion to update the content calendar. - Update the content calendar to show which episodes carried which campaigns
- Note any show that's under-delivering on inventory
- Leave renegotiating a campaign to your ad ops team
Done when The Notion content calendar reflects last week's ad delivery.
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
Does it change my ad campaigns in Megaphone?
No. WebRun only reads delivery and revenue numbers. Adjusting or renegotiating a campaign stays with your ad ops team.
What counts as under-delivering?
Any campaign whose impressions delivered fall short of what was booked, flagged in Sheets so it doesn't go unnoticed.
Does this affect what listeners hear?
No. It only reconciles numbers after the fact. Ad insertion and what plays in each episode is entirely Megaphone's doing.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.