Use your business data to manage campaigns

Create a business data table

Creating a business data table makes it possible for Search Ads 360 to validate the business data you enter or upload. Learn more about organizing your business data in Search Ads 360.

To create a business data table:

  1. Navigate to an advertiser.  

    Steps for navigating to an advertiser
    1. Click the navigation bar to display navigation options.

    2. In the "Agency" list, click on the agency that contains the advertiser. You can search for an agency by name or scroll through the list.

    3. In the "Advertiser" list, click on the advertiser.

    4. Click Apply or press the Enter key.

    Search Ads 360 displays the advertiser page, which contains data for all of the advertiser’s engine accounts.

  2. In the left navigation panel, click Business data.

  3. Click + Business data table, which appears above the reporting table.

  4. Enter a name for the new table.
    See Important notes for choosing a table name.

  5. Click Save.

Search Ads 360 creates the table and adds the ID column, which can contain any string you want. For example, you can use the ID column to name each sales region. If you want the table to contain more data, such as quotas for each region, add more columns.

Next steps:

Important notes for choosing a table name

  • The name can contain letters, numbers, spaces, and any punctuation other than "." and ":" (period and colon).

  • When you view business data in a Search Ads 360 report, the table name will be prefixed to all of the table's columns, segments, and dimensions as follows: table-name.column-name

    For example, if you create a table named Hotel, you'll see this column, segment, or dimension when you view business data in a Search Ads 360 report:
    Hotel.ID

  • If you use business data in a formula column, the table name will be prefixed to all of the table's columns as follows: c:table-name.column-name

    If you happen to have a formula column with the same name as a Business Data column, Search Ads 360 will always use the value from the formula column.

    For example, if you or someone in your advertiser created a formula column named Car Model.Trim and you include c:"Car Model.Trim" in a formula, Search Ads 360 will use the data from the Car Model.Trim formula column instead of from the Car Model.Trim Business Data column.

  • If you remove a business data table, you can't create a new one with the same name.

 

Was this helpful?
How can we improve it?