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:
-
Start creating a formula column.
-
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", "--"
)