Skip to content
AgeDash

Amazon seller analytics dashboard: sales by date, product, state and ACoS

Upload your Amazon order, business and ads reports, and they become one clear dashboard by date, product and state, with ACoS and TACoS worked out for you.

Try it: turn three Amazon reports into one dashboard

Visual demo, free to try. Switch the tools at the top and watch it re-skin.

Turn three Amazon reports into one dashboard
Loading the demo…Simulated demo, sample data
Read this demo as text
  1. Sana (seller)“Here are the October reports: All Orders, Business Report and Ads.”
  2. Behind the scenesRequest received on your dashboard
  3. Behind the scenesAll Orders (Oct, 1,200 rows), Business Report, Ads report
  4. Behind the scenesJoined. Cancelled orders and returns marked
  5. Behind the scenesOctober saved next to September
  6. Behind the scenesDashboard refreshed
  7. OverviewOctober totals: ₹9,60,000 sales, 1,200 orders, ₹1,20,000 ad spend, ACoS 30%, TACoS 12.5%
  8. OverviewCeramic table lamp: ₹3,20,000, ACoS 25%
  9. OverviewLinen cushion covers: ₹2,40,000, ACoS 30%
  10. OverviewBrass tea light holder: ₹1,60,000, ACoS 25%
  11. OverviewJute floor rug: ₹1,40,000, ACoS 60%
  12. OverviewStoneware mug set: ₹1,00,000, ACoS 30%
  13. By dateWeek of 29 Sep added
  14. By dateAd spend for the week of 29 Sep added
  15. By dateWeek of 6 Oct added
  16. By dateAd spend for the week of 6 Oct added
  17. By dateWeek of 13 Oct added
  18. By dateAd spend for the week of 13 Oct added
  19. By dateWeek of 20 Oct added
  20. By dateAd spend for the week of 20 Oct added
  21. By dateChart note: sales grew each week in October
  22. By productSales by product for October: the lamp leads at ₹3,20,000
  23. By productChart note: the lamp leads, the rug has the highest ACoS
  24. By locationSales by state for October: Maharashtra leads at ₹2,60,000
  25. By locationChart note: October by ship-to state
  26. Ad spendCampaign: Lamps, exact match, ACoS 25%
  27. Ad spendCampaign: Cushions, auto, ACoS 30%
  28. Ad spendCampaign: Brass, sponsored brands, ACoS 25%
  29. Ad spendCampaign: Rugs, broad match, ACoS 60%
  30. Ad spendCampaign: Mugs, auto, ACoS 30%
  31. Behind the scenesReply sent
  32. Lumen dashboard assistant“October is in, and your AgeDash dashboard is up to date.”Reports detected: All Orders October, 1,200 rows, Business Report Sessions and units by ASIN, Ads report 5 campaigns, TACoS 12.5%.
  33. Sana (seller)“Show me the last 7 days”
  34. Behind the scenesRequest received on your dashboard
  35. Behind the scenes25 to 31 October selected
  36. Behind the scenesPeriod set to the last 7 days
  37. OverviewLast 7 days: ₹2,40,000 sales, 300 orders, ₹36,000 ad spend, ACoS 40%, TACoS 15%
  38. By dateThe chart marks last week: TACoS up to 15%
  39. Behind the scenesReply sent
  40. Lumen dashboard assistant“Last 7 days: ₹2,40,000 in sales and ₹36,000 on ads. TACoS rose to 15% from 12.5% for the month, so ads took a bigger share of sales this week.”
  41. ResultOne tap to change the period. No exports, no pivot tables. The same numbers in AgeDash dashboard, for the last 7 days.

Your AgeDash dashboard

The dashboard you get

Upload three reports from Seller Central, or connect your Amazon account once. Either way the numbers land in the same dashboard. Click the tabs to look around.

LiveSample data
Sales
₹9,60,000
Orders
1,200
Ad spend
₹1,20,000
TACoS
12.5%

Sales by month

6
7
7.5
8
8.6
9.6

How does an Amazon seller dashboard work?

You give the workflow your Amazon reports: the All Orders report, the Business Report and the advertising reports. They can be uploaded, sent to an inbox, or pulled through Amazon’s Selling Partner and Ads APIs where your account allows it. The workflow recognises each report, cleans it, joins everything by ASIN and date, and stores it. Then one dashboard shows sales by date, by product and by state or city, with ad spend, ACoS and TACoS worked out for you.

The manual way, and what goes wrong

Amazon splits your numbers across many reports. Orders are in one file, sessions and units in the Business Report, and ad spend in the advertising console. Each has its own date range and columns. Most sellers download them every week, paste them into a sheet, fix the dates and try to match products by hand.

It takes hours, and the questions that matter most need data from more than one report: which products lose money after ads, which states are growing, whether ads are lifting total sales or just replacing them. By the time the sheet is ready, the week has moved on.

