How to fill the Brand Entity Consistency Audit with DataForSEO
============================================================

Data source: DataForSEO AI Optimization: LLM Mentions (AI answers (ChatGPT or Google AI Overviews) that mention a domain or keyword, with their cited sources).
This is a sign-off workflow. DataForSEO responses are the evidence you attach; the human checks stay manual by design.

1. Request the data
   POST https://api.dataforseo.com/v3/ai_optimization/llm_mentions/search_mentions/live
   Body:
   [
     {
       "target": [
         {
           "domain": "yourdomain.com"
         }
       ],
       "platform": "chat_gpt",
       "location_code": 2840,
       "language_code": "en",
       "limit": 100
     }
   ]
   Auth: HTTP Basic with your DataForSEO API login and password. Keep credentials out of shared files.

2. Save the complete JSON response (not just the task ID) next to this folder, e.g. response.json.

3. Convert it to the input CSV (offline, Python 3.10+, no API call, no credentials):
   python3 Automation/dataforseo_import.py import --template 29 --csv --input my-filled.csv --output my-inputs.csv

4. Complete the columns DataForSEO can't supply:
   - Entity name
   - Attribute
   - Official value
   - Observed value
   - Human semantic match
   - Owner
   - Review date

5. Open the workbook, clear the demo rows in Workspace (lime input cells only), and paste the CSV values at cell A13.

Filled automatically: Observed source URL
Source reference fills automatically with the task ID, endpoint, location, language, device and snapshot time, so every row is traceable.

Costs: estimate them first with the DataForSEO Cost Calculator (template 38). Live endpoints cost more than task_post/task_get.
Docs: https://docs.dataforseo.com/v3/