Formulas

This guide provides a rapid overview of the most common syntax patterns used in Merch Jar Formulas for users familiar with filtering, scripting, or formula concepts.

Get acquainted with Merch Jar Formulas, the powerful engine for creating advanced segments and automation logic using V2 syntax.

Understand the fundamental building blocks of Formulas, including properties, operators, functions, and key definitions like Segments and Workflows.

Learn how to access the Formulas interface and about its different components.

Learn how to access the Formula Composer and write your first basic formula to filter your advertising data.

Explore the different ways to specify date ranges (Relative, Literal, Offset, Lifetime) required for time-based properties like clicks or sales.

Learn how to use and, or, and parentheses () to create complex filter expressions with multiple conditions.‍

Discover how to use arithmetic operators (+, -, *, /) and the percent sign % for calculations within your formulas.

Learn about the different data sources (Campaigns, Ad Groups, Keywords, etc.) you can select for your formulas and how they affect available properties.

Understand the concept of properties (time-based vs. static) and how they represent the data fields and settings used in formulas.

Get a high-level look at the available functions like now(), interval(), case(), and let that add dynamic capabilities to your formulas.‍

Dive into using the let keyword to define variables within your formula, which automatically create new calculated columns (Custom Properties) in your Segments.

Learn how to leverage the values from your Custom Properties (defined using let) to drive dynamic Workflow Actions like changing bids or budgets.

Master the case function to implement if/then/else style logic directly within your formulas based on specific conditions.

Understand how to use single-line // and block /* */ comments to explain your formulas or temporarily disable code.‍

Explore the available actions (like Change Bid, Set State) that can be automated based on your Formula Segments and learn about scheduling options.

Learn how to interpret common syntax validation errors and understand how special values like NaN or division by zero are handled.

See practical examples demonstrating how to combine various syntax elements to achieve common analysis and optimization goals.

Discover the key changes between Recipes v1 and the new Formulas v2 syntax.