Upload business data using bulksheets

Once your business data tables are defined, you can use a bulksheet to add new business data or edit existing business data. The overall process for adding or editing business data is as follows (the details are in the sections below):

1. Download an editable bulksheet that contains business data tables.

2. In the downloaded bulksheet, add or edit business data.
    
3. Upload the bulksheet.

Tip: You can also use a single bulksheet to both add business data and apply it to campaigns, ad groups, and other items in Search Ads 360. Because it's more complicated to create and apply data in a single bulksheet, you may want to successfully upload business data on its own before you try applying in the same bulksheet.

Add or edit rows in the tables

To add new business data:

1. Add a row to the bulksheet.

2. In the Row type column, enter c:table_name, where table_name is the name of the business data table to which you’re the adding row.

3. In the Action column, enter create.

4. Enter information in all of the business data columns.

To edit existing business data in a row, leave the Action column set to edit, and change information in any of the business data columns. To remove existing business data in a row, enter remove_content in the column.

Bulksheet columns for adding or editing business data

• c:table_name.ID: Specifies an ID for the business data, where table_name is the name of an existing business data table. The ID is used to uniquely identify each row, and to apply that row's business data to accounts, campaigns, and other items in Search Ads 360. An ID can be any string of text you’d like.

• c:table_name.column_name: Specifies the name of a column in a business data table, where table_name is the name of an existing business data table, and column_name is the name of a column in the table.
  
  Within a given business data table, all columns are required. For example, if you're adding a row to a Location business data table, you'll need to enter values in all of the c:Location.column_name columns.

Example

Here’s an example bulksheet that uploads business data for two linked tables, Location and Hotel. For the sake of brevity, the example table below only shows some of the business data columns that were discussed in earlier examples. Note that to link a hotel to a location, specify a location ID in the hotel row.

RowType	Action	c:Location.ID	c:Location.Region	c:Location.City	c:Hotel.ID	c:Hotel.Avail
c:Location	create	Boston: Back Bay	Northeast	Boston
c:Location	create	New York: Chelsea	Northeast	New York
c:Hotel	create	Boston: Back Bay			Sleepwell	50
c:Hotel	create	New York: Chelsea			Rest Eazy	200
c:Hotel	create	New York: Chelsea			Harbor View	100

Removing business data not supported

Once you add and upload a row to a business data table, you cannot remove it. Instead, you can detach the business data from items in Search Ads 360 and the data will no longer be used.