Generate Text Ad Bulksheets - User Guide

What does it do?

This Enhanced Script generates an Ad Bulksheet that can be used to create new ads in your AdWords account. It creates Ad Bulksheets based on the performance of the existing ads, and 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. 

Why should you use it?

  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 does it work?

Choose the account you want to run the script in and go to the All Enhanced Scripts page. The script lets you set basic and advanced settings. 

You can either create a new setting by selecting 'Create new setting' or 'Copy setting from an existing account'. To create a new setting, follow the steps below:

Basic Settings

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.

Goal of the Bulsksheet:

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. 

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.

How to Determine the Best Current Ad:

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. 

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.

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. 

Notifications and Sharing:

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

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 

Google Spreadsheet Settings

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.

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.

Spreadsheet location

Specify by a 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.

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.

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.

Campaign Picker

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

Campaign Name Contains:
Select campaigns by specific names or leave empty to select all campaigns. 

Limit Which Ads to Consider

Ad Label Is:
The name of the AdWords label you applied to ads. This limits which ads the script evaluates and it impacts two things: 

1. Which ads are used to select the current best ad.
2. The count of how many ads the script thinks exist in each ad group.

Device Preference:
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.
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. If certain campaigns are paused due to spent budget, you still might want the script to evaluate these to create the ad bulksheet. 

How the Best Ad is Selected

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

Minimum Impression Threshold:
Minimum impressions the ad should have had before being considered as the best ad. 

How to install and run the enhanced script?

After entering the details for the setting, click on 'Save settings'. This will give you an option to 'Download' the script which can then be installed in the AdWords account. For detailed steps on how to install a script in AdWords, read this article. 

Can’t find what you’re looking for?

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