Filters for Google Analytics Extracts
This topic lists the supported filter operators for use when extracting data using the Google Analytics Connector.
Filter Operators for Google Analytics Metrics
Operator |
Description |
URL Encoded Form |
Examples |
== |
Equals |
%3D%3D |
Return results where the time on the page is exactly ten seconds: ga:timeOnPage%3D%3D10 |
!= |
Does not equal |
!%3D |
Return results where the time on the page is not ten seconds: ga:timeOnPage!%3D10 |
> |
Greater than |
%3E |
Return results where the time on the page is strictly greater than ten seconds: ga:timeOnPage%3E10 |
< |
Less than |
%3C |
Return results where the time on the page is strictly less than ten seconds: ga:timeOnPage%3C10 |
>= |
Greater than or equal to |
%3E%3D |
Return results where the time on the page is ten seconds or more: ga:timeOnPage%3E%3D10 |
<= |
Less than or equal to |
%3C%3D |
Return results where the time on the page is ten seconds or less: ga:timeOnPage%3C%3D10 |
Filter Operators for Google Analytics Dimensions
Operator |
Description |
URL Encoded Form |
Example |
== |
Exact match |
%3D%3D |
Aggregate metrics where the city is Irvine: ga:city%3D%3DIrvine |
!= |
Does not match |
!%3D |
Aggregate metrics where the city is not Irvine: ga:city!%3DIrvine |
=@ |
Contains substring |
%3D@ |
Aggregate metrics where the city contains York: ga:city%3D@York |
!@ |
Does not contain substring |
!@ |
Aggregate metrics where the city does not contain York: ga:city!@York |
=~ |
Contains a match for the regular expression |
%3D~ |
Aggregate metrics where the city starts with New: ga:city%3D~%5ENew.* (%5E is the URL encoded from of the ^ character that anchors a pattern to the beginning of the string.) |
!~ |
Does not match regular expression |
!~ |
Aggregate metrics where the city does not start with New: ga:city!~%5ENew.* |