Create or edit a query

Filter your report

As part of the report creation process, you have the option to narrow down your report results.

To refine and specify your report data, you have the ability to apply filters. You can view data by dimension family, configure the filter to include or restrict values from the selected family, and further narrow down your results by specific values from the dimension family. The dimension and operation options help you to exclude or include specific pieces of data. Every selected dimension can be filtered.

Set your filters

  1. Click the first filter drop-down to select your dimension. For example, if you needed to filter by country, you would select “Countries,” choose your operator, and then select from the list of countries.
  2. Click the second filter drop-down to select your operator. Select either is or is not. In addition, you can also select contains or does not contain. These two options allow you to enter specific strings to include or exclude data. Reporting attempts to do an exact match on the string (regardless of case).
    Filter operator Affect on your report Examples
    greater than (>) includes one or more items in the report that exceeds the value you input Impressions greater than "1000", if set, would be included in your report
    greater than or equal to (>=) includes one or more items in the report that exceeds or equals the value you input Impressions greater than or equal to "1000", if set, would be included in your report

    is (=)

    includes one or more items in the report that match your selection

    A creative size of “300x250”, if selected, would be included in your report

    is not (≠)

    excludes one or more items in the report that match your selection

    The country “France” if selected, would be excluded from your report

    less than (<) includes one or more items in the report that is less than the value you input Impressions less than "1000", if set, would be included in your report
    less than or equal to (<=) includes one or more items in the report that is less than or equal to the value you in put Impressions less than or equal to "1000", if set, would be included in your report

    Include selected

    includes any items in your report that match the pattern you have specified

    Include the selected advertisers

    Exclude selected

    excludes any items in your report that match the pattern you have specified

    Exclude the selected advertisers

    Regular expressions (for example, "*.google.com") are not currently supported.

  3. Click in the field and type your filter option. The filters display drop-down menus that allow you to select a list of possible values to filter on.
  4. To create additional filters, click Add and repeat the steps above. 
Was this helpful?
How can we improve it?