AI Prompt Research Template (Optimization Theory, v3.0, November 2026)
=================================================================

Turn real customer tasks and keywords into a weighted prompt panel for ChatGPT, Perplexity, Gemini and AI Overviews.

What it decides
  Which prompts belong in your AI visibility panel, how much each matters, and how many observations each tracking cycle needs.

Files
  AI Prompt Research Template.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  AI Prompt Research 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. Collect real tasks: Mine sales calls, support tickets, onsite search, People Also Ask and community threads for the jobs customers are trying to get done.
  2. Write natural prompts: Phrase each prompt the way a person would type or say it, with context. One prompt per row.
  3. Weight by relevance and demand: Link a related keyword and its volume, then set business relevance (0 to 1).
  4. Plan the cycle: Set repeat runs (answers vary run to run) and platforms. The Dashboard totals observations per cycle.

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/ai-prompt-research-template/
Part of the AI Visibility & GEO Toolkit: https://optimizationtheory.com/download-view/ai-visibility-toolkit-6-geo-research-and-measurement-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
