Back to Tools

Legacy Tool

This tool requires the old Universal Analytics (pre-GA4) data format. It may still work if you have historical UA exports, but is not compatible with GA4.

Underlinked High-Value Pages

Use cases

Prioritising internal linking for revenue impact Finding hidden gem pages that deserve more visibility Data-driven internal link building

Merges GSC internal links data with GA Universal Analytics landing page performance using pandas.

Implements percentile-based filtering to isolate pages in the bottom 10% for internal links.

Uses glob for wildcard file matching (Analytics*.xlsx, *target*.csv) and urllib.parse for domain extraction.

Streamlit App

Platform

Browser-based (no installation required)

Input

GSC internal links CSV

GA Landing Pages Excel export (Dataset1 sheet)

Files must match patterns: Analytics*.xlsx and *target*.csv

Output

CSV with Target page, Internal links, Sessions, Users, Transactions, Goals, Goal Conversion Rate – filtered to bottom 10% of internal links.

Launch App View Source

Features

  • Percentile-based internal link threshold (default: bottom 10%)
  • Glob wildcard file matching for batch imports
  • Pandas merge on target page URLs
  • Configurable keep percentage for filtering
  • Outputs Sessions, Users, Transactions, Goals, Goal Conversion Rate

How to use

  1. 1 Export "Top linked pages internally" from GSC as CSV
  2. 2 Export Landing Pages from GA as Excel (Behavior > Site Content)
  3. 3 Place both exports in the same folder matching naming patterns
  4. 4 Configure the keep percentage (default 10%)
  5. 5 Run to merge and filter by internal link percentile

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

Best Sellers to XML Sitemap

E-commerce

Generate XML sitemaps from GA landing page exports filtered by top transactions or revenue.

Category Page Suggester

E-commerce

Suggest new category pages based on product H1 n-grams and search demand.

eCommerce Image Centering Tool

E-commerce

Center 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