Interactive demo with synthetic data. This environment demonstrates Terra PPC workflows using synthetic advertising, seller-business, financial and economics data. Actions remain inside this demo and are not sent to Amazon or any external advertising or selling account.
Search Term Analysis
Which search terms are burning money, which are worth scaling, and which reach you through more than one campaign or target.
Terra Home & Packaging / USLast 30 daysADS: Simulated advertising data (Amazon Ads API-oriented workflow).DERIVED: Calculated by Terra PPC from other values shown.DEMO: Synthetic demo value. No live Amazon connection.
Money Burned
Settled spend — clicks older than the 7-day attribution window, whose sales are final — on search terms with enough clicks and no attributed sale, plus the settled spend above the modeled break-even ACoS on terms that do sell. The wave stops where the attribution window begins.$59.97
No sales $49.35 · above break-even $10.62
ADS: Simulated advertising data (Amazon Ads API-oriented workflow).ASSUMPTION: User-configured assumption. Not provided by Amazon.DERIVED: Calculated by Terra PPC from other values shown.Share of Spend Burned
Money Burned divided by all search-term spend on the settled days (older than 7 days).5.6%
of $1,062.60 settled search-term spend
DERIVED: Calculated by Terra PPC from other values shown.DEMO: Synthetic demo value. No live Amazon connection.Terms Worth Scaling
Search terms with at least 3 orders and an ACoS under their campaign's Target ACoS, with nothing holding a scale-up. The wave is their daily ad-attributed sales.15
5 run near the daily budget
ADS: Simulated advertising data (Amazon Ads API-oriented workflow).DERIVED: Calculated by Terra PPC from other values shown.Competing Search Terms
Search terms that reached the account through two or more targets in the period. The amount is what the other paths spent beyond what their sales would have cost at the lead path's ACoS — an estimate that assumes the lead path would have won those sales at its own ACoS. The wave is the other paths' daily spend.5
Above the lead path's ACoS $39.47
ADS: Simulated advertising data (Amazon Ads API-oriented workflow).ASSUMPTION: User-configured assumption. Not provided by Amazon.DERIVED: Calculated by Terra PPC from other values shown.Answers for the last 30 days
Each answer links to the evidence behind it.
Which search terms are burning money?
$59.97 of $1,062.60 settled search-term spend (5.6%) earned no profit: 2 terms with no sales and 1 above break-even ACoS, judged on clicks older than 7 days.
Which search terms are worth scaling?
15 terms convert below Target ACoS with room to grow; 5 of them run in a campaign near its daily budget, so confirm the budget over several days.
Which paths compete for the same search term?
5 search terms reach you through more than one target; the other paths spent $39.47 more than their sales would have cost at the lead path's ACoS (an estimate).
Judged on settled clicks (Aug 26–Sep 17): older than the 7-day attribution window, so their attributed sales are final. The last 7 days appear under each number and are not counted yet.
| Search term | Path | ClicksClicks older than 7 days, whose attributed sales are final. The line under a number adds the last 7 days, not judged yet. | Spend | Orders | Money burnedAll settled spend when the term has no sales; the settled spend above break-even ACoS when it sells at a loss. | Evidence | Next step |
|---|---|---|---|---|---|---|---|
| No sales | Corrugated Mailers — Broadcardboard boxes (broad) | 23+9 last 7 days | $26.45+$10.35 last 7 days | 0 | $26.45 | 0 orders in 23 settled clicks · 4.4% chance of that if it converted like its campaign (12.7%), unlikely to be chance | |
| No sales | Discovery — AutoAuto · loose-match | 21 | $22.90 | 0 | $22.90 | 0 orders in 21 settled clicks · 30.5% chance of that if it converted like its target (5.5%), so it could still be chance | |
| Above break-even | Discovery — AutoAuto · loose-match | 21+5 last 7 days | $22.80+$5.40 last 7 days | 1 | $10.62 | ACoS 78.6% on settled clicks vs break-even 42.0% (target 30.0%) |
Not judged yet · 13 terms · $221.30 spend in the periodShowHide
These terms have no sale or sell above break-even in the period, but their settled clicks do not reach the minimum (20 clicks and $20.00 spend) or do not show the loss. Acting now would judge them on too little traffic, or on sales that are still arriving.
- Not enough data yetDiscovery — Auto · Auto · substitutes12 of 20 settled clicks · +2 in the last 7 days · $16.20 in the period
- Not enough data yetSeasonal Gifts — Auto · Auto · loose-match17 of 20 settled clicks · +3 in the last 7 days · $15.00 in the period
- Not enough data yetSeasonal Gifts — Auto · Auto · complements12 of 20 settled clicks · $8.50 in the period
- Waiting for attributionSeasonal Gifts — Auto · Auto · loose-match15 of 20 settled clicks · +7 in the last 7 days · $16.50 in the period
- Not enough data yetDiscovery — Auto · Auto · complements14 of 20 settled clicks · $17.90 in the period
- Not enough data yetDiscovery — Auto · Auto · complements14 of 20 settled clicks · +2 in the last 7 days · $20.30 in the period
- Not enough data yetDiscovery — Auto · Auto · substitutes11 of 20 settled clicks · +1 in the last 7 days · $13.90 in the period
- Not enough data yetDiscovery — Auto · Auto · loose-match2 of 20 settled clicks · +6 in the last 7 days · $9.20 in the period
- Not enough data yetSeasonal Gifts — Auto · Auto · close-match1 of 20 settled clicks · +6 in the last 7 days · $6.30 in the period
- Not enough data yetDiscovery — Auto · Auto · close-match15 of 20 settled clicks · $13.20 in the period
- Waiting for attributionDiscovery — Auto · Auto · loose-matchSettled ACoS 34.4% is within break-even 42.0%; the last 7 days add 8 clicks and 0 orders so far
- Waiting for attributionDiscovery — Auto · Auto · loose-matchSettled ACoS 31.9% is within break-even 42.0%; the last 7 days add 7 clicks and 0 orders so far
How this analysis works
- Rows come from the synthetic Sponsored Products search term report (the Amazon Ads spSearchTerm report, grouped by search term): one row per customer search term and the campaign, ad group and target it matched. A term appears in the report only after it received a click. Sales and orders are the 7-day attributed columns (sales7d, purchases7d) Amazon uses for seller Sponsored Products; attribution for a day stays incomplete until its 7-day window has passed.
- Burning money is judged on settled clicks only — the ones older than 7 days, whose sales can no longer change. A term counts once those clicks reach the Negative Targeting rule’s safeguards (20 clicks and $20.00 spend). The chance of zero orders assumes the term converts like its target (or, when the target has no orders, its campaign) on the same days.
- Worth scaling needs 3 orders below Target ACoS over the whole period; sales still arriving can only lower that ACoS. The CPC ceiling is average order value × conversion rate × Target ACoS. A suggested bid is the current bid × ceiling ÷ CPC — it assumes the CPC moves with the bid, so watch the CPC after a change — and never exceeds the 20% global safety limit per change. A campaign at 95% of its daily budget on 3 of the last 7 days holds the scale-up; on fewer days it is only a signal, because Amazon may spend up to twice the daily budget on one day.
- Competing paths groups identical customer search terms across targets. The query’s clicks, spend and results are split between different bids, so each path learns from only part of it, and a weaker path keeps buying clicks a stronger one converts better. Amazon credits each conversion to one ad interaction only, so the paths’ results do not double-count. The lead path has the lowest ACoS among converting paths; the amount above it is an estimate that assumes the lead path would have won the same sales at its own ACoS.
- Search terms are never bid on directly: a bid change applies to the target and every search term it matches. A negative keyword (exact or phrase) applies to its whole ad group or campaign and can take up to 72 hours to take effect; a product-page “search term” (an ASIN) is blocked with a negative product target instead.