Products dashboard Products dashboard

Products dashboard

Tyler Yannes Tyler Yannes

Table of contents


Dashboard overview

🎉 May 2024 Updates  🎉

  • Added one-time (non subscription) order data.
  • Introduced a new "Top 5" table to compare the value of the best performing products on subscription and one-time purchases.
  • New component for subscription shipping intervals.
  • Upgraded products table.
  • New build-a-box products table.
  • New graph showing the order count distribution for each product.
  • New metrics to show the total count of subscriptions, subscribers, and products that were active at some point in the date range.
  • This page will provide more granular details into subscriptions and products.
  • This page will show new activations and cancellations per product along with cancellation reasons.
  • This page should be complemental to the store performance overview tab.

Things to keep in mind

  • Dashboard filters
    • Use the calendar selector to change the date range for this dashboard.
    • Adjust the comparison period with the compare to calendar selector.
  • Our dashboards update every 4 hours and will likely show a lag compared to Shopify for today's values.
  • Hovering over any metric name will display the metric's definition and hovering over the comparison % number will show the compare to value.
  • Want a walkthrough of the dashboard? Click the "i" icon button in the upper right hand to trigger a tutorial wizard.

Overview metrics

Screenshot 2024-04-19 at 6.43.05 AM.png

  • Total subscriptions: The count of active subscriptions on the last day of the date range.
  • New subscriptions: The count of new subscriptions created in the date range.
  • Cancelled subscriptions: The count of subscriptions cancelled in the date range.

Daily activations & cancellation

Screenshot 2024-05-14 at 8.19.19 PM.png

Graph

  • Provides a breakdown of subscriptions created (activated) and cancelled per day over the date range selected.
  • Hover over each column to see the value for that day.

Overview

Screenshot 2024-04-19 at 6.52.45 AM.png

Metrics

  • Subscribers: A count of subscribers that were active at one point in the date range. This is the total number of unique customers or subscribers and is different from subscriptions and product subscription lines. This count will include subscribers that cancelled in the date range, but not before the date range started.
    • Created in date range: This is the count of all new subscribers who were created in the date range that didn’t previously have a subscription. If a subscriber cancelled a subscription and checked out with a new one, they would not count towards a new subscriber since they previously checked out with a subscription.
    • Cancelled in date range: This is the count of subscribers who has cancelled all active subscriptions in the date range selected. Customers may have multiple subscriptions, but there can only be 1 customer per store.
    • Avg subs per customer: This is the average number of active subscriptions per subscriber in the date range.
    • Avg products per customer: This is the average number of active product subscription lines per subscriber (not per subscription) in the date range.
  • Subscriptions: This is the total number of unique subscriptions with an Active status at one point in the date range selected. This count will include subscriptions that cancelled in the date range, but not before the date range started.
    • Created in date range: This is the count of newly created subscriptions during the date range.
    • Cancelled in date range: This is the count of all unique subscriptions cancelled during the time period. If a subscription contains multiple products, the cancellation would only count once.
    • Failed: This is the count of subscriptions with a failed status at one point during the date range.
    • Avg products per sub: This is the average number of active product subscription lines per subscription in the date range.
  • Products: This is the total count products in active subscriptions in the date range at one point. 
    • Created in date range: This is the count of all new product subscription lines created during this period from new subscriptions created at checkout, splitting subscriptions, creating new subscriptions manually, and adding additional products to an already active subscription. The metric is counting individual product subscription lines created.
    • Cancelled in date range: This is the count of all subscription lines cancelled during the date range. This count includes all the product subscription lines and is different from cancelled subscriptions; each subscribed product counts as its own product subscription line.

 


Top products

Screenshot 2024-05-14 at 8.20.00 PM.png

Subscriptions tab metrics 

  • Top 5 subscription products by revenue: The top 5 revenue generating subscription products in the date range.
  • Top 5 products in new subs created: The count of the top 5 products created with new subscriptions in the date range.
  • Top 5 products added to subs in the period: The count of the top 5 products added to active subscriptions in the date range.
  • Top 5 products that were cancelled: Top 5 products that were in subscriptions that cancelled in the date range.

