Some filters are only available for certain columns. For example, only conversion-oriented columns can be filtered by a custom conversion variable. If a filter isn’t listed in the filter panel (in visual mode) or in the filter suggestions (in text mode) after inserting a column, then it’s not supported for that column.
For instructions on how to use filters in custom columns, read Create custom columns.
You can add a filter to a column in visual mode by clicking on the column name and adding the filter in the side panel. You can add a filter in text mode by adding a period after a column name and typing a filter name from the suggestions that appear or by referencing the table below. Values in text mode are specified in parentheses after the filter name. For example, clicks filtered to only clicks from either mobile or tablet devices would be written as clicks.device(mobile, tablet)
.
Multiple filter types can be specified on the same metric (up to 2 distinct types, such as “Device” and “Network”). If multiple types are specified, they combine with a logical “AND”, filtering the metric multiple times. See the table below for the behavior of the filter values (such as mobile, tablet, and desktop for the device type) for each type. For most types, filter values are combined with a logical “OR”, and there’s no limit on the number of values that can be specified.
Filter Name | Filter Name in Text Mode | Allowed Values in Text Mode | Notes |
Conversion action | conversion_action |
Values vary; see notes. Example value: |
Allowed values include the names of all conversion actions visible to the owner of the custom column wrapped in double quotes. Select at least one value. |
Conversion source | conversion_source |
|
Some conversion source values are only available to accounts that have that feature enabled. Select at least one value. |
Device | device |
|
Select at least one value. |
Network (with search partners) | network |
|
Select at least one value. |
Top vs. Other | placement |
|
Select at least one value. |
Custom variable | custom_variable |
Values vary; see notes. Example value (equals):
Example value (contains):
|
Select one custom variable and at least one result value. Specify the name of your variable surrounded by double quotes, followed by an = (for equals) or ~ (for contains). Next, you can list any number of result values to match against surrounded by double quotes and separated by | (representing a logical OR). |
Date range | date_range |
|
Select exactly one value. |
between_dates |
Values (specify 2):
Optional addition on a value: |
Specify exactly two values (a start date and end date, both inclusive), separated by a comma in text mode. The order of the dates does not matter. To specify an exact date, use the date(..) value with a 4-digit year, a month (from 1-12), and day (from 1-31 depending on the month) separated by commas. After either or both date values, you add the .shift(...) modifier to adjust the date forward or backward any number of years, months, and days. The “report range” start/end dates represent the global start and end dates of any table, chart, or report that contains your custom column. |