This article provides custom column examples for both visual and text mode. If you want to re-create the examples in visual mode (the default mode), follow the step-by-step instructions under “Visual mode (step-by-step).”
Or, if you prefer to copy and paste the example formulas, you'll need to:
- Switch to text mode by clicking the text mode icon
in the custom column editor in Google Ads.
- Copy the formulas with a green background under “Text mode” in this article.
Learn more about creating custom columns
Average daily cost (last 7 days)
This reports the average cost per day for the previous 7 days (not including today), regardless of the table or report’s overall date range.
Visual mode (step-by-step)
- Click + Column, expand Performance, and select Cost.
- Click the oval labeled “Cost”, expand the “Date range” section in the filter panel on the right, and select + Add Filter.
- Expand Select date range, select Last 7 days, and click Apply.
- Click after the oval, then type / 7.
- Your formula should resemble this image:
- Select Money in the “Data format” dropdown in the upper right before saving.
Text mode
Select Money in the “Data format” dropdown in the upper right before saving.
Example output in a table: $12.54
Learn more: The date range selection is an example of a filter. Learn more about available filters
Daily performance meets threshold
This displays true or false, depending on whether the table row meets the conditions in the formula. In this example, this custom column will display true if the average number of clicks per day is greater than or equal to a value that you feel is appropriate for your business (the placeholder value used in the example below is 100), or false otherwise.
The “report_days_count” function provides the number of days between the start and end date in your table or report. In this example, dividing “Clicks” by “report_days_count” gives us the average number of clicks per day over the date range of the table or report where the custom column is used. Notice “Clicks / report_days_count()” is wrapped in parentheses so that it’s computed before comparing it to the value. Learn about available functions
Visual mode (step-by-step)
- Type (Clicks and select Clicks from the dropdown.
- Type / report_days_count() to divide clicks by the number of days in your table or report’s date range.
- Close the first parentheses by typing ). We’re wrapping the division in parentheses so it’s computed before comparing the value.
- Type >= which means “greater than or equal to”.
- Enter a number to compare against average daily clicks.
- Your formula should resemble this image:
- Select True/False in the “Data format” dropdown in the upper right before saving.
Text mode
Example output in a table: True
Report on specific conversions
This reports the number of conversions for all of the selected conversion actions. If you select multiple conversion actions, this custom column will show the total number of conversions across all of them.
The “All conversions” metric is used instead of “Conversions” because “Conversions” only includes conversion actions that have their “Include in conversions” setting checked. Learn more about conversion actions
Visual mode (step-by-step)
- Click + Column, expand Performance, and select All conversions.
- Click the oval labeled “All Conversions”, and expand the “Conversions action” section in the filter panel on the right.
- Select all the conversion actions you want to include.
- Your formula should resemble this image:
Text mode
Replace "Example conversion action" and "Other conversion action" with the names of conversion actions in your account. You can either have one conversion action, or list more by adding a comma between each conversion action.
Example output in a table: 68
Lost impression share due to budget
This displays one value if a campaign lost any impression share due to its budget, and another value otherwise.
The “Search Lost IS (budget)” column shows the percentage of time that your ads weren't shown on the Search Network due to insufficient budget, while the “Display Lost IS (budget)” column shows the same information for the Display Network. This data is available at the campaign level only. The “or” function can be used to return a true value if either column is greater than zero. Learn more about impression share
Visual mode (step-by-step)
- Type if. Select the suggested function.
- Replace “condition” by typing or. Select the suggested function.
- Replace “x” by typing Search Lost IS Budget > 0. When you type “Search Lost IS Budget”, select it from the dropdown so that it turns into a column oval.
- Replace “y” by typing Display Lost IS Budget > 0. When you type “Display Lost IS Budget”, select it from the dropdown so that it turns into a column oval.
- Replace “if_true” with a message to display if the condition is met, such as "Impr. limited by budget".
- Replace “if_false” with a message to display if the condition is not met, such as "No lost impr. share due to budget".
- Your formula should resemble this image:
- Select Text in the “Data format” dropdown in the upper right before saving.
Text mode
Example output in a table: Impr. limited by budget
Learn more: “if” and “or” are examples of functions. Learn about available functions
Device click summary
This displays custom text that summarizes a breakdown of clicks by 2 device types: mobile phones and desktop.
Visual mode (step-by-step)
- Type concat("Mobile: ", to_text(value), " Desktop: ", to_text(value)).
- Highlight the first instance of “value” in the formula, select + Column, expand Performance, and select Clicks. Repeat for the second instance of “value”.
- Click the first oval labeled “Clicks”, expand the “Device” section in the filter panel on the right, and select Mobile phones.
- Click the second oval labeled Clicks, expand the Device section in the filter panel on the right, and select Desktop.
- Your formula should resemble this image:
- Select Text in the “Data format” dropdown in the upper right before saving.
Text mode
Select Text in the “Data format” dropdown in the upper right before saving.
Example output in a table: Mobile: 57; Desktop: 46
Learn more: “concat” and “to_text” are both examples of functions. concat combines 2 or more pieces of text together, while to_text takes a numeric value (like Clicks) and converts it to text. Learn about available functions
