Back to Tools

Share of Voice Calculator

Use cases

Competitive market analysis by traffic share Tracking visibility changes over time Identifying market leaders in a keyword set Client reporting on organic market share

Calculates Share of Voice as (Domain Traffic / Total Traffic) × 100 with 2 decimal precision.

Automatic domain column detection with UTF-8/Latin-1 encoding fallback.

Filters unwanted domains via regex pattern matching.

Exports multi-sheet Excel workbook via xlsxwriter with embedded column chart.

Streamlit App

Platform

Browser-based (no installation required)

Input

Ahrefs Traffic by Domain CSV from Keywords Explorer

Bad domains CSV for exclusion (optional)

Output

Excel with share of voice rankings

Launch App View Source

Features

  • SOV formula: (Domain Traffic / Total Traffic) × 100
  • Auto domain column detection with encoding fallback
  • Regex-based bad domain filtering
  • Top N domains slider (5-50)
  • Excel export with embedded column chart (xlsxwriter)
  • Summary metrics: domain count, total traffic, leader SOV

How to use

  1. 1 Export Traffic by Domain from Ahrefs Keywords Explorer
  2. 2 Upload CSV (auto-detects UTF-8 or Latin-1 encoding)
  3. 3 Select domain column if auto-detection fails
  4. 4 Upload optional bad domains list to exclude
  5. 5 Set Top N domains (5-50) and download Excel

Let's work together

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

Let's Talk