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

Rank every keyword by the profit it could add per hour of work, not by search volume alone.

What it decides
  Which keywords deserve your next hours of work, ranked by the monthly profit each could add per hour invested, with every assumption visible and editable.

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

Quick start
  1. Export your keywords: Pull keywords with search volume from your keyword tool, and your current CTR per keyword from Google Search Console (clicks ÷ impressions). Use 0 if you don't rank.
  2. Set realistic targets: Enter a target CTR for the position you can credibly reach, your conversion rate, value per conversion and an attainment factor (0.5 = you expect to capture half the modeled gain).
  3. Estimate effort honestly: Add the work hours for each keyword: writing, design, dev and links. Effort is the denominator, so lowball guesses distort the ranking more than anything else.
  4. Sort and commit: Sort Workspace by Monthly profit / hour, or read the Top 10 on the Dashboard. Commit to the top of the list and record the source export in Source reference.

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/keyword-prioritization-template/
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
