Bulk Update Ads using Generate Text Ad Bulksheets Enhanced Script

Steps to update ads using Generate Text Ad Bulksheets: 

When there is a seasonal promotion or offer, you may want to bulk update ads with the new promotion. Or, add new ads highlighting the promotion. You can read more about how to use this script to create ads for this use case.

1. After the script runs, access the generated Ad Bulksheet/spreadsheet from the 'Logs' section in Optmyzr. Open the spreadsheet to make changes.

2. In the generated Ad Bulksheet, add a filter to the top row. Then filter to only see suggestions with a specific ad type - legacy or expanded. You can then bulk edit the description lines and headlines to add seasonal offers to the text ads.

a) For example, in legacy text ads, update the seasonal or promotional offer in the Description Line 2 and copy it across all the suggested ads cells. After this, copy all the cells and paste the values on a new sheet. You'll have to use the paste special function (screenshot below).

b) Similarly, for expanded text ads, you can edit the seasonal or promotional offer in Headline 2 in one go and copy it across all the cells for the shortlisted ads. After this, copy all the cells and paste special (with values only) it on a new sheet. 

3. For both ad types, after copying the ads in a separate sheet, remove the cells not relevant to the specific text ad type. For example, remove the cells not relevant to expanded text ads and copy the remaining cells (relevant to expanded text ads) on to another sheet. This new sheet is now ready to be imported to AdWords to create expanded text ads.

4. Upload all the ads through AdWords Editor by selecting one of the available options in AdWords Editor -  'Paste text' or 'Import from file'.

Demo Video


Can’t find what you’re looking for?

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