Local Rank Grid Tracker (Optimization Theory, v3.0, November 2026)
=============================================================

Log rankings across a geo grid, see a colour heatmap and measure weighted top-3 coverage for any local keyword.

What it decides
  How much of your service area sees your business in the local top 3 for a keyword, and where coverage drops off.

Files
  Local Rank Grid Tracker.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  Local Rank Grid Tracker - 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 SERP API: Google Maps
  Fills automatically: Grid point ID, Keyword, Business CID, Observed maps rank
  Full steps: HOW-TO-USE-WITH-DATAFORSEO.txt (also in the Automation folder), with example-request.json

Quick start
  1. Define the grid: Pick a center (usually the business) and spacing. Name points R1C1 to R5C5.
  2. Collect ranks: Use a local rank tracker or the DataForSEO Maps endpoint with coordinates. Enter 0 if not found within the tracked depth.
  3. Set point weights: Equal weights work by default. Weight points by population or customer density if you have it.
  4. Read the heatmap: Red edges show where competitors win. Use them to plan local pages, reviews and citations.

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/local-rank-grid-tracker/
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
