How to fill the SEO Content Calendar Template with DataForSEO
============================================================

Data source: DataForSEO Labs: Keyword Overview (search volume, monthly history, difficulty and intent for a list of keywords).
DataForSEO supplies the URL or query list and the audit trail; you add the measurements listed below.

1. Request the data
   POST https://api.dataforseo.com/v3/dataforseo_labs/google/keyword_overview/live
   Body:
   [
     {
       "keywords": [
         "your keyword 1",
         "your keyword 2"
       ],
       "location_code": 2840,
       "language_code": "en"
     }
   ]
   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 23 --input response.json --output my-inputs.csv

4. Complete the columns DataForSEO can't supply:
   - Content ID
   - Deliverable
   - Owner
   - Due date
   - Review date
   - Estimated hours
   - Completed hours
   - Published verified

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

Filled automatically: Keyword
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/