Get organic search report by date (impressions, clicks, position, CTR)

Returns the organic search report aggregated by date (all pages). Supply site URL and date range. Use Dimensions='date' for daily totals. Date parameters support static values or date functions.

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