ODBC guide

Get brand search trend by date

Daily brand awareness trend: filter search queries that contain your brand name to measure brand lift from campaigns. Use Dimensions='date' and a DimensionFilterGroups filter on query with operator contains. Replace brand-name with your brand.

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