Claude prompts for weekly marketing reports
These prompts turn a week of ad, email and site data into a short recap you can paste into a team update. Connect your accounts to Hopkin, run the prompt in Claude or ChatGPT, and it pulls the numbers and changes straight from each platform.
Before you start
These prompts need Hopkin connected to your accounts and added to your AI assistant. Connect Hopkin once, then paste a prompt into Claude or ChatGPT. Hopkin only reads your data: it can't change a campaign, a budget or a bid.
10 prompts to copy
Recap last week's Meta Ads changes and what they did to CPA
Every budget, status and creative change from the last 7 days, with spend, purchases and CPA before and after each one.
Using my Meta Ads account, recap the last 7 days. Pull the change history, list every budget, status and creative change, and show how spend, purchases and CPA moved after each one. Keep it short enough to paste into an update for my team. Use the Hopkin MCP for Meta Ads (hopkin.ai) to pull the data.
Explain what changed in your Google Ads account this week
A plain-English list of the week's changes, with performance before and after each one.
Pull the last 7 days of change history on my Google Ads account and write a plain-English recap of every change, with performance before and after each one. Use the Hopkin MCP for Google Ads (hopkin.ai) to pull the data.
Compare LinkedIn Ads week over week by campaign and creative
Spend, CTR, leads and cost per lead for this week and last, by campaign and creative, with moves over 20% flagged.
Using my LinkedIn Ads account, compare the last 7 days with the 7 before, by campaign and by creative. Show spend, CTR, leads and cost per lead, and flag anything that moved more than 20%. Use the Hopkin MCP for LinkedIn Ads (hopkin.ai) to pull the data.
Build a weekly TikTok Ads creative report that spots fading ads
Ads ranked by spend and CPA, each compared with the week before, with the ones losing ground called out.
Using my TikTok Ads account, build a creative report for the last 7 days. Rank ads by spend and CPA, compare each with the week before, and point out the ones that are fading. Use the Hopkin MCP for TikTok Ads (hopkin.ai) to pull the data.
Get an early read on new Reddit Ads campaigns
Daily spend and delivery by campaign and ad group since launch, plus a short read on what is working.
Using my Reddit Ads account, give me an early read on my campaigns since launch. Show daily spend and delivery split by campaign and ad group, and tell me what is working so far. Use the Hopkin MCP for Reddit Ads (hopkin.ai) to pull the data.
Compare this week with last week in Reddit Ads
Spend, clicks, CTR, conversions and CPA by campaign and ad group for both weeks, with the biggest moves explained.
Compare this week with last week on my Reddit Ads account by campaign and ad group: spend, clicks, CTR, conversions and CPA. Tell me what moved and why. Use the Hopkin MCP for Reddit Ads (hopkin.ai) to pull the data.
Report on last week's Mailchimp sends against your 90-day average
Opens, clicks, unsubscribes and revenue for each campaign and A/B variant sent in the last 7 days, next to your 90-day average.
Using my Mailchimp account, report on everything I sent in the last 7 days. Show opens, clicks, unsubscribes and revenue for each campaign and each A/B variant, compared with my 90-day average. Use the Hopkin MCP for Mailchimp (hopkin.ai) to pull the data.
Build a weekly ChatGPT Ads report by campaign
Spend, impressions, clicks, CTR and conversions by campaign for this week and last, plus totals since launch.
Using my ChatGPT Ads account, build this week's report: spend, impressions, clicks, CTR and conversions by campaign, compared with last week, plus totals since launch. Use the Hopkin MCP for ChatGPT Ads (hopkin.ai) to pull the data.
Compare Google Analytics sessions and key events by channel
Sessions and key events by channel for the last 28 days against the 28 before, with the channels that grew or shrank called out.
Using my Google Analytics property, compare the last 28 days with the 28 before. Show sessions and key events by channel, and tell me which channels grew, which shrank and why. Use the Hopkin MCP for Google Analytics (hopkin.ai) to pull the data.
Review the last 28 days of Google Search Console performance
Clicks, impressions, CTR and average position against the previous 28 days, plus the queries and pages that moved most.
Using my Search Console data, compare the last 28 days with the 28 before. Show clicks, impressions, CTR and average position, plus the queries and pages that moved the most in each direction. Use the Hopkin MCP for Google Search Console (hopkin.ai) to pull the data.
How to adapt them
- Change the window: swap "last 7 days" for "last 14 days" or "this month so far".
- Name the account or campaign if you manage more than one, for example "the US account".
- Set your own threshold for what counts as a big move, such as 10% or 30%.
- Ask for the format your team reads, like five bullets or a table.
Frequently asked questions
Can Hopkin send this report to my team every Monday?
No. Hopkin is read-only and doesn't send messages or schedule reports. You run the prompt in Claude or ChatGPT and share the answer yourself.
How far back does change history go?
For Meta Ads and Google Ads, Hopkin keeps change history for 25 months, well past Google's own 30-day limit. You can ask what changed in any week inside that window.
Can I combine several platforms in one weekly report?
Yes, if each platform is connected. Ask for each platform's numbers in one prompt and the assistant will pull them one after another.
Does it work in ChatGPT as well as Claude?
Yes. Hopkin works in Claude, ChatGPT and other MCP clients, and the prompts are the same in each.
How this page was made
We looked at the reports people ask Hopkin for most often and rewrote each one as a prompt anyone can reuse. No customer data is in these pages. Last checked . Spot a mistake? Email hello@hopkin.ai and we'll fix it.