Back to Tools

Title Keyword Gap Finder

Use cases

Finding quick-win title optimisations Identifying high-impression keywords missing from titles Page title refresh campaigns Content optimisation audits

Converts queries and titles to lowercase, splits titles by configurable delimiter (default |), and checks if query appears within any title segment.

Exports Excel via OpenPyXL with conditional row highlighting: green for matched, yellow for missing.

Max keywords per page slider (5-50).

Minimum impressions threshold filter.

Streamlit App GSC Data

Platform

Browser-based (no installation required)

Input

Screaming Frog CSV with Address/URL and Title 1 columns

GSC export CSV

Flexible column naming with auto-detection

Output

Excel: green rows (matched), yellow rows (missing keywords). CSV exports: full results and gaps-only. Top missing keyword frequency analysis.

Launch App View Source

Features

  • Title delimiter configuration (default |)
  • Brand terms exclusion filter
  • URL pattern filter
  • Max keywords per page slider (5-50, default 10)
  • Minimum impressions threshold (0-10,000)
  • OpenPyXL Excel with conditional highlighting

How to use

  1. 1 Export crawl from Screaming Frog
  2. 2 Export GSC query data with page URLs
  3. 3 Upload both files – columns auto-detected
  4. 4 Set title delimiter and brand exclusions
  5. 5 Configure max keywords per page and impression threshold
  6. 6 Download highlighted Excel or CSV

Want me to run this for you?

I offer this as a managed service. You get the insights without touching the tool.

Get in Touch

Related Tools

GSC Coverage Visualiser

Search Console

Visualise indexing issues from Search Console coverage reports with interactive Plotly treemaps and sunbursts.

GSC Data Exporter

Search Console

Bulk download Search Console data beyond the 1,000 row limit with automatic batch processing.

GSC Question Finder

Search Console

Extract question-based keywords from Search Console using regex pattern matching.

Let's work together

Monthly retainers or one-off projects. No lengthy reports that sit in a drawer.

Let's Talk