1 ×

Google Analytics Query

KNIME Google API Nodes version 4.3.0.v202011261638 by KNIME AG, Zurich, Switzerland

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.

Best Friends (Incoming)

Best Friends (Outgoing)



To use this node in KNIME, install KNIME Google Cloud Storage Connection from the following update site:


A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.


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.