Article Outline:
- Dashboard Overview
- Activation & Cancellation Metrics
- Subscription Metrics
- Subscription Product Metrics
- One-time Add-on Metrics
- Surprise & Delight Metrics
- Helpful Resources
Dashboard Overview
- 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
Data questions this dashboard answers
- How many subscribers, subscriptions, and product sub lines do I have?
- How many new subscriptions am I gaining?
- How many subscriptions am I losing through cancellations?
- How many products do I have on subscription as of today?
- How many products did I gain during the period?
- How many products did I lose during the period?
- How many active units of subscriptions do I have active?
- How many products are added as one-time add-ons and what is the value?
- How many surprise & delight gifts have been added?
Things to keep in mind:
2. Products are defined by subscription lines, Subscriptions are defined by unique
subscriptionIds, and Subscribers are defined by unique userIds3. Skio uses gross revenue which is the total price charged before taxes, shipping, and additional discounts (non-subscribe and save)
Activation & cancellation
Daily activations & cancellation graph
Graph Description:
- Provides a breakdown of revenue type by day over the date range selected
- This graph is useful to pinpoint specific spikes in new subscriptions revenue and recurring subscriptions revenue
- Hover over each column to see the value for that day
1. Each row is a product subscription line (product included in a subscription). All rows are product activations or cancellations within the time range selected.
2.
subscriptionID is how we group together product subscription lines into each subscription; use the unique count of subscriptionID to find the number of subscriptions3.
userID is how we identify subscribers; use the unique count of userID to find the number of subscribers4. The
kind value identifies the type of subscription line, either ACTIVATION or CANCELLATION5. To find activations and cancellations for subscriptions, products, and subscribers, use the
kind value as a filter with unique count of subscriptionID for subscriptions, count of rows for products, and unique count of userId for subscribers
Metrics:
Total subscriptions: This is the total number of unique subscriptions with an Active status on the last day of the date range selected. This metric excludes subscriptions in dunning. Subscriptions are defined by having a unique subscription ID. Use the Active Products metric to find the count of individual products on subscription and Dunning Subscriptions for subscriptions in dunning.
Subs per subscriber: This is the average number of subscriptions per unique subscriber (the average number of unique sub ids per customer/subscriber) on the last day of the date range.
Products per subscriber: This is the average number of product subscription lines per subscriber (not per subscription) on the last day of the date range.
New subscriptions: This is the count of newly created subscriptions during the date range.
New products: 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.
New Products per subscriber: This is the average number of activated product subscription lines per subscriber (not per subscription) in the date range selected.
Cancelled subscriptions: This is the count of all unique subscriptions cancelled during the time period. If a subscription contains multiple subscription lines, the cancellation would only count once since it’s per sub ID.
Cancelled products: 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.
Cancelled products per subscriber: This is the average number of cancelled product subscription lines per subscriber (not per subscription) in the date range selected.
Total subscribers: A count of total Active Subscribers on the last day of the date range filter. This is the total number of unique customers or subscribers and is different from subscriptions and product subscription lines.
New subscribers: This is the count of all new customers 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 subscribers: This is the count of customers 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.
Subscription products breakdown table
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.
Activations: This is count of subscriptions created in the date range with this product included.
Cancellations: This is count of subscriptions cancelled in the date range with this product included.
Revenue: This is the sum of revenue generated from this product row in the date range selected.
AOV: This is the average order value of orders that processed in the date range with this product included.
One-time add-ons table
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
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.
Helpful Resources
- Full metric definition list: Analytics Definitions & Glossary
- All other dashboard guides can be found here: Skio Data Platform
- Use this helpful guide to find the important KPIs for your store: How to Find Your KPIs
Comments
0 comments
Please sign in to leave a comment.