On this page:
What does it do?
The Ad Template Report script helps you find the best-performing ad headlines and description lines in your Google Ads account. It aggregates the data for the same headlines and description lines throughout the account. This helps you understand what is working for the account and what is not, and generates a report based on that information.
Why should you use it?
To find the best-performing ad text elements in your Google Ads account.
To find the best headline, description or display URL for new ad texts.
To get enough data to make statistically valid decisions about ad text performance by aggregating data from similar ads across an entire account.
Basic Settings
Setting Name
Enter the name you want to give the setting. You can have multiple settings for the same script, and you can choose to pause and enable these settings as you wish.
For example, in one setting you can choose to run the ad template report for brand campaigns, and in another setting, you can choose to run it for non-brand campaigns. You can also categorize campaigns based on the products in the campaigns.
Spreadsheet URL: The script outputs the results onto a Google Spreadsheet. If you want to paste the results into an existing spreadsheet, put in the address of the spreadsheet. The sharing settings for the spreadsheet should be 'anyone with a link'. If you leave "NEW", the script will create a new spreadsheet each time it runs.
Note: If the sharing settings are not correct, the script will not be able to write the URLs it checks to the spreadsheet.
Range: Choose the date range for which you want the script to aggregate data. The default is set to last 30 days.
Campaign Name Includes: If you want to run the script in specific campaigns, you can write the name of the campaign in this field. Leaving it blank will run the script for all campaigns. This can be helpful if you have a very large account or well-segregated campaigns based on product category.
For example, if you put 'Brand' in this field, the script will run for all campaigns that have 'Brand' in their name.
Share Results Spreadsheet With These Google Accounts: Enter additional email addresses you want to share the spreadsheet with. By default, the spreadsheet is shared with Google Ads email address.
Email Addresses To Notify: If you would like to send the notification email to another team member, you can enter their emails in the 'Email Addresses To Notify' setting and they will be notified. You can enter multiple email addresses.