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

See Also
Extracting Data from Google Analytics