Applying Filters

Filters are a key element of effective Search and Social management. Using filters, you can:

  • Narrow down the data that's visible in the grid for day-to-day management
  • Built out reports, alerts, and even Dashboards
  • Troubleshoot keywords and campaigns that may need your attention
  • And apply multiple filters to the same column for added granularity

Types Of Filters

Text Filters 

For Text Columns (such as the Keyword or Campaign columns), you can apply the following filters.

Available Filters Definition
Contains Shows all items that match a given search term
Equals Shows all items that match the given search term exactly
Is Blank Shows all items with a blank value in the given column. This is useful for reviewing Landing Pages and Dimensions. 
Does Not Contain Shows all items that do not match a given search term
Does Not Equal Shows all items that do not match the given search term exactly
Is Not Blank Shows all items without a blank value in the given column. This is useful for reviewing Landing Pages and Dimensions. 

Metric Filters 

For Metrics Columns (such as the Clicks or Impressions columns), you can apply the following filters:

Available Filters Definition
Equals Shows all items with metrics that equal a certain value exactly
Does Not Equal Shows all items with metrics that do not equal a certain value exactly
Greater Than Shows all items with metrics over a certain value
Greater Than or Equal To Shows all items with metrics over a certain value, inclusive of the given value
Less Than Shows all items with metrics under a certain value
Less Than or Equal To Shows all items with metrics under a certain value, inclusive of the given value
Between Shows all items in between two values, inclusive of the start and end points. 

Category Filters 

For certain columns (Publisher, Match Type, Status), you will see a list of specific values that can be applied as filters. For example, the Publisher column allows you to filter for Google, Microsoft, Amazon, etc. while the Match Type column allows you to filter for Broad, Phrase, or Exact. 

Date Filters 

For date columns (Creation Date, Override Until), you can filter based on a certain date. This can be one of the following: 

Available Filters Definition
On Shows dates that match your filter exactly
On or Before Shows dates that match your filter exactly or took place before the selected date
On or After Shows dates that match your filter exactly or took place after the selected date
Between Shows dates that took place in between two dates, inclusive of the start and end points

How To Apply Filters

From any column in MarinOne, follow the steps below to apply a filter.

  1. Click on the Filter button ('funnel' icon) in the column header, next to the column name.

    If you don't see the Filter icon, hover over the column name until it becomes visible. 
  2. Then, from the drop-down, select the type of filter you'd like to apply. In steps 3 - 6 below, we'll go over the types of columns that are available along with the filters options that exist for each.
  3. Some types of columns allow you to select one or more possible value, so if you'd like to look at both Google and Microsoft data, simply apply your filter accordingly.
  4. Once you've selected the type of filter you'd like to apply using the drop-down, you can apply your specific filter criteria simply by typing it into the available text box.
  5. After typing in your filter criteria, simply hit Enter or Return on your keyword to apply your filter. You can also apply your filter by clicking on the Plus sign ('+' icon) in the bottom-right corner of the text box. 

    You will see all active filters at the bottom of your filter panel in blue.
  6. When you're ready, click Apply to add your filters to the applicable column. 

How To Remove Filters

From the Filter icon in a given column, you can remove your filters granularly by clicking the X next to a specific filter. To remove all filters for a given column, select Clear.

These an also be removed from the Filter Pane, which can be accessed by clicking on the Filter button ('funnel' icon) to the top-left of the grid. From here you can remove filters individually or collectively. We'll talk more about the Filter Pane later in this article. 

How To Filter For Multiple Conditions

In Text Columns, you can apply multiple filters on the same column. For example, you may want to find all campaigns which contain the word 'brand' but don't contain the word 'mobile'. There are a number of operators that can be used to refine your search.

Note: This type of filter is not available from Metrics Columns, such as Clicks or Impressions

In MarinOne, simply follow the How to Apply Filter instructions for up to 10 filter conditions.

For example, if you're looking for keywords that contain both 'running' and 'shoes,' simply apply each filter individually.

You can then select the Join operators using drop-down and select one of the following choices:

  1. And - 'And' filters allow you to search for objects that contain multiple tokens. In the example above, a filter for 'running' AND 'shoes' would allow you to identify keywords that contain BOTH 'running' and 'shoes,' thus helping you narrow down the keywords in your grid substantially. 

    Note: If you're applying two "Does Not Contain" filters, you will need to use the AND join operator, not the OR join operator. For example, Does Not Contain "Shoes" AND "Running".
     
  2. Or - 'Or' filters allow you to search for objects can contain one of a several different tokens. In the example above, a filter for 'running' OR 'shoes' would allow you to identify keywords that contain EITHER 'running' OR 'shoes.' thus helping you identify keywords that meet a variety of different criteria. 
  3. Unlike in Marin Search, there isn't a filter condition for And Not, but you can achieve the same result by filtering for Contains one condition and Does Not Contain another. Using the same example as above, you would apply a filter for Contains 'running,' join operators using And, and finally apply a second filter for Does Not Contain ‘shoes.’

The Filter Pane

The Filter Pane allows you to see all filters that are currently in place, remove filters granularly or across-the-board, and apply additional high-level filters, known as facets, across your entire grid. 

To launch the Filter Pane, click on the Filter button ('funnel' icon) to the top-left of the grid, just below the Navigator and to the left of the Search Bar

From here, you can: 

  • See all filters that are currently applied
  • Remove filters granularly. So if you have multiple filter conditions applied to the same column, you can remove them one at a time without impacting the other filters that have been applied. To remove a filter, simply click the next to it.
  • Remove all filters across all columns by selecting Clear All
  • Remove all filters for a specific column by selecting Clear next to the column-name grouping
  • Apply additional Quick Filters at the bottom of the Filter Pane, under Facets

To collapse the Filter Pane, click on the Double Arrow button ('<<' icon).

Important Information About Using Filters

  • MarinOne filters support boolean text filtering.

The below points apply only to MarinOne Search, not to MarinOne Social.

  • The '%' symbol does not work when applying filters because it acts as a wildcard. If required, a workaround is to try \% in MarinOne, then it will return the desired results. For example, if you want to filter on Contains "123%" you would need to use "123\%" or "123\\%".
  • The '_' symbol does not work when applying filters in MarinOne because it acts as a wildcard. If required, a workaround is to try \_ in MarinOne, then it will return the desired results. For example, if you want to filter on Contains 'abc_' you would need to use 'abc\_' or 'abc\_'.
  • MarinOne does not support multi-tabbing (having more than one tab of MarinOne open at the same time). This may cause filters to work incorrectly. If your filters are not providing the expected results, please make sure you only have one window open with MarinOne.
  • For certain types of searches (for example a space in a destination URL) you should use the following syntax for your query: % %

In this case, 'percentage space percentage' would allow the use of space in a search term.

Written by Marin Software

Last published at: June 28th, 2023