How to Read an Amazon Report: A Seller’s Guide to the Data That Matters

Most sellers open their Amazon reports, glance at the revenue number, and close the tab. That’s a problem - because the number you just looked at probably includes orders that haven’t shipped, doesn’t subtract returns, and ignores the fees Amazon already took. You’re not reading a profit report. You’re reading a wish list.

Amazon Seller Central offers over 50 report types across five categories. The difference between sellers who use them and sellers who just download them is the ability to read what the data actually says - not what it appears to say at first glance.

Table of Contents

• The Five Report Categories You Need to Know
• Business Reports: Where Most Decisions Start
• Sessions vs. Page Views: The Metric Everyone Misreads
• Payment Reports: What You Actually Earned
• Inventory and Fulfillment Reports
• Advertising Reports and Attribution
• The CSV Trap: Why Excel Destroys Your Data
• A Diagnostic Framework for Your Numbers
• FAQ

The Five Report Categories You Need to Know

Seller Central organizes reports under five sections - each measuring something different, using different time definitions, and often producing numbers that don’t match across categories. That’s by design, not a bug.

Category	What It Measures	Where to Find It
Business Reports	Sales, traffic, conversion	Reports > Business Reports
Payments	Revenue after fees, disbursements	Reports > Payments
Fulfillment	FBA inventory, shipments, returns	Reports > Fulfillment
Advertising	Campaign performance, search terms	Reports > Advertising
Tax Documents	1099-K, invoices	Reports > Tax Document Library

The trap: sellers try to reconcile numbers across categories and panic when they don’t match. Business Reports count orders at time of placement. Payment Reports count orders at time of shipment. Advertising Reports use a 7- or 14-day attribution window from the click date. These are three different answers to “how much did I sell?” - and all three are correct for their purpose.

Business Reports: Where Most Decisions Start

The Detail Page Sales and Traffic report - available by date, by ASIN, or by child item - is the single most important report for diagnosing listing health. Two metrics in particular deserve careful reading.

Unit Session Percentage is Amazon’s name for your conversion rate. The formula: Units Ordered divided by Sessions. But this counts units, not orders. A customer buying a 3-pack counts as 3 units from 1 session - giving you a 300% “conversion rate” for that visit. For products frequently bought in multiples, this metric runs hot. Don’t compare it to eCommerce conversion benchmarks without adjusting.

Buy Box Percentage (now called Featured Offer Percentage) tells you what share of page views displayed your offer as the default purchase option. Below 80%, you’re bleeding sales to competitors who may not even have a better product - just better Buy Box eligibility metrics. Check your pricing, shipping speed, and order defect rate if this number drops.

One detail most sellers miss: Business Report data has a 24-48 hour processing delay, and it’s available for roughly two years. Don’t make reactive decisions based on yesterday’s data - it’s incomplete.

Conversion Rate Benchmarks by Category

A 10% conversion rate doesn’t mean the same thing in every category. As of early 2026:

Category	Typical Conversion Range
Grocery & Gourmet Food	20-35%
Beauty & Personal Care	15-25%
Health & Household	12-20%
Home & Kitchen	10-18%
Books	10-25%
Toys & Games	8-14%
Apparel	9-13%
Sports & Outdoors	8-12%
Electronics	7-10%
Automotive	5-10%

A 7% conversion rate in Electronics is perfectly healthy. A 7% rate in Grocery is a red flag. Compare within your category, not across them.

Sessions vs. Page Views: The Metric Everyone Misreads

Two columns, similar names, completely different meaning. Most sellers treat them as interchangeable. They’re not.

A session is one unique visitor within a 24-hour window. If someone visits your listing three times today, that’s one session. A page view is every page load, including repeats. Three visits = three page views.

Page views should always be higher than sessions. If they’re equal, nobody is coming back for a second look - which usually means your listing failed to hold interest.

The part that really trips people up: sessions are counted per ASIN, not per seller. If five sellers list the same product, all five see the same session count. Your actual traffic share is closer to your Buy Box percentage multiplied by total sessions. At 50% Buy Box share and 1,000 sessions, your effective traffic is around 500 - not the 1,000 your report shows.

Payment Reports: What You Actually Earned

$50,000 in your Business Reports and $38,000 in your payment settlement. That’s not a glitch - it’s the gap between what was ordered and what actually shipped, survived returns, and cleared after Amazon’s fees.

The Payment Transaction Report is where optimism meets reality. Settlement reports come roughly every 14 days and break down into product charges (price times quantity), shipping credits, Amazon fees (referral, FBA, subscription), and refunds. Only shipped orders appear. Pending, canceled, or returned items don’t.

For any financial decision - margin calculations, tax prep, cash flow planning - use payment data, not Business Report data. The Business Report is the aspiration. The payment report is what actually landed in your account.

