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 you observe in your data. In this article, we’ll explain how to download, edit, and upload a spreadsheet.

Example

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

  1. Sign in to your AdWords account at https://adwords.google.com .
  2. Click the Campaigns tab.
  3. Click the KeywordsAds, Ad Group, Campaigns, or Product groups tab (depending on the type of edits you’d like to make ).
  4. From the Edit menu, choose Download spreadsheet….
  5. Choose a format for your spreadsheet and click Download.
Try it now
Tip: Save your original downloaded spreadsheet

Once a bulk upload is submitted, there is 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.

Downloading an editable ad extension template
  1. Sign in to your AdWords account at https://adwords.google.com.
  2. Click the Campaigns tab.
  3. Click the Ad extensions tab.
  4. From the Edit menu, select Download spreadsheet template.
  5. Select the format for your report.
  6. Click Download.

Edit spreadsheets with account changes

General rules for editing spreadsheets

Add keywords, ads, ad groups, campaigns, or product groups

To add a keyword, ad or any other item, create a new row in your downloaded spreadsheet.

Next, enter any values you want for your new item, such as bid, budget or status. If you do not specify a status, any new items will default to being enabled.

Remove keywords, ads, ad groups, campaigns, or product groups

To remove a keyword, ad or any other item:

  1. In your downloaded spreadsheet, find the row containing that item.
  2. In the Status column for that row, enter Removed.
  3. Upload your spreadsheet.

General rules for editing

  • Do not modify or delete the second row, which contains column names.
  • You do not have to note or signal your changes. When you are finished and you upload your spreadsheet, we will compare the spreadsheet to your current options to pick out any changes you’ve made. You’ll also have the chance to preview any changes before you make them.
  • Don’t worry about deleting extraneous columns or the total rows.
  • Be sure to save your spreadsheet in one of our supported formats (.xls, .xlsx, .tsv, or .csv).
Tips for editing your keyword spreadsheets
  • Type the keyword in the Keyword column. Use square braces ([ ]) or quotes ("") around the keyword to specify exact or phrase match.
  • Enter the ad group name in the Ad group column.
  • You cannot edit the keyword or match type column for an existing keyword. When you change a keyword or match type, the old keyword is removed and a new one is created. The same is the case with bulk uploads. Therefore, if you want to edit a keyword or match type in an editable report, you will have to remove the current and create a new keyword with your desired changes.
Tips for editing your ads spreadsheets

You cannot edit the text for an existing ad. When you change an ad, the old ad is removed and a new ad is created. The same is the case with bulk uploads. Therefore, if you want to edit an ad offline in a spreadsheet, you have to remove the current ad and create a new ad with your desired changes.

Tips for editing your ad extension spreadsheet

Add an ad extension

To add a new ad extension, select a blank row and enter “Add” in the Action column.

  • In the “Campaign” column, type the campaign where you want to add your extension.
  • If you want to add the extension to an ad group, then also specify the ad group in the “Ad group” column.
  • To add an app extension, you must specify:

    • Mobile OS: The operating system that your target customers are using. You can enter android or ios.
    • Package name: The unique ID of your app. For Android, the Package Name follows id= in the app’s Google Play URL:

      http://play.google.com/store/apps/details?id=com.example.appname

      For iOS apps, enter the App ID, which appears after id in the app’s iTunes URL:

      http://itunes.apple.com/us/app/example-app-name/id#########

    • App link text: Text that people will click on to get to your app. For example, you could use “Download app.”
    • App link URL: The URL displayed to your customers for your app. For example, this might be the URL of your app in the Google Play store.
  • To add a call extension, you must specify:

    • Phone number: The number that will be called when a customer clicks your extension.
    • Country code: The country where your phone number is listed. For example, if your phone number is in the United States of America, you would put US.
    • Use forwarding number (optional): Whether you want to use a Google forwarding number with your ad. You can enter yes or no. The default is no.
    • Is call only (optional): Whether you want your ad to show only your phone number, or to show both your number and website URL. You can enter yes or no. The default is no.
  • To add a review extension, you must specify:

    • Source name: The person or organization that provided the review.
    • Source URL: The URL where the person or organization printed your review.
    • Text: The text of your review.
    • Is exact quote (optional): Whether your text is exactly the words in the review. You can enter yes or no. The default is no.
  • To add a sitelink extension, you must specify:

    • Sitelink text: The text that you want to appear as the clickable link in your sitelink.
    • Sitelink URL: The URL where the link in your sitelink will lead.
    • Description 1 and Description 2 (optional): Descriptive text that will appear below your sitelink link text. This text should provide additional information to your target customer about what they will find if they follow your sitelink.
  • To add callout extensions, you must specify:
    • Callout text: The text you want to appear as your callout

