The marketing world is constantly changing, and what was true yesterday may not be true today. How do you manage this chaos and stay on top of it? How to effectively analyze the benefit of the changes made in the advertising system account and detect mistakes in time? Imagine a script that presents you with five key metrics in five clear graphs, all built on 180 days of data. And the best part? This data is broken down by the platforms where the ad is served.
This script is exceptional because it’s easy to deploy, and its outputs are easily visualized in Looker. You can see the breakdown down to such granularity as days, weeks, or months.
It allows us to analyze better the impact of changes, such as adding a new ad and adjusting tROAS and budget. We can immediately detect bugs or errors made in campaigns. As a bonus, we can track the impact on pmax if we make adjustments in other campaigns.
Are you curious about how and where we use this script? Watch our video:
How to set up a PMAX report:
Step 1.
Make a copy of the Config spreadsheet Template Config spreadsheet PMAX, which will serve us for easy setup.
Step 2.
Make a copy of the spreadsheet Template PMAX Cost Daily, which will be used for data storage.
Step 3.
Fill in the Config spreadsheet.
The Config spreadsheet contains four columns that we need to fill in:
Column A (Client): It is used to identify the client.
Column B (Google Ads Account): Here you need to enter the Google Ads account id, i.e. in the form “123-456-7890”.
Column C (Spreadsheet): Here, you need to enter the URL to the document “PMAX Cost Daily” in the form “https://docs.google.com/spreadsheets/d/xxxxxxxxxxxxxxxxx/edit”.
Column D (Days back): It defines the number of days we want to download the data. The recommended value is “180”.
Config spreadsheet defines the accounts from which we want to download data. Each row represents a separate client account. It is also necessary to have a different “PMAX Cost Daily” file for each client (Step 2.).
It is possible to add multiple clients to the Config spreadsheet. The number of them depends on the size of the client and the number of campaigns. It should be taken into account that Google Ads Script has a timeout of 30 minutes.
Step 4.
Copy the script https://drive.google.com/file/d/1871wkHZG5Eu4ZvBCKMzp6XEPtuFQjtYG/view?usp=sharing and insert it into Google Ads.
We insert the script at the MCC account level, not at the client account level.
Google Ads > Tools and Settings > Bulk Actions > Scripts
Click on “+” > New script
Step 5.
In the 9th line of the script insert the URL address of the Config spreadsheet in the form “https://docs.google.com/spreadsheets/d/xxxxxxxxxxxxxxxxx/edit”
Step 6.
Save the script and run it.
Step 7.
Set the frequency of how often and when to run the script.
Step 8.
Create a copy of the report https://lookerstudio.google.com/reporting/49288c9e-c3c5-45dd-8e81-c5795205e8e7
Click on the three dots at the top right and then “Make a copy”. This will create a custom report to which we will add data in the next step.
Step 9.
After copying the report, you need to add the data source. This is done as follows:
Resources > Manage added data sources > Add data source.
Select Google Sheet and find the spreadsheet we created in Step 2.
Select the “PMAX Daily Data” tab.
Click Add and wait for a while until the data source is loaded.
Step 10.
Once it is loaded, click File > Report settings in the top menu.
Settings will open on the right and select “Select Data Source”,and select the data source we added in Step 9.
