Help
Reference Docs
Getting Started
Navigating Merch Jar
Connect Your Amazon Advertising Account
Connecting Multiple Advertising Accounts
Setting and Managing Target ACOS
Setting Min and Max Bid Guardrails
Set Default Ad Account
Basics
Glossary: Terms and Definitions
Keywords Vs. Targets in Merch Jar
Rounding Strategies
Date Range Selection
Using Filters
Selecting Multiple Rows
Using Bulk Actions
Column Visibility
Amazon Campaign Structure
Formulas Recipes V2
Formulas Syntax: Quickstart
Intro to Formulas (Recipes v2)
Core Syntax Concepts
The Formulas Interface
Getting Started: Writing Formulas
Using Time Periods
Combining Conditions: Boolean Logic & Grouping
Math Operations
Understanding Datasets (Formula Sources)
Understanding Properties
Understanding Functions
Defining Variables & Custom Properties
Using Custom Properties in Workflows
Conditional Logic
Adding Comments
Workflows & Actions
Error Handling & Special Values
Example Formulas & Use Cases
Upgrading from Recipes V1
Recipes V1 Legacy
Recipes V2: Next-Generation Automation for Amazon Ads
Recipes Overview
Recipe Metrics and Properties
Conditions and Rules
Boolean Logic
Use of Parentheses
Combining Multiple Rules
Comments
Validation Messages
Create New Recipe
Import Recipes
Smart Campaigns
Smart Campaigns Overview
Creating a Smart Campaign
Linking Ad Groups
Create Smart Campaign Rule
Managing Smart Campaign Rules
Activating Your Smart Campaign
Smart Campaign Bid Resolution
Smart Campaign 'Dry Run' Feature
Ad Manager
Navigating the Search Term Page
Setting Ad State
Setting Campaign State
Change Campaign Daily Budget
Creating Negative Keywords From Search Terms
Negative Search
KDP Metrics & Settings
Blended Metrics
Adjusted Metrics
Ad Impact Multipliers
Calculating Ad Impact Multipliers
Calculating Average Profit Margin
Account
Signing up for a Merch Jar Account
Understanding the Cascading Settings System (CSS)
Smart Bids Overview
Editing and Creating Smart Bid Profiles
Resetting Your Password
Advertising Data Not Syncing
Troubleshooting
Advertising Data Not Syncing
Formulas Reference
Advanced Filters & Logic
Properties
Functions
Template Library
Segments & Workflows
Help Center
/
Syntax
/
Properties

roi

IN THIS ARTICLE
This is some text inside of a div block.
SUPPORTED DATASETS

Return on Investment. Profit relative to cost (sales - spend) / spend).

roi(60d) > 50%

roi(lifetime) < 0%

Features
Recipes
Smart Campaigns
Bulk Actions
Starter Automations
Resources
Help Center
Recipe World
Free Seller Tools
Blog
Contact Us
Terms
Privacy

© Merch Jar LLC