Ask this table
it builds a filter, it does not fetch an answer
×
campaigns spending over $20 a day where ACoS is above 30% and we have less than two weeks of stock
⏎
the filter I built — every line is yours to change
where
Spend (30d)
is greater than
$20 / day
change
You said "a day", and this table measures spend over the window, so I divided by the window length rather than reading your daily budget.
and
ACoS
is greater than
30%
change
Unambiguous.
and
Days of cover
is less than
14
change
"Two weeks of stock" — see the reading below, there were two.
Two readings of “two weeks of stock”
used
Days of cover < 14 — warehouse plus FBA, at the 30-day sales rate
other
FBA only, at the 7-day rate — stricter, and 6 more campaigns match
use this instead
Matches 14 of 64
Save as view
Make a rule
Apply filter
I built a filter and changed nothing. Anything a question can do here, the filter builder can do by hand — which is the point: you can check the work.