When you create a report, you can narrow down your report results by advertiser, order, key-value, and more with filters. 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 Reports, and then New report.
- Set up the report and select any dimensions or metrics you want to use.
For detailed instructions, go to Create a new report. - Next to
, click Add filter and enter or select filter options.
- To run your report, click Run.
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 creatives
Filter by “Creative Set ID.” Note that you can filter either by using “Creative ID” or “Creative Set ID,” but the exported report actually captures “Creative Set ID” data in the "Creative ID" column.
Filter by substring with boolean operators
Use "contains" or "does not contain" to only display report data associated with items that match a substring connected by boolean operators AND, OR, NOT, and the negative symbol (-). The operators must be in all capital letters. For exact phrases, use double-quotes ("). Use spaces with care. If there is not a proper operator after the space, then it is interpreted as an AND operation.
| Filter field text | >Search performed |
|---|---|
| NOT "a" | NOT LIKE '%a%' |
| >"a" AND "b" | >LIKE '%a%' AND LIKE '%b%' |
| >"a" OR "b" | >LIKE '%a%' OR LIKE '%b%' |
| "a" AND "b" AND "c" | LIKE '%a%' AND LIKE '%b%' AND LIKE '%c%' |
| "a" "b" "c" | LIKE '%a%' AND LIKE '%b%' AND LIKE '%c%' |
For example: To exclude the values a, b, and c, select does not contain, then enter "a" "b" "c," and then click Apply.
Put another way, if you select does not contain for values "a" "b" "c," it is interpreted as NOT_LIKE("a") AND NOT_LIKE("b") AND NOT_LIKE("c"), rather than NOT_LIKE("a" AND "b" AND "c").
Special considerations
The following describes special considerations when applying different filters.
Ad units
You can filter on the "Ad unit" dimension without adding the Ad unit dimension, but you can only use the "contains" filter for top-level ad units. To use the OR operator in the "Ad unit" filter, add "Ad unit" as a dimension with "Top level" selected.
Filtering "Ad unit" dimension
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 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 (with All Levels), parent ad unit rows are split into "(Total)" and "(Only)" to indicate subtotals. The leaf rows for each ad unit and the "(Only)" rows never contain impressions for any child ad units.
- 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 affects each ad unit type (above) differently. This is consistent behavior for the filter.
Key-values
Include the Key-values dimension to filter by key-values. Key-values reports can be very large, so we recommend you run them for only a single day or a full month. Try using total targeted Impressions rather than total impressions, as this pulls far fewer rows of data.
Targeting
Filter by targeting only works if you have included the Targeting dimension. If you add the Targeting filter without the Targeting dimension, you might get overlapping results.
Deals
When filtering by "Deal ID" or "Deal name," only deals with registered matched requests in the past six months will appear in the filter selection list. You can also use _contains_ or _does not contain_ to narrow down the results.
Custom fields
For Custom field filtering, the filter types vary based on field type.
- Text-based fields default to the "contains" type
- Drop-down or toggle-based fields default to the "is any of" type
- Number-based fields default to the "between" type
