Turn campaign numbers into a weekly report that says what to change
Every Monday Claude reads last week's campaign exports and writes a one-page report: what each campaign delivered, the best and the worst, and what to change this week.
FullMarketingEvery week
Set it up4 steps
Open the Claude desktop app and sign in with the Claude account you use for work. On a personal Free, Pro or Max plan, chats can be used for training unless you switch off SettingsPrivacyHelp improve Claude.
No account yet? Ask your manager.
Where things are in Claude
- CustomizeConnectors In Claude's left sidebar: connect your email and files.
- /schedule Type it in a new Cowork task to run a prompt on a schedule.
- Scheduled In Claude's left sidebar: what runs, to pause or change it.
- Each Monday before 10:00, about 5 minutes: export last week's results per campaign (totals, not lead lists) from your ad accounts and newsletter tool into a Drive folder called Campaigns.
- Connect Google Drive under CustomizeConnectors.
- Type /schedule, paste this workflow's prompt and pick Weekly, Monday at 10:00.
- It runs while your computer is on and Claude is open. A Monday it was off is skipped, not queued.
Set this up on your computer: the Claude desktop app runs it.
The prompt
- Every Monday at 10:00, read last week's campaign exports in my "Campaigns" folder and the report from the week before.
- Write this week's report as a one-page Google Doc in the same folder:
- 1. For each campaign: spend, reach, clicks, leads and cost per lead, against the week before.
- 2. The best and the worst campaign, with the numbers that show it and the likely reason.
- 3. Three changes to make this week, each tied to a number.
- Use only the numbers in the exports. If two exports disagree or a number looks wrong, mark it instead of fixing it.
If your company keeps prices out of AISafe version
Reports results only, from exports without the spend columns: reach, clicks and leads. Spend, budget and cost per lead stay out.
What you get
A one-page report built only from the exports, with three changes tied to the numbers behind them.
Get this workflow for your team
Two minutes each: everyone gets a plan of ready workflows like this one, inside your company's rules.
Your manager sees progress and hours. Never what Claude reads or writes.
FirstPrompt's workflow library adapts parts of Anthropic's knowledge-work-plugins (Apache-2.0), rewritten by FirstPrompt. Source and licence