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.

BCG Matrix Generator

Use cases

Identifying high-revenue/low-traffic anomalies Strategic content portfolio analysis by folder Drilling down into category performance Presenting folder-level ROI to stakeholders

Creates BCG matrix charts from Google Analytics Excel exports using matplotlib.

Normalizes sessions and revenue to 0-100 scale, sizes bubbles by session volume, and divides into four quadrants at 50/50 crosshairs.

Auto-generates cascading reports one URL depth level deeper for each category folder.

Jupyter Notebook

Platform

Jupyter Notebook (requires Python environment)

Input

GA landing page Excel export

Output

BCG matrix PNG charts by category

View Source

Features

  • Four-quadrant BCG framework (Finders, Keepers, Losers, Weepers)
  • Cascading reports one folder level deeper per category
  • Bubble sizing proportional to session volume
  • Configurable url_depth for folder extraction (default 2)
  • 300 DPI PNG export for presentations

How to use

  1. 1 Export GA landing page report as Excel
  2. 2 Upload to notebook
  3. 3 Set url_depth for folder extraction level
  4. 4 Configure quadrant labels and text styling
  5. 5 Download PNG charts (main + cascading by category)

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

Google Trends Forecasting

Reporting

Forecast search trends using NeuralProphet ML.

Resolution Screenshot Tool

Reporting

Capture screenshots at GA visitor resolutions using Pyppeteer async browser automation.

Core Update Analyser

Reporting

Analyse Google core update impact by URL folder using Ahrefs data.

Let's work together

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

Let's Talk