If you don’t know SQL, but it’s better with JavaScript, you may prefer to do this data preparation logic in the Google Tag Manager code that sends the data, or if it’s better, in Python, maybe in the cloud function that collects the data. The GCP terminal must process the site’s GET requests, insert them into a BigQuery table, analyze them in columns and rows, and finally connect the data to Google Data Studio. We’ll also show you how to use the powerful, cost-effective and scalable features of the Google Cloud platform to build the back-end of the monitoring system, and finally give you some ideas on how to view the data in a Google Data Studio report. Then you need to change the code to specify the project, record and table for the BigQuery target data. The side effect in this case is the addEventCallback API, the purpose of which is to collect metadata about the data collection, preferably to an end point separate from the monitored tags. For this reason, this article uses a Google Cloud endpoint from the Google Cloud platform to collect data. Sending batch queries should reduce the effort on the terminal to analyze the data in the BigQuery table. The advantage of cloud resources is that you don’t have to install them locally and then implement the whole project at once – you can simply customize the queries. txt file in the online editor so that the cloud resource automatically installs the dependency before you run the code. In the Google Tag Manager Monitor tag, update the GET request endpoint to display the correct HTTP endpoint of the cloud feature and save the tag. We also recommend that you perform this type of data erasure in BigQuery, otherwise code updates will need to be performed in hard-to-reach places. If you’ve come this far, congratulations! You now have a live data stream from your Google Tag Manager installation in BigQuery. To do this, the BigQuery table that accepts GTM data will have a data scheme as simple as possible: it accepts the entire URL as a string and does not yet try to evaluate tag names or GTM events.