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

 

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

     

    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. 

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.
 

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

 

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. 
 

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 


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

 

Last modified

Tags

Classifications

Complete
MarinOne
None

 

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