Edit column filters

Click in the toolbar.

In the filter settings, do any of the following:

• To add a filter, click ADD FILTER , and then do the following:

  1. (Optional) To filter the column names by text string, enter the search string in the ADD FILTER input field.

  2. Select a column name from the column menu.

  3. Define the filter on the column:

     • (Filters without input fields) Click next to the second menu, select the check boxes next to each value to include, and then click .

     • (Filters with input fields) Select an operator from the second menu, enter the applicable value, and then click .

       For example, if you’ve selected the “Clicks” column and want to return only rows with more than 100 clicks, then select greater than" and enter 100 in the input field.

       Depending on the data type, available operators may include greater than, less than, equals, contains, doesn’t contain, starts with, ends with, no value, or has value, before, after, or no date.

       Note: Text values aren’t case-sensitive. For example, if you search for campaigns with “loan” in the name, then the results include “Consumer Loans” and “loan applications.”

• To edit an existing filter, click the filter, change the filter definition, and then click .

• To remove an existing filter, click X next to the filter definition.

(Keywords view only; optional) Select or deselect the setting to “Include rows with no performance data.”

Click Apply.

(If necessary) In the filter set above the data table, click to expand the filter set.

Above the data table, click the filter definition.

Edit the filters to apply:

1. (Optional) Edit the column name from the column menu.

2. (Optional) Redefine the filter on the column:

   • (Filters without input fields) Click next to the second menu, select the check boxes next to each value to include, and then click .

   • (Filters with input fields) Select an operator from the second menu, enter the applicable value, and then click .

     For example, if you’ve selected the “Clicks” column and want to return only rows with more than 100 clicks, then select greater than" and enter 100 in the input field

     Depending on the data type, available operators may include greater than, lesser than, equals, contains, not contains, or starts with.

     Note: Text values aren’t case-sensitive. For example, if you search for campaigns with “loan” in the name, then the results include “Consumer Loans” and “loan applications.”