Custom formula columns combine and convert values or text from other Search Ads 360 columns and show the result in a single reporting column, helping you to see the data the way you want it. For example, you can use custom formula columns to calculate total conversions, weight and sum metrics from other columns, or rename a column.
You can set up bulk edits or automated rules to update settings in campaigns, ad groups, and other Search Ads 360 items to the value returned by a formula column.
Example
to_money(IF(Actions * 1.1 > Actions.For_date_range(Last_7_days()), Daily_budget * 1.1, Daily_budget))How to update settings to the value of a custom formula column
- Create a custom formula column that returns the type of value appropriate for the setting you're changing. For example, if you're setting the mobile bid adjustment (which is a percent), create a formula column that returns a percent.
- Start creating an automated rule or a bulk edit for campaigns, ad groups, ads, or keywords.
- Select a setting to update. See the list of available settings below. Then do the following:
- Click Set to ▼and select Set to custom formula column.
- Click Select a custom formula column ▼ and select the custom formula column you created. The Select a custom formula column only displays custom formula columns in your advertiser that return the type of value appropriate for the setting you're changing.
- Finish creating the rule or bulk edit.
- Before creating a rule or bulk edit, add the custom formula column to the reporting table to verify that the formula is applied correctly and yielding values that you intend.
- Use decimal numbers to indicate percentages. For example, enter .20 and not 20%.
- You can remove a custom formula column only if it isn't used in any other columns, rules, or bid strategies. You can click Bulk operations, Scheduled edits, and Rules in the left navigation pane to see if a custom formula column is used.
Settings that can be updated to the value returned by a custom formula column
The following table lists the settings you can change in bulk using a custom formula column. Note that the custom formula column needs to return the type of value that's appropriate for the setting you're changing. For example, if you're setting the mobile bid adjustment (which is a percent), you only use a custom formula column that returns a percent.
| New Search Ads 360 item | Setting | Type of value |
| Campaigns |
|
Currency Percent |
| Ad groups |
|
Currency Percent |
| Keywords |
|
Currency |
| Ads |
Headline |
Text |
| Dynamic ad targets |
|
Currency |
| Product groups |
|
Currency |
Example
Search Ads 360 displays the sub-manager account page, which contains data for all the sub-manager account’s advertising platforms. The Campaigns tab is selected by default.
- Create a custom formula column to identify campaigns that are going to exceed their daily budget.
- In the Enter equation box, type:
IF ( ( COST / DAILY_BUDGET ) > 0.8, to_money(DAILY_BUDGET * 1.2), to_money(DAILY_BUDGET ))- If the cost of a campaign is more than 80% of the campaign’s daily budget, the daily budget is increased by 20%. If the cost is less than 80%, the budget is not changed.
- In the Enter equation box, type:
- Create an automated rule to identify the brand campaigns that have spent 80% of budget and use the formula column to increase the budget by 20%.
Pause or remove the automated rule
- Sign in to your Search Ads 360 experience.
- Navigate to a manager or sub-manager account.
- From the page menu, under “Tools & settings”, click Bulk actions.
- Click Rules.
- Select the checkbox of the rule that increases the budget for brand campaigns.
- On the Edit menu, click Pause if you want to use the rule again, or click Remove to permanently remove the rule.