Using MerchDash

Campaigns & filters

The main workbench: browse, chart, filter, and edit your entire campaign archive.

The Campaigns page is a fast, sortable table over your entire archive — tens of thousands of campaigns load and filter instantly. A trend chart at the top plots any metric (impressions, clicks, spend, orders, sales, ACOS, ROAS, CTR, CVR, CPC, CPO) over the selected window, and tabs switch between Campaigns, Targets, Keywords, ASINs, and your Watchlist.

Campaigns table with a metric trend chart, quick search, and a query filter box reading ORDERS = 0 AND SPEND > 5, over a list of campaigns with type, state, budget, and portfolio columns. — The Campaigns table with the trend chart and the live query filter.

Two ways to filter

Quick search for matching campaign names.
The query box — a plain-text filter language. Type something like ORDERS = 0 AND SPEND > 5 and the table filters live as you type, with autocomplete and inline error checking. Combine metrics with AND / OR, comparisons, and text matches such as STARTS WITH — the same condition syntax the automation language uses, so a filter you prototype here translates directly into a rule.

Save a filter you use often as a preset, and change the date window to recompute every column over that period. Columns can be shown, hidden, and reordered; your layout is remembered.

Columns worth knowing

Most columns are metrics over the window you picked. Four are not, and read differently:

Column	What it actually says
Avg Time In Budget	Amazon’s own estimate of the share of the day a campaign stayed in budget — a campaign at 60% stopped showing for roughly 40% of each day, which is money left on the table rather than a targeting problem. Sponsored Products only, and see the note below.
Suggested budget	Amazon’s recommended daily budget for that campaign, from the same source. A suggestion, not a target — nothing acts on it unless you do.
Serving status	Why a campaign that is enabled still isn’t delivering — out of budget, ended, incomplete billing. Enabled and serving are not the same thing, and this column is the difference. Rules can read it as servingStatus.
Placements	The three Sponsored Products bid adjustments (top of search, product pages, rest of search) as percentages. Blank on Sponsored Brands and Display, which have no equivalent.

Avg Time In Budget does not follow your date range. It is Amazon’s figure over its own most recent 7-day window, which ends a few days back — so it stays put when you change the window above the table, and it will not agree with the spend you are looking at. It reads — rather than 0% when Amazon has no recent data for the campaign, when its window is too old to mean anything, or on any campaign that is not Sponsored Products. A dormant campaign echoing a delivery week from a year ago would be worse than no number at all, so that one is cleared.

Drill down: campaign → ad groups → detail

Click a campaign to open its ad groups, and an ad group to see its keywords, targets, and products. Every level keeps the same chart, date window, and filter tools, and supports inline edits — state, budget, and bids — all logged in Change history.

Editing from the table

Budgets and states can be edited inline, and row selections unlock bulk actions (enable, pause, adjust budgets). Campaign rows also show and filter by portfolio, and campaigns can be moved between portfolios.