Bulk uploads & edits

Intro to bulk uploads

Next: Format spreadsheets

Using bulk uploads is an efficient way to brand changes to your Google Ads account(due south). This feature saves you fourth dimension by allowing y'all to download templated spreadsheet reports, make line-item changes offline, and so upload those changes dorsum into your account or manager business relationship. If you're using a manager account, you tin upload a single spreadsheet that affects any grouping of accounts y'all choose below your manager account hierarchy.

This allows you to take immediate majority activity on issues and opportunities y'all detect in your information. Nosotros'll explain how to download, edit, and upload a spreadsheet beneath.

Case

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

Once Amy uploads the edited spreadsheet, she tin preview any 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 2nd opinion.

Step 1: Download spreadsheets to edit

There are two options that yous accept to start making an uploadable spreadsheet. The first option is to download a report containing your existing data within Google Ads, which is great when you intend to make line-detail changes to existing data. The 2d choice is to brand an upload spreadsheet from scratch using the supported column headers available in Google Ads, this can be useful if yous are making something new (like creating many new campaigns) rather than making line-particular edits to something that already exists (similar making precise bid adjustments on a grouping of existing campaigns).

Choice 1: Download spreadsheet direct from Google Ads account

Downloading your spreadsheet from your Google Account is highly recommended as information technology not only gives you the required editable columns that y'all demand, just also populates those columns with your existing data. This will allow y'all to make unproblematic line-particular changes to your information rather than having to manually import the required data needed to make changes.

  1. Sign in to your Google Ads account.
  2. Select All campaigns from the navigation menu.
  3. Select Keywords, Ads, Advert Group, Campaigns, or Product groups (depending on the type of edits you'd similar to brand).
  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" cheque the box for Editable columns for Majority Upload.
  7. Click Download.

Attempt it now

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

Option two: Download or Create a Spreadsheet Template

While Option 1 is oftentimes the best choice, sometimes downloading your existing data is not helpful to your use case. It may be easier to start with a blank template and fill in the required changes on your own. (For instance, if you 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-fabricated template from our Templates page that matches your use case and save your original downloaded spreadsheet.

Note: Nosotros recommend that yous ever salve a copy of your original downloaded report in case you ever need to see what your settings were before y'all made changes

Move on to step 2: Format spreadsheets for bulk uploading

Was this helpful?

How tin can nosotros better information technology?