Google Analytics Query - 120Feet Edition

Google Analytics Query - 120Feet Edition
by Gavin Attard @120Feet
Improves on the original node resolving, Reliabilty, Accuracy and Pagination.

> Reliability - Re-try if query call fails
> Accuracy - Any date range fed generates a query per day. This ensure no sampling takes place on the google end.
> Pagination - The node has max records set to 10K. For queries generating more than 10K rows the component will request additional queries to ensure all rows are downloaded.

Instructions:
> Requires the Google Analytics Meda Data component for interface to work.

If using mulitple instances of the node you can use the Date Selector component to pass the date range into the component.

Version 2.0: - 18/01/2021
Changes:
- Better handling of incorrect segment or filter settings. Now fails and stops workflow if encountered.
- Better handling of too many concurrent users. Where a large volume of parallel requests are made from multiple instances of the component, the loop kept re-trying, on rare occasions never resolving the issue. Now a small random delay is introduced to spread the re-tries and reduce the concurrent connections.
- Option to download data in default Google behaviour for User Level Metrics.

Input ports

1. Type: Google Analytics
   GA Connection
   Connect the Google Analytics Connector here
2. Type: Table
   MetaData in
   Connect the Google Analytics MetaData node here

Output ports

1. Type: Table
   Report Table
   Your requested data