Our Product Dashboard provides a quick reference to which SKUs are selling and across which channels. This is important so you can ensure you have inventory on-hand, particularly if you are planning a promotion in a channel that will drive increased sales.
Not all products have the same role in your business. You may have high volume SKUs that are great for acquisition, or high margin SKUs that can increase your bottom line. This dashboard helps make these things clear to help guide your buying, site merchandising and promotional decisions.
This dashboard has two filters relating to Date options and one relating to the order source to display output.
The first filter (A) is a traditional Date Filter that determines the date range that the data shown is for. Simply change the date range and click Run to refresh the results.
The second filter (B) is a Date Type filter. This allows you to easily update certain visualizations to be by Day, Week or Month.
The third filter (C) is for the Order Source. By Default, this dashboard contains product sales from all your sales channels. To filter for a specific order source:
- Change the dropdown to "is equal to"
- Click in the empty dialog box to the right
- Choose an option from the result that populate (I.e. Shopify, Amazon, B2B)
Overall Product Sales
The top section displays your top selling products by both Revenue & Units Sold. Sometimes these two ways of looking at product sales result in a different list of SKUs, pending your assortment. This quickly illustrates which product(s) are your high volume movers (Units Sold) vs. which are driving your topline sales (Revenue).
You'll want to make sure you are always stocked with these products and they are well-positioned on your website. Running out or de-prioritizing their site presence could negatively impact your conversion rate (CVR) and your sales.
The stacked bar chart below illustrates the daily volume inclusive of your top 50 SKUs.
To determine which product may be making up a slice of the bar, simply hover your mouse over that section.
To see the bars as weeks instead of days, update the Date Type filter to Weeks and click Run.
Top Orders by Vendor
Down the right side, you'll see donut charts for the top selling products by
The attribution as Facebook or Google orders is via the "Vendor" dimension. These are identified by Channel Mapping, ensure you fill in the Vendor column.
Note: Neither Facebook nor Google supply orderID information from converted orders they measure. The only orders that can be identified as Facebook or Google are Last Click, Modified Last Click or Attribution orders, relying on last click UTMs.
Non-Paid orders are identified as:
- Direct (direct to site visitors)
- Organic Search
- Missing from GA
The next section illustrates your products that bring in the highest and lowest gross margin by volume. The size of the circle represents the relative volume of products sold during the time period of the dashboard.
The larger the circle, the more units sold.
Circles toward the bottom of the graph have lower gross margin, the circles towards the top of the chart have the highest gross margin.
The final visualizations are called Sankey charts. They show the relationship between products within the same order and also from the first order to the second order by the same customers.
The same cart product affinity map illustrates products on the right that are in the same cart as the product it is connected to on the left. Strong trends here could lead to promo opportunities or bundle ideas.
In the First to Second Purchase map, the first purchase is on the left and the 2nd purchase is on the left. This could help determine retention campaigns to increase repurchase and re-engagement.