The Multi-Product view within Sales Analytics' Profit Overview allows you to see how your company-level profitability is broken down between products. This option helps you easily identify which products are driving profitability and which ones are financially struggling.
Simply enable/disable the columns you want to see from the following options:
- Product Information: Marketplace, ASIN & SKU (cannot be disabled)
- Total Sales: The total revenue from Amazon sales.
- COGS: Product costs, shipping, and misc. costs for the units sold in this time period based on what you entered in the Product Costs section.
- Operating Expenses: Seller Fees, Sales Tax and other costs added in the Other Transactions panel as Manual Entries‡ (basically, any additional costs associated with a specific ASIN or business expenses)
- Net Profit: Gross Profit‡ minus Operating Expenses.
- Gross Margin %: Gross Profit divided by Revenue, multiplied by 100.
- ROI: Gross Profit divided by the sum of Unit Costs + Supplier Shipping.
- Units Shipped: How many units you have sold (comprises the total of Units Shipped + Promo Rebates + Pending Units).
- Promo Units: Units purchased at a discount via promotions, coupons, or manual discounted price that have been shipped.
- Pending Units: Any unshipped orders, both regularly priced and promotional (Amazon considers these units estimates only because a shopper can still cancel an order before it ships out).
- Organic Sales: Amazon sales not attributed to PPC.
- PPC Sales: Amazon sales attributed to PPC ads.
- PPC Revenue %: PPC Sales divided by the Total Amazon Sales.
- Returns: Number of units returned by customers.
- Refund Rate: Units Returned divided by the sum of Units Shipped + Promo Units Shipped.
By clicking on any one ASIN you can access additional information and dive deeper into specific product performance to explore sales, profit and revenue, PPC campaign costs & performance, among other details.
The first section is a summary of Units, Profit & Revenue and ROI:
In the next section, you can click on any of the relevant tabs to analyze and compare your products in detail:
Each of these tabs includes a Summary section and a graph with historical data:
You can hover over each value or data point in the graph to see more information:
Underneath the Summary & Historical graph section, you'll find the Cost Breakdown. This is a visual representation of Costs and the respective % from the Total Cost. Hover each bar to access additional information:
‡ Helpful Terminology
- Manual Entries: Basically, any additional costs associated with a specific ASIN or business expenses.
- Gross Profit: Revenue minus Unit Cost, Supplier Shipping and FBA Inbound Shipping, Miscellaneous Cost and Order Fees