This Enhanced Script automatically creates ad groups, ad texts, keywords and labels based on a spreadsheet with your data. It can be used to turn a product database into an AdWords account or it can be used as an alternative to the AdWords interface or the AdWords Editor for creating new ads at scale.
Before you can start using the script, you need to create the settings for the account where the script will run.
When creating the settings, the Google Spreadsheet URL you'll use to feed data to the script must include all the columns required to create keywords, ads, and ad groups. If the spreadsheet is blank, the script will display an error.
If you click on the question mark next to each setting, you'll find more details about the information you need to include/choose.
Also, if you need help with the spreadsheet format, you can download our Create Ads from Spreadsheet sample.xlsx.
After you put in the spreadsheet URL, the system automatically pulls the different column headers and shows them on the right side of the screen.
Enter the name of the campaign in which the script will create the ad groups, ads, and keywords. The campaign needs to exist in your account as the script doesn't create campaigns.
You can dynamically insert the data from the spreadsheet into the ad template. To insert it, select the columns from the right by clicking on them.
When creating an Ad Template, you can also dynamically insert the ad data from the spreadsheet to create different templates.
Inserting the column headers will ensure the script picks up the corresponding value from the spreadsheet.
Important: The Display URL must always include www, http, or https. Otherwise, the script will fail.
Create a default ad with no dynamic insertion parameters to make sure that all ad groups will have at least one ad that fits within the characters limits.
The script automatically checks if the same keywords and ads have already been created in the ad groups, so it doesn't create duplicates.
You can learn how to install the script in AdWords here.
Our award-winning customer care team is here for you.