How does the tool decide a keyword is missing from a title?

It splits each title on the delimiter and compares GSC queries against those segments as whole strings (lowercased, exact equality). A query only counts as 'in the title' if it exactly equals a complete segment. That means 'running shoes sale' is still suggested for the title 'Running Shoes | Brand', because no segment equals the full query, even though the words overlap.

Why was a keyword not suggested even though it is missing from that page's title?

The exclusion check is global, not per page: a GSC query is removed from suggestions if it matches a title segment on any analysed page. So if 'leather bags' is a title segment on one category, it will never be suggested for any other page either, even where those pages earn clicks for it.

Do the crawl URLs and GSC page URLs need to match exactly?

Yes. Title keywords are extracted per exact URL string and the current title is looked up the same way, so protocol, www or trailing-slash differences between the two exports mean the page's existing title keywords are never extracted and its current title shows blank. That inflates suggestions with keywords already in the title. Export both files against the same canonical URL format.

What if my titles do not use the pipe character?

Change the delimiter in the sidebar (default is |). If your titles use a different separator such as ' - ' and you leave the default, each whole title becomes a single segment, almost nothing matches, and nearly every query is suggested as missing.

How does brand exclusion behave?

It is a case-insensitive substring filter applied to both GSC queries and title keywords: anything containing the brand string anywhere is removed. A short or generic brand name (for example 'Gap') will also strip unrelated queries, so use the most distinctive form of your brand.

Back to Tools

Category Title Suggester

Use cases

Category page title optimisation Finding missing keywords in titles E-commerce title improvements Data-driven title rewrites

Splits existing page titles on a configurable delimiter (default "|") to extract the keywords already targeted, then compares them against GSC queries for the same pages.

Queries that earn clicks but are missing from the title become suggestions, ranked by clicks.

Auto-detects URL, title, page, query, and clicks columns from the uploaded files, with optional brand name exclusion.

Streamlit App

Platform

Browser-based (no installation required)

Input

Crawl CSV with URL and page title columns (Screaming Frog, Sitebulb)

GSC performance CSV with page, query, and clicks columns

Output

CSV/Excel of suggested keywords per page with clicks and current title, plus a Summary sheet with suggestion counts and total clicks per page.

Launch App View Source

Features

Title splitting on configurable delimiter (default |)
URL filter to isolate category pages (default /category/)
Auto-detection of URL/title/query/clicks columns
Brand name exclusion from queries and title keywords
Minimum clicks threshold and max suggestions per page (3-20, default 10)
Two-sheet Excel export with per-page summary

How to use

1 Upload the crawl export and confirm URL/title columns
2 Upload GSC data and confirm page/query/clicks columns
3 Set the URL filter, title delimiter, and brand exclusion
4 Set minimum clicks and max suggestions per page
5 Click Analyze Titles and review per-page suggestions
6 Download CSV or Excel

Frequently asked questions

How does the tool decide a keyword is missing from a title?: It splits each title on the delimiter and compares GSC queries against those segments as whole strings (lowercased, exact equality). A query only counts as 'in the title' if it exactly equals a complete segment. That means 'running shoes sale' is still suggested for the title 'Running Shoes | Brand', because no segment equals the full query, even though the words overlap.
Why was a keyword not suggested even though it is missing from that page's title?: The exclusion check is global, not per page: a GSC query is removed from suggestions if it matches a title segment on any analysed page. So if 'leather bags' is a title segment on one category, it will never be suggested for any other page either, even where those pages earn clicks for it.
Do the crawl URLs and GSC page URLs need to match exactly?: Yes. Title keywords are extracted per exact URL string and the current title is looked up the same way, so protocol, www or trailing-slash differences between the two exports mean the page's existing title keywords are never extracted and its current title shows blank. That inflates suggestions with keywords already in the title. Export both files against the same canonical URL format.
What if my titles do not use the pipe character?: Change the delimiter in the sidebar (default is |). If your titles use a different separator such as ' - ' and you leave the default, each whole title becomes a single segment, almost nothing matches, and nearly every query is suggested as missing.
How does brand exclusion behave?: It is a case-insensitive substring filter applied to both GSC queries and title keywords: anything containing the brand string anywhere is removed. A short or generic brand name (for example 'Gap') will also strip unrelated queries, so use the most distinctive form of your brand.

Want me to run this for you?

I run this tool as a managed service, or build something custom around your data. You get the insights without touching the code.

Tell Me What You Need

Meta Description GraderAppContent

Score and compare meta descriptions using OpenAI GPT models on key SEO criteria.

Meta Description RewriterAppContent

Rewrite meta descriptions using AI with proper length optimisation.

Content Reviewer (LLM)AppContent

Review web content and get AI-powered annotations with improvement suggestions.

Keyword Extractor (LLM)AppContent

Extract and categorise keywords from content for internal linking opportunities.

Gist Summary GeneratorAppContent

Create "At a glance" bullet point summaries from articles using AI.

Robots.txt TesterBrowserTechnical SEO

Test if a URL is allowed or blocked by robots.txt rules.

Need something built for your business?

This tool started as bespoke client work. I build custom scripts, data pipelines, and full apps for SEO and product data problems that off-the-shelf tools don't solve.