ODBC guide

Get brand evaluation searches (reviews, comparisons)

High-intent brand evaluation searches such as reviews, ratings, or comparisons — often indicating users close to a purchase decision. Filter by multiple contains expressions (e.g. "brand-name reviews", "brand-name vs").

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