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.
Columns
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, supplier shipping, misc. costs (based on what you entered in the Product Costs section), FBA inbound shipping, order fees, other costs, and PPC fees for the units sold in this time period
- Operating Expenses: 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 that have been processed).
- 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, multiplied by 100.
- Returns: Number of units returned by customers.
- Refund Rate: Units Returned divided by the sum of Units Shipped + Promo Units Shipped.
Product Performance
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:
FBA Fulfillment Fees
- If your FBA fees change, you will see a banner informing you of the product, the per-unit FBA fee change, and the date when this change took effect:
- You can navigate to the Cost - Summary to compare the old FBA fee vs. the new one:
- You will also be notified of FBA changes via a similar banner inside the Home Dashboard.
‡ 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
- FBA Per-Unit Fulfillment Fee represents the total FBA fees charged, while the italicized number underneath is the actual per-unit cost.