On this page:
What does the script do?
The PMax Search Terms script adds all your Performance Max search term data into a spreadsheet. These automated reports provide enhanced visibility into search term performance, significantly surpassing previous options available for Performance Max campaigns. You can run the script either at the account level or at the MCC level.
The script includes the following search term information in the report:
Campaign Name
Category Label
Search Term
Sub Category
Impressions
Clicks
Conversions
Conv. Val
CTR
Why use this script?
Utilizing a script automates the search term analysis process, reducing your time multifold. This data is beneficial for analyzing search term patterns, optimizing campaigns, and refining audience targeting by identifying:
Irrelevant search terms that trigger your ads
High-performing search terms that drive conversions - you can optimize these terms for more search volume
Search categories for additional keyword ideas that are already working
High-impression, low-click terms that may indicate poor ad relevance and could benefit from better ad creative assets like headlines and descriptions
It’s your ticket to greater PMax control!
Settings
Google Spreadsheet settings
The script outputs the results onto a Google Spreadsheet. You can ask the system to:
Paste the results into an existing spreadsheet: You'll need to enter the spreadsheet’s URL in this field, and the system will update this spreadsheet during every run. The sharing settings for the spreadsheet should be 'Anyone with a link'.
Please note that if the sharing settings are not correct, the script will not be able to write data onto the spreadsheet.
Create a new spreadsheet each time the script runs: For this, simply mention "NEW" in the text field.
Date range period
Choose your preferred date range for populating the PMax search term data, ranging from “Last 7 Days” to “Last 360 Days” from the dropdown.
Note - It won’t be possible for the script to pull search term data from before March 2023, since this data wasn’t available before then.
Notifications and Sharing
Email Addresses To Notify: Enter a comma-separated list of email addresses of everyone whom the system should notify when the script executes.
Share Results Spreadsheet With These Google Accounts: Enter any additional email address(es) you want to share the spreadsheet with, separated by commas.
Thresholds for Categories
Set thresholds for Categories based on the following KPIs for obtaining refined search term performance data:
Impressions
Clicks
Conversions
Only Categories meeting or exceeding the specified KPI value(s) will be included in the spreadsheet.