Back to Tools

E-commerce Page Title Optimiser

Use cases

Category page title optimisation Product page SEO Finding title keyword gaps Data-driven title rewrites

Splits page titles using configurable delimiters (|, -, :, —), normalises to lowercase, and creates keyword sets per URL.

Compares GSC query keywords against title keyword sets to flag missing terms.

Suggestions sorted by click volume with configurable max per page (3-20).

Optional brand name exclusion.

Exports three-sheet Excel via xlsxwriter.

Streamlit App

Platform

Browser-based (no installation required)

Input

Screaming Frog CSV with Address and Title 1 columns

GSC export with Query, Page, Clicks, Impressions (flexible column names)

UTF-8 and Latin-1 encoding supported

Output

Excel: All Suggestions, Top 20 Opportunities, Summary by Page (aggregated with top 5 keywords concatenated). Paginated interactive table.

Launch App View Source

Features

  • Configurable title delimiters: |, -, :, —
  • Click-volume ranked suggestions
  • Max suggestions slider (3-20 per page)
  • Optional brand name exclusion
  • URL path filtering for specific sections
  • Three-sheet Excel export via xlsxwriter

How to use

  1. 1 Export crawl from Screaming Frog (internal_html.csv)
  2. 2 Export keyword data from Google Search Console
  3. 3 Upload both files
  4. 4 Select title delimiter and set brand name (optional)
  5. 5 Configure max suggestions per page (3-20)
  6. 6 Filter by URL path if needed
  7. 7 Download three-sheet Excel report

Let's work together

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

Let's Talk