What happens, step by step

  1. Reports come in. Uploaded in your AgeDash dashboard, or pulled on a schedule through Amazon’s APIs where your account has access.
  2. Each report is recognised. The workflow checks the columns to tell an All Orders report from a Business Report or an ads report, and notes the date range.
  3. The data is cleaned and joined. Dates and currencies are made consistent, cancelled orders and returns are marked, and everything is joined by ASIN and date.
  4. It is stored with your history. In BigQuery or Google Sheets, next to the months already imported, so trends build up on their own.
  5. The dashboard refreshes. Overview, by date, by product, by location and ad spend, in your AgeDash dashboard, Looker Studio or Google Sheets, with ACoS and TACoS for every view.

What you get

  • One dashboard for orders, sessions, ad spend and returns.
  • Sales by date, product, state and city, with drill-down.
  • ACoS and TACoS by product and campaign, every period.
  • A history that grows each month without manual exports.
  • A short note when a campaign or product stands out.

What you need to provide

  • Your Amazon reports, or access through Amazon’s Selling Partner and Ads APIs.
  • Your product list with costs, if you want profit after ads.
  • The questions you ask every week, so the first page answers them.
  • Where the dashboard should live: your AgeDash dashboard, Looker Studio or Google Sheets.

Which tools can be swapped?

PartOptions
How reports arriveUploaded in your dashboard today, or a scheduled pull through Amazon’s APIs once your account allows it.
Dashboard inYour AgeDash dashboard, with its own login, or Looker Studio or Google Sheets.
StorageBigQuery for larger histories, Google Sheets for smaller ones.

Limits, and when it is not a good fit

  • Amazon reports some numbers with a delay, and ad sales can change for several days after a click. Recent days in the dashboard may still move.
  • Returns and refunds arrive later than the order. The dashboard marks them when they come in, so a past month can change slightly.
  • Profit after ads needs your product costs. Without them, the dashboard shows sales and ad efficiency, not profit.
  • API access depends on your seller account and Amazon’s approval. Where it is not available, uploads or an inbox work instead.

What are ACoS and TACoS, in plain words?

ACoS is your ad spend divided by the sales those ads brought in. It tells you how efficient the ads are on their own. TACoS is your ad spend divided by all your sales, from ads and without them. It tells you how much of your whole business is being paid for with ads.

In the demo’s sample data, ₹1,20,000 of ad spend brought ₹4,00,000 of ad sales, so ACoS is 30 percent. Total sales were ₹9,60,000, so TACoS is 12.5 percent. Looking at both matters: a falling ACoS with a rising TACoS can mean ads are taking sales you would have made anyway.

Questions about this automation

What is the difference between ACoS and TACoS?

ACoS divides ad spend by the sales the ads brought. TACoS divides ad spend by all sales, including sales without ads. ACoS shows how efficient the ads are; TACoS shows how much your business depends on them.

Can it connect to Amazon directly instead of uploads?

Often, yes. Amazon’s Selling Partner API and Ads API can supply orders, business data and ad data on a schedule, with your permission. Where your account does not have that access, uploading the reports or emailing them to an inbox works the same way.

Can it show Amazon sales by state and city?

Yes. Each order carries a ship-to state and city, so sales can be grouped by state and then drilled into cities. The demo drills into Maharashtra as an example.

Does it include returns and refunds?

Yes, when the return reports are included. Returns are matched to their orders and shown separately, so you can see sales before and after returns.

How long does setup take, and what does it cost?

It depends on which reports you use, how much history you want imported and where the dashboard should live. On the first call we look at your reports and give you a clear plan and price.

E-commerce

Price, stock and product ID tracker

Give it product IDs or links. Every morning it checks public prices and stock on the marketplaces you sell on, logs them in a sheet and alerts you when something changes.

Tools: Amazon, Flipkart, Meesho, Myntra, Nykaa, Blinkit, Zepto, Swiggy Instamart, Telegram, Slack, WhatsApp Business API, Email, Google Sheets, Airtable, n8n+10
Try the previewView dashboard
Marketing

Meta Ads daily report and summary

Every morning your Meta Ads numbers land in a sheet by campaign and ad set, and a plain summary tells you what changed and what to pause.

Tools: Meta Ads, Facebook, Instagram, Google Sheets, Airtable, Looker Studio, Slack, WhatsApp Business API, Email, OpenAI, n8n+6
Try the previewView dashboard
Marketing

AI video editing for ads and podcasts

A row in a sheet becomes finished short videos in your Drive folder: the best hooks picked, silences cut, captions added and the call to action kept last.

Tools: Google Sheets, Google Drive, Dropbox, OpenAI, Instagram, YouTube, n8n+2
Try the previewView dashboard

See it on your own case

Book a 30 minute call. We look at how you do this today and show you the same demo with your own tools, rules and wording.