Bulk uploads

Bulk uploads is an efficient way to make changes to the keywords, ads and ad groups in your AdWords account. This feature saves you time by allowing you to download editable reports, make changes right in the document, and then upload the updated reports back into your account where your new changes will be automatically 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 report.

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. 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.

Downloading your editable report

  1. Sign in to your AdWords account at http://adwords.google.com.
  2. Click the Campaigns tab.
  3. Click the KeywordsAds, or Ad Group tab (depending on which kind of report you want to download).
  4. Make sure the table is displaying all of the keywords, ads or ad groups you may want to edit. Then, click the download button, which looks like Download button.
  5. Check the box marked "Editable." (Note: you can't have segments in editable reports, and they can only be downloaded in .csv, .tsv, and Excel formats.) Select editable
  6. Click "Create."
Try it now
Tip: Save your original downloaded report

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 and submitted a bulk upload.

Editing your keyword reports

When you edit your report, there are some specific rules to follow to ensure that we properly interpret your change requests.

General rules for editing your keyword reports

  1. Do not modify or delete the first three rows: Report info, Parameters, and Column names.
  2. For every change you make, whether it's an addition, a deletion, or an edit, you must enter a value in the "Action" column. You have three options: Add, Remove, or Set. If you don’t enter one of these action words in the “Action” column of a row, our system will ignore the row completely, and your changes will not take effect.
  3. When editing an existing row, you can only modify these three columns: keyword state (“paused” or “enabled”), destination URL, and keyword max CPC. Changes to any other column will be ignored.

    For example, when editing an existing row, you cannot change the keyword or match type values. If you wish to change a keyword’s match type, you must delete the keyword and re-create it with the proper match type. (See the “Instructions for common edits” section below for a step-by-step guide.)
  4. Don’t worry about deleting extraneous columns or the total rows. Simply upload the whole report, and we’ll ignore what isn’t essential.
  5. Do not use square braces ([ ]) or quotes (“”) to indicate a keyword’s match type. Instead, specify the keyword’s match type by name (broad, exact or phrase) in the match type column.
  6. Be sure to save your upload file in one of our supported formats(.csv, .tsv, and Excel).

Instructions for common edits

  • Add a keyword

    To add a new keyword, select a blank row and enter "Add" in the Action column.

    1. Enter “enabled” or “paused” in the keyword state column. (If you leave this blank, the keyword will default to “enabled”)
    2. Type the keyword in the keyword column. Do not use square braces ([ ]) or quotes ("").
    3. Enter a value for match type in the match type column (broad, exact, or phrase).
    4. Enter the ad group ID number in the ad group ID column. (You can copy this number from another row in the report.)
    5. Keyword max CPC bid and destination URL are optional fields. If you leave these blank, the ad group default CPC bid and the individual ad destination URLs will apply.
    6. Leave the keywordID column blank. AdWords will assign an ID to this keyword.
  • Delete a keyword

    To delete a keyword, enter "Remove" in the Action column of that keyword's row, without the quotation marks. Simply deleting the keyword or the row will have no effect.

  • Edit a keyword's status, maximum CPC or destination URL
    • For example, to change the status of a keyword from "paused" to "enabled," enter "Set" in the Action field of that keyword's row, and change "paused" to "enabled" in the keyword status column.
    • To edit an attribute such as a keyword max CPC bid or a destination URL for a specific keyword, change the value in the appropriate column and then enter “Set” in the Action column.
    • To delete a keyword max CPC bid or destination URL, enter “delete_value” in the cell. Simply deleting the contents of the cell will have no effect.
  • Edit a keyword or match type

    You cannot edit the keyword or match type column for an existing keyword. When you change a keyword or match type in the AdWords web interface, the old keyword is deleted 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 delete and recreate the keyword using the steps for adding a keyword outlined above.

Editing your ad reports

When you edit your report, there are some specific rules to follow to ensure that we properly interpret your change requests.

General rules for editing your ad reports

  1. Do not modify or delete the first three rows: Report info, Parameters, and Column names.
  2. Only text ads can be modified using bulksheets.
  3. For every change you make, whether it’s an addition or a deletion, you’ll have to enter a value in the “Action” column. You have three options: Add, Remove, or Set. If you don’t enter one of these action words in the “Action” column of a row, our system will ignore the row completely, and your changes will not take effect.
  4. When editing an existing row, you can only modify these columns: Ad state (“paused” or “enabled”). Changes to any other column will be ignored. To modify the ad text, you must delete the existing ad and create a new one. So you will have two rows, one marked Remove and another marked Add.
  5. Don’t worry about deleting extraneous columns or the total rows. Simply upload the whole report, and we’ll ignore what isn’t essential.
  6. Make sure you save your upload file in one of our supported formats (xls, xlsx, csv, tsv).

Instructions for common edits

  • Create a new text ad

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

    1. Enter “enabled” or “paused” in the ad state column. (If you leave this blank, the ad will default to “enabled.”)
    2. Type the ad text in the Ad (type the headline here), Description line 1, Description Line 2, Display URL and Destination URL columns.
    3. Optionally, specify the device preference. If you leave this blank, the device preference will default to “All.”
    4. Enter the Ad group ID number in the Ad group ID column. (You can copy this number from another row in the report.)
    5. Leave the AdId column blank. AdWords will assign an ID to this ad.
  • Delete a text ad

    To delete a text ad, enter “Remove” in the Action column of that ad’s row, without the quotation marks. Simply deleting the ad or the row will have no effect.

  • Edit an ad’s status

    For example, to change the status of a text ad from “paused” to “enabled,” enter “Set” in the Action field of that ad’s row, and change “paused” to “enabled” in the Ad Status column.

Editing your ad group reports

When you edit your report, there are some specific rules to follow to ensure that we properly interpret your change requests.

General rules for editing your ad group reports

  1. Do not modify or delete the first three rows: Report info, Parameters, and Column names.
  2. For every change you make, whether it’s an addition, a deletion, or an edit, you’ll have to enter a value in the “Action” column. You have three options: Add, Remove, or Set. If you don’t enter one of these action words in the “Action” column of a row, our system will ignore the row completely, and your changes will not take effect.
  3. When editing an existing row, you can only modify these the following columns: State (“paused” or “enabled”), ad group name, default max. cpc, display network max. cpc and max cpm. Changes to any other column will be ignored.
  4. Don’t worry about deleting extraneous columns or the total rows. Simply upload the whole report, and we’ll ignore what isn’t essential.
  5. Make sure you save your upload file in one of our supported formats (xls, xlsx, csv, tsv).

Instructions for common edits

  • Add an ad group

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

    1. Enter “enabled” or “paused” in the ad group state column. (If you leave this blank, the ad group will default to “enabled.”)
    2. Type the ad group name in the ad group name column.
    3. Specify Max CPC bid in the default max. cpc column.
    4. Enter the Campaign ID number in the Campaign ID column. (You can copy this number from another row in the report.)
    5. Display network max cpc and max cpm are optional fields.
    6. Leave the AdGroupID column blank. AdWords will assign an ID to this ad group.
  • Delete an ad group

    To delete an ad group, enter “Remove” in the Action column of that ad group’s row, without the quotation marks. Simply deleting the row or removing the contents from the row will have no effect.

  • Edit an ad group’s Status, Maximum CPC or Destination URL
    • For example, to change the status of a ad group from “paused” to “enabled,” enter “Set” in the Action field of that ad group’s row, and change “paused” to “enabled” in the State column. Similarly, you can change the max cpc of this ad group.
    • To delete the display network max cpc bid to use the default from max cpc, enter “delete_value” in the cell. Simply deleting the contents of the cell will have no effect.

Uploading your report

  1. In your AdWords account, click the Reports and Uploads tab in the left navigation window.
  2. Select the Uploads subtab. Uploads tab
  3. Click "Browse for file" to locate your edited and saved report.
  4. Click the "Upload" button.
  5. A yellow box will appear reminding you that uploading the report will immediately update your account. (Beyond this point, there is no "undo" or "cancel" option.) Yellow dialog box
  6. Clicking "Yes, I understand" will immediately begin the process of applying your changes to your account.

Viewing 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. Check the “Status” column to see if your job is complete. Processing the file may take several minutes. Once it’s complete, you’ll see a summary in the status column with the following updates:

  • rows submitted
  • changes detected
  • successful changes
  • failed changes (if any)
Status column

This summary will also contain a link to “Download results” which will provide you with a copy of your uploaded file, appended with error messages (if there were any errors). This link will be removed 30-60 days after your initial upload.

What to do if there are errors

  • Download the results file from the “Download results” link.
  • Scan the new “Errors” column to find all the rows that are marked with an error.
  • Make the necessary corrections, save the file, and then re-upload the file. It’s fine to upload the whole file again, including the previous changes.

Sometimes there may be a problem that prevents the file from processing. In this case, you’ll find the error message in the first row (if it’s a .csv or .tsv file) or in a new “General Errors” worksheet (if its an .xls or .xlsx file).

For those who don’t view AdWords in US English

While bulk uploads can be used to modify any AdWords account -- regardless of your account’s language -- certain parts of the upload file must be defined in US English (so our computers do not misinterpret your intent).

Therefore, when you download an editable report, the following elements will always be in English:

  • The first three rows (which include columns headers) of the report.
  • All values for the Match Type and Keyword State columns.

This also means that certain values that you enter or edit must also be in English:

  • In the Action column, the only values you can enter are: “Add”, “Set,” or “Remove”.
  • For status, the only values you can enter are: “Paused” or “Enabled.”
  • If you want to delete a cell value (such as Keyword Destination URL), you must enter “delete_value”.

AThe other text fields such as ad group name, keyword or ad text can be in any language.