ODBC guide

Exclude low-intent or internal searches from brand report

Exclude internal or low-intent queries (e.g. login, support) so the brand report focuses on genuine discovery. Use contains for brand and notContains for terms to exclude.

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" },
        { "dimension":"query", "operator":"notContains", "expression":"login" },
        { "dimension":"query", "operator":"notContains", "expression":"support" }
    ] }'
)