Edit column filters

Edit a filter set

  1. Click Filter in the toolbar.

  2. In the filter settings, do any of the following:

    • To add a filter, click Add Filter 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 Down arrow next to the second menu, select the check boxes next to each value to include, and then click Update Filter .

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

          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 Update Filter .

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

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

    note warning
    WARNING
    Selecting this option increases the page load time.
  4. Click Apply.

Edit a single filter

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

  2. Above the data table, click the filter definition.

  3. 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 Down arrow next to the second menu, select the check boxes next to each value to include, and then click Update Filter .

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

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

recommendation-more-help
bba95088-f653-468b-a1c0-bd1dbc81025c