| name | sales-movers-scanner |
| description | Scan the whole catalog for the SKUs that moved the most this period - up and down - and decompose each move into its cause: traffic, conversion, price, or buy-box. Ranked by the size of the swing in money, with a data-completeness guard so a lagging recent week doesn't read as a fake collapse. Live from DataDoe, read-only. Use for "what changed", "biggest movers", "why did sales drop", "what's up this week", "sales down", "which products dropped", "what moved", or "week over week". |
| metadata | {"author":"DataDoe","check-more-skills-at":"https://app.datadoe.com/hub/ai-agents-and-skills","access":"read","category":"Reporting","interface":"mcp","output":"report"} |
Sales Movers Scanner
Scans the whole catalog for the SKUs that moved the most this period - up and down - and
decomposes each move into its cause: traffic, conversion, price, or buy-box. Instead
of "sales dropped," it tells you "sales dropped because sessions fell 40%" or "because
you lost the buy box" - so you act on the reason, not the symptom. Ranked by the size of
the swing in money, so you see what actually matters. Live from DataDoe, read-only.
When to use this
- Weekly review: "what changed across my catalog, and why?"
- Revenue is up or down overall and you need the SKUs and reasons behind it.
- Monday-morning triage - a short list of what needs attention, already diagnosed.
- After a price change, ad change, or a competitor move, to see the ripple per SKU.
- Trigger phrases: "what changed", "biggest movers", "why did sales drop", "what's up
this week", "sales down", "which products dropped", "what moved", "week over week".
The framework. Rank the movers, decompose the cause
Sales for a SKU are roughly sessions x conversion x price. So a change in sales comes
from one (or more) of three levers, and the buy-box sits behind conversion. Compare a
recent window to the prior equal window, then for each big mover decompose:
- Size the move - rank SKUs by the absolute change in sales (money), not by percent
(a 5% drop on a hero SKU beats a 90% drop on a trickle SKU). Look at gainers AND
decliners.
- Decompose the driver for each mover:
- Traffic -
sessions (or page_views) down/up -> visibility/rank/ads change,
a suppression, or seasonality. Sales followed the traffic.
- Conversion -
units_session_percentage (unit session rate) down/up while
traffic held -> listing/price/reviews/offer problem or win.
- Price / AOV - sales per unit (
total_sales / total_units) shifted -> a price
change, promo, or mix shift, even if units held.
- Buy-box -
buybox_percentage down is the classic hidden cause of a conversion
drop (you still get traffic but can't convert it). Always check it on a decliner.
- Availability - a mover whose
buybox_percentage (or conversion) rises from
~0 is usually back in stock / newly buyable, not an organic win; label it that
way. A conversion reading above 100% is a units-per-session quirk (multi-unit
orders), not a literal rate - don't report it as-is.
- Name the dominant driver per SKU (the lever that explains most of the swing) and
route it: traffic -> rank/ads/suppression check; conversion -> listing/price/reviews;
buy-box -> pricing/competitor; price -> confirm the change was intended.
- Roll up: is the catalog move concentrated in a few SKUs or broad? One suppressed
hero SKU vs an across-the-board seasonal dip are very different stories.
Data-completeness guard (check before you trust a broad decline). Sales & Traffic
lags, so the most recent days of the recent window may still be filling in. The tell:
if most SKUs drop by a similar amount and all read as "traffic" (sessions down
~uniformly), that is almost always an incomplete recent window, not a real collapse -
do NOT report a catalog crash. Either widen the recent window's end-buffer to a few more
days and re-pull, or state clearly that the recent window looks under-reported. A real
move is usually concentrated in specific SKUs with mixed drivers (traffic here, buy-box
there), not a flat uniform drop everywhere.
Configuration
- MCP base:
https://mcp.datadoe.com/mcp/v1
- Data source (resolve by table name with
exports_sources_get):
amazon_sales_and_traffic_with_cogs - per child ASIN per day: total_sales,
total_units, total_orders, session, page_views, units_session_percentage
(conversion), buybox_percentage, product_name. This one table carries both the
outcome (sales) and the funnel (traffic, conversion, buy-box) to decompose it.
- Windows: compare a recent window to the prior equal window (e.g. last 7 days vs the 7
before). This table can lag up to ~4 days, so end the recent window a few days back
so you compare two complete windows, not a full week against a half-reported one.
- Currency/marketplace: read
marketplace_country_code; keep each marketplace in its own
currency and scan them separately - never sum sales across currencies.
Step-by-step workflow (MCP-native)
sellers_and_vendors_list -> pick the seller.exports_sources_get -> confirm amazon_sales_and_traffic_with_cogs is enabled.- Pull both windows:
exports_create twice (recent + prior equal window), each
groupBy [child_asin, product_name], summing total_sales, total_units,
session, page_views, and averaging units_session_percentage and
buybox_percentage. Respect the ~4-day lag when setting the recent window's end.
- Join on child ASIN and compute per SKU: sales change (abs + %), and the change in
sessions, conversion, price-per-unit and buy-box.
- Rank by absolute sales change; take the top gainers and top decliners.
- Decompose each to its dominant driver (traffic / conversion / price / buy-box) and
attach the lever. Add the catalog roll-up (concentrated vs broad).
Output format
Sales Movers - {marketplace} - {recent window} vs {prior window} (~4d lag respected)
Net catalog change: {cur}{delta} ({pct}%) · concentrated in {k} SKUs / broad
TOP DECLINERS (by money lost)
SKU / ASIN sales (was -> now) driver detail lever
{sku} {cur}.. -> {cur}.. traffic -{x}% sessions {a}->{b} rank/ads/suppression
{sku} {cur}.. -> {cur}.. buy-box -{x}pp bb {a}%->{b}% pricing/competitor
{sku} {cur}.. -> {cur}.. conversion -{x}% CVR {a}%->{b}% listing/price/reviews
TOP GAINERS (by money gained)
{sku} {cur}.. -> {cur}.. traffic +{x}% sessions {a}->{b} protect / scale ads
Biggest single swing: {sku} {cur}{delta} - {driver} -> {lever}
Worked example (illustrative)
A weekly scan shows the catalog down modestly, but the decline is concentrated in two
SKUs, not broad. The first: sales down a third while sessions held - conversion fell,
and its buybox_percentage dropped from ~95% to ~40% -> buy-box loss is the cause
(a reseller/price move), routed to pricing, not copy. The second: sales down with
sessions down the same amount -> a traffic problem (check rank/ads/suppression), not
the listing. Meanwhile a gainer doubled on rising sessions -> ads/rank working, protect
it. The output is a short, ranked, already-diagnosed list - not a spreadsheet of every
SKU's delta.
Quality self-check
- Did I rank by absolute money change, not percent (so hero SKUs surface)?
- Did I decompose each mover into traffic vs conversion vs price vs buy-box, not just
report the delta?
- Did I check buy-box on every decliner (the classic hidden conversion killer)?
- Did I respect the ~4-day data lag so I compared two complete windows?
- Did I say whether the move is concentrated or broad (one SKU vs seasonality)?
- Did I keep each marketplace in its own currency?
Common mistakes
- Reporting deltas with no cause - the decomposition (traffic/conversion/price/buy-box)
is the whole point.
- Ranking by percent - tiny SKUs dominate and the real money hides.
- Comparing a partial recent week (data lag) against a full prior week - a fake drop.
- Blaming the listing when sessions fell (that's traffic) or when the buy-box dropped
(that's pricing/competitor).
- Summing sales across marketplaces/currencies into one number.
- Reacting to a single SKU's noise instead of the ranked, material movers.
- Reporting a broad, uniform, all-traffic decline as real - that is the recent window
still reporting (data lag); widen the buffer or flag it, don't cry wolf.
- Calling a buy-box/conversion rise from ~0 an organic win when it's back-in-stock, or
reporting a >100% conversion rate literally (units-per-session quirk).
Notes
- Read-only (analysis). Fixes that follow (price, listing, ads) are separate write
skills, each dryRun-gated.
- Complements the weekly business review (account-level) and the buy-box root-cause
skill (buy-box only) - this is the catalog-wide, cause-attributed mover scan.
- A DataDoe skill, built on DataDoe sales & traffic (sessions, conversion, buy-box) data.
