Order Analytics for Amazon Stores
Order Analytics is where you can see a detailed breakdown of all of your store's orders in a chosen period. You can open Order Analytics quickly in the Dashboard dropdown.
You can export all order analytics data in the chosen time range to a .csv file or .xlsx file.
Choose a date range from the top right-corner menu to view the data in a specific period. You can also pick a custom range in any way you want.
Note: The last row in the order analytics table will display the sum of all orders within the time range you chose.
You can customize the order analytics table by choosing the Order status and Metric columns being displayed.
Here's the list of the metrics included in the dashboard:
Order ID and Purchase Date: The exact ID and the order date of each order. Clicking on the Order ID will take you to the order's report in Amazon Seller Central.
Product details: Showing the thumbnail, title, ASIN, SKU, item price, and the quantity of the item in the order.
Sales: The total revenue from the order. All refunded units have Sales counted as 0.
Units: The order's total number of units. All refunded units have Units counted as 0.
Refunds: The total refunded units.
Sellable returns : The total refunded units that qualified for resale.
Order status: The status of each order.
Amazon fees: The costs charged by Amazon when fulfilling orders. Amazon fees = FBA fulfillment + Referral fee
Advertising cost: The total cost of Amazon Ads for that order.
To see how the ad spend of each product is calculated, let's take Product A for example. At the end of the day, the system will start calculating the total ad spend for Product A and divide the ad cost by all orders containing Product A. If the day is not over yet, the ad spend in your dashboard is only an estimated amount in real-time.
If at the end of the day, Product A has zero orders, its ad spend for that day will be counted toward the next order in the future.
If an order containing Product A is canceled after ad spend has been calculated for the day, the system will recalculate the cost by taking the total ad spend and dividing it between the remaining orders. For example: The ad spends for Product A on 1/3/2023 is $10 for 5 orders: $2/order. However, if one order of that day is canceled on 3/3/2023, then the ad spend for 1/3/2023 will be $10 divided by 4 orders: $2.5/order.
COGS: Cost of Goods Sold. If an order contains just one product then COGS = Quantity * Product's COGS. If there are multiple products in an order then COGS = (Product A Quantity * Product A's COGS) + (Product B Quantity * Product B's COGS).
Profit: Each order's profit is calculated by Profit = Sales - Amazon Fees - Advertising Cost - COGS - Gift Wrap - Marketplace Withheld Tax. If the order is refunded then Profit = 0 - Advertising Cost - Gift Wrap - Refund Commission + Referral Fee + Marketplace Withheld Tax
Profit Margin: Each order's profit margin is calculated by Profit Margin = (Profit / Sales) * 100. If the order is refunded then the profit margin is not calculated.
You can export all order analytics data in the chosen time range to a .csv file or .xlsx file.
What's Included in the P&L Report
Date Range Picker
Choose a date range from the top right-corner menu to view the data in a specific period. You can also pick a custom range in any way you want.
Note: The last row in the order analytics table will display the sum of all orders within the time range you chose.
Sorting and Filtering
You can customize the order analytics table by choosing the Order status and Metric columns being displayed.
Table Metrics
Here's the list of the metrics included in the dashboard:
Order ID and Purchase Date: The exact ID and the order date of each order. Clicking on the Order ID will take you to the order's report in Amazon Seller Central.
Product details: Showing the thumbnail, title, ASIN, SKU, item price, and the quantity of the item in the order.
Sales: The total revenue from the order. All refunded units have Sales counted as 0.
Units: The order's total number of units. All refunded units have Units counted as 0.
Refunds: The total refunded units.
Sellable returns : The total refunded units that qualified for resale.
Order status: The status of each order.
Amazon fees: The costs charged by Amazon when fulfilling orders. Amazon fees = FBA fulfillment + Referral fee
Advertising cost: The total cost of Amazon Ads for that order.
How your Amazon Ads is calculated at the end of each day:
To see how the ad spend of each product is calculated, let's take Product A for example. At the end of the day, the system will start calculating the total ad spend for Product A and divide the ad cost by all orders containing Product A. If the day is not over yet, the ad spend in your dashboard is only an estimated amount in real-time.
If at the end of the day, Product A has zero orders, its ad spend for that day will be counted toward the next order in the future.
If an order containing Product A is canceled after ad spend has been calculated for the day, the system will recalculate the cost by taking the total ad spend and dividing it between the remaining orders. For example: The ad spends for Product A on 1/3/2023 is $10 for 5 orders: $2/order. However, if one order of that day is canceled on 3/3/2023, then the ad spend for 1/3/2023 will be $10 divided by 4 orders: $2.5/order.
COGS: Cost of Goods Sold. If an order contains just one product then COGS = Quantity * Product's COGS. If there are multiple products in an order then COGS = (Product A Quantity * Product A's COGS) + (Product B Quantity * Product B's COGS).
Profit: Each order's profit is calculated by Profit = Sales - Amazon Fees - Advertising Cost - COGS - Gift Wrap - Marketplace Withheld Tax. If the order is refunded then Profit = 0 - Advertising Cost - Gift Wrap - Refund Commission + Referral Fee + Marketplace Withheld Tax
Profit Margin: Each order's profit margin is calculated by Profit Margin = (Profit / Sales) * 100. If the order is refunded then the profit margin is not calculated.
Updated on: 25/04/2023
Thank you!