With the help of a Google Service Account connected to stape, you integrate server Google Tag Manager with BigQuery and Firestore. This blog post will show how to create a Google Service Account and connect it to your stape container.
Google Service Accounts can be used by applications to make authorized API calls. With the help of a Google Service Account connected to the sGTM container, it is possible to integrate BigQuery and Firestore with server GTM.
To create a Google Service account, you will need to have a Google Cloud Platform account and generate an Access Key. The service account JSON key file must be added to an sGTM container power-up in app.stape.io to authenticate with these services.
Firestore is a database that can write/read or sync data. It can be used to enrich data sent using server-side tags. For example, with the help of user ID, you can extract additional user data from Firestore and send more user parameters to Facebook CAPI, which will increase the FB event match quality score.
To simplify integration, Google released the Firestore Lookup variable. With the help of this variable, you can extract specific values from the Firestore document. The only disadvantage is that Firestore is not a free service - check the price here.
Using server Google Tag Manager, it’s possible to write data directly to BigQuery from sGTM Tag or Client. Previously BigQuery integration was only available for 360 users. With the release of sGTM and GA4, all users can send data to BigQuery for free or cheaper than before. BigQuery is also not free - check its pricing here.
1. Create or login to the Google Cloud Platform web console.
2. Select IAM & Admin -> Service Accounts -> Click Create service account.
3. Add account -> Click Next -> Select Roles BigQuery Data Editor role for BigQuery access or the Cloud Datastore User role for Firestore.
If you want to use Google Service Account only for BigQuery, choose only the BigQuery Data Editor role. The same for Firestore.
When you get to the 3rd step, just click Done.
4. Create private key -> Select JSON -> select Create -> JSON will be downloaded to your computer.
5. Open your stape.io account -> open sGTM container -> open Power-ups tab -> Click on Google Service account -> Upload JSON file that you’ve downloaded from Google Cloud -> Click Save.
All it takes is a few simple questions. Click Get A Quote, fill-up the form, and we will send you a quote.
For Google Universal Analytics, Google still has not provided free options to export raw data to BigQuery or any other database for that matter. But what if you don’t have plans to migrate to GA4 and want to get the benefits of BigQuery raw data? I decided to solve this question with GTM Server Side tagging and created this how-to article for you.
Oct 25, 2020Zapier is the most popular software that helps connect your apps and automate workflow. It became the number one tool in this niche, but using Zapier may be too expensive for some businesses since it limits the number of tasks and events you can send in each plan. This article will explain how you can use Google Tag Manager Server-Side container to replace one of the most popular Zapier features – automatic Slack notifications.
Apr 3, 2022Want to learn how to set up the Snapchat Conversion API using server Google Tag Manager? Look no further! In this blog post, I will talk about everything you need to know.