Notification

Welcome to the help center for Search Ads 360, a platform for managing search marketing campaigns.  While the help center is available to the public, access to the Search Ads 360 product is available only to subscribing customers who are signed in. To subscribe or find out more, contact our sales team.

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 helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
536245238889676349
true
Search Help Center
true
true
true
true
true
263
false
false