Sales Statistics
GET {{SL_BASE_URL}}/api/sales/statistics-dashboard?seller_id=<string>&marketplace_id=<string>&view_by=<string>&group_by=<string>&start_date=<yyyy-mm-dd>&end_date=<yyyy-mm-dd>&per_page=<integer>
This endpoint makes Sales Statistics screen data available through API. The product based statistics can be obtained by passing 'product' as viewby, or to get date based statistics viewby should be 'date'. After the view selection, next you have to choose is the statistical group, by passing any one of: Product, SKU, ASIN, ParentASIN, Brand or ProductGroup (if the view is product), or any one of: Date, Week, Month, Quarter, Semester, Year (if the view is date). You can also specify start and end date of your choice, but if not specified it will return passed 7 days data only. Please see the complete list of parameters below in the calls.
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
seller_id | string | (Required) The Amazon Seller ID | |
marketplace_id | string | (Required) The Amazon Marketplace ID | |
view_by | string | (Required) Any one of: product or date | |
group_by | string | (Required) For product (any one of): Product, SKU, ASIN, ParentASIN, Brand, ProductGroup OR | |
| For date (any one of): Date, Week, Month, Quarter, Semester, Year | |||
start_date | string | (Optional) Start period; must be in yyyy-mm-dd format, e.g. 2019-01-01 | |
end_date | string | (Optional) End period; must be in yyyy-mm-dd format, e.g. 2019-12-31 | |
per_page | string | (Required) Number of records per page, e.g. 500 (recommended), 1000 | |
page | string | (Optional) Jump on page number, e.g. 3,7 | |
filter_by | string | (Optional) Any one of: sku, asin, parent_asin | |
filter_value | string | (Optional) Value against filter_by, e.g. BxxxxBxxxO |
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
Accept | string | Required |
RESPONSES
status: OK
{"current_page":1,"data":[{"Date":"2021-07-01","Orders":"1,565","Units":"1,608","Refunded":"54","Promo Units":"0","Organic Units":"1,608","Ordered Product Sales":"23,141.15","Per Unit Revenue":"14.80","Revenue":"23,000.77","Shipping Cost":"0.00","Miscellaneous Cost":"0.00","COGS":"-4,835.92","FBA Fees":"-8,116.45","Taxes":"0.00","Promo Amount":"-220.82","Sessions":1923,"Page Views":2412,"Impressions":"288,830","Clicks":"2,982","PPC Orders":"305","PPC Sales":"12,715.32","PPC Cost":"-4,274.46","PPC Conv":"34.94","OOE":"-189.75","Net Profit":"5,363.37","Net Margin":"23.32","Net ROI":"41.41","Currency":"USD"},{"Date":"2021-07-02","Orders":"1,446","Units":"1,474","Refunded":"47","Promo Units":"0","Organic Units":"1,474","Ordered Product Sales":"20,988.30","Per Unit Revenue":"14.66","Revenue":"20,913.05","Shipping Cost":"0.00","Miscellaneous Cost":"0.00","COGS":"-4,451.02","FBA Fees":"-7,394.57","Taxes":"0.00","Promo Amount":"-244.48","Sessions":1779,"Page Views":2320,"Impressions":"283,294","Clicks":"2,818","PPC Orders":"309","PPC Sales":"11,612.05","PPC Cost":"-3,927.27","PPC Conv":"37.45","OOE":"-160.82","Net Profit":"4,734.89","Net Margin":"22.64","Net ROI":"39.97","Currency":"USD"},{"Date":"2021-07-30","Orders":"1,740","Units":"1,784","Refunded":"58","Promo Units":"0","Organic Units":"1,784","Ordered Product Sales":"24,624.10","Per Unit Revenue":"14.16","Revenue":"24,441.85","Shipping Cost":"0.00","Miscellaneous Cost":"0.00","COGS":"-5,388.64","FBA Fees":"-8,771.34","Taxes":"0.00","Promo Amount":"-227.82","Sessions":2369,"Page Views":2957,"Impressions":"245,159","Clicks":"2,931","PPC Orders":"445","PPC Sales":"14,261.09","PPC Cost":"-4,568.72","PPC Conv":"42.58","OOE":"-188.95","Net Profit":"5,296.38","Net Margin":"21.67","Net ROI":"37.40","Currency":"USD"},{"Date":"2021-07-31","Orders":"1,750","Units":"1,781","Refunded":"54","Promo Units":"0","Organic Units":"1,781","Ordered Product Sales":"24,103.05","Per Unit Revenue":"13.89","Revenue":"23,986.82","Shipping Cost":"0.00","Miscellaneous Cost":"0.00","COGS":"-5,411.35","FBA Fees":"-8,873.06","Taxes":"0.00","Promo Amount":"-213.83","Sessions":2549,"Page Views":3363,"Impressions":"279,128","Clicks":"3,184","PPC Orders":"478","PPC Sales":"14,660.74","PPC Cost":"-4,855.09","PPC Conv":"39.87","OOE":"-166.89","Net Profit":"4,466.60","Net Margin":"18.62","Net ROI":"31.27","Currency":"USD"}],"first_page_url":"https://app.sellerlegend.com/api/sales/statistics-dashboard?seller_id=A2xxxxxxxxxxxx\u0026marketplace_id=ATVPDKIKX0DER\u0026view_by=date\u0026group_by=Date\u0026start_date=2021-07-01\u0026end_date=2021-07-31\u0026per_page=500\u0026page=1","from":1,"last_page":1,"last_page_url":"https://app.sellerlegend.com/api/sales/statistics-dashboard?seller_id=A2xxxxxxxxxxxx\u0026marketplace_id=ATVPDKIKX0DER\u0026view_by=date\u0026group_by=Date\u0026start_date=2021-07-01\u0026end_date=2021-07-31\u0026per_page=500\u0026page=1","next_page_url":null,"path":"https://app.sellerlegend.com/api/sales/statistics-dashboard","per_page":"500","prev_page_url":null,"to":31,"total":31}