An Amazon advertising dashboard for a client should answer three questions every week: what did we spend and sell, was it efficient (ACOS, ROAS, TACOS), and are we winning the searches that matter (top-of-search share, brand vs non-brand, new-to-brand). Pull ad data from Amazon’s reports, total sales from Seller or Vendor Central, label the last few days as provisional, and keep one attribution window per ad product.
- TACOS needs total sales from Seller Central or Vendor Central; the ads console doesn’t have it.
- Amazon restates conversions 1, 7 and 28 days after they happen.
- Don’t add view-through sales from vCPM campaigns to click sales without labelling them.
- Split brand and non-brand, or the headline ACOS hides the real cost of growth.
The metrics, defined
Metric glossary for the client
| Formula or source | Watch out for | |
|---|---|---|
| Spend | Ad cost from Amazon reports | Currency per marketplace |
| Sales and orders | Ad-attributed, from Amazon reports | Attribution window differs by ad product |
| ACOS | Spend ÷ sales | Lower isn’t always better: it can mean underinvesting |
| ROAS | Sales ÷ spend | The inverse of ACOS; use it next to other channels |
| TACOS | Spend ÷ total sales (ads plus organic) | Needs Seller or Vendor Central sales |
| CVR | Orders ÷ clicks | Listing problems show here first |
| CPC and CTR | Spend ÷ clicks; clicks ÷ impressions | A CPC jump on brand terms means a new competitor |
| Top-of-search impression share | Share of eligible top-of-search impressions you won (SP and SB) | Read it per campaign, not blended |
| New-to-brand orders and sales | First-time orders for the brand in 12 months (SB and SD) | Amazon’s report docs list it for SB and SD; check your console before promising it for SP |
The layout: eight blocks, one page
Weekly Amazon dashboard layout
| What goes in it | Grain | |
|---|---|---|
| 1. Headline row | Spend, sales, ACOS, ROAS, TACOS and orders vs last week, vs plan | Week |
| 2. Pacing | Spend to date vs monthly budget or PO, projected month-end | Month to date |
| 3. By ad product | SP, SB and SD side by side | Week |
| 4. By intent | Brand, generic, competitor, auto: spend share and ACOS | Week, from naming |
| 5. Search share | Top-of-search impression share for brand and top generic campaigns | Week trend |
| 6. Products | Top advertised ASINs by spend and sales; products out of stock or ineligible | Week |
| 7. Search terms | Top converting terms and top wasted terms | Last 30 days |
| 8. Actions | What you changed last week and what you will change next | Text |
Block 4 depends on campaign names. If names follow a convention with an intent token (see campaign structure), the dashboard can split brand and non-brand with a simple text rule.
Where each number comes from
- Amazon Ads console: Measurement and Reporting > Reporting. Amazon made unified reporting generally available on 8 June 2026, with up to 15 months of daily or weekly data and up to 6 years of monthly data, and says the old Sponsored ads report pages are sunset by 31 December 2026 (Amazon). Rebuild scheduled reports there before the end of the year.
- Seller Central or Vendor Central: total sales for TACOS, by day and marketplace.
- Your plan: monthly budgets and targets for pacing.
- Exchange rates: if one client runs several marketplaces, convert at a fixed monthly rate and keep local currency in the table.
Why last week’s numbers change
Amazon’s reporting FAQ says impression and click data arrives within 12 hours and can change for up to three days, while conversion data arrives within 24 hours and is restated 1, 7 and 28 days after the conversion. Mark the last three days as provisional, refresh the previous week again when you send the next report, and tell the client why sales go up after the fact.
Keep attribution windows straight
Sponsored Products uses a 7-day window for sellers and 14 days for vendors, matching the console (Amazon). Sponsored Brands and Display report 14 days. For campaigns bought on viewable impressions, Amazon’s sales metric includes sales after a view as well as a click (report columns). Show "sales from clicks" next to total sales whenever vCPM campaigns are in the mix.
Where this goes wrong
- Adding view-through sales to click sales. Sponsored Display and vCPM Sponsored Brands can make blended ROAS look much better than search ads alone.
- Comparing 7-day and 14-day numbers across ad products, or across seller and vendor accounts, without a label.
- Locking last week on Monday morning. The last days will rise as conversions are restated.
- TACOS with the wrong denominator. Use total sales for the same marketplaces and dates as the ad spend.
- ACOS as the only KPI. A falling ACOS with falling sales is not a win. Show sales and TACOS next to it.
Do it faster with Whathead
Amazon Ads is a source in Whathead’s Google Sheets add-on and Looker Studio connector. You pick a report type (Sponsored Products campaigns, placements, keywords and targets, search terms or advertised products; Sponsored Brands campaigns, ads, placements and search terms; Sponsored Display campaigns and targeting) and fields including spend, sales, orders, sales from clicks, top-of-search impression share, new-to-brand and video metrics. Queries refresh on demand or on a schedule. Whathead is our product.
Total sales for TACOS still come from Seller or Vendor Central, so paste or import them into a tab next to the ads data. For the weekly commentary, Claude or ChatGPT can read the same numbers through the Amazon Ads MCP:
- “Summarise last week for the UAE profile: spend, sales, ACOS and ROAS by ad product and by brand vs non-brand (campaign names contain _BRAND_), with the change vs the week before. Mark the last 3 days as provisional.”
- “Which five campaigns moved ACOS the most week on week, and what changed in their search terms?”
Reading reports changes nothing in Amazon, and you can use the read-only connection for this job.
Related: the GA4 Looker Studio dashboard, the Facebook Ads report template, the Amazon media plan and brand defence.
Amazon advertising dashboard: common questions
Which metrics should an Amazon Ads dashboard include?
Spend, sales, orders, ACOS, ROAS, TACOS, conversion rate, CPC, top-of-search impression share, and new-to-brand orders for Sponsored Brands and Display, split by ad product and by brand vs non-brand.
How do I build an Amazon Ads dashboard in Looker Studio or Google Sheets?
Use a connector that reads Amazon Ads reports into Sheets or Looker Studio, add a tab with total sales from Seller or Vendor Central for TACOS, and build the eight-block layout on top. Refresh weekly and re-pull the previous week.
What is TACOS on Amazon?
Total advertising cost of sales: ad spend divided by total sales, including organic. It shows whether advertising grows the whole business, not just ad-attributed sales.
What is Amazon unified reporting?
The reporting page under Measurement and Reporting > Reporting in the Amazon Ads console, generally available since 8 June 2026. Amazon says the older sponsored ads report pages are sunset by 31 December 2026.
Why did last week’s Amazon sales go up after I reported them?
Amazon restates conversion data 1, 7 and 28 days after the conversion, and click data can change for up to three days. Treat recent days as provisional.
Sources
- Amazon Ads: unified reporting announcement, 8 Jun 2026, ACOS guide
- Amazon Ads advanced tools center: reporting FAQ (data freshness and restatement), report columns, attribution defaults
- Whathead: Amazon Ads MCP, Amazon Ads connection setup, Google Sheets add-on, Looker Studio connector
Written by Ahmed Shahin, founder of Whathead. Last reviewed 19 November 2026.
Amazon Ads in Sheets and Looker Studio
Pull Sponsored Products, Brands and Display into the weekly dashboard on a schedule, next to Meta and Google.



