1 ×

Google Analytics Query

KNIME Google API Nodes version 4.1.0.v201911232043 by KNIME AG, Zurich, Switzerland

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

Options

Dimensions
(Optional)
The dimension data to be retrieved from the API. A single request is limited to a maximum of 7 dimensions.
Metrics
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.
Segment
(Optional)
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").

Example:
users::condition::ga:city==Konstanz
Filters
(Optional)
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

Example:
country==Canada
city=~^New.*
Sort
(Optional)
The order and direction to retrieve the results. Can have multiple dimensions and metrics. Prepending a dash will sort in descending order.

Example:
pageLoadTime
-visits
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)

Installation

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

KNIME 4.1
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.

Developers

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.