Search
Clear search
Close search
Google apps
Main menu

Keep your business data updated

After you’ve set up your business data feeds, you need to keep your business data feed fresh and updated on a regular basis. You can automatically schedule updates to refresh your business data feed based on how often your data changes. 

Before you begin

Pay close attention to the required feed attributes and make sure your data complies with Google’s advertising policies and any relevant laws in your targeted locations.

This is an instructional article about updating your business data feed. Before you get started, you may want to read About feeds and business data

Add or edit items to your data

You can add or edit items to your data sources one at a time in AdWords, or you can upload a spreadsheet with changes.

Instructions

Add items within AdWords
  1. From Shared library on the left navigation bar, choose Business data.
  2. Under “Name,” click the data source you’d like to add items (rows) to.
  3. Click +ITEM.
  4. Fill out details for your new item.
  5. Click Save.
Edit items within AdWords
  1. From Shared library on the left navigation bar, choose Business data.
  2. Under “Name,” click the data source whose items (rows) you’d like to edit.
  3. Click the value of any item to edit it.
  4. Make your changes, and click Save.
Add attributes within AdWords
  1. From Shared library on the left navigation bar, choose Business data.
  2. Under "Name," click the feed or data set you'd like to add an attribute to.
  3. Click + Add next to "Attributes" and above "Upload history."
  4. Name your new attribute and specify what type of data the column will include.
  5. Click Save.
  6. To see your new attribute, modify your columns to add it.

Note: Attributes that you add to your dynamic display ad feeds should follow these specs; custom attributes aren't available.

Edit your data with a spreadsheet

Bulk-editing with a spreadsheet lets you update multiple rows of your data set or feed at the same time. When you do this, you can choose to replace all the rows, or to update some of the rows. If you choose the update option, you'll need to include an "Action" column and an ID column that's specific to each feature.

Keep in mind that the size limit for your spreadsheet upload is 500MB and 50MB for other file types.

Replace all values with a spreadsheet
  1. Create a spreadsheet to update your data set or feed.
  2. Include the same columns you have in your existing data set or feed. Make sure to match the column names exactly.
  3. From Shared library on the left navigation bar, choose Business data.
  4. Under “Name,” click the data source you’d like to replace.
  5. Click Edit, then choose Upload spreadsheet.
  6. Choose Replace. If your file includes items that are identical to existing ones, AdWords preserves any performance stats for those items.
  7. Click Browse for file, then click Upload.
Update particular rows with a spreadsheet
  1. Create a spreadsheet to update your data set or feed.
  2. Include an Action column. The actions you can define are Set, Add, and Remove.
  3. Include an ID column.
    • For ad customizers, include the Item ID column that AdWords creates, or the Custom ID column that you've added.
    • For dynamic display ads, include the ID column for your vertical. See specs
    • Can't see what the ID is for the rows you want to update? Modify your columns to add an ID column
  4. From Shared library on the left navigation bar, choose Business data.
  5. Under “Name,” click the feed or data set which you'd like to bulk-edit.
  6. Click Edit, then choose Upload spreadsheet.
  7. Choose Update. If your file includes items that are identical to existing ones, AdWords preserves any performance stats for those items.
  8. Click Browse for file, then click Upload.

Note

If you'd like to add a new column to your feed or data set, you'll need to add the attribute within the AdWords interface before uploading data to that column in a spreadsheet. Bulk-editing only applies to existing columns.

Schedule automatic updates

You can set up AdWords to automatically update your business data daily, weekly, or on the first day of the month. Here’s how to schedule automatic updates: 

  1. Sign in to your AdWords account.
  2. In the left menu, click Shared library > Business data.
  3. Click +Data and select your business data file.
  4. Click the Scheduled uploads tab. 
  5. Click +SCHEDULE.
  6. Select how often you’d like AdWords to update your data from the “Frequency” menu. 
  7. Select your data’s format from the “Source” menu. 
  8. Link your file by completing the required fields:
    • Google Drive: Click Choose file, then select the file containing your business data. Once your file is linked, share it with the email address that's displayed on screen, then click Save. Learn how to share a file
    • HTTP: Add your file’s URL to the “URL” field, then click Save
    • HTTPS: Add your file’s URL and the username and password required to access your file, then click Save
    • FTP / SFTP: Add your file’s URL and the username and password required to access your file, then click Save
  9. Click Save.
Was this article helpful?
How can we improve it?
Sign in to AdWords

Get account-specific help and tips by signing in with your AdWords account email address, or learn how to get started with AdWords.