Use your business data to manage campaigns

Tables, IDs, and columns

Here are some of the terms you'll need to know when working with business data in Search Ads 360.

Table

A business data table is a formal definition that tells Search Ads 360 what to expect about the data you're uploading. Defining business data tables makes it possible for Search Ads 360 to validate the data you've uploaded and let you know if you've accidentally misformatted or entered the wrong type of data.

ID

All business data tables include an ID column by default. 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 text you’d like, including letters, numbers, spaces, and punctuation.

Column

After you create a business data table, you can add more columns to the table (in addition to the default ID column that is added automatically when you create the table). Each column should contain a single piece of information that’s relevant to managing your search marketing campaigns.

Common examples include:

  • “Brand” and “Category” columns in a business data table that describes products

  • “Star rating”, “Brand”, and “City” columns in a business data table that describes hotels

  • “Origin airport” and “Destination airport” columns in a business data table that describes flights

A column specifies a name, which needs to be unique within a table, and one of the following types of data:

  • Text: Letters, spaces, and punctuation. You can also include numbers, but Search Ads 360 will treat them as text. For example, features such as automated rules won't be able to compare the value of the numbers with other numbers.

  • Integer: A whole number with no decimal value, such as 1, 50, or 10000

  • Decimal: A number with an optional decimal value, such as 1, 50.5, 10000.22

A column can also specify a reference to another Business Data table. Note that a table can be referenced by only one other table. For example, the Location table can be referenced by the Hotel table or the Restaurant table, but not by both.

Ready to get started?

Was this article helpful?
How can we improve it?