ODBC guide

Get exact brand keyword performance by date

Impressions, clicks, CTR, and average position for an exact brand keyword (strong brand intent). Use Dimensions='date~query' and filter with operator":"equals" for the exact phrase. Replace brand-name with your keyword.

SELECT *
FROM get_report
WITH(
    SiteUrl='sc-domain:mycompany.com',
    StartDate='today-30d',
    EndDate='today',
    Dimensions='date~query',
    DimensionFilterGroups='{ "filters":[
        { "dimension":"query", "operator":"equals", "expression":"brand-name" }
    ] }'
)