SEO and content

Monthly organic ranking report for management

A read-only monthly update built from stored rank history, Search Console and GA4: position buckets, top winners and losers, organic sessions and key events, and a plain-language executive summary.

When to use it

When it is time for the monthly organic update and you need to show management what moved in rankings and traffic and why.

What you get

A month-over-month report with position buckets, top 5 winners and losers, organic sessions and key events for their pages, and a 5-bullet executive summary.

Does it change anything in my account?

No. The assistant only reads your data and reports back.

Works with

SEO Intelligence, Search Console, GA4

Fill in before sending

[domain]

Prepare the monthly organic ranking update for management for [domain]. Compare the last 30 days with the 30 days before that. I run this in the first days of each month. 1. Read stored rank history for our tracked keywords over the last 60 days. It is free and needs no new credits. If the history does not cover both periods (tracking started recently or was stopped), say so clearly, and use Search Console average position for the missing period instead. 2. From Search Console, pull query and page data for the last 30 days and for the last 60 days. Derive the previous 30 days' clicks and impressions by subtracting the first from the second. Do not subtract positions; take positions from rank history. 3. From GA4, pull sessions and key events by landing page for the last 30 and the last 60 days, split by channel, and keep Organic Search only. Derive the previous period the same way. Deliver the following: 1. A bucket table showing the count of keywords in the top 3, top 10, positions 11-20 and not ranking, for this period vs the previous one. 2. The top 5 winners and top 5 losers by position change. Include only moves of 3 or more positions. Show the ranking URL, the change in clicks and the change in impressions. 3. Organic sessions and key events for the landing pages behind those winners and losers. 4. A 5-bullet executive summary in plain business language covering what moved, the likely reason and what we do next. If you use an SEO term, explain it in one line. Flag every keyword whose position improved while clicks fell. That pattern often means a SERP feature or an AI Overview is taking the click, but treat it as a hypothesis. Check seo_history for any AI Overview check already run on those keywords and use it. If I want confirmation for the rest, list them and ask before running new AI Overview checks, since they cost credits. This is reporting only. Do not change anything.

Prepare the monthly organic ranking update for management for [domain]. Compare the last 30 days with the 30 days before that. I run this in the first days of each month.

1. Read stored rank history for our tracked keywords over the last 60 days. It is free and needs no new credits. If the history does not cover both periods (tracking started recently or was stopped), say so clearly, and use Search Console average position for the missing period instead.
2. From Search Console, pull query and page data for the last 30 days and for the last 60 days. Derive the previous 30 days' clicks and impressions by subtracting the first from the second. Do not subtract positions; take positions from rank history.
3. From GA4, pull sessions and key events by landing page for the last 30 and the last 60 days, split by channel, and keep Organic Search only. Derive the previous period the same way.

Deliver the following:
1. A bucket table showing the count of keywords in the top 3, top 10, positions 11-20 and not ranking, for this period vs the previous one.
2. The top 5 winners and top 5 losers by position change. Include only moves of 3 or more positions. Show the ranking URL, the change in clicks and the change in impressions.
3. Organic sessions and key events for the landing pages behind those winners and losers.
4. A 5-bullet executive summary in plain business language covering what moved, the likely reason and what we do next. If you use an SEO term, explain it in one line.

Flag every keyword whose position improved while clicks fell. That pattern often means a SERP feature or an AI Overview is taking the click, but treat it as a hypothesis. Check seo_history for any AI Overview check already run on those keywords and use it. If I want confirmation for the rest, list them and ask before running new AI Overview checks, since they cost credits.

This is reporting only. Do not change anything.

Open in Claude Open in ChatGPT Discuss in the forum

More prompts

SEO and contentRead-only

Build intent-based keyword clusters from a few seed keywords

A ranked list of keyword clusters with volume, difficulty and the right page type or ad group for each.

When to use itWhen you are starting keyword research for a business and only have a few seed keywords.

I sell [product or service] in [city or country]. Start from these seed keywords: [3 to 5 seed keywords].

First check seo_history so you reuse earlier results instead of paying for the same query twice. Then use Keyword Planner and SEO keyword research to collect ideas with average monthly searches, competition and keyword difficulty.