Optional specifications for all ad extensions

In addition to the required columns in each report, you can use bulk uploads to identify device preference, start and end dates for your extension, and scheduling preferences. To specify these options, add a new column to your spreadsheet with the following names and information:

  • Start time: The date and time you want your extension to start showing. This should should use a mm/dd/yyyy hh:mm format. For example, July 1, 2014, at 3:05 p.m. would be 07/01/2014 15:05.
  • End time: The date and time you want your extension to stop showing. This should should use a mm/dd/yyyy hh:mm format. For example, July 1, 2014, at 3:05 p.m. would be 07/01/2014 15:05.
  • Device preference: The devices you want to show your extension on. You can specify all or mobile.
  • Scheduling: The days of the week and times you want your extension to be shown. You must use the format of Day, start time - end time. For example, if you wanted to schedule from 9 a.m. to 5 p.m. on Mondays, you would enter Monday, 09:00 AM - 05:00 PM. If you want to schedule for multiple days, separate your days with a semicolon. For example, you could schedule for both Monday and Tuesday using Monday, 09:00 AM - 05:00 PM; Tuesday, 09:00 AM - 05:00 PM.

Remove an ad extension

To remove an ad extension, enter Remove in the Action column of that ad extension’s row. This will remove the extension from the campaign or ad group (though the extension will still exist for use with other campaigns and ad groups). Deleting the row or removing the contents from the row will have no effect.

Edit your product group report

Below are the columns you’ll see in your editable product group report, along with instructions for how to make your changes. Depending upon the columns visible on your “Product groups” tab when you downloaded your report, you could see additional columns, all of which are non-editable.

For all changes, make sure you enter Set in the “Action” column. If you make changes without this step, our system will ignore the row completely, and your changes will not take effect.

Column name Description Edit instructions
Campaign Shows the name you gave your campaign. Editable (Must also change campaign ID)
Campaign ID Shows the number AdWords assigned to each campaign. Editable (Must also change campaign name)
Ad group ID Shows the number AdWords assigned to each ad group. Editable (Must also change ad group name)
Ad group Shows the name you gave your ad group. Editable (Must also change ad group ID)
Criterion ID Shows the number AdWords assigned to each product group. Non-editable
Product group Shows how the product group has been subdivided. For example, ‘* / Category = "Electronics" / Brand = *’ indicates a product group that was initially subdivided by the Google Product Category “Electronics,” then subdivided again by the “Brand” attribute. Non-editable
Partition type Shows whether a row represents a subdivision or a unit. Non-editable
MaxCPC Shows the current maximum cost-per-click bid for the product group. You won’t see a value if the product group has been sub-divided. To change your bid, edit the value in the column.
Clicks Shows the number of clicks on ads for the products in that product group. Use this information to decide how you might want to adjust your bid. Non-editable
Keyword/Placement landing page Shows the current landing page for the product group. You won’t see a value if the product group has been sub-divided. To change your landing page, change the value in the column.
KTracking template Shows the tracking template. Edit the template in the column.
Custom parameter Shows your custom parameters. Edit the names and values in the column.

Upload your spreadsheets

How to upload through the Edit menu
  1. From the Edit menu, choose Upload spreadsheet….
  2. Click Choose file….
  3. In the window that appears, select the spreadsheet you want to upload.
  4. Click Upload and preview.
  5. To view more details about any proposed changes or errors, click Preview changes. Otherwise, click Apply changes.
How to upload in the Bulk operations section

Here's how to upload your spreadsheet:

  1. In your AdWords account, click Bulk operations in the left navigation window.
  2. Select Bulk uploads.
  3. Click Choose file… to locate your edited and saved spreadsheet.
  4. Click Upload and preview.
  5. When loaded, a preview of your changes will appear. At this point, you can see what your changes would look like, fix any errors in your spreadsheet then upload again, or ignore the errors and click Apply changes.
View the results of your upload

Once your file is uploaded, you’ll see a new entry for that file at the top of the table in the Bulk operations section. Applied changes will have a Details link where you can view your past changes. For uploaded spreadsheets that you have not applied, you can choose to Preview, Apply, or Remove.

What to do if there are errors
  1. Locate your spreadsheet in the Bulk operations table.
  2. In the row with your report, click Download > Errors only or click Details to look at the errors within your account.
  3. In the Results column on the spreadsheet – or the Status column if you’re looking at errors in your account – find the issue with each row, then fix that issue.
  4. Save the file then upload it in the Bulk Operations area.