Icon

GA Connector 120Feet Edition Example Workflow

GA Connector 120Feet Edition Example Workflow
Use this to login via browser usingyour google credentials as you wouldwhen logging into Google Analytics. An alternate authentication method ifyou have a GCP service accoutn withassociated permissions. Ideal forautomated ETL runs or where theworkflow should run indeendent of theindividual. This component pulls the dimensionand metric names that are standard ingoogle analytics and feeds then to theQuery Builder in the 120Feet editioncomponent. It will not download your specificcustom dimentions meteric names. You will still use numerical entry forthose If you are making multipe queries (i.e.you have many instances of theGoogle Analytic Query - 120Feetedition component. then connect thisto all of them to have a single Dateselector. Set your report query here, sit back and watch the dataroll in. From here, world is your oyster. Wrangle, mangle, feed itto he machine, spit out those insights and drive actionlike never before. 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). Thisleads 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). The120Feet edition splits yoru date range into daily report requests, which in the vast majority of cases always avoids sampling. Use this to login via browser usingyour google credentials as you wouldwhen logging into Google Analytics. Select your Account, Property and View here from which to draw your dataAlternate authentication method Google Analytics Query- 120Feet Edition Google AnalyticsMetaData Google Analytics Query - DateSelector for 120Feet Edition Google AnalyticsConnection GoogleAuthentication Google Authentication(API Key) Use this to login via browser usingyour google credentials as you wouldwhen logging into Google Analytics. An alternate authentication method ifyou have a GCP service accoutn withassociated permissions. Ideal forautomated ETL runs or where theworkflow should run indeendent of theindividual. This component pulls the dimensionand metric names that are standard ingoogle analytics and feeds then to theQuery Builder in the 120Feet editioncomponent. It will not download your specificcustom dimentions meteric names. You will still use numerical entry forthose If you are making multipe queries (i.e.you have many instances of theGoogle Analytic Query - 120Feetedition component. then connect thisto all of them to have a single Dateselector. Set your report query here, sit back and watch the dataroll in. From here, world is your oyster. Wrangle, mangle, feed itto he machine, spit out those insights and drive actionlike never before. 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). Thisleads 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). The120Feet edition splits yoru date range into daily report requests, which in the vast majority of cases always avoids sampling. Use this to login via browser usingyour google credentials as you wouldwhen logging into Google Analytics. Select your Account, Property and View here from which to draw your dataAlternate authentication method Google Analytics Query- 120Feet Edition Google AnalyticsMetaData Google Analytics Query - DateSelector for 120Feet Edition Google AnalyticsConnection GoogleAuthentication Google Authentication(API Key)

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Gavin
Created at: 2021-11-15
On NodePit since: 2021-11-15
Last update: 2024-12-17
Created with KNIME version: v4.3.2
Tags: google analytics

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!