Google Analytics Query (PG)

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.

Views

This node has no views

Workflows

  • No workflows found

Links

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.