Get organic search keywords report (impressions, clicks, position, CTR)

Returns the organic search report grouped by search query (keywords). Supply site URL and date range. Use Dimensions='query' to see impressions, clicks, position, and CTR per keyword.

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