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"

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", "--"
)