ODBC guide

Get brand searches landing on specific pages

Which pages receive brand-related search traffic. Use Dimensions='page~query' and combine a query filter (brand) with a page filter (e.g. URL contains /products/) to see brand traffic per page.

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