All Collections
Enhanced Scripts for Google Ads
Generate Text Ad Bulksheets
Generate Text Ad Bulksheets (Deprecated) - User Guide
Generate Text Ad Bulksheets (Deprecated) - User Guide
Geetanjali Tyagi avatar
Written by Geetanjali Tyagi
Updated over a week ago

On this page:

Basic Settings

  • 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. 

  • 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.

  • 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. 

  • Does the Best Ad Have the Highest or Lowest Value For The Metric: Specify whether the metric should have the highest or lowest value.

Advanced Settings 

Google Spreadsheet Settings

URL of Target Spreadsheet:
This option lets you add this report to an existing Google Spreadsheet. 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.

  • 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 Google Ads Editor or Bulk Upload option to select the format in which you want to upload the new ads to Google Ads.

  • 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. 

  • Ad Label Is: The name of the Google Ads 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 metric with metrics available in the basic settings. Add a question mark before each metric used. 

Did this answer your question?