SEO and content

Ranking losses on pages that actually sell, with root cause

Finds the organic ranking and click losses of the last 28 days, weights them by GA4 organic purchases per landing page, and diagnoses the top pages with URL inspection and a live SERP check. It uses stored rank history when it exists and falls back to Search Console when it does not. Read-only.

When to use it

When rankings have slipped and you need to know which losses are actually costing sales and why.

What you get

A table of pages that lost rankings, sorted by organic purchases with a priority level, plus a likely cause and next action for the top 5.

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][site][GA4 property][minimum purchases]

Find which ranking losses are costing us sales on [domain] (Search Console property: [site], GA4 property: [GA4 property]). Step 1: find the losses. - Read the stored rank history for [domain] over the last 30 days (free). List keywords that dropped out of the top 10, or lost 3 or more positions. - If there is no stored history, or it covers only a few keywords, say so plainly and use Step 2 as the main source of losses. Get current positions from the domain's ranked keywords (check seo_history first so we reuse a recent run). Step 2: confirm with Search Console. - Pull page,query rows for the last 28 days and for the last 56 days. Derive the previous 28 days by subtraction: clicks and impressions = 56-day value minus 28-day value. Previous position = (56-day position × 56-day impressions − 28-day position × 28-day impressions) / previous impressions. - Flag page,query pairs that lost 3 or more positions, or fell from top 10 to beyond 10, and calculate click change per page. Step 3: weight by sales. - List the key events and confirm the purchase event name. - Pull GA4 for the last 90 days by landing page with channel as the second dimension, and keep Organic Search for sessions and key events. If the property has several key events, also run landing page × event so the purchase count is isolated. If organic and purchase cannot be isolated together, say which number you used. Deliver one table, sorted by organic purchases, with these columns: - landing page - lost keywords - average position change - click change % - organic purchases (90 days) - priority Priority rule: - High: the page has ≥ [minimum purchases] organic purchases and lost ≥ 20% of clicks. - Medium: one of those two conditions is true. - Low: the rest. For the top 5 high-priority pages: - Inspect the URL in Search Console: indexing, chosen canonical, last crawl. - Run a live SERP check on the biggest lost keyword to see who replaced us and with what kind of page. Give a one-line likely cause and next action per page. If the stored history was missing, end with a list of the 20 keywords I should start tracking, but do not start tracking them. This is read-only, so change nothing.

Find which ranking losses are costing us sales on [domain] (Search Console property: [site], GA4 property: [GA4 property]).

Step 1: find the losses.
- Read the stored rank history for [domain] over the last 30 days (free). List keywords that dropped out of the top 10, or lost 3 or more positions.
- If there is no stored history, or it covers only a few keywords, say so plainly and use Step 2 as the main source of losses. Get current positions from the domain's ranked keywords (check seo_history first so we reuse a recent run).

Step 2: confirm with Search Console.
- Pull page,query rows for the last 28 days and for the last 56 days. Derive the previous 28 days by subtraction: clicks and impressions = 56-day value minus 28-day value. Previous position = (56-day position × 56-day impressions − 28-day position × 28-day impressions) / previous impressions.
- Flag page,query pairs that lost 3 or more positions, or fell from top 10 to beyond 10, and calculate click change per page.

Step 3: weight by sales.
- List the key events and confirm the purchase event name.
- Pull GA4 for the last 90 days by landing page with channel as the second dimension, and keep Organic Search for sessions and key events. If the property has several key events, also run landing page × event so the purchase count is isolated. If organic and purchase cannot be isolated together, say which number you used.

Deliver one table, sorted by organic purchases, with these columns:
- landing page
- lost keywords
- average position change
- click change %
- organic purchases (90 days)
- priority

Priority rule:
- High: the page has ≥ [minimum purchases] organic purchases and lost ≥ 20% of clicks.
- Medium: one of those two conditions is true.
- Low: the rest.

For the top 5 high-priority pages:
- Inspect the URL in Search Console: indexing, chosen canonical, last crawl.
- Run a live SERP check on the biggest lost keyword to see who replaced us and with what kind of page.

Give a one-line likely cause and next action per page. If the stored history was missing, end with a list of the 20 keywords I should start tracking, but do not start tracking them. This is read-only, so change nothing.

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.