Ecommerce SEO Prioritization Template (Optimization Theory, v3.0, November 2026)
===========================================================================

Rank product pages by potential orders, unit contribution and profit per hour, and catch out-of-stock or noindex SKUs.

What it decides
  Which products deserve SEO work first, based on the profit each could earn per hour invested, and which are blocked by stock or indexing.

Files
  Ecommerce SEO Prioritization Template.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  Ecommerce SEO Prioritization Template - 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: Keyword Overview
  Fills automatically: Page URL, Keyword, Monthly searches
  Full steps: HOW-TO-USE-WITH-DATAFORSEO.txt (also in the Automation folder), with example-request.json

Quick start
  1. Join catalog and keyword data: One row per SKU: URL, target keyword, volume, price, variable cost, stock and indexability.
  2. Set target CTR and conversion rate: Use realistic CTR for an achievable position and your product page conversion rate.
  3. Estimate effort: Hours to improve the page: copy, images, reviews, schema, internal links.
  4. Work the ranked list: Sort by contribution per hour. Fix stock or indexing first for flagged SKUs.

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/ecommerce-seo-template/
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