One wrinkle worth noting: in 2026, Amazon restructured Date Range reports with new transaction status and release date columns aligned to 1099-K requirements. If your accounting exports broke this year, that’s likely why - update your import mappings before chasing phantom variance.

Inventory and Fulfillment Reports

Most sellers check inventory levels. Fewer check what that inventory is costing them - and that’s where the money leaks.

The Inventory Health Report breaks down sellable quantity, unfulfillable quantity, aged inventory (units sitting over 90 days), and estimated storage fees. The number that matters most is sell-through rate: units sold divided by average inventory on hand. Below a 4x annual rate, you’re paying to warehouse product that isn’t moving fast enough to justify the space. The Recommended Removal Report flags the specific SKUs where the math has turned against you - don’t ignore it until the long-term storage fee bill arrives.

Two other reports worth a monthly check: the FBA Customer Return Report, where the reason codes tell you whether returns stem from a product defect or just buyer’s remorse (if “Not as described” exceeds 1.5% of units in 30 days, fix your images first), and the Reimbursements Report, where anything unreconciled past 45 days is worth opening a support case.

Advertising Reports and Attribution

Skip the Performance Over Time summary - it’s a single line of totals that hides everything useful. If you run PPC campaigns, go straight to the Search Terms Report. It shows the actual queries customers typed before clicking your ad - not your targeted keywords, but what they searched. That distinction is the difference between optimizing campaigns and guessing.

The mistake that costs sellers the most money here: comparing advertising “attributed sales” to Business Report sales for the same day. Amazon’s attribution uses a lookback window - typically 7 days for Sponsored Products. A click on Monday that produces a purchase on Thursday gets attributed to Monday’s data. Recent days always look underwhelming because the attribution window hasn’t closed yet. Evaluate ACoS and TACoS over weekly or monthly periods, never daily.

Your reports tell you what happened. Feedvisor’s AI tells you what to do about it - from automated repricing to advertising optimization, turning Seller Central data into margin-improving actions without the spreadsheet gymnastics.

The CSV Trap: Why Excel Destroys Your Data

This one has been tripping up sellers since the beginning: when you open a CSV report directly in Excel, it auto-converts certain fields. An ASIN like 0123456789 becomes 123456789 - the leading zero disappears. Large tracking numbers turn into scientific notation (1.23E+15). Your data is now silently corrupted, and you might not notice until you try to look up an order that doesn’t exist.

If a field can start with zero or exceed 12 digits, force Text on import. For ASIN, UPC, and tracking number columns, never let Excel guess the data type. The safest approach: use Excel’s Data Import wizard and set those columns to Text before the data loads. Google Sheets handles this better by default. Either way, spot-check the raw CSV in a text editor first - if the numbers look right there and wrong in your spreadsheet, the spreadsheet broke them.

A Diagnostic Framework for Your Numbers

Reports are most useful when you cross-reference them instead of reading each in isolation.

What You See	What It Means	What to Do
High sessions, low conversion	People find you but don’t buy	Fix listing: images, price, reviews, A+ content
Low sessions, high conversion	Listing converts but nobody sees it	Increase advertising, improve keyword targeting
Dropping Buy Box %	You’re losing the Featured Offer	Check pricing strategy, inventory levels, fulfillment method
Sessions = Page Views	Zero engagement - one look and gone	Major listing issue or wrong traffic source
Business Report sales >> Payment sales	Orders pending, canceling, or returning	Check order status and refund rates

That last row catches newer sellers every time. The $12,000 gap between your Business Report and your settlement isn’t missing money - it’s pending orders, returns, and Amazon’s fees, all in one number. Run the numbers yourself before you panic.

FAQ

What is the most important Amazon seller report?

The Detail Page Sales and Traffic report under Business Reports. It combines traffic (sessions, page views), conversion (Unit Session Percentage), and Buy Box ownership in one view. Start there.

Why don’t my Business Report sales match my Payment Report?

Business Reports count all orders placed, including pending and unshipped. Payment Reports only count shipped orders after fees and refunds. The gap reflects pending fulfillment, cancellations, returns, and fee deductions.

How often should I check my Amazon reports?

Business Reports and advertising data weekly. Payment/settlement reports every disbursement cycle (roughly every 14 days). Inventory health reports monthly - aging stock costs more to store than most sellers realize until the quarterly bill arrives.

What is a good Unit Session Percentage on Amazon?

It depends entirely on category. The platform-wide average is roughly 10-11%, but Grocery items regularly hit 20-35% while Electronics hover around 7-10%. Compare your rate to category peers, not the overall average. Anything consistently below your category floor signals a listing problem.

How do I fix Excel cutting off leading zeros in ASINs?

Don’t open CSV files directly in Excel. Use the Data Import wizard and format ASIN and tracking columns as “Text” before loading. Google Sheets preserves leading zeros by default.