SEO and content

Indexing audit: published pages Google is not showing

Finds published WordPress pages with zero Search Console impressions, inspects their index status in batches and groups them by cause with a fix for each, read-only.

When to use it

When you have published pages that never show up in Google, get zero impressions, or you suspect an indexing problem.

What you get

A table of inspected URLs grouped by cause (crawled not indexed, never crawled, noindex, canonical conflict, no impressions) with a fix for each group, plus counts to show management.

Does it change anything in my account?

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

Works with

Search Console, WordPress

Fill in before sending

[site name][property URL][maximum URLs to inspect, e.g. 100]

List every published page and post on the WordPress site [site name], with its URL and publish date (page through the results until you have them all). Drop anything published in the last 14 days. Confirm that [property URL] is one of my verified Search Console properties, then pull its page report for the last 90 days with a limit high enough to cover the whole site. Match URLs ignoring http/https, www and trailing slash differences. Flag every remaining published URL that has zero impressions or does not appear in the report at all. Inspect the flagged URLs in batches of 20, newest first, up to [maximum URLs to inspect, e.g. 100] in total. Stop early and tell me if you hit a quota error. For each inspected URL, read the canonical we declare from its WordPress SEO fields. Return a table with these columns: - URL - publish date - verdict and coverage state - last crawl date - robots/indexing state - canonical we declared - Google-selected canonical Group the inspected results: 1) Crawled but not indexed 2) Discovered but never crawled 3) Excluded by noindex or robots 4) Canonical points elsewhere (Google picked a different URL than we declared) 5) Indexed but getting no impressions For each group, give the likely cause and the fix. Fixes include merging thin content, removing a wrong noindex, adding internal links from pages that already get traffic, or redirecting a duplicate. For the 3 most important URLs in groups 1 and 4, run a full single URL inspection for the extra detail. Report the counts so I can show management the scale of the problem: total published pages older than 14 days, how many have zero impressions, how many you inspected, and how many of the inspected ones fall into each group. Do not extrapolate to the uninspected URLs. List them separately as "not inspected yet" so I can run the next batch later. This is read-only. Make no changes.

List every published page and post on the WordPress site [site name], with its URL and publish date (page through the results until you have them all). Drop anything published in the last 14 days.

Confirm that [property URL] is one of my verified Search Console properties, then pull its page report for the last 90 days with a limit high enough to cover the whole site. Match URLs ignoring http/https, www and trailing slash differences. Flag every remaining published URL that has zero impressions or does not appear in the report at all.

Inspect the flagged URLs in batches of 20, newest first, up to [maximum URLs to inspect, e.g. 100] in total. Stop early and tell me if you hit a quota error. For each inspected URL, read the canonical we declare from its WordPress SEO fields. Return a table with these columns:
- URL
- publish date
- verdict and coverage state
- last crawl date
- robots/indexing state
- canonical we declared
- Google-selected canonical

Group the inspected results:
1) Crawled but not indexed
2) Discovered but never crawled
3) Excluded by noindex or robots
4) Canonical points elsewhere (Google picked a different URL than we declared)
5) Indexed but getting no impressions

For each group, give the likely cause and the fix. Fixes include merging thin content, removing a wrong noindex, adding internal links from pages that already get traffic, or redirecting a duplicate. For the 3 most important URLs in groups 1 and 4, run a full single URL inspection for the extra detail.

Report the counts so I can show management the scale of the problem: total published pages older than 14 days, how many have zero impressions, how many you inspected, and how many of the inspected ones fall into each group. Do not extrapolate to the uninspected URLs. List them separately as "not inspected yet" so I can run the next batch later.

This is read-only. Make no changes.

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.