All Shopify orders tab metrics 

  • Top 5 products by all revenue: Top 5 revenue generating products in your Shopify store including both one-time purchases in your Online Store and subscription products.
  • Top 5 products for one-time orders: Top 5 revenue generating products from one-time purchases (excludes subscription orders).
  • Top 5 products by AOV: Top 5 products by AOV in all orders processed in the date range, including both one-time purchases and subscription orders.
  • Top 5 products checkout products (one-time purchases + first-time sub orders): Top 5 revenue generating products at checkout including one-time purchases and subscriptions created at checkout; excludes recurring subscription orders.

Shipping intervals

Screenshot 2024-05-14 at 8.20.52 PM.png

  • All subscriptions: The count of unique subscriptions per shipping interval frequency for subscriptions that were active at one point in the date range.
  • New subs created: The count of unique subscriptions per shipping interval frequency for subscriptions that were newly created in the date range.
  • Cancelled subs: The count of unique subscriptions per shipping interval frequency for subscriptions that were cancelled in the date range.

Subscription products table

Screenshot 2024-05-14 at 8.21.53 PM.png

Overview tab metrics

  • Product: The product title; this value may appear as multiple rows if there are multiple variants or SKUs associated with this product title.
  • Variant: The variant title; this value may appear as multiple rows if there are multiple SKUs associated with this variant title.
  • SKU: The product SKU; this value may be blank if there are products without SKUs and it may repeat if the same SKU is used for multiple products or variants.
  • Active subscribers: The count of unique customers or subscribers that are subscribed to this product on the last day of the date range.
  • Active subs: The count of subscriptions that are subscribed to this product on the last day of the date range.
  • Active Quantity: This is sum of the quantity of units of this row that is active as of the last day of the date range; this number is different than active product subscription lines since this includes the sum of quantity.
  • Activated: This is count of subscriptions created in the date range with this product included.
  • Cancelled: This is count of subscriptions cancelled in the date range with this product included.

KPIs tab metrics

  • Product: The product title; this value may appear as multiple rows if there are multiple variants or SKUs associated with this product title.
  • Variant: The variant title; this value may appear as multiple rows if there are multiple SKUs associated with this variant title.
  • SKU: The product SKU; this value may be blank if there are products without SKUs and it may repeat if the same SKU is used for multiple products or variants.
  • Revenue: The total Shopify revenue generated from both one-time purchases in your Online store and subscription orders from this product in the date range.
  • AOV: This is the average order value of orders that processed in the date range with this product included.
  • Sub revenue: The total subscription revenue generated from first-time and recurring subscription orders from this product in the date range.
  • Total orders: The total count of Shopify orders processed from both one-time purchases in your Online store and subscription orders that included this product in the date range.
  • Total revenue: The total Shopify revenue generated from both one-time purchases in your Online store and subscription orders from this product in the date range.
  • Added: The total count of subscriptions that had this product added to their active subscription in the date range.
  • Removed: The total count of subscriptions that had this product removed to their active subscription in the date range.

Product distribution by order count

Screenshot 2024-04-25 at 3.56.00 PM.png

What is this table?

The purpose of this dashboard is to understand how your products are being distributed by the order count of your subscription orders. This table will help you understand if specific products are included in checkout orders, recurring orders early in the subscription lifecycle, and/or if your higher-valued subscribers are ordering specific products.

 

Each numbered column is the order count and the distribution of order counts across your subscriptions that had that product in an order that processed in the date range. Column 1 is the percentage of orders that had that product at checkout, column 2 is the percentage of orders that had the product included in their first recurring order (order 2 overall), and so on.

 

Count tab metrics

  • Each row is an individual product and the count of orders processed in the date range with that product included.
  • The columns indicate the order number for the subscriptions that processed with that product.
  • Column 1 is the percentage of orders that had that product at checkout, column 2 is the percentage of orders that had the product included in their first recurring order (order 2 overall), and so on.

Revenue tab metrics

  • Each row is an individual product and the count of orders processed in the date range with that product included.
  • The columns indicate the order number for the subscriptions that processed with that product.
  • Column 1 is the total revenue generated from orders that had that product at checkout, column 2 is the revenue generated from orders that had the product included in their first recurring order (order 2 overall), and so on.

One-time add-ons table

