Keyword Prioritization Template
Keyword Prioritization Template
Rank every keyword by the profit it could add per hour of work, not by search volume alone.
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.
- Excel workbook (.xlsx), opens in Google Sheets
- PDF field guide, 9 to 11 pages
- Blank and worked CSV templates
- DataForSEO import script
Free, no email required. Version 3.0, updated November 2026.
=IF(J13="","",IF(J13<>"Ready","n.a.",K13*E13*F13))The formula above is the real one from cell L13. Scroll it sideways to read the whole rule.
Connected to the DataForSEO API
This template is designed around one DataForSEO endpoint. Pull the data, convert it with one command, and the workbook does the rest.
DataForSEO Labs: Keyword OverviewSearch volume, monthly history, difficulty and intent for a list of keywordsdataforseo_labs/google/keyword_overview/live
Save the JSON responseThe full API response, kept as your source of truth.response.json
Run the import scriptOffline. No API calls, no credentials.dataforseo_import.py import --template 01
Paste at A13Dashboard, checks and action list update instantly.Keyword Prioritization Template.xlsx
Column map for this template:Filled by the APIAudit trail (automatic)You add
What the keyword prioritization template decides
Most keyword lists get sorted by search volume, then difficulty, and that's where prioritization stops. The problem is that volume says nothing about whether the traffic converts, how much of it you can realistically win, or how many hours it will take to get there. A 40,000-search keyword you already rank fifth for can be worth less than a 2,400-search keyword you could move from page three to the top three with one good page.
This keyword prioritization template turns a raw keyword export into a ranked work queue. For each keyword it estimates the clicks you'd add by moving from your current CTR to a realistic target CTR, converts those clicks into monthly profit, then divides by the hours the work will take. The result is a single, defensible number for every keyword: added profit per work hour.
Who it's for
- SEOs choosing which pages to build or improve next quarter
- Agencies that need to justify a keyword plan to a client in money, not rankings
- Content leads with more ideas than writers
- Ecommerce teams deciding between category, product and guide content
Where it fits in your workflow
The keyword prioritization template answers one question. These three templates answer the questions around it:
- Keyword Mapping Template: which single URL should own each keyword, and where your map assigns the same query to two different pages.
- SERP Overlap Keyword Clustering Template: whether two queries should be targeted by one page or separate pages, based on how many ranking URLs their SERPs share.
- Keyword Gap Analysis Template: which competitor-ranked queries you have no coverage for, how big each opportunity is, and which ones need a new page.
What's inside the download
One ZIP with the workbook, a 9-column input template (blank and filled), the PDF field guide and an offline script that converts saved DataForSEO responses into the input CSV. The workbook has five tabs.
How the keyword prioritization template calculation works
Added clicks = search volume × (target CTR minus current CTR, never below zero) × attainment. Added profit = added clicks × conversion rate × value per conversion. Profit per hour = added profit ÷ work hours. Every input is a cell you can change, so a stakeholder who disagrees with an assumption can change it and watch the ranking move, instead of arguing about a black-box score.
The key formula, exactly as it appears in the workbook
=IF(J13="","",IF(J13<>"Ready","n.a.",K13*E13*F13))
| Result column | Plain-English formula | What it tells you |
|---|---|---|
| Added clicks / month | Monthly searches × MAX(0,Target CTR-Current CTR) × Attainment factor | Searches multiplied by the positive CTR gap and the attainment assumption. |
| Added profit / month | Added clicks ÷ month × Conversion rate × Value per conversion | Expected added clicks multiplied by conversion rate and contribution per conversion. |
| Monthly profit / hour | Added profit ÷ month ÷ Work hours | Monthly contribution opportunity per implementation hour. |
How to use the keyword prioritization template
- Export your keywordsPull 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.
- Set realistic targetsEnter 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).
- Estimate effort honestlyAdd 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.
- Sort and commitSort 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.
The worked example in the Workspace tab. Clear the lime input cells, paste your CSV at A13 (values only) and every result recalculates.
Fill the keyword prioritization template with DataForSEO
Every template in this library is built to run on DataForSEO data. This one uses DataForSEO Labs: Keyword Overview: search volume, monthly history, difficulty and intent for a list of keywords.
Most of the data columns fill automatically. Add the business inputs listed below, then paste.
- Request the dataSend this request with your DataForSEO API login (HTTP Basic auth).
POST https://api.dataforseo.com/v3/dataforseo_labs/google/keyword_overview/live [ { "keywords": [ "your keyword 1", "your keyword 2" ], "location_code": 2840, "language_code": "en" } ]
- Save the full JSON responseSave the complete response, not just the task ID, next to the template folder.
- Convert it with the included scriptIt runs offline, makes no API calls and never sees your credentials.
python3 Automation/dataforseo_import.py import --template 01 --input response.json --output my-inputs.csv
- Add what the API can't knowCurrent CTR, Target CTR, Conversion rate, Value per conversion, Attainment factor, Work hours
- Paste at A13Clear the demo rows, paste the CSV values at Workspace cell A13 and the dashboard updates.
| Fills automatically from DataForSEO | You add |
|---|---|
| Keyword, Monthly searches | Current CTR, Target CTR, Conversion rate, Value per conversion, Attainment factor, Work hours |
Source reference fills automatically with the task ID, endpoint, location, language, device and snapshot time, so every row is traceable. Before a big pull, estimate the cost with the DataForSEO pricing calculator. The same steps, plus an example request file, are in the download's Automation folder.
Worked example: Northbeam Outdoor
Every template ships filled with data from Northbeam Outdoor, a fictional outdoor-gear retailer that appears across all 40 workbooks, so you can see what useful output looks like before you add your own. This workbook has 20 example rows.
Trail running shoes tops the per-hour ranking because its fix takes only 6 hours, while waterproof hiking boots adds the most profit in absolute terms. Sorting by both tells you what to do this week and what to plan for the quarter.
Top 10 by added profit / month
| # | Keyword | Added profit / month |
|---|---|---|
| 1 | waterproof hiking boots | $5,743.58 |
| 2 | mens down jacket | $3,815.77 |
| 3 | trail running shoes | $3,610.88 |
| 4 | camping stove | $3,120.08 |
| 5 | hydration pack | $2,385.15 |
Input fields
Keep the columns in this order when you prepare a CSV. A missing observation stays blank; use 0 only for a measured zero or a verified No. Fields marked DataForSEO can be filled automatically by the included script.
| CSV field | Column | Meaning and rule | Source |
|---|---|---|---|
| keyword | Keyword | Exact query in the selected country and language. | DataForSEO: keyword |
| search_volume | Monthly searches | Provider monthly search-volume estimate. Use one market, language and source date. | DataForSEO: search_volume |
| current_ctr | Current CTR | Assumed organic click-through rate as a decimal. Calibrate by device, brand and SERP layout. Decimal: 0.08 = 8%. | Your records |
| target_ctr | Target CTR | Assumed organic click-through rate as a decimal. Calibrate by device, brand and SERP layout. Decimal: 0.08 = 8%. | Your records |
| conversion_rate | Conversion rate | Conversions divided by eligible organic sessions for the same segment. This is an assumption. Decimal: 0.08 = 8%. | Your records |
| value_per_conversion | Value per conversion | USD contribution profit per conversion or expected lead profit. Use one value basis. | Your records |
| attainment | Attainment factor | Planning haircut for uncertainty, 0 to 1. This is your assumption, not a probability supplied by the API. Decimal: 0.08 = 8%. | Your records |
| effort_hours | Work hours | Estimated implementation hours, greater than zero. | Your records |
| source_ref | Source reference | Task ID, export filename and observation scope. Retain the untouched source response separately. Optional. | DataForSEO: source_ref |
Reading the result honestly
Compare opportunities on a consistent value basis. A high result can come from an optimistic assumption, so inspect the drivers.
Limits. Keyword difficulty is context, not a calibrated probability. Deduplicate overlapping keyword clusters before summing forecasts.
Keyword prioritization template mistakes to avoid
Tips from practice
- Group near-duplicate keywords first with the SERP overlap template, so you don't count the same page's traffic twice.
- Re-run the sheet each quarter with fresh Search Console CTRs. Keywords that moved will drop down the list on their own.
- Add a column for the target URL and feed the winners straight into the keyword mapping template.
Frequently asked questions
What is a keyword prioritization template?
It's a spreadsheet that scores each keyword by its likely business value so you can decide what to work on first. This one scores by added profit per work hour, using search volume, CTR gap, conversion rate, value per conversion, an attainment factor and effort.
How do I prioritize keywords for SEO?
Estimate the extra clicks a better ranking would bring, convert them into profit with your conversion rate and margin, then divide by the effort required. Rank by that number and sanity-check the top of the list for intent and feasibility.
Where do I get the CTR values?
Current CTR comes from Google Search Console (clicks ÷ impressions for the query). Target CTR should come from your own site's CTR by position, or a published CTR curve if you don't have enough data.
Does this work in Google Sheets?
Yes. Upload the XLSX to Google Drive and open it with Google Sheets. All formulas use functions that work in Excel, Google Sheets and LibreOffice.
Is keyword difficulty included?
Not as a score. Difficulty is captured more honestly through the target CTR you choose, the attainment factor and the hours you estimate. A hard keyword should carry a lower target, lower attainment and more hours.
Use it with these templates
Each template answers one decision. These are the ones that feed into, or follow from, the keyword prioritization template.
02Keyword Mapping TemplateLabs: Ranked Keywords
Assign every keyword to exactly one URL and catch conflicting assignments before they become cannibalization.
03SERP Overlap Keyword Clustering TemplateSERP API: Google Organic
Decide whether two keywords belong on one page or two by measuring how much their Google results overlap.
04Keyword Gap Analysis TemplateLabs: Ranked Keywords
Find the queries your competitors rank for that you don't, and size each gap in potential clicks.
31SEO Forecast TemplateLabs: Keyword Overview
Project added clicks and contribution per keyword cluster with CTR, attainment and seasonality you can defend.
36Ecommerce SEO Prioritization TemplateLabs: Keyword Overview
Rank product pages by potential orders, unit contribution and profit per hour, and catch out-of-stock or noindex SKUs.
40SEO Roadmap TemplateOn-Page API
Sequence 90 days of SEO and GEO work by weighted opportunity per hour, dependencies and acceptance criteria.
Part of the Keyword Research Toolkit
Get all 6 Keyword Research templates in one ZIP, or the complete set of 40 SEO and GEO templates with the 401-page field handbook.
Further reading on Optimization Theory
Built by Jourdan Rombough, technical SEO and GEO consultant with 15+ years in search. About Jourdan or get an SEO plan.






