Data reference

Introduction

Amazon Seller Central is Amazon’s dashboard for third-party sellers on the Amazon marketplace. This connector reads sales, traffic, orders, and returns data from Amazon’s Selling Partner API (SP-API). The user picks one report type at connection time — Sales & Traffic (by day or by ASIN), Orders, or Returns — and Adriel refreshes that report daily. As an e-commerce connector, order, revenue, and product breakdowns are standardized so widgets can aggregate alongside ad-platform sources without additional configuration. To connect this data source, see How to connect Amazon Seller Central to Adriel.

Data refresh strategy

Architecture data

Amazon Seller Central does not import a separate architecture tree — the report type chosen at connection time defines the shape of the data source.

Reports data

Daily cache. Report data is fetched from Amazon SP-API on a daily schedule; dashboards read from the cached snapshot rather than triggering live requests. Refresh schedule. The cache refreshes daily at 10:00 UTC (rolling 2-day window). Initial back-fill. After connection, the last 90 days of historic data is retrieved. Payment vs order date. For Orders reports, attribution uses the Amazon purchase-date field, converted to yyyy-MM-dd. For Returns reports, attribution uses return_request_date.

Report types

One report type is chosen at data source creation and cannot be changed later. Each type maps to a distinct SP-API report family with its own file format and chunk cadence.

Report type	What it covers	Amazon SP-API report
Sales and Traffic	Daily rollup of sales and traffic across the marketplace at parent-ASIN granularity.	`GET_SALES_AND_TRAFFIC_REPORT` (parent, by date)
Sales and Traffic by Child ASIN	Daily sales and traffic split per child ASIN.	`GET_SALES_AND_TRAFFIC_REPORT` (child ASIN)
Sales and Traffic by Parent ASIN	Daily sales and traffic split per parent ASIN.	`GET_SALES_AND_TRAFFIC_REPORT` (parent ASIN)
Orders	All orders by order date, one row per order.	`GET_FLAT_FILE_ALL_ORDERS_DATA_BY_ORDER_DATE_GENERAL`
Returns	All returns by return request date, one row per return.	`GET_FLAT_FILE_RETURNS_DATA_BY_RETURN_DATE`

Date range limits

Breakdown	Max range
Daily	93 days
Weekly	1 year
Monthly / Quarterly / Yearly	No explicit cap (bounded by the 90-day historical back-fill)

Metrics

How to read the columnsThe Data type column uses this vocabulary: Number, Currency, Percentage, Ratio, Duration, Date, Text, URL, Array, Boolean.The API Key column in code style like unitsOrdered is the literal SP-API report field. Because each report type has its own dynamic schema, the exact set of fields that appear for a given data source is populated after the first successful sync.

Orders and revenue (Sales & Traffic reports)

Metric	Description	Data type	API Key
Ordered product sales	Total sales value of ordered products.	Currency	`orderedProductSales.amount`
Ordered product sales (B2B)	Sales value of B2B orders.	Currency	`orderedProductSalesB2B.amount`
Units ordered	Count of units ordered.	Number	`unitsOrdered`
Units ordered (B2B)	Count of B2B units ordered.	Number	`unitsOrderedB2B`
Total order items	Distinct order line items.	Number	`totalOrderItems`
Total order items (B2B)	Distinct B2B order line items.	Number	`totalOrderItemsB2B`
Average sales per order item	Sales divided by order items.	Currency	`averageSalesPerOrderItem.amount`
Average selling price	Sales divided by units ordered.	Currency	`averageSellingPrice.amount`
Average units per order item	Units divided by order items.	Ratio	`averageUnitsPerOrderItem`

Traffic (Sales & Traffic reports)

Metric	Description	Data type	API Key
Sessions	Detail page sessions.	Number	`sessions`
Sessions (B2B)	B2B detail page sessions.	Number	`sessionsB2B`
Browser sessions	Sessions via browser.	Number	`browserSessions`
Mobile app sessions	Sessions via the Amazon mobile app.	Number	`mobileAppSessions`
Page views	Detail page views.	Number	`pageViews`
Page views (B2B)	B2B detail page views.	Number	`pageViewsB2B`
Session-to-order conversion	Order items divided by sessions.	Percentage	`unitSessionPercentage`
Buy Box percentage	Share of page views where the seller held the Buy Box.	Percentage	`buyBoxPercentage`

