All templates
Google Ads Media Plan
Turn a budget and a goal into a monthly Google Ads plan — grounded in your account's real CPCs and conversion rates, not industry averages.
Sources
Google Ads
Runs in
ClaudeChatGPT
Output
ExcelPDF
Frequency
QuarterlyOn-demand
The prompt
Copy this into Claude or ChatGPT with your HYPD MCP connected, then swap in your account details.
Copy
Prompt
Build a Google Ads media plan.
Inputs (ask me for any that are missing before you start):
- Ad account: [account name or ID — or "new account, no history"]
- Planning period: [e.g. Q4 2026, next 6 months]
- Budget: [total or monthly, and how flexible]
- Goal: [target ROAS or CPA, plus any revenue/lead target]
- Market: [country + language]
- Output format: [Excel, PDF, or both]
Steps:
1. If an account exists: hypd: google_ads_run_gaql — pull 12 months of performance per campaign type (CPC, CVR, ROAS/CPA, seasonality).
2. hypd: research_get_search_volume + research_estimate_ad_traffic — check search demand and headroom for the core keyword themes; for new accounts this replaces account history.
3. Allocate the budget across campaign types (Brand / Search / Shopping / PMax / Demand Gen) based on marginal performance and headroom — don't scale a line past its available demand.
4. Forecast per line: spend, clicks, conversions, revenue or leads — state every assumption (CVR, CPC trend, seasonality) so I can adjust it.
5. Return a monthly plan table (Month | Campaign type | Budget | Est. clicks | Est. conversions | Est. ROAS/CPA) in the chosen format(s), plus the top 3 risks to the plan.
How it works
- 1
Sign up for HYPD
Create your HYPD account, connect your ad accounts, and set per-client permissions so AI only ever sees what you allow.
- 2
Connect Claude or ChatGPT
Add the HYPD MCP to your AI tool so it can read your live ad data, read-only and GDPR compliant.
- 3
Paste the prompt and run
Copy the prompt above into Claude or ChatGPT and run it. It returns real results from your own accounts.