Features
A powerful feature of Formulas is the ability to use the dynamic values calculated by your let
statements directly in the Actions of your Workflows. This allows automation steps like bid
or budget
changes to adapt precisely to the data of each individual item in your Segment.
Recall that defining a variable with let
in the Composer (e.g., let new_bid = ...;
) also creates a corresponding Custom Property column in your Segment results. The values in this column can then be used to drive actions.
Create one or more let
statements in your Formula to calculate the desired value(s) you want to use in an action. These become your variables internally and Custom Properties in the output.
// Example: Define a calculated bid
let calculated_bid = case(
acos(14d) < 25% => cpc(14d) * 1.15, // Increase bid by 15%
else bid * 0.9 // Decrease others by 10%
);
// Filter for active items
state = "effectively enabled" and calculated_bid != 0
When setting up the Action for your Workflow (e.g., attached to the Segment created by the formula above):
calculated_bid
).When the Workflow runs:
By linking let
variables (which generate Custom Properties) to Workflow Actions, you unlock truly dynamic and intelligent automation possibilities.
© Merch Jar LLC