Search
Clear search
Close search
Google apps
Main menu

Create or edit a query

Filter your query

As part of the query 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. The Query Tool attempts to do an exact match on the string (regardless of case).
    Filter operator Affect on your report Examples

    is

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

    An 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

    contains

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

    Only those campaigns that match the pattern “RTB” would appear in your report

    does not contain

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

    Only those campaigns that match the pattern “RTB” would not appear in your report

    The "is" and "is not" operators are pre-populated with drop-down values for selecting your filter. The "contains" and "does not contain" operators are populated with free form values for entering your filter.

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

    If you create multiple filters and you select operation “is,” you cannot include another instance of that dimension.
  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. Repeat steps 1 through 3.
Was this article helpful?
How can we improve it?