Google ads media plan
Skill kastriasani/google-ads-skills/skills/google-ads-media-plan
Build a quarterly Google Ads media plan, budget, and 90-day rollout roadmap. Allocates a monthly or quarterly budget across campaign types (Brand Search, Non-brand Search, Shopping, Performance Max, Demand Gen, Display, YouTube) by CAC, CPA, and ROAS efficiency, with conservative, moderate, and aggressive scenarios and a phased launch plan. Use when the user asks to plan a Google Ads budget, build a paid search media plan or roadmap, split spend across campaign types, forecast conversions or ROAS, decide brand vs non-brand allocation, size a quarterly or monthly PPC budget, or plan a phased campaign rollout. Triggers on phrases like media plan, budget allocation, campaign roadmap, paid search forecast, how much should I spend on Google Ads, and quarterly PPC plan.From its SKILL.md
npx -y skills add kastriasani/google-ads-skills --skill google-ads-media-planAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
One thing to look at
- 0 stars0 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
SKILL.md
5.2 KB, 984 tokens by cl100k_base, as published. Nobody here has run it
Google Ads Media Plan
Turn a budget and a goal into an approved quarterly Google Ads media plan: how much to spend, on which campaign types, to hit which target, and in what order to launch. This is the planning document a client or finance team signs off on before a single campaign goes live.
When to use
Use this skill when the user wants to:
- Plan or size a Google Ads budget for a month or quarter.
- Decide how to split spend across campaign types (Brand, Non-brand Search, Shopping, Performance Max, Demand Gen, Display, YouTube).
- Forecast conversions, CPA, or ROAS for a planned budget.
- Settle the brand vs non-brand allocation question.
- Produce a phased 90-day rollout roadmap with launch gates.
If the user instead wants to build the actual account structure and upload file,
use google-ads-campaign-setup. If they want ad copy, use google-ads-ad-copy.
Workflow
-
Gather the essentials. Ask only for what is missing: total budget and period (month or quarter), primary goal (lead gen or ecommerce sales), conversion definition, target CPA or target ROAS, and average revenue per conversion (AOV, or pipeline value x close rate for lead gen). If the user pastes a CSV of historical campaign performance, use those CPC and CVR numbers instead of defaults.
-
Allocate the budget. Run
scripts/budget_allocator.pyto split the budget across campaign types by efficiency and produce conservative / moderate / aggressive scenarios. The script ranks each type by CPA (lead gen) or ROAS (ecommerce), nudges high-intent capture ahead of cold reach, and fills to realistic capacity ceilings. Example:python3 scripts/budget_allocator.py --budget 90000 --period quarter --goal sales --aov 120Why: funding the demand you can convert most efficiently first protects CPA before you pay to create new demand. Seereferences/budget-allocation.md. -
Forecast the ramp. Run
scripts/growth_simulator.pyto project month-by-month spend, conversions, revenue, and cumulative ROAS across three rollout paces (Steady / Balanced / Fast), accounting for the learning period and efficiency improvement. Example:python3 scripts/growth_simulator.py --start-budget 20000 --months 6 --cpa 45 --aov 120Why: a budget total hides the truth that month 1 runs inefficiently while the account learns. The simulator shows when the plan reaches break-even. -
Assemble the plan. Fill in the sections in
references/media-plan-template.md: summary, goal and economics, allocation table, scenario forecast, the 90-day phased rollout, measurement plan, and risks. Present the moderate scenario as the recommendation with conservative and aggressive as the sensitivity band. -
Sequence the rollout. Use the phased rollout table in the template. Launch high-intent capture first, prove CPA, then scale and add prospecting. State the exit gate for each phase so scaling is earned, not assumed.
Inputs and data sources
This skill runs standalone. The minimum input is a budget and a goal; the scripts ship with defensible benchmark defaults so they produce a full plan with no account data. Quality improves with real data:
- Pasted CSV or numbers: historical CPC, CVR, CPA, or ROAS per campaign type.
Pass overrides to the allocator via a
--fileJSON. - Google Ads API: pull actual campaign-type performance to replace benchmarks.
- GA4: conversion values and assisted-conversion data for demand-gen channels.
- Search Console: query and impression data to size non-brand opportunity.
- Google Sheets / BigQuery: store the plan and forecast outputs for sharing.
When the user has no data, state that the numbers are benchmark estimates and must be re-forecast after 30 days of actuals.
Outputs
- A quarterly media plan document following
references/media-plan-template.md. - A budget allocation table across campaign types with shares and target CPA/ROAS.
- A three-scenario forecast (conservative / moderate / aggressive).
- A month-by-month ramp projection with break-even.
- A 90-day phased rollout roadmap with per-phase launch gates.
References
references/media-plan-template.md- the full quarterly plan sections plus the 90-day phased rollout table and pacing rules.references/budget-allocation.md- allocation frameworks, percentage splits by business model, the brand vs non-brand discipline, and the testing reserve.
What ships with it: 5 files
52.9 KB alongside SKILL.md, 2 of them executable
assets/
- example.html19.7 KB
references/
- budget-allocation.md5.0 KB
- media-plan-template.md4.6 KB
scripts/
- budget_allocator.pyruns14.1 KB
- growth_simulator.pyruns9.4 KB