Google Analytics 4 Blends Local Files

This workflow showcases the capabilities of Google Analytics 4 in conjunction with the KNIME Analytics Platform. You can easily download and run the workflow directly in your KNIME installation. We recommend that you use the latest version of the KNIME Analytics Platform for optimal performance.

As you may notice, the workflow nodes are currently not executed (indicated by the red light) because you need to authenticate through your Google account via the Google Authenticator node. Select the node and refer to its description on the left side panel for instructions.

Once you have authenticated, you can connect to the Google Analytics Connector and the Google Sheets Connector. The Google Analytics Query node allows you to configure your query and extract data, such as sessions and total users by city (ID) and date. Due to demo purposes, you don't need to configure the node. Just run it.

In the bottom branch, we read the Geo Targets file using the CSV Reader node, which contains information such as city ID, city name, country, etc. This file was downloaded from Google and saved in the workflow data area.

With the Value LookUp node, we perform a VLOOKUP-like function using the Geo Target list as our dictionary table and the city ID as the key value. The final output is a table from Google Analytics with appended Geo Target information.

Finally, we create a new Google Sheets document using the Google Sheets Writer node.

External resources

• Geo Target source - Google