Get organic search report for pages (impressions, clicks, position, CTR)

Returns the organic search report broken down by page and date: impressions, clicks, position, and CTR. Supply the site URL (e.g. sc-domain:mycompany.com or full URL) and date range. Use Dimensions='date~page' for per-page breakdown; you can use static dates or date functions (e.g. monthstart, today) for dynamic reporting.

SELECT * FROM get_report
WITH(
    SiteUrl='sc-domain:mycompany.com',
    StartDate='monthstart',
    EndDate='today',
    Dimensions='date~page'
)