GA4 BigQUery Tool - 120Feet Edition

v1.5

----------------

This component makes creating your initial table query super easy and quick.

Use it together with other Knime DB tools to make more complex queries and supercharge your capabilities without writing a single line of code

------------------

Initialise

Click the initialise checkbox and run the component. This will populate the field list and event list.

When done, untick, select your fields and events.

The lists are accurate for the date range selected.

Re-run initialisation across a different date range if the field you are expecting is not listed.

-----------------

Field List

The field list names will match the schema available here https://support.google.com/analytics/answer/7029846?hl=en

For nested fields:

event_params---> event.xxx

user_properties --> user.xxx

item_params --> item_param.xxx

	Data Integrity Check
	GA Connector 120Feet Edition Example Workflow
	GA4 BigQuery - 120Feet Edition
	Google Analytics MetaData
	Google Analytics Query - 120Feet Edition
	Google Analytics Query - Date Selector for 120Feet Edition