Advanced Guide: Using formulas in your Media Planner columns

Overview

Formulas let you create calculated columns that automatically compute values based on the data in your plan. Whether you're calculating pacing, CTR, or derived financial metrics, formulas add flexibility and precision to your media planning workflow.

Instructions

1. When creating a new or editing an existing column, toggle the Calculated Column on to open up the formula input box.

2. Input a valid formula based on the columns you’ve added and the available functions in Media Planner, click Add or Save to enable the column formula.

3. This column’s values will now dynamically update based on changes to the formula’s parameters.

A calculated column cannot be referenced in the formula of another calculated column.

Supported Functions and Syntax

1. Alli supports all basic arithmetic symbols such as:

   1. + - addition

   2. - - subtraction

   3. * - multiplication

   4. / - division

   5. () - parentheses

2. Alli also supports some key built-in functions such as:

   1. currentDate() - fetches the current date.

   2. dateDiff(startDate, endDate) - calculates the number days between two dates.

   3. ifThen(condition, trueValue, falseValue) - applies conditional logic to your formula