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
- 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.
- 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
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
excludes one or more items in the report that match your selection
The country “France” if selected, would be excluded from your report
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.
- 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.
- To create additional filters, click +add. Repeat steps 1 through 3.