Are you ready to save even more time when adding, removing and editing bulk keywords in AdWords? You’re in luck. Google just released a new bulk keyword upload feature that builds on its November 2012 release of the bulk keyword editor.
Add, Edit and Remove Keywords on a Large Scale
The new bulk upload feature makes editing and processing changes to keywords on a large scale much more efficient. Changes to your keywords can now be made directly from a downloadable report in spreadsheet format, instead of using another tool or going back into AdWords to enter them from the spreadsheet to the AdWords user interface.
Senior AdWords product manager Jon Diorio explained in an official announcement, that the new feature “provides a new level of flexibility and automation by allowing you to use standard spreadsheet functions and logic to manage your keywords.”
In its expanded bulk uploading tutorial on AdWords Help, Google does an excellent job at providing a real world example to demonstrate just how efficient the new tool is:
“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. Now, with keyword bulk uploads, she can download an editable keyword report, change her bids by applying her proprietary formula to the spreadsheet, and then commit these changes by uploading the same sheet directly into her AdWords account.
This way she can make hundreds of changes at once, saving her time. Once she uploads the edited report, AdWords will tell Amy how many changes were successfully committed, and how many, if any, had errors that prevented individual changes from being committed. Should she have any errors in her upload, she can then download a version of her report detailing those errors, fix them, and then upload that report, ensuring that all her changes happen.”
Are you convinced it’s worth a shot? I know I am.
How to Test and Use Keyword Bulk Edit Uploads
To test or use the new feature, navigate to the keywords tab for your selected campaign and click the “download report” icon. In the “download and schedule report” window, you can now click the box next to ‘editable?’ to download an editable version of the keyword report.
Before you start editing your keyword spreadsheet, you should familiarize yourself with all of the variables involved in editing keywords in an uploadable document. This will guarantee that your changes translate accurately back to your AdWords campaigns. Here are a few key points to keep in mind that I’ve summarized from the AdWords tutorial:
- Leave the first three spreadsheet rows intact (report info, parameters, column names);
- Always enter a value in the “Action” column or the row will be ignored;
- Avoid using symbols like [ ] or ““ to specify keyword match type; identify this by typing “broad,” “exact” or “phrase” in the match type column;
- To delete keywords, don’t delete the row in your spreadsheet program – type “remove” in the “Action” column of that row;
- Even if you don’t use AdWords in English, some information displayed and edited must remain in English to ensure proper changes upon upload; those values are listed on the AdWords help page.
Once you download your report and complete your edits, save the file in CSV, TSV or Excel formats. To implement the changes, navigate to the ‘reports and uploads’ tab on the left AdWords sidebar and then click ‘uploads.’
Beware: There’s No Turning Back
If you decide to use the bulk keyword upload feature, be sure to back up your original downloadable report before making edits. This is important because once you upload your edited document; there is no way to reverse your changes.
To ensure that you can switch back to your settings pre-bulk upload, save your original report with a different file name before you start to make edits. This extra step will save you just in case you realize you made an error or need to view your previous settings after you’ve completed the bulk upload.