Build a 12-month demand and competitor activity calendar
Combines 12-month search demand, competitor ad activity and your monthly Google Ads results into one planning calendar. It sets budget weights per month and flags when new copy and offers need to be ready.
When to use it
When you need to plan monthly Google Ads budgets around seasonality and competitor timing instead of spreading spend evenly.
What you get
A 12-month table with demand index, competitor activity, your results and a budget weight per month, plus the 2-3 months when new copy and offers must be ready.
Does it change anything in my account?
No. The assistant only reads your data and reports back.
Works with
SEO Intelligence, Google Ads
Fill in before sending
[country or region][core keywords][language][competitor brand names or domains][country code]
Help me plan my budget around seasonality. This is a planning document. Do not change any budgets or campaigns.
0. Check seo_history first. If a trend or paid keyword run for these keywords or competitors can still be reused, reuse it.
1. Demand:
- Get the Google Trends interest for my 5 core service keywords in [country or region]: [core keywords].
- Then look up the geo id for [country or region] and pull Keyword Planner historical metrics for the same keywords, covering the last 12 months with language [language], so I also see real monthly search volumes.
- For each month, build a demand index where my peak month = 100. Base it on the combined monthly volumes, and use Trends as a cross-check. Remember that Trends gives relative interest only.
2. Competitors: pull the live ads of [competitor brand names or domains] from the Google Ads Transparency Center for region [country code].
- If the results include first-shown or start dates, use them to show which months each competitor launches seasonal campaigns or promotions, and what they offer.
- If dates are missing or a competitor has no data, which is common for small advertisers, write "no timing data". Don't invent it.
- Then run competitor paid search for each competitor domain to see their current ad headlines, offers and landing pages. Treat this as a snapshot of today, not a history.
3. My performance: run a GAQL query on my Google Ads account for the last 12 full months, segmented by month (segments.month). Pull cost, conversions and cost per conversion, and calculate my annual average cost per conversion.
Combine everything into one table: month | demand index | competitor activity (or "no timing data") | my conversions | my cost per conversion | recommended budget weight.
Set budget weights with these rules:
- Raise the weight in months where demand is above 80 and my cost per conversion stays within 20% of my annual average.
- Lower it in months where demand is below 50 or my cost per conversion is more than 40% above average.
- Otherwise keep it neutral. Show the weights so they add up to 100% across the year.
Also list:
- The 2-3 months where I should have new ad copy and offers ready, based on the demand peaks and when demand starts climbing.
- How many weeks before each peak competitors usually start. Only give this where start dates were returned, and label it an estimate. Where no dates exist, use the month demand starts rising as the lead-time signal instead.
Do not change any budgets or campaigns.
A one-page brief mapping who advertises in the client's market, where, with what message, and where the client stands today.
When to use itWhen you are about to start with a new client and need to understand who they compete against in paid and organic search before the kickoff call.