In this article:
General issues
Why can't I remove my custom column?
Why does my custom column display a dash in a table?
Custom columns display dashes in the table when a formula doesn’t have any valid value to show in a row. Common reasons include:
- A dependency is also empty: If one of the columns that is included in the custom column’s formula is displaying a dash in a row, then the custom column will also display a dash in that row. You can check the value of each column included in the formula by also adding it to the table.
- Incompatible filters: Some columns and filters are incompatible in certain tables, even if you can save a custom column with the combination. For example, adding a Conversion Source filter on a Clicks column will make the custom column show a dash because Clicks can’t be filtered by Conversion Source.
- Calculation error: If the formula could not be computed due to a calculation error, it will show a dash. For example, if you wrote a formula that multiplies two extremely large numbers, it could result in a calculation error.
- Summary row: Dashes may appear in the summary rows for custom columns under certain conditions.
Why can’t I add a custom column to a table?
A custom column can’t be added to a table if the custom column’s formula includes columns or filters that aren’t available for that table. Similarly, if the formula includes another custom column that can't be added to the table, the custom column can’t be added to the table either.
You can add the custom column to a different table that has all of the columns and filters used in the formula available, or you can modify the custom column’s formula to remove the columns or filters that are not available on the current table.
What are the limits of custom columns?
- There may not be more than 1,000 custom columns owned by one account.
- Custom column formulas may not be longer than 10,000 characters when viewed in text mode
- Up to 4 different filter types (e.g. Device, Network, etc.) may be added to a formula across all columns in the formula. There is no limit on the number of values allowed in each filter.
- A custom column may not reference any more than 5 other custom columns directly in its formula
- References of custom columns to one another may not create a chain of references longer than 4. For example, if column A referenced column B, which referenced column C, which referenced column D, then column D may not reference any other custom column because this would increase the chain length to 5. Likewise, in this scenario, no other custom column may reference column A, since that would also increase the chain length to 5.
- Custom column references may not create a cyclical chain. For example, if column A referenced column B, which referenced column C, then column C may not reference column A or column B.
How is my custom column calculated in summary rows?
The value of custom columns in summary rows are calculated across the row horizontally.
For example, if Custom Column A is Clicks > 10 and Custom Column B is CTR * 2, a table might look like following example, where the third row is the summary row:
| Impr | Clicks | CTR | Custom Column A | Custom Column B |
| 10 | 5 | 50% | False | 100% |
| 40 | 10 | 25% | False | 50% |
| 50 | 15 | 30% | True | 60% |
Some custom columns may not have any value in summary rows (or may have a dash displayed), even though it may have a value in other rows. Reasons can include:
- The custom column’s "Data format" is "Text", "True/False", or "Date".
- The custom column’s formula includes a column that doesn’t have an addable value (like Campaign Name), or it includes another custom column that includes a non-addable column in its formula.
Which accounts can access my custom columns?
Custom formula columns
Why can't I save my custom formula column?
Custom columns can be saved only if they include a valid name, a valid formula, and a Data Format that matches the formula.
If the formula is invalid due to a syntax error, one or more red underlines will appear under part of the formula. These underlines provide an approximate location in the formula where the error was detected. You might need to modify a part of the formula that is not above the underline to fix the error (for example, adding another parentheses at the beginning or end of the formula to fix a mismatched parentheses error).
Common reasons why a formula might be invalid include:- Mismatched data types: Every column, constant, and function has a data type (number, text, true/false, or date). Ensure that you’re combining columns, constants, and functions in compatible ways. For example, the length function only accepts text values, so
length(Clicks)is invalid becauseClicksis a number. Check the column list, function list, and the operator list for their data types. - Missing operator: An operator must be placed between each column, constant, function, and parenthetical expression. For example,
2(Impr + Clicks)is invalid because an operator (such as*) is missing after the number. - Mismatched parentheses: Check that every open and closing parenthesis has a corresponding parenthesis of the opposite type placed correctly. For example,
(56 * round(Clicks)) + Clicks)is invalid because there is no open parenthesis that corresponds correctly with the last parenthesis after the clicks column. - Misspellings: Check the list of columns, filters, and functions in custom columns for the correct spellings of common custom column content.
- Misuse of double quotes: Ensure that double quotes are used correctly. Numbers, standard columns, and true/false values should generally not be surrounded by double quotes because double quotes will cause the value to become text. For example,
("Clicks" > 4) = "true"would be invalid. Instead, this formula should be written as(Clicks > 4) = true. Only custom column references, certain filters, and text constants use double quotes. - Missing order of operations: Check that you have parentheses surrounding the calculations that should happen first. For example,
Clicks * 2 > 10may not be saved because it may attempt to calculate the>comparison first, then multiply second, which is not valid. Instead, wrap the first operation in parentheses to save the formula:(Clicks * 2) > 10.
Why must I save my existing custom formula column as a new column?
When editing an existing custom column, there are two cases where you may be prompted to save your custom column as a new custom column instead of updating the existing custom column. In these cases, you’ll also see an option to “Save as new column”. If you select this option, your edited formula will be copied into a new custom column and you can save the custom column under a new name.
“You can’t save this change because the formula content no longer matches the column format.”
This occurs when a formula is changed so that it no longer matches the selected Data Format for the formula. The Data Format of a custom column may not be changed after the custom column is created. For example, if your formula is Clicks / Impr and your Data Format is Percent, then you modify your formula to Clicks > Impr, you can’t save this change because it would change the Data Format to True/False.
“You can't save this change because it could result in errors for reports that might be using this custom column.”
This occurs when you add or remove certain columns or other custom columns from the formula that would impact the way the custom column is displayed in charts and in summary rows. For example, if the formula contains only the Clicks and Conversions columns, but you edit the formula to also include the Campaign Name column (which can’t be displayed in charts), you will see this error. You may see this error even if your custom column is not currently used in any tables, charts, or reports.
How do I duplicate or copy a custom formula column?
In text mode, you can copy a formula, then paste it into a new custom column:
- Select the pencil icon beside the custom column you want to copy/duplicate.
- Change to text mode.
- Highlight the entire formula’s text.
- Copy the formula (Ctrl+C or Cmd+C).
- Select Cancel to close the formula editor.
- Select + Custom Column to create the new custom column.
- Change to text mode.
- Paste the formula (Ctrl+V or Cmd+V) into the formula area, and make any desired changes.
- Provide a unique name for the new custom column.
- Select the desired Data format.
- Save the new custom column.
- (Optional) Remove the previous custom column.
Note: You can’t paste text while in visual mode. To paste text in a formula, switch to text mode.
Why can’t I modify the data format?
Once a custom column is saved for the first time, its "Data format" may not be changed.
If you are editing an existing custom column and make changes to the formula that change the formula output between a numeric value, a text value, a true/false value, and a date value, you will be automatically prompted to save the changes as a new custom column.
If you want to change the "Data format" between "Number", "Percent", and "Currency", you can copy the current formula to a new custom column.
How do I include quotes inside text in a formula?
Whenever text is used in a formula, it is surrounded by double quotes. If you want to include the double quote character in your text, you can “escape” the character by placing two double quotes back-to-back. This applies anywhere double quotes are used in formulas, including text constants, references to other custom columns, and filter values.
For example, if you wanted to display My “Fast” Flowers as the value of a custom column, you would write "My ""Fast"" Flowers" as the formula.
Why are spaces added/removed from my formula when I save?
Why can't I select my custom formula column in a chart?
Some custom columns can’t be used in charts. Reasons can include:
- The custom column’s “Data format” is “Text”, “True/False”, or “Date”.
Why can’t I change between visual and text mode?
Why can’t I add filters to certain columns in a formula?
Is the formula syntax internationalized?
In visual mode, column names, filter names, and filter values are localized to the same language as the rest of Google Ads. However, function names are the same regardless of your language. See the function list for a list of functions.
In text mode, all column names, filter names, filter values, and functions are the same regardless of your language preference. The names used in text mode are similar to the English names for each item, but are modified to not include spaces or special characters. See the column list, filter list and function list for a full list of allowed values.
In both modes, use a period as the decimal separator. For example, a quantity of five-and-a-half would be 5.5 instead of 5,5. A thousands separator is not used in formulas.
Additionally, columns that may be a fixed set of text values (like the Campaign Status column) will always return English text (such as Enabled) when used in a formula. See the column list for the values that may be returned.