GA Connector 120Feet Edition Example Workflow
Google Analtyics Query Component - 120Feet Edition. by Gavin Attard. I buildt this component to overcome some of the reporting api limitations to allow me to create quicker, more useful reports and dashboards from whcih to draw insight and drive action in the organisations i work with. WIth this i can build better data sets that are repeateable and automatable. The node ((whcih incidentally uses API V3), overcomes the below limitations of the standard node Re-try on fail - For several reasons the data request can fail, this casues the workflow to stop in it's tracks. The 120Feet edition, will re-try on fail until the data is downlaoded succesfully. Pagination - When the query generates more than 10K rows, the standard node does not generate the querues for additional rows. The 120Feet edition resolbves that ensuring all of the rows for the request are downloaded. Accuracy, or rather how to avoid sampling - The GA Reporting API will use Sampling when the request uses lots of data for the requested metrics (which normally occurs for any request for data over more than one day if the website is busy). This leads to data not correlating with the GA UI and/or inaccurate metrics (I’ve seen cases where the metrics returned were way off trend and caused many a headache and discussion with stakeholders about data ‘trust’, sources of truth and the like). The 120Feet edition splits yoru date range into daily report requests, which in the vast majority of cases always avoids sampling.
Used extensions & nodes
Created with KNIME Analytics Platform version 4.3.2
Loading ad hoc jobs
By using or downloading the workflow, you agree to our terms and conditions.