Features
Every Recipe rule requires a timeframe, metric or property, operator, and a value. This document contains all the available timeframes, metrics, operators, and properties you can use when constructing your Recipe rules.
A timeframe is essential in every Recipe rule to specify the period over which the conditions should be evaluated. It sets the context for analyzing data, ensuring that decisions are based on relevant and timely information.
last X days
, a maximum of 180 days can be selected, providing extensive coverage while maintaining data manageability. The "lifetime" data may not encompass all historical data if the campaign predates the earliest data point Merch Jar can retrieve.Examples:
over the last 30 days clicks > 5
Short-term Analysis: Evaluates whether there have been more than 5 clicks in the past 30 days
over the lifetime orders = 0
Long-term Analysis: Checks if a campaign has failed to generate any orders since the earliest data point available to Merch Jar.
Metrics are quantifiable data points used to measure the performance of your advertising campaigns. They typically involve numerical values and are evaluated over specific timeframes. They must be combined with a numeric operator and a numeric value.
roi
aov
acos
clicks
impressions
orders
sales
roas
cpc
cac
ctr
cvr
spend
The following metrics are only available for KDP ad accounts:
blended profit
blended acos
blended roas
blended rpc
blended cvr
blended cac
blended aov
adjusted sales
adjusted orders
adjusted page reads
adjusted estimated royalties
pages read
estimated royalties
>
>=
=
<
<=
=
!=
Numeric values can be integers, decimals, and/or percentages for applicable metrics.
Properties are attributes of campaigns or ads that reflect their current state or configuration, such as whether a campaign is enabled, its name, or its bid value. While properties must be included within a rule that incorporates a date range, they do not analyze historical data but rather provide a snapshot of the ad's or campaign's present condition. Properties are categorized into four types: Numeric, String, State, and Date.
Numeric properties will accept all numeric operators and can be integers or decimals, and include an optional currency symbol.
bid
budget
String properties require a string operator and a string value enclosed in quotes.
campaign name
ad group name
=
!=
contains
does not contain
starts with
ends with
These are text-based values that must be enclosed in quotes.
over the last 7 days
state = "effectively enabled" and
state != "archived"
State properties require a state operator and a state value, which should be text-based and enclosed in quotes.
state
=
!=
State values are treated as string values and must be enclosed in quotes.
enabled
Synonyms: active, running
effectively enabled
Indicates an entity is delivering - i.e. it is enabled and is also contained within enabled elements.
paused
archived
over the last 7 days
campaign start date < 7 days ago and
campaign end date before 14 days ago
Date properties must be combined with a numeric or state operator and a date value.
campaign start date
campaign end date
Accept all numeric operators and specific date operators.
before (synonym: <)
after (synonym: >)
Date values should be expressed as a relative term such as 'X days ago' and are converted into YYYYMMDD format when evaluated.
> 7 days ago
before 14 days ago
Please note that date values are relative to the current day. The examples above are illustrative and will have a different value relative to 'today's' date.
(over the last 7 days
acos > 25%
and orders > 4
)
and
(over the last 30 days spend > $10 and (
cpc > $0.65
or ctr > 0.2%
or impressions > 1000
))
and
(over the last 14 days
acos < 15%
or (
spend > $50
and ctr > 0.5%
)
)
Boolean operators are essential tools in constructing Recipe rules, allowing you to combine multiple conditions within a single rule or to link several rules within a single Recipe. They are fundamental in defining complex criteria that reflect specific advertising strategies.
Operators:
and
: Ensures all conditions connected by this operator must be true for the rule to be applied. Used to enforce stricter criteria by combining conditions that must all be satisfied.or
: Allows any of the conditions connected by this operator to be true for the rule to be applied. Used to broaden the criteria, offering flexibility by accepting multiple possible true conditions.Example Usage:
(over the last 7 days acos > 25% and orders > 4)
— This rule is true if both conditions are met within the last 7 days.(over the last 7 days acos > 25% and orders > 4) and (over the last 30 days cpc > $0.65 or ctr < 0.2%)
— This rule applies if the conditions of both the last 7 days and any condition from the last 30 days are met.For a more detailed explanation of how these operators function and additional examples, please visit our comprehensive guide on Boolean Logic.