Filters and sort

Filters keep only the rows you want. Sort sets their order. Both are in the report builder, under Date range.

Add a filter

1. Select + Add filter.
2. Choose the field to filter on.
3. Choose a condition and enter a value.
4. To test the same field again, select + Add condition.

A row is kept only when it matches every filter and every condition. Select × to remove a condition or a filter.

Conditions

• Text: =, ≠, starts with, does not start with, contains, does not contain, matches regex, does not match regex. Upper and lower case count as the same.
• Numbers, money and dates: =, ≠, >, ≥, <, ≤.

A report can have up to 50 conditions, and up to 5 of them can be regex conditions.

Sort the rows

Under Sort, choose a field, then A→Z or Z→A. To sort by a field, add it to the report's fields first.

Limit the rows

Under Show # of records, choose All, or 10, 25, 50, 100, 500 or 1,000 rows.

Rows with zero impressions

Rows with zero impressions are left out. Tick Include zero impressions to keep them.