Created and maintained by tyssejc (charlie.tysse at searchdiscovery dot com).
The goal of this project is to allow you to have a Looker Studio dashboard that provides a "panopticon" view of all the GTM containers you manage.
This project was heavily inspired by b-kuehn's excellent google/analytics-settings-database utility.
- Google Cloud Platform (GCP) project with billing enabled - Create or use an existing project as needed.
- Note: This solution uses billable GCP resources.
- Google Tag Manager
- Navigate to your Google Cloud project and open Cloud Shell
- Enter the following into Cloud Shell:
rm -rf gtm-database && git clone https://github.com/searchdiscovery/gtm-database.git && cd gtm-database && bash deploy.sh- Enter the information when prompted during the deployment process. a. When asked if unauthenticated invocations should be allowed for the Cloud Function, answer no.
- When finished, add the service account email generated during the deployment process to your Google Tag Manager accounts.
This will create the following:
- A Cloud Function (2nd gen)
- A Cloud Scheduler Job
- A BigQuery dataset with the name "gtm_database"
- The following tables:
- gtm_accounts
- gtm_containers
- gtm_tags
- gtm_variables
- gtm_built_in_variables
- gtm_triggers
- A service account with the Editor role