Use your business data to manage campaigns

Use business data in formula columns

When you need to apply your own calculations to reporting data in Search Ads 360, instead of downloading the data and using spreadsheet functions, you can create a formula column and apply spreadsheet-like functions to your data directly in Search Ads 360. You can add formula columns to Search Ads 360 reports, but formula columns that contain business data cannot be used in bid strategies.

You can create formula columns that include data from any business data column.

Example

For example, if you've created the following business data table:

Car Model:

ID

Brand

Name

Trim

Color

Base Roadster, White

Electro

Roadster

Base

White

Lux Roadster, Black

Electro

Roadster

Deluxe

Black

Base Sedan, Green

Electro

Sedan

Base

Green

 

You can create a formula column that includes data from the Brand, Name, Trim, or Color columns. Here's a formula that uses data from the Trim and Color columns in the table above to create another way of categorizing cars:
IF(
   AND(c:"Car Model.Trim" = "Base", c:"Car Model.Color" = "White"), "Fleet",
   AND(c:"Car Model.Trim" = "Deluxe", c:"Car Model.Color" = "Black"), "Limo",
   "Consumer"
)

 

To use business data in a formula column:

  1. Start creating a formula column.

  2. Use the following syntax to refer to a business data column:
    c:"Table-name.Column-name"

Note:

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.

 

Using business data from tables that are included by reference

You can also use business data from tables that are included by reference. For example, here's a "Dealership" business data table:

Dealership:

ID

Region

City

Tier

Tacoma Electro

Northwest

Tacoma

Mid

Tacoma Electro

Northwest

Tacoma

Mid

Jones Discount Auto

Northwest

Seattle

Discount

 

And here's a Car Model table that includes the Dealership table by reference:

Car Model:

ID

Brand

Name

Trim

Dealership.ID

Base Roadster, White

Electro

Roadster

Base

Tacoma Electro

Lux Roadster, Black

Electro

Roadster

Deluxe

Tacoma Electro

Base Sedan, Green

Electro

Sedan

Base

Jones Discount Auto

 

Just as you can include any column from the Car Model table in a formula column, you can also include any column from an included table. Here's a formula that uses data from the Car Model.Name and Dealership.Region columns in the table above to create another way of categorizing cars:
IF(
   AND(c:"Car Model.Name" = "Roadster", c:"Dealership.Region" = "Northwest"),
   "On sale",
   AND(c:"Car Model.Name" = "Roadster", c:"Dealership.Region" = "West"),
   "Limited inventory", "--"
)

Was this article helpful?
How can we improve it?