Welcome!
Welcome to the Marin Software Support Center. We're glad you're here. Here's what you can look forward to:
  • Real-time search so you can find what you need faster than ever.
  • Easy-to-follow video guides for our most popular articles.
  • Interactive simulations and Live Screenshots to make learning easy.
  • Regular content updates to ensure every word you read is accurate and up-to-date.
Home > English > Your Marin Account > Grids, Tabs & Columns > How To Articles: Grids, Tabs & Columns > Applying Filters

Applying Filters

Overview

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

Note: This article contains instructions about using filters in both MarinOne and Marin Search.

 

f17.jpg

Types of Filters


Text Filters

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

 

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

Metric Filters

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

Available Filters Definition Availability (Marin Search, MarinOne, or Both)
Equals Shows all items with metrics that equal a certain value exactly Both
Does Not Equal Shows all items with metrics that do not equal a certain value exactly Both
Greater Than Shows all items with metrics over a certain value Both
Greater Than or Equal To Shows all items with metrics over a certain value, inclusive of the given value Both
Less Than Shows all items with metrics under a certain value Both
Less Than or Equal To Shows all items with metrics under a certain value, inclusive of the given value Both
Between Shows all items in between two values, inclusive of the start and end points.  Both
|x| greater than Shows all rows where the absolute value of the change column is greater than the value entered. This is useful for finding large changes, whether they were positive or negative. (Change columns only) Marin Search only
|x| less than Shows all rows where the absolute value of the change column is less than the value entered. This is useful for finding small changes, whether they were positive or negative. (Change columns only)  Marin Search only

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 Availability (Marin Search, MarinOne, or Both)
On Shows dates that match your filter exactly Both
On or Before Shows dates that match your filter exactly or took place before the selected date Both
On or After Shows dates that match your filter exactly or took place after the selected date Both
Between Shows dates that took place in between two dates, inclusive of the start and end points Both

How to apply filters


In MarinOne

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.

     

    f2b.jpg
     

    If you don't see the Filter icon, hover over the column name until it becomes visible. f1b.jpg​​​​
     
  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. 
     

    f3b.jpg
     

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

    f4b.jpg
     

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

    f5b.jpg
     

  5. When you're ready, click Apply to add your filters to the applicable column. 

In Marin Search

  1. To add a new filter, click on the Filter icon in the column header. f3.jpg
     
  2. Currently applied filters are displayed above the grid, in the Filter bar
     

    f4.jpg
     

  3. All filters are turned on and off by clicking the Filter icon in the column headers, or by clicking the 'X' icon next to the filter above the grid.

How to Remove Filters


In MarinOne

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. 

In Marin Search

There are two ways to remove filters:

  • Click the Filter icon in the column header and remove your filter text, then click Apply. If you remove the last filter, the Filter bar will close.
     

    f2.jpg
     

  • In the Filter summary above the grid, click the 'X' icon. The selected filter will be cleared.
     

    f1.jpg

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

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.
 

f6.jpg



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

    f18.jpg

 

In Marin Search

Marin Search supports AND, OR and AND NOT filter operators for applying additional granularity to your filtering. To use these in a filter, follow these steps:

  1. Go to the main grid that you'd like to filter on, for example Keywords.
  2. Click the Filter icon in the header of the column you'd like to filter. f3.jpg
  3. In the bubble that appears, click the drop-down menu and choose the type of filter you would like to apply.  

    Note: Additional operators are supported in the Contains, Equals, and Doesn't contain filter types. The other options, Is blank and Is not blank, do not require operators or search terms.
     

    f2.jpg


     
  4. In the Filter text box, enter your conditions with operators. For example, you could select a filter which Contains the terms brand AND mobileThis would return all objects which meet these conditions.
     

    f5.jpg


     

The above process can be used on any of the main grids in Marin Search.

Important Information When Using Multiple Conditions

  • When using the NOT operator, please make sure that you use AND NOT. For example, 'Red NOT Blue' would not work, whereas 'Red AND NOT Blue' would work.
  • Per condition, up to 10 filters are supported, but using more filters may not work.

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. 

Note: The Filter Pane is a feature unique to MarinOne and is not available in Marin Search.
 

f16.jpg

 

 

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
 

f8.jpg

 

 

From here, you can: 

  • See all filters that are currently applied 
     

    f10.jpg


     
  • 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
     

    f11.jpg


     
  • Apply additional Quick Filters at the bottom of the Filter Pane, under Facets
     

    f12.jpg

 

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

Important Information About Using Filters 


The below points apply only to MarinOne Search and Marin 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 or \\% in Marin Search, 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 or \\_ in Marin Search, 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.

  • In Marin Search, the \ symbol does not work when applying filters. For example, it is not possible to filter on Contains \123. You may need to apply multiple filters to avoid using \.

 

Last modified

Tags

Classifications

This page has no classifications.

 

wiki.page("Internal/Mindtouch_Launch_Sandbox/js.cookie.js")