MarketingWeekly and monthly paid ads reports from your exports
Paid media reporter
Hand it your Google Ads, Meta, LinkedIn or any other ad export and it maps the columns once, keeps a clean history and builds the same report every week and month: spend, results and cost by campaign, against the period before, with short commentary on what moved and why. When someone asks for a number, it drafts the answer with the date range and the file it came from. It never changes a campaign and never sends or posts without your yes.
- Works with
- Google SheetsGoogle DriveGmailSlackNotion
- Recommended model
- Claude Opus 5.5
- Skills
- 7
What it does
- Reads exports from Google Ads, Meta, LinkedIn or any ad CSV and maps them to one set of fields
- Keeps a dated metrics history so every report uses the same numbers
- Builds a weekly report by campaign against last week, with the top movers
- Builds a monthly report with a three month trend and budget pacing
- Explains what moved and why, with the number behind every sentence
- Drafts answers to reporting questions with the date range and source
The skills it brings
Playbooks the mate follows when the job calls for them. You can read and edit every one after adding it.
/pmr-map-exportpmr-map-exportUse when the person hands over an ad platform export, adds a platform, an export's headers change, or before any report or reporting answer so the history is current.
/pmr-weekly-reportpmr-weekly-reportUse when a week closes, when the person asks how last week went or wants a week-over-week read, or when the weekly report routine runs.
/pmr-monthly-reportpmr-monthly-reportUse when a month closes, when the person asks for a monthly or month-over-month read or a budget pacing check, or when the monthly report routine runs.
/pmr-what-movedpmr-what-movedUse when the person asks why a paid media number changed, or when a weekly or monthly report needs its commentary written.
/pmr-reporting-askpmr-reporting-askUse when someone asks for a paid media number in chat, by email or in Slack, or when the person pastes a reporting question and wants a reply drafted.
/pmr-report-filepmr-report-fileUse when a weekly or monthly paid media report is written and needs its self-contained HTML file with tables and charts, ready to attach or share.
/ads-mathAds mathsCalculating ad economics from the person's numbers: CPA, ROAS, break-even CPA and ROAS, profit per sale, LTV to CAC and payback, MER, impression share opportunity, and budget forecasts with scenarios, always showing the formula and inputs.
Things to ask it
Here's last week's Google Ads export. Build the report.How did Meta do in September compared to August?Why did our cost per lead go up last week?Draft a reply to this question from my boss: …