Edit column filters

In the toolbar, click .

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, and then select the check boxes next to each value to include.

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

       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, has value, before, after, or no date.

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

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

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

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, and then select the check boxes next to each value to include.

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

       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, and then change the filter definition.

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

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

Click Apply.

Above the data table, click the filter definition.

Redefine the filter on the column:

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

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

  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.”