Generate Text Ad Bulksheets - User Guide

This Enhanced Script generates an Ad Bulksheet that can be used to create new ads in your AdWords account. The script creates Ad Bulksheets based on the performance of the existing ads. It lets you choose the metric which you'd like to use as a benchmark for creating new ads. The generated ad bulksheet can be used later on for creating new ads via bulk uploads or the AdWords Editor. 


Use Cases

  1. Bulk update ads to highlight ongoing promotions, include seasonal messaging or create ads in ad groups that have less than a certain number of ads.
  2. Migrate legacy text ads to expanded text ads  

How to set up the script Generate Text Ad Bulksheets?

Before you can start using the script, you need to create the settings for the account where the script will run. Access the Generate Text Ad Bulksheets Script in the interface from the Enhanced Scripts® page. Click on 'Add Setting' or 'Create a Setting' to configure the script. 

Basic Settings

1. Setting Name

Give a name to the setting for creating the ad bulksheet. Using a descriptive name helps recall what the setting does as you can have multiple settings for the same script.

2. Goal of the Bulksheet

a) Goal:  Define the goal the script should meet. You can choose to either add 'n' number of ads to every ad group or ensure that each ad group has at least 'n' number of ads in it. 

b) Value of N For The Previous Question: Define the number of ads, you want to create in each ad group or the number of ads that each ad group should have depending on the selected goal.

3. How to determine the best current ad that the script will use as the default

a) Metric used to select the best ad: Specify the metric you'd like to choose for selecting the default ad for creating the new ads. You can choose from the following three options:

  • AdWords metric - Impressions, Clicks, Conversions etc.
  • Optmyzr metric - Share of clicks, conversions or impressions in an ad group.
  • Custom Calculation metric - Create your own custom metric using the available AdWords metrics to select ads. 

b) Does the best ad have the highest or lowest Value For The Metric: In this setting, you need to specify whether the metric should have the highest or lowest value. Say you want to add new ads based on ads that have the highest CTR. Then you can select highest after you select CTR in the setting above. However, if you choose cost/conversion as a metric then the best performing ads will have the lowest value.

c) Date Range
Choose the date range that the script should use to analyze data when selecting the best performing current ad variation to create copies. 

4. Notifications and sharing

a) Email Addresses to Notify: Comma-separated e-mail addresses of all the users who should get an e-mail when the spreadsheet is ready.

b) Share results spreadsheets With these Google accounts: Mention the Google accounts that should have access to the spreadsheet after the script generates it.


Advanced Settings 

1. Google Spreadsheet Settings

a) URL of target spreadsheet: This option lets you add this report to an existing Google Spreadsheet. You can either:

  • Enter the URL of an existing Google Spreadsheet to which the script adds the report.
  • Leave this option blank to create a new spreadsheet every time the script runs.

b) Name for new spreadsheet: If you select the second option in the setting above, you can give a name to the new spreadsheet here. The script can also append account name, the date when the spreadsheet is generated or the date when the default metric for ad creation was selected.

2. Spreadsheet location: Mention the comma separated list of folder and sub-folder names where the spreadsheets should be saved every time they are created. You can use [account name] or [account id] which will be automatically converted to the right values for your account.

3. Sheet settings: Name of the sheet in which the new spreadsheet should be pasted. It will create a new sheet in the spreadsheet if left empty.

4. Bulksheet settings: Choose between AdWords Editor or Bulk Upload option to select the format in which you want to upload the new ads to AdWords.

5. Campaign Picker

a) Campaign Label is - Select campaigns with specific labels for the script to evaluate or leave empty to select all campaigns.

b) Campaign Name Contains - Select campaigns by specific names or leave empty to select all campaigns. 

6. Limit which ads to consider

a) Ad label is - The name of the AdWords label you applied to ads. This limits which ads the script evaluates and this impacts two things: 1. which ads are used to select the current best ad, and 2. the count of how many ads the script thinks exist in each ad group.

b) Device preference is - This setting limits which types of ads the script evaluates and this impacts two things. 1. which ads are used to select the current best ad, and 2. the count of how many ads the script thinks exist in each ad group. You can add another setting to consider only enabled campaigns and/or ad groups for selecting the default ad to create new ad text. Uncheck the boxes here to select data from paused campaigns/ad groups. So if certain campaigns are paused due to spent budget, you still might want the script to evaluate these to create the ad bulksheet. 

7. How the best ad is selected

a) Custom Metric Formula - Create a custom metrics with metrics available in the basic settings. Add a question mark before each metric used. For example: To include CTR and Conversion rate as custom metrics you can type in = ?CTR* ?Conversion rate

b) Minimum Impression Threshold - Minimum impressions the ad should have had before being considered as the best ad. 

After defining all the settings, click on save settings. After this, you can download and install the script in AdWords.


Install script

You can learn how to install the script in AdWords here.


Can’t find what you’re looking for?

Our award-winning customer care team is here for you.