SEO Visibility Score Calculator (Optimization Theory, v3.0, November 2026)
=====================================================================

Weight rankings by search volume and CTR to see real visibility gains and losses across a fixed keyword set.

What it decides
  Whether your visibility for a stable keyword set went up or down, and which keywords drove the change, measured in modeled clicks rather than average position.

Files
  SEO Visibility Score Calculator.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  SEO Visibility Score Calculator - Field Guide.pdf  the illustrated guide
  Input-Template-blank.csv ..... column headers in paste order
  Input-Template-example.csv ... the worked example (Northbeam Outdoor, fictional data)
  HOW-TO-USE-WITH-DATAFORSEO.txt step-by-step: request, save, convert, complete, paste
  Automation/ .................. import script, example request, field mapping (python3 Automation/dataforseo_import.py --help)

Built to run on DataForSEO
  Source: DataForSEO Labs: Ranked Keywords
  Fills automatically: Keyword, Monthly searches, Current rank
  Full steps: HOW-TO-USE-WITH-DATAFORSEO.txt (also in the Automation folder), with example-request.json

Quick start
  1. Fix your keyword set: Choose the keywords you'll track every period and keep the list stable, so changes reflect rankings, not list edits.
  2. Enter both periods' ranks: Add current and previous ranks. Use 0 for not ranking within your tracked depth.
  3. Apply a CTR curve: Enter the CTR for each rank, ideally from your own Search Console data. The template ships with a typical curve in the example.
  4. Read the losers first: The Dashboard lists the biggest modeled losses first. Investigate those before celebrating the gains.

Works in Microsoft Excel, Google Sheets (upload, then open with Sheets) and LibreOffice Calc.
Paste values only at Workspace cell A13. Lime cells are inputs; blue cells are formulas.

Full tutorial: https://optimizationtheory.com/download-view/seo-visibility-score-calculator/
Part of the Keyword Research Toolkit: https://optimizationtheory.com/download-view/keyword-research-toolkit-6-seo-planning-workbooks/
All 40 templates: https://optimizationtheory.com/download-view/free-seo-geo-toolkit-40-spreadsheets-and-field-guides/

Free to use in your own and client work. Please don't resell the templates themselves.
Built by Jourdan Rombough, optimizationtheory.com
