The Add Column and Edit Column Pipeline steps allow you to use formulas to transform your data. You can either use one of our built-in formulas as-is, or write your own formula using the Custom formula option.

If you aren’t seeing a formula type you expect to see for an existing column, check the column’s data type. Some formulas are only available for numeric columns.

Formulas in the Data Pipeline

Tip: When dividing integers, be sure to multiply the top value by 1.0 to convert your results to a decimal. For example:

(1.0 * "Count of Clicks")/"Ad Cost"