Order details (Orders report)

Metric	Description	Data type	API Key
Order ID	Amazon order identifier.	Text	`amazon-order-id`
Order status	Order status (Shipped, Pending, Cancelled, etc.).	Text	`order-status`
Order item quantity	Units on the order line.	Number	`quantity`
Order item price	Item price on the order line.	Currency	`item-price`
Order item tax	Tax on the order line.	Currency	`item-tax`
Shipping price	Shipping charged on the order line.	Currency	`shipping-price`
Purchase date	Order purchase timestamp.	Date	`purchase-date`

Returns (Returns report)

Metric	Description	Data type	API Key
Return quantity	Units returned on the request.	Number	`return_quantity`
Return refund amount	Refund amount issued for the return.	Currency	`refunded_amount`
Return reason	Buyer-submitted return reason.	Text	`reason`
Return request date	Date the return was requested.	Date	`return_request_date`

Breakdowns

Report-type-scoped. Available breakdowns depend on the report type chosen at connection time. Some breakdowns exist only for specific reports.

Product hierarchy

Breakdown	Description	API Key
Parent ASIN	Parent-ASIN identifier.	`parentAsin`
Child ASIN	Child-ASIN identifier.	`childAsin`
SKU	Seller SKU on the order line.	`sku`

Order details (Orders report)

Breakdown	Description	API Key
Order status	Order status.	`order-status`
Sales channel	Amazon sales channel (e.g. `Amazon.com`).	`sales-channel`
Fulfillment channel	MFN or AFN.	`fulfillment-channel`
Ship state	Ship-to state.	`ship-state`
Ship city	Ship-to city.	`ship-city`
Ship country	Ship-to country.	`ship-country`

Time & date grouping

Breakdown	Description
Auto Time Breakdown	Automatically picks the best granularity for the date range.
Daily	Split reports by day.
Weekly (Start: Mon)	Split reports by ISO week, starting Monday.
Weekly (Start: Sun)	Split reports by week, starting Sunday.
Monthly	Split reports by calendar month.
Quarterly	Split reports by calendar quarter.
Yearly	Split reports by calendar year.

Overview & status

Breakdown	Description
No Grouping	Do not break down; return one aggregated row.
Datasource Name	Group by Adriel datasource name.

Limitations

Report type is fixed at connection time. To view a different report, connect a new data source with that report type selected.
Cross-report joins are not supported. Each report type stores data in its own isolated table with its own schema.
90-day historical back-fill. Data older than 90 days from the connection date cannot be retrieved.
Marketplace-currency reporting. Monetary values are reported in the marketplace’s configured currency; Adriel applies currency conversion at query time when combining with other reporting currencies.
Availability may be restricted. Amazon Seller Central connections are gated by workspace allowlist while the integration is finalized with Amazon.
Marketplace permission scope. If Amazon rejects the marketplace for the connected user, the connection is marked disconnected and returns EXTERNAL_SERVICE_PERMISSION_MISSING.

Introduction

Data refresh strategy

Architecture data

Reports data

Report types

Date range limits

Metrics

Orders and revenue (Sales & Traffic reports)

Traffic (Sales & Traffic reports)

Order details (Orders report)

Returns (Returns report)

Breakdowns

Product hierarchy

Order details (Orders report)

Time & date grouping

Overview & status

Limitations

API references (Amazon)

See also

​Introduction

​Data refresh strategy

​Architecture data

​Reports data

​Report types

​Date range limits

​Metrics

​Orders and revenue (Sales & Traffic reports)

​Traffic (Sales & Traffic reports)

​Order details (Orders report)

​Returns (Returns report)

​Breakdowns

​Product hierarchy

​Order details (Orders report)

​Time & date grouping

​Overview & status

​Limitations

​API references (Amazon)

​See also

Introduction

Data refresh strategy

Architecture data

Reports data

Report types

Date range limits

Metrics

Orders and revenue (Sales & Traffic reports)

Traffic (Sales & Traffic reports)

Order details (Orders report)

Returns (Returns report)

Breakdowns

Product hierarchy

Order details (Orders report)

Time & date grouping

Overview & status

Limitations

API references (Amazon)

See also