Clean the list:
- remove keywords under 30 monthly searches
- remove job, free, DIY, course and competitor-brand terms unless they clearly fit my business
- merge close variants and plurals

Cluster the rest by search intent, with one cluster per distinct need a searcher has. For each cluster give:
- cluster name and head keyword
- 5 to 10 supporting keywords
- combined monthly volume and average difficulty
- intent: informational, commercial or transactional
- best use: service page, blog post or a Google Ads ad group

Rank the clusters by volume and fit for a small business with a limited budget. Mark the top 3 to start with and explain why in one line each.

SEO and contentChanges after your approval

Turn search terms that convert in ads into organic content clusters

Uses 90 days of converting Google Ads and Microsoft Ads search terms to find topics where you pay for conversions but have weak or no organic visibility. Returns a prioritized content plan and a preview-only list of keyword additions.

When to use itWhen you pay for conversions on search terms but are unsure which topics deserve organic content so you can rely less on ads.

I want to use my ad data to decide what to write about. Use the last 90 days on every source.

1. Pull my Google Ads search terms for the last 90 days (days=90, or an explicit start and end date), sorted by conversions. Keep only terms with at least 1 conversion. If the response is truncated, page through until you have every converting term.
2. If Microsoft Ads is connected, find the default account and pull its search terms for the same 90 days. Keep only terms with at least 1 conversion and add them to the pool, marking which platform each term came from.
3. Group all converting terms into topic clusters by search intent. For each cluster show total cost, conversions and cost per conversion, split by platform where both are present.
4. Find my Search Console property (use [site property] if I named one) and pull organic data for the last 90 days with dimension query, plus a page,query pull so you can see which page ranks for each query. Use a high enough limit to cover the long tail.
5. Match each cluster to the Search Console queries that express the same intent. Use your judgement for close variants and wording differences, and say which queries you counted. Report organic clicks, impressions and average position per cluster, and the page that ranks best for it if there is one.

Classify each cluster:
- Content gap: converts in ads, organic average position worse than 10 or no organic impressions. I should build a page.
- Improve: converts in ads, organic position 4 to 10. Name the existing page that needs strengthening.
- Covered: organic position 1 to 3. Note it as a possible place to test lower ad spend later.

Deliver a table sorted by ad conversions, then the top 5 content-gap clusters with a suggested page title and URL slug for each.

Separately, list my Google Ads keywords (list_entities, entity keywords) and show converting Google search terms that are not yet keywords in the account. For Microsoft terms, just flag them; do not check or change Microsoft keywords. Do not add anything. If you think some Google terms should be added as exact match, tell me which ad group each one belongs in and run add_keywords with confirm=false so I see the exact preview. Wait for my approval before applying.

SEO and contentChanges after your approval

Cluster the searches that find my Business Profile and fix my services

Clusters of the real Google Search and Maps queries behind your listing, compared with your services and categories, plus a previewed fix.

When to use itWhen your Business Profile gets views but you suspect your services and categories do not match what people really search for on Google and Maps.

For my Business Profile location [location name], pull the search terms people used on Google Search and Maps to find the listing over the last 3 months.

Cluster the terms into:
- brand searches
- service searches, with one cluster per service
- "near me" and neighborhood or district searches
- problem-based searches, such as a symptom or an issue the customer has

For each cluster show total impressions and the top 5 terms.

Then read my listing details: primary and additional categories, and the services list. Compare them with the clusters and tell me:
- service clusters with real demand that are missing from my services list
- services I list that get almost no searches
- whether an additional category would match a strong cluster. Search the category names to confirm they exist.

Draft the new service entries, with a name and a description of up to 300 characters for each, written around the words people actually search.

Show me the exact changes as a preview first. Do not update the listing until I approve.

SEO and contentRead-only

Build a seasonal content and ad calendar from keyword demand

A 12-month calendar showing when each keyword cluster peaks, when to publish content and when to raise or lower ad budgets.

When to use itWhen you want to time content and ad budgets around real seasonal demand instead of guessing when interest peaks.