0 ×

Google Analytics Query (PG)

P&G Google Analytics Nodes for KNIME Workbench version 1.2.6.201908171104 by Procter & Gamble, eBusiness Analytics

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

View basic tutorial for Google Analytic Nodes on PGTube at http://pgtube.pg.com/pgtube/play.php?id=63625-22bc7d20d2a116d6

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

Example:
source=~twitter
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

Icon
A connection to the Google Analytics API.

Output Ports

Icon
The resulting table.

Best Friends (Incoming)

Best Friends (Outgoing)

Installation

To use this node in KNIME, install PG Google Analytics Nodes for KNIME Workbench from the following update site:

KNIME 4.3

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.

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.