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

Turn incremental sessions into revenue, contribution, net return and a break-even month against real SEO costs.

What it decides
  Whether SEO is paying back, by month and cumulatively, after real costs, and when it broke even.

Files
  SEO ROI Calculator.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  SEO ROI 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: the audit trail (Source reference)
  Full steps: HOW-TO-USE-WITH-DATAFORSEO.txt (also in the Automation folder), with example-request.json

Quick start
  1. Estimate incremental sessions: Sessions above a baseline or control, not total organic sessions.
  2. Add conversion and value: Use organic conversion rate, average order value and your contribution margin.
  3. Enter real costs: Retainer, salaries share, content, tools and dev time spent on SEO, per month.
  4. Read the cumulative line: The chart shows when cumulative net crosses zero: your payback month.

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-roi-calculator/
Part of the SEO Business & Delivery Toolkit: https://optimizationtheory.com/download-view/seo-business-toolkit-10-forecasting-and-delivery-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
