Amazon seller analytics and optimization tools.

Nobody is short of Amazon data. Seller Central will hand you a dozen report types, most of them tens of thousands of rows, all of them raw. The work is not getting the file — it is the afternoon of pivot tables that turns the file into a decision, and that afternoon is why most exports are downloaded once and never opened again.

The reports also do not agree with each other on their own. Ad spend lives in one, the sales it produced in another, the fees that decide whether those sales were profitable in a third. The questions that actually matter — is this ACOS good, why did conversion drop, where is the money going — each need two or three of them read together.

So the honest description of what this is: the pivot tables, already built, for every Amazon report shape we have shipped against. You bring the export; the answer is on screen in about ten seconds.

The Business Report is the daily diagnostic — sessions, unit session percentage, Featured Offer share and ordered product sales per ASIN. Read properly it separates the two reasons a product is not selling: not enough people are seeing it, or the people seeing it are not buying. Those need completely different responses.

The by-date version answers the other question — not which product changed, but which day it changed on, which is usually the fastest route to what caused it.

Twenty-five advertising reports across Sponsored Products, Sponsored Brands and Sponsored Display, each with its own module because the columns and the attribution windows genuinely differ between programmes.

The single highest-value one is the search term analysis: it holds both the spend that produced nothing and the terms worth promoting to exact match, and a full audit runs from that one file.

Revenue is not profit, and on a marketplace the gap between the two is larger than it feels when fees are deducted a few rupees at a time. Referral, closing, fulfilment, storage, returns and advertising all come out before anything is yours.

The settlement calculator itemises what Amazon will actually pay on an order before you price it. The margin calculator does the same arithmetic for a whole month, with advertising and returns included — which is where most sellers discover their real margin for the first time.

The Search Term Report is where advertising is actually decided, and it is also the report people give up on first — tens of thousands of rows with a useful signal in a few dozen of them.

N-gram analysis is the part worth knowing about: it splits every term into component words and totals spend and orders per word, which surfaces leaks no single term would reveal. One word negated at campaign level can stop spend across forty terms at once.

The geography reports map revenue to states and cities — which regions carry the sales, which never order despite receiving traffic, and what changed between two months. Most sellers have a rough idea of their top three states and no idea at all about the next thirty.

It is the report that separates a slow month caused by demand from one caused by distribution, and the one most often used to justify a regional warehouse or a state-level advertising push. The month-on-month comparison is the more useful of the two: a city that stopped ordering entirely is a signal that a single number for the quarter would have averaged away.

Note that the zone bucketing here is built around Indian states, so this pair is India-only and says so above the upload area rather than quietly mapping a US export onto the wrong regions.

Every module exports to Excel with its analysis intact, so what you find here becomes the working list you take into Seller Central or a bulk sheet. Nothing is locked inside a dashboard.

The reference modules — the optimization SOP and the ads cheat sheet — are the decision layer behind that: what to change, in what order, and what to leave alone. They are the parts of an agency engagement that are actually reusable.