Screenshot 2024-05-14 at 8.23.36 PM.png

Metrics

  • Product: The product title; this value may appear as multiple rows if there are multiple variants or SKUs associated with this product title.
  • Variant: The variant title; this value may appear as multiple rows if there are multiple SKUs associated with this variant title.
  • SKU: The product SKU; this value may be blank if there are products without SKUs and it may repeat if the same SKU is used for multiple products or variants.
  • Revenue: This is the sum of revenue generated from this row in the date range selected.
  • Quantity: This is the sum of the quantity of units generated from this row in the date range selected.
  • Total Orders: This is the sum of orders generated from this row in the date range selected.

Surprise & delight add-ons table

Screenshot 2024-05-14 at 8.24.01 PM.png

Metrics

  • Product: The product title; this value may appear as multiple rows if there are multiple variants or SKUs associated with this product title.
  • Variant: The variant title; this value may appear as multiple rows if there are multiple SKUs associated with this variant title.
  • SKU: The product SKU; this value may be blank if there are products without SKUs and it may repeat if the same SKU is used for multiple products or variants.
  • Quantity: This is the sum of the quantity of units included in orders in the date range selected.
  • Total Orders: This is the sum of orders with this product included in the date range selected.

Build-a-box table

Screenshot 2024-05-14 at 8.24.16 PM.png

Overview tab metrics

  • Product: The product title; this value may appear as multiple rows if there are multiple variants or SKUs associated with this product title.
  • Variant: The variant title; this value may appear as multiple rows if there are multiple SKUs associated with this variant title.
  • SKU: The product SKU; this value may be blank if there are products without SKUs and it may repeat if the same SKU is used for multiple products or variants.
  • Active Quantity: This is sum of the quantity of units of this row that is active as of the last day of the date range; this number is different than active product subscription lines since this includes the sum of quantity.
  • Activated: This is count of subscriptions created in the date range with this product included.
  • Cancelled: This is count of subscriptions cancelled in the date range with this product included.

KPIs tab metrics

  • Product: The product title; this value may appear as multiple rows if there are multiple variants or SKUs associated with this product title.
  • Variant: The variant title; this value may appear as multiple rows if there are multiple SKUs associated with this variant title.
  • SKU: The product SKU; this value may be blank if there are products without SKUs and it may repeat if the same SKU is used for multiple products or variants.
  • Total revenue: The total Shopify revenue generated from both one-time purchases in your Online store and subscription orders from this product in the date range.
  • AOV: This is the average order value of orders that processed in the date range with this product included.
  • Sub revenue: The total subscription revenue generated from first-time and recurring subscription orders from this product in the date range.
  • Total orders: The total count of Shopify orders processed from both one-time purchases in your Online store and subscription orders that included this product in the date range.
  • Total revenue: The total Shopify revenue generated from both one-time purchases in your Online store and subscription orders from this product in the date range.
  • Added: The total count of subscriptions that had this product added to their active subscription in the date range.
  • Removed: The total count of subscriptions that had this product removed to their active subscription in the date range.

FAQs

What are the Total orders and revenue metrics?

  • With our latest dashboard update, Skio now displays all orders and revenue from your Shopify store including both one-time checkout purchases and subscription orders. You can now see how much of your total store revenue comes from subscription orders directly in this dashboard without needing to use Shopify analytics.
  • The subscription order count and subscription revenue is also provided so you can compare the revenue and order count per product from subscriptions and one-time customers.

Do you have net revenue metrics?

  • Yes! By default, our dashboards show gross revenue before additional discounts, shipping, and taxes are applied. In the top right corner of the dashboard, there is a toggle for discounts, shipping, and taxes; each one can be toggled on and off individually. 

What is the product distribution by order count graph?

  • This table breaks down each product and gives the percentage of subscriptions that had that product in an order in the date range broken out by the order count number and revenue totals for each subscription per product.
  • The distribution helps you gain insight into each product's revenue and order count broken out by where a subscription is in their post-purchase order cycle.

How does the Activated and Added columns differ in the products table?

  • Activations is the count of subscriptions created with this product whereas Added is the count of subscriptions that added this product in the date range post-checkout to their subscription.

Add comment

Please sign in to leave a comment.