Features
Welcome to Merch Jar Formulas, the next generation of our Recipes v1, and the powerful engine behind segment creation and automation! Formulas provide a flexible and precise way to segment and analyze your Amazon Ads data, define custom calculations, and build automation workflows using a dedicated syntax.
While the core goal remains automating actions based on data, the Formulas (V2) syntax offers significantly more flexibility, power, and clarity.
In V1, a "Recipe" encompassed the logic, the action, and the schedule all in one. Over the coming weeks we will be transitioning to Formulas (v2) which separates these concepts for greater flexibility:
Think of Formulas as a specialized language combining advanced filtering capabilities with dynamic calculations. Unlike basic filters, Formulas allow you to:
acos > target acos
).sales(14d) / clicks(14d)
to get RPC).let
) to store values or complex expressions for analysis and use in actions.and
/or
) and grouping ()
.This capability enables you to pinpoint very specific Segments of your advertising entities based on nuanced performance or configurations, and even generate new calculated data points (Custom Properties) for those segments.
If you're familiar with our legacy Recipes (v1), the Formulas (v2) syntax is significantly more capable. Key enhancements include:
target acos
, match type
and last bid change
.sales(30d)
> sales(30d..60d)
).bid < cpc(14d) * 1.1
).let
& Custom Properties: Define reusable variables that also appear as calculated columns in your results.case
: Implement if/then/else style logic.clicks(30d)
) from static properties (campaign name
).Ready to explore? Head over to our guide on Writing Formulas to learn how to access the editor and write your first rule. For a detailed breakdown of all available syntax elements, consult the Syntax Reference.
© Merch Jar LLC