Search
Clear search
Close search
Google apps
Main menu

Manage ads and feeds in "Business data"

Business data is where you provide and manage data sources for ads, extensions, and targeting. You’ll upload some of these sources yourself. Other sources, like phone numbers and sitelinks from your ad extensions, are added in by AdWords.

What's kept in business data

When you go to the Business data section of your Shared library, you'll see a table with the data associated with your account. Ad customizer, ad extension, location targeting and dynamic display ad data can appear here.

Ad customizer data

Ad customizers are parameters that adapt your text ad to the context of a user’s search (for ads on the Search Network), or the website someone’s browsing (for ads on the Display Network).

  • Ad customizers work using ad customizer data that dynamically updates ad text.
  • You upload your ad customizer data within the Business data section of your Shared library.
Learn how to create ad customizers.

Dynamic display ads feeds

If you want to dynamically populate your ads with your products or services, you'll create a dynamic display ads feed. This type of feed is a inventory of your products or services that's sourced to create ads.

  • Rows are products or services. Columns are attributes of each product or service, such as images or prices.
  • You upload your feed to the Business data section of your Shared library.
  • You associate your feed with your dynamic remarketing campaign.
Learn more about dynamic display ads feeds.

Ad extension data

AdWords creates ad extension data in the Business data section of your Shared library, any time you add or edit an ad extension on the Ad extensions tab. You might see, for example, a “Main sitelink feed” with the sitelink text and URLs of your sitelinks extensions.

  • Click on any item to see the approval status, policy details, and performance stats of that extension.
  • Use this interface to edit the extensions you share across multiple entities (like campaigns or ad groups).
  • You’ll see only one entry for the data associated with each extension, even when you share that extension across entities.
  • You can edit the data for your extensions here, but you’ll need to go to the Ad extensions tab to add new extensions.
Learn more about ad extensions.

Location targeting data

You can use location targeting data to target areas that are important to you but are different from your business locations. Here are a few reasons you might want to target other locations:

  • You don’t own the places that distribute your products, like car dealerships.
  • Your products or services might be appealing to customers visiting venues relevant to what you offer. For example, you could target fans of a baseball team by targeting that team’s stadium location.
Learn how to create location targeting data.

Upload a new data set or feed

Unicode encoding supported

