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.
conversion_action
Values vary; see notes.
Example value:
"Conversion action name here"
conversion_source
analytics
website
phone_number_clicks
mobile_app
ios_app_install
import_from_clicks
google_play
calls_from_website
store_visits
store_sales
store_sales_automated
store_sales_uploaded
device
mobile
tablet
desktop
tv
network
search
partners
display
placement
google_search_top
google_search_other
google_display_network
partners_top
partners_other
cross_network
custom_variable
Values vary; see notes.
Example value (equals):
"Example variable name" = "Result A" | "Result B"
Example value (contains):
"Example variable name" ~ "Result A" | "Result B"
date_range
today
yesterday
last_7_days
last_14_days
last_30_days
last_week_starting_sunday
last_week_starting_monday
last_month
last_quarter
last_year
last_business_week
this_week_starting_sunday
this_week_starting_monday
this_month
this_quarter
this_year
between_dates
Values (specify 2):
date(<year>, <month>, <day>)
today
yesterday
week_start_sunday
week_start_monday
month_start
year_start
report_range_start
report_range_end
Optional addition on a value:
<value>.shift(<years>, <months>, <days>)
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.
