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
- Reports come in. Uploaded in your AgeDash dashboard, or pulled on a schedule through Amazon’s APIs where your account has access.
- 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.
- 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.
- It is stored with your history. In BigQuery or Google Sheets, next to the months already imported, so trends build up on their own.
- 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?
| Part | Options |
|---|---|
| How reports arrive | Uploaded in your dashboard today, or a scheduled pull through Amazon’s APIs once your account allows it. |
| Dashboard in | Your AgeDash dashboard, with its own login, or Looker Studio or Google Sheets. |
| Storage | BigQuery 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.