GSC Dataset Template

A schema for turning raw Google Search Console exports into a structured, queryable dataset of queries, pages, clicks, impressions, and position over time.

For: SEO analysts, publishers, site owners

Schema fields

query (required)

string -- Search query string.

page_url (required)

url -- Landing page URL.

clicks (optional)

number -- Clicks in the reporting period.

impressions (optional)

number -- Impressions in the reporting period.

position (optional)

number -- Average position.

date_range (optional)

string -- Reporting period covered.

Use cases

Keyword research
Content gap analysis
Rank tracking history
AI visibility tracking

Exports: CSV, JSON, XLSX

License: Standard personal/commercial license