Use filters in your reports
When you create an Interactive report, you can narrow down your report results by adding filters, such as "Advertiser," "Order," "Key-value," and so on.
Note that some dimension filters are only available after you add the same dimension to the report, such as "Key-values" and "Targeting."
Add a filter to a report
- Sign in to Google Ad Manager.
- Click Reporting, then Interactive reports.
- Create a new report, or click the name of an existing report.
- Add metrics and dimensions.
- Next to 👁 Image
, click Add filter, and then:- Select a filter from the menu.
- Enter or select filter options.
- Click Apply.
- Select the filter "Ad break duration (seconds)."
- Select an operator, such as ">", and enter a value, such as "30."
- To finish, click Apply.
For more details on filter setup, review the following sections.
Filter by a list of items
Use "is any of" or "is none of" to filter by a list of items. Only report data associated with one of the listed items will be displayed in your report. To filter by a set of items, enter a comma-separated list of IDs.
Filter by substring with boolean operators
Individual filters are combined using "AND" logic.
Within a "contains" or "does not contain" filter, you can enter multiple values (one value per line); the filter treats these with "OR" logic, matching any of the specified values. The following table shows some examples of filters using "contains" and "does not contain."
| Filter logic | Example filters |
| NOT "a" | Country does not contain "a" |
| NOT "a" OR "b" OR "c" |
Country contains none of "a," "b," "c" In the filter setup, enter one value per line, like so:
a b c |
| "a" AND "b" |
Country contains "a", Country contains "b" You can continue adding individual filters, such as
"Country contains c", and so on. |
| "a" OR "b" | Country contains any of "a," "b" |
Special considerations
Review the following details for some of the filters.
Ad units
Filtering "Ad unit" dimensions
You can filter on a number of different ad unit dimensions, including specific levels such as "Ad unit: top level." In addition, you can choose to show child ad units in the totals:
- Ad unit (show child ad units): They show as separate values for the "Ad unit (all levels)" dimension.
Tip: If no ad unit dimension is selected, child impressions are included in the reported data. - Ad unit (hide child ad units): They're still counted when the "Ad unit (top level)" dimension is selected, but they don't show.
Tip: If no ad unit dimension is selected, only the impressions for the selected ad unit are shown.
Missing impressions when applying the “Ad Unit (hide child ad unit)” filter
In all cases, the Totals row displays the sum of impressions for all (and only) the rows shown in the report. None of the situations above should result in the sum of the impressions shown in each row differing from the total shown at the end of the report.
In "Hierarchical report" mode:
- When using "Ad unit level X" or "Ad unit code level X," parent ad unit rows include the summation of all child leaf rows. Each leaf row includes the summation of leaves, or the leaf itself if it has no children.
- A row for "Ad unit (top level)" always includes impressions for any child ad units, along with any direct impressions, regardless of filter type.
- A row for "Ad unit (all levels)" never includes impressions for any child ad units. It only shows direct impressions to that particular ad unit, regardless of filter type.
- Filters only affect rows that are displayed, and affect each ad unit type (above) differently. This is consistent behavior for the filter.
Learn more about reporting on Ad unit hierarchy.
Creatives
Custom fields
- Text-based, toggle-based, and drop-down fields default to the "is any of" type. You can select the values.
- Number-based fields default to the number type. You can select operators such as >, <, =, and so on.