ODBC guide

Get brand and product keyword searches (OR condition)

Search performance for brand and product-related keywords using OR logic. Use multiple filters in DimensionFilterGroups (e.g. contains "brand-name shoes", contains "brand-name hats") to track product awareness from brand searches.

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