Features
This document provides a comprehensive reference for all available Metrics and Properties you can use when building rules in Merch Jar Recipes V2. Understanding the distinction between these two is key to writing effective automation logic.
Note that Recipes V2 syntax is case-insensitive for metric/property names, string values, and operator names (like and, or, contains).
clicks
, sales
, ACOS
). Metrics always require a time period specified in parentheses, like clicks(30d)
.bid
, state
, campaign name
). Properties generally do not use a time period and reflect the current or latest value.clicks(30d) > 10 // Clicks is a Metric and requires a time period
bid < $1.00 // Bid is a Property and does not use a time period
Important Notes on Values:
acos(30d) > 25%
is treated as acos(30d) > 0.25
).The following operators and constants are available in Recipes V2:
>
, >=
, <
, <=
, =
, !=
(Used for comparing numbers)=
, !=
, contains
, does not contain
, starts with
, ends with
(Used for comparing text, case-insensitive)and
, or
, not
(Used for combining conditions)contains any
, contains all (Used for comparing against lists of strings, case-insensitive)true
, false
(Case-insensitive)Metrics represent performance data calculated over a time period (e.g., sales(30d)). They primarily use Numeric/Comparison Operators.
Metric Name | Description | Data Type | Notes |
---|---|---|---|
sales |
Total sales revenue attributed to ads. | Decimal | Uses default ad account currency. |
spend |
Total amount spent on ads. | Decimal | Uses default ad account currency. |
orders |
Total number of orders attributed to ads. | Integer | |
clicks |
Total number of clicks on ads. | Integer | |
impressions |
Total number of times ads were displayed. | Integer | |
acos |
Advertising Cost of Sale (Spend / Sales). | Decimal | Result is a ratio. Use decimals or % (e.g., acos(30d) > 0.25 or acos(30d) > 25% ). % divides value by 100. |
roas |
Return on Ad Spend (Sales / Spend). | Decimal | Result is a ratio (e.g., 4.0 for 400%). |
cpc |
Cost Per Click (Spend / Clicks). | Decimal | Uses default ad account currency. |
ctr |
Click-Through Rate (Clicks / Impressions). | Decimal | Result is a ratio. Use decimals or % (e.g., ctr(30d) > 0.005 or ctr(30d) > 0.5% ). % divides value by 100. |
cvr |
Conversion Rate (Orders / Clicks). | Decimal | Result is a ratio. Use decimals or % (e.g., cvr(30d) > 0.1 or cvr(30d) > 10% ). % divides value by 100. |
aov |
Average Order Value (Sales / Orders). | Decimal | Uses default ad account currency. |
cac |
Customer Acquisition Cost (Spend / Orders). | Decimal | Uses default ad account currency. |
rpc |
Revenue Per Click (Sales / Clicks). | Decimal | Uses default ad account currency. |
units |
Total number of units sold attributed to ads. | Integer | Alias: `ordered units`. |
These metrics are only available for Amazon KDP ad accounts and incorporate KENP royalty estimates and configured impact multipliers.
Metric Name | Description | Data Type | Notes |
---|---|---|---|
pages read |
Kindle Edition Normalized Pages (KENP) Read count attributed to ads. | Integer | KDP Only. |
estimated royalties |
Estimated KENP royalties earned from ad-attributed page reads. | Decimal | KDP Only. Uses default ad account currency. |
adjusted sales |
Sales multiplied by the Order Impact Multiplier set in Ad Account Settings. | Decimal | KDP Only. Uses default ad account currency. |
adjusted orders |
Orders multiplied by the Order Impact Multiplier set in Ad Account Settings. | Integer | KDP Only. |
adjusted page reads |
Page Reads multiplied by the KENP Impact Multiplier set in Ad Account Settings. | Integer | KDP Only. |
adjusted estimated royalties |
Estimated Royalties multiplied by the KENP Impact Multiplier set in Ad Account Settings. | Decimal | KDP Only. Uses default ad account currency. |
blended profit |
Calculated profit combining adjusted sales (factoring in profit margin) and adjusted estimated royalties. See KDP documentation for formula. | Decimal | KDP Only. Uses default ad account currency. Requires Profit Margin and Impact Multipliers to be set. |
blended acos |
Blended Advertising Cost of Sale (Spend / Blended Profit). | Decimal | KDP Only. Result is a ratio. Use decimals or % (e.g., blended acos(30d) > 0.25 or blended acos(30d) > 25% ). % divides value by 100. |
blended roas |
Blended Return on Ad Spend (Blended Profit / Spend). | Decimal | KDP Only. Result is a ratio. |
blended rpc |
Blended Revenue (Profit) Per Click (Blended Profit / Clicks). | Decimal | KDP Only. Uses default ad account currency. |
blended cvr |
Blended Conversion Rate using Adjusted Orders (Adjusted Orders / Clicks). | Decimal | KDP Only. Result is a ratio. Use decimals or % (e.g., blended cvr(30d) > 10% ). % divides value by 100. |
blended cac |
Blended Customer Acquisition Cost using Adjusted Orders (Spend / Adjusted Orders). | Decimal | KDP Only. Uses default ad account currency. |
blended aov |
Blended Average Order Value using Adjusted Sales & Orders (Adjusted Sales / Adjusted Orders). | Decimal | KDP Only. Uses default ad account currency. |
Properties represent settings, configurations, or states (e.g., bid
, campaign name
, state
). They generally reflect the current value and do not require a time period. Applicable operators and availability vary by property.
Property Name | Description | Data Type | Applicable Operators | Allowed Values / Format | Dataset Availability |
---|---|---|---|---|---|
bid |
The current bid amount. | Decimal | Numeric/Comparison | Number (e.g., 1.25 ) |
Keywords & Targets |
default bid |
The default bid amount set at the Ad Group level. | Decimal | Numeric/Comparison | Number (e.g., 0.75 ) |
Ad Groups |
budget |
The daily budget amount set for a Campaign. | Decimal | Numeric/Comparison | Number (e.g., 50.00 ) |
Campaigns |
campaign name |
The name of the Campaign. | String | String (`=`, `contains`), List (Future) | Text in quotes (e.g., "My Campaign" ) |
All Sources |
ad group name |
The name of the Ad Group. | String | String (`=`, `contains`), List (Future) | Text in quotes (e.g., "Exact Match Group" ) |
Ad Groups, Keywords & Targets, Ads |
keyword text |
The text of the keyword. | String | String Comparison | Text in quotes (e.g., "running shoes" ) |
Keywords & Targets |
target expression |
The expression for a product or category target. | String | String Comparison | Text in quotes (e.g., 'asin="B0..."' ) |
Keywords & Targets |
sku |
The Stock Keeping Unit (SKU) of the advertised product. | String | String Comparison | Text in quotes (e.g., "SHOE-RED-10" ) |
Ads |
asin |
The Amazon Standard Identification Number (ASIN) of the advertised product. | String | String Comparison | Text in quotes (e.g., "B012345XYZ" ) |
Ads |
state |
The current status of the entity. | State (String) | State (`=`, `!=`) |
|
All Sources |
match type |
The match type for keyword targeting or the specific type for automatic/product targeting. | String | String (`=`, `!=`, `contains`), List (`contains any` - Future) |
Keyword:
|
Keywords & Targets |
bid strategy |
The bidding strategy set at the campaign level. | String | String Comparison (`=`, `!=`) |
|
Campaigns |
© Merch Jar LLC