"Business data" supports UTF-8, UTF-16 and UTF-32 (it's best to use UTF-8). The data transformation between these formats is lossless.

"Business data" doesn't support UTF7, UTF1, UTF-EBCDIC, SCSU, BOCU, GB-18030, Latin 1, or ISO-8859-1.

Upload your file

  1. Sign in to your AdWords account.
  2. From Shared library on the left navigation bar, choose Business data.
  3. Click +DATA and choose the sort of data you’d like to add.
  4. Name your new data source.
    • It’s best to use a short name without any spaces.
    • Make sure not to re-use the name of an old data set or feed that you've removed. AdWords can only recognize new names.
  5. Click Browse for file and choose the file you’d like to upload. Keep in mind that the size limit for .csv and .tsv files is 500MB and 50MB for other file types.
  6. Click Upload

Check your upload status

  1. Click + Upload history to see your recent uploads.
  2. Under the “ACTION” column, you can Download results if the upload was successful, or Download errors to see what you can fix.

View your data

See the details of your data or feeds

  1. Sign in to your AdWords account.
  2. From Shared library on the left navigation bar, choose Business data.
  3. Under “Name,” click the data source you’d like to look at.
  4. You’ll see a detailed view of that data source.
Modify columns to see more detail

You can customize your data by changing the columns.

  1. From the detailed view of your data source (see steps above), go to Columns, then choose Modify columns.
  2. Click Performance to show statistics for how ads performed when a particular item appeared with the ad.
  3. Click Level of detail to show more detail by campaign, ad group, or ad.
  4. Click Add next to any of the metrics.
  5. Click Apply.

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

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

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.

Fix upload errors

When your data set or feed isn't formatted right, this can prevent your ads from showing. AdWords shows errors that can help you fix your spreadsheet in a few places:

  • In the upload panel: As soon as you upload, you might see text in red describing something that's wrong.
  • Under "Summary" in your "Upload history" table: Errors here show how you should change the format of your uploaded spreadsheet.
  • In the "Details" under "Summary" in your "Upload history" table: Errors here show how you should change the format or content of the rows within your spreadsheet. Want to download a spreadsheet with all of these row-level errors? Click the Download errors button under "ACTIONS."
Fix upload errors
Error message Issue How to fix it
An ID value is not allowed when using the action "Add" You provided an "Item ID" for a row that you're trying to add. New rows shouldn't have Item IDs, because these are added by AdWords. Edit your file, remove the ID value for the row you're trying to add, and re-upload.
Image not accessible AdWords can't access the image. For example, the server hosting the image may be blocking access or taking too long to allow access. Host the image in an accessible location.
Invalid image format The image isn't a standard file type or format. Convert the image to .PNG, .JPG, .JPEG, .GIF, and save it in RGB color code with an ICC profile attached.
Invalid image size The image is too large. Reduce the image:

- Recommended image size: 300px by 300px
- Recommended resolution: 72dpi
- Maximum file size: 6MB
Invalid address format The address isn't formatted correctly. Use one of these formatting methods:

- City, state code, country
- Full address with zip code
- Latitude-longitude in the DDD format

Use commas to separate your address. See specs for cities, regions, and countries.
Invalid [attribute name]: [error] The type of data you've entered for a custom attribute doesn't match the attribute type you've chosen. Make sure your data is in the right format for the attribute type you've specified. For dates, remember that 00:00:00 signifies midnight (not 24:00:00).
See attribute types
Looks like you've added new attributes. You'll need to add these attributes to your existing data set or feed before you can bulk-edit them. Your file has columns AdWords doesn't recognize. Remove the problem columns and try again, or add the new columns before bulk-editing them.
New data sets or feeds can't include an "Action" column (the "Action" column is for bulk-editing existing data sets or feeds). Please remove that column and try again. The file you're uploading includes an "Action" column. Remove the "Action" column and try again.
No item matching Item ID. Your file includes a row with an "Item ID" that AdWords doesn't recognize. AdWords defines these values. Find your item IDs: click "Columns", then "Attributes", and "Item ID" to add that column to the table. Use these IDs when you're bulk-editing the values of your feed or data set.
One of the rows you're trying to edit doesn't exist in your current business data set. If you'd like to add a new row, make sure to choose the "Update" option and put "add" in the "Action" column. Your file includes a row with an ID that AdWords doesn't recognize. Either correct the ID value or, if you're adding a new row, change the action to "Add."
One or more columns you've defined has an unrecognized type. AdWords recognizes these types: (text), (number), (price), (date). One or more of your custom columns is missing a valid attribute type. Define a text, number, price, or date attribute type for each of your custom columns.
See specs for attribute types
Please use either "Target keyword" column or both "Target keyword text" and "Target keyword match type" columns. All three cannot be used in a single row. You're using too many keyword targeting columns. Use either:

- A "target keyword" column
- A "target keyword text" column with a "target keyword match type" column.

See all targeting attributes
Set or Remove actions requires the "Item ID" column. AdWords can't tell which rows you want to update. Include an ID column in the file you're using to update your data set or feed.
To find the IDs that AdWords has assigned, click "Columns", choose "Attributes," then choose "Item ID."
Target ad group not found. AdWords can't find the "target ad group" you've specified. Make sure to match the name of an existing ad group exactly, including spaces and capitalization.
Target campaign not found. AdWords can't find the "target campaign" you've specified. Make sure to match the name of an existing campaign exactly, including spaces and capitalization.
"Target campaign" is required when setting "Target ad group." The "target campaign" column is missing. You need this column when you're using the "target ad group" column. Add a "target campaign" column.
See all targeting attributes
"Target keyword match type" is required when using "Target keyword text." The "Target keyword match type" column is missing. You need this column when you're using the "Target keyword text" column. Add a "Target keyword match type" column.
See all targeting attributes
The "Custom ID" column needs to be named "Custom ID," with no attribute type, like "(number)" or "(text)," specified. Remove the type, save your file again, and re-upload. See attribute guidelines You've included an attribute type with your "Custom ID" column, which shouldn't include an attribute type. Remove the attribute type next to the column you've named "Custom ID."
This item already exists. The file you're using to update your feed or data set says to "add" a row that already exists. Use a new "Custom ID," or don't specify an ID, for rows you're adding.
Value is incompatible with the attribute's type in column "X." E.g., the type "number" is incompatible with any values that have letters or symbols. A row in your file includes data that's in the wrong format for the attribute you've specified. Format your data according to the attribute type you've chosen. See standard attribute formats
You already have a data set or feed with this name. Please enter a new name. You already have a data set or feed with this name. Use a new name for each of your new data sets or feeds.
Your data set or feed wasn't updated because the spreadsheet you're trying to upload includes an "Action" column. Choose "Update" (not "Replace") if you'd like to include an "Action" column, or remove your "Action" column and try again. Your file contains an "Action" column. The "Action" column is only for updating your data, and you chose "Replace." Remove the "Action" column and try again.
You've reached the limit of business data sets you can have (100 sets). You'll need to remove one before you can add a new one. Your account has too many data sets. Remove a data set you're not using in order to add a new one. Be careful not to remove extension feeds (like "Main sitelink feed") if you want to keep those extensions.
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.