E-commerce Page Title Optimiser
Use cases
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.
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.
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 Export crawl from Screaming Frog (internal_html.csv)
- 2 Export keyword data from Google Search Console
- 3 Upload both files
- 4 Select title delimiter and set brand name (optional)
- 5 Configure max suggestions per page (3-20)
- 6 Filter by URL path if needed
- 7 Download three-sheet Excel report
Want me to run this for you?
I offer this as a managed service. You get the insights without touching the tool.
Related Tools
Best Sellers to XML Sitemap
E-commerceGenerate XML sitemaps from GA landing page exports filtered by top transactions or revenue.
Category Page Suggester
E-commerceSuggest new category pages based on product H1 n-grams and search demand.
eCommerce Image Centering Tool
E-commerceCenter product images using OpenCV multi-method contour detection with threshold fallbacks.
Let's work together
Monthly retainers or one-off projects. No lengthy reports that sit in a drawer.
Let's Talk