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

$79 Get This Template