Metrics and Properties Reference

Updated
April 2, 2025

Recipes V2: Metrics and Properties Reference

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).

  • Metrics: Represent performance data calculated over a specific time period (e.g., clicks, sales, ACOS). Metrics always require a time period specified in parentheses, like clicks(30d).
  • Properties: Represent configuration settings, states, or attributes of your campaigns, ad groups, keywords, or targets (e.g., 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:

  • Currency: Currency symbols ($, €, etc.) in numeric values are ignored. Calculations and comparisons use your ad account's default currency.
  • Percentages: Percentage symbols (%) are accepted for relevant metrics/properties (ACOS, CTR, CVR, Blended ACOS). The value is automatically divided by 100 before evaluation (e.g., acos(30d) > 25% is treated as acos(30d) > 0.25).

Operators & Constants

The following operators and constants are available in Recipes V2:

  • Numeric/Comparison: >, >=, <, <=, =, != (Used for comparing numbers)
  • String Comparison: =, !=, contains, does not contain, starts with, ends with (Used for comparing text, case-insensitive)
  • Logical: and, or, not (Used for combining conditions)
  • List (Coming Soon): contains any, contains all (Used for comparing against lists of strings, case-insensitive)
  • Constants: true, false (Case-insensitive)

Metrics

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`.

KDP-Specific Metrics

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

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 (`=`, `!=`)
  • "enabled" (Aliases: "active", "running")
  • "paused"
  • "archived"
  • "effectively enabled" (Item and parents are enabled)
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:
  • "broad"
  • "phrase"
  • "exact"
Auto Targeting Group:
  • "close match"
  • "loose match"
  • "substitutes"
  • "complements"
Product/Category Targeting:
  • "asin category same as"
  • "asin substitute related"
  • "asin accessory related"
  • "asin same as"
Expanded Targeting:
  • "similar"
(Confirm exact API strings)
Keywords & Targets
bid strategy The bidding strategy set at the campaign level. String String Comparison (`=`, `!=`)
  • "legacy for sales" (Down Only)
  • "auto for sales" (Up and Down)
  • "manual" (Fixed)
  • (Placeholder for other confirmed API values)
Campaigns