Make changes with bulk uploads
Using bulk uploads is an efficient way to make changes to the keywords, ads, ad groups, campaigns and product groups (for Shopping campaigns) in your AdWords account. This feature saves you time by allowing you to download spreadsheets, make changes offline, and then upload the updated spreadsheet back into your account where your new changes will be applied. This way you can take immediate, bulk action on issues and opportunities that you observe in your data. In this article, we’ll explain how to download, edit and upload a spreadsheet.
Amy is an online retailer who sells sporting equipment. She has thousands of keywords spread across dozens of ad groups. In the past, she used spreadsheets and a proprietary formula to make changes to her bids, which she entered manually into her AdWords account. With bulk uploads, she can download a spreadsheet of her keywords, change her bids by applying her proprietary formula to the spreadsheet, then upload this same spreadsheet directly into her AdWords account.
Once Amy uploads the edited spreadsheet, she can preview any changes, get details of possible errors and apply the changes when she’s ready – all in the same tab. She can even share her preview with colleagues if she wants a second opinion.
Download spreadsheets to edit
- Sign in to your AdWords account.
- Click the Campaigns tab.
- Click the Keywords, Ads, Ad Group, Campaigns or Product groups tab (depending on the type of edits that you’d like to make).
- From the Edit menu, choose Download spreadsheet.
- Choose a format for your spreadsheet and click Download.
If you download a report, it won't include all of the fields that you can edit.
After a bulk upload has been submitted, there's no automated way to cancel or reverse your changes. Therefore, we recommend that you always save a copy of your original downloaded report in case you ever need to see what your settings were before you made changes.