Google Analytics Query

Execute a query to retrieve data from the Google Analytics API.


The dimension data to be retrieved from the API. A single request is limited to a maximum of 7 dimensions.
The metrics data to be retrieved from the API. A single request needs at least one metric and is limited to a maximum of 10 metrics.
Specifies a subset of visits based on either an expression or a filter. The subset of visits matched happens before dimensions and metrics are calculated. You can either use the predefined segmentations or define your own (for details see Filters or the Google Core Reporting API documentation).
Note: segmentations that are defined without a scope (e.g. "source=~twitter") are interpreted to be user conditions ("users::condition::ga:source=~twitter").

Specifies a subset of all data matched in analytics. Multiple filters are separated by , (OR operator) or ; (AND operator). \ escapes the special characters , ; and \ .

Dimension operators:
== Exact match
!= Does not match
=@ Contains substring
!@ Does not contain substring
=~ Contains a match for the regular expression
!~ Does not match regular expression

Metric operators:
== Equals
!= Does not equal
> Greater than
< Less than
>= Greater than or equal to
<= Less than or equal to

The order and direction to retrieve the results. Can have multiple dimensions and metrics. Prepending a dash will sort in descending order.

Start date
Beginning date to retrieve data in format YYYY-MM-DD.
End date
Final date to retrieve data in format YYYY-MM-DD.
Start index
Use this parameter to request more rows from the API. For example if your query matches 100,000 rows, the API will only return a subset of them and you can use this parameter to request different subsets. The index starts from 1 and the default is 1.
Max results
Maximum number of results to retrieve from the API. The default is 1,000 but can be set up to 10,000.

Input Ports

A connection to the Google Analytics API.

Output Ports

The resulting table.


This node has no views


Further Links


You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.