Google Analytics Query (legacy)

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

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.

Views

This node has no views

Workflows

• BausteineKNIME Hub
• Blog PerformancesKNIME Hub
• GA Connector 120Feet Edition Example WorkflowKNIME Hub
• GA monthly queries with variable start-end dateKNIME Hub
• Google Analytics 4 and Google Universal AnalyticsKNIME Hub
• Show all 10 workflows

Links

• No links available

Developers