Copyright 2023 Google LLC. This is not an official Google product. This solution, including any related sample code or data, is made available on an “as is,” “as available,” and “with all faults” basis, solely for illustrative purposes, and without warranty or representation of any kind. This solution is experimental, unsupported and provided solely for your convenience. Your use of it is subject to your agreements with Google, as applicable, and may constitute a beta feature as defined under those agreements. To the extent that you make any data available to Google in connection with your use of the solution, you represent and warrant that you have all necessary and appropriate rights, consents and permissions to permit Google to use and process that data. By using any portion of this solution, you acknowledge, assume and accept all risks, known and unknown, associated with its usage, including with respect to your deployment of any portion of this solution in your systems, or usage in connection with your business, if at all.
LEGO is a data pipeline solution that helps clients fetch Google Ads metrics and stores the data in clients' Google Cloud Big Query tables.
It is a powerful tool that can help businesses track their ad performance and make informed decisions about their campaigns.
The backend of LEGO leverages two Open-source solutions:
- https://github.com/GoogleCloudPlatform/cloud-for-marketing/tree/main/marketing-analytics/activation/data-tasks-coordinator
- https://github.com/GoogleCloudPlatform/cloud-for-marketing/tree/main/marketing-analytics/activation/gmp-googleads-connector
LEGO offers a number of features that make it a valuable tool for businesses, including:
- The ability to daily fetch Google Ads metrics
Lego can help businesses benefit in a number of ways, including:
- Improved ad performance
- Increased ROI
- Better decision-making
- Increased efficiency
We suggest using a new Cloud Project to install this solution. Following installation process should be run by the project owner.
Follow preparation doc to create authentication credentials and Google Ads developer token.
| Product | Resource | Notes |
|---|---|---|
| Google Ads | MCC account ID | The top MCC account contains all the Ads accounts for reporting. |
| Google Ads | Developer token | Check the access level. Should be Standard access. |
| Google Ads | User account | Grant access to Google Ads accounts through OAuth during the installation. |
| GCP | Billed GCP project ID | This GCP shouldn’t engage with any other Google Ads developer token. |
| GCP | User account | Login in GCP and install the solution, ideally the 'owner'. |
| GCP | OAuth client ID and client secret | The OAuth application’s type should be ‘Desktop app’. |
| Other | Google account | Needs to be submitted before installation to be grant access. |
- Open the Cloud Shell
- Git clone the repo
Run the deployment scrip, and follow the prompt to enter your client id, client secret, Google Ads developer token, and mcc id.
cd ads-bi-suite; chmod a+x deploy.sh; ./deploy.sh2.4.1. Initialize Firestore in Native mode in Google Console
2.4.2. Prepare the Google Ads API TOKEN - See Instruction
| Timeline | Item | Notes |
|---|---|---|
| Q2"23 | Upgade to Google Ads API v.13 | The top MCC account contains all the Ads accounts for reporting. |