Majority uploads & edits

Intro to majority uploads

Next: Format spreadsheets

Using bulk uploads is an efficient way to make changes to your Google Ads account(s). This feature saves you time by allowing y'all to download templated spreadsheet reports, make line-detail changes offline, and so upload those changes back into your account or director account. If you lot're using a manager account, y'all tin upload a single spreadsheet that affects whatever group of accounts yous choose beneath your manager account hierarchy.

This allows you lot to take immediate majority action on problems and opportunities you observe in your data. We'll explain how to download, edit, and upload a spreadsheet below.

Instance

Amy is an online retailer who sells sporting equipment. She has thousands of keywords spread across dozens of advertisement groups. In the past, she used spreadsheets and a proprietary formula to make changes to her bids, which she entered manually into her Google Ads account. With bulk uploads, she tin download a spreadsheet of her keywords, change her bids past applying her proprietary formula to the spreadsheet, then upload this same spreadsheet directly into her Google Ads account.

Once Amy uploads the edited spreadsheet, she tin can preview whatever changes, get details of possible errors, and apply the changes when she's ready – all in the same tab. She tin can even share her preview with colleagues if she wants a second opinion.

Step ane: Download spreadsheets to edit

There are ii options that you have to get-go making an uploadable spreadsheet. The first option is to download a study containing your existing data within Google Ads, which is great when you intend to make line-item changes to existing data. The second option is to brand an upload spreadsheet from scratch using the supported column headers available in Google Ads, this tin be useful if you are making something new (like creating many new campaigns) rather than making line-item edits to something that already exists (like making precise bid adjustments on a group of existing campaigns).

Choice one: Download spreadsheet straight from Google Ads account

Downloading your spreadsheet from your Google Account is highly recommended as it not only gives you the required editable columns that yous demand, only likewise populates those columns with your existing data. This volition permit y'all to make simple line-particular changes to your data rather than having to manually import the required data needed to make changes.

  1. Sign in to your Google Ads business relationship.
  2. Select All campaigns from the navigation menu.
  3. Select Keywords, Ads, Ad Group, Campaigns, or Product groups (depending on the type of edits you lot'd like to make).
  4. Click the download icon Download, and select More options at the bottom of the dropdown.
  5. Select a format for your spreadsheet.
  6. Under "Include" check the box for Editable columns for Bulk Upload.
  7. Click Download.

Attempt it now

Note: If you download a report, it may not include all of the fields you tin edit. Please review the listing of supported columns to see all editable columns y'all are able to touch on with bulk upload

Option 2: Download or Create a Spreadsheet Template

While Option 1 is frequently the all-time option, sometimes downloading your existing data is not helpful to your use case. It may exist easier to start with a blank template and fill in the required changes on your own. (For example, if y'all are creating new campaigns). If that is your goal, downloading a pre-congenital template or making your own template may be a more efficient option.

Download a pre-made template from our Templates page that matches your utilize instance and relieve your original downloaded spreadsheet.

Note: We recommend that you lot e'er save a copy of your original downloaded study in example you e'er demand to encounter what your settings were earlier yous made changes

Move on to step 2: Format spreadsheets for bulk uploading

Was this helpful?

How can we ameliorate information technology?