Explore: Subscription Churn Time Series

Description

Subscription churn data based on time since subscription start date. Uses TOB (time on books) to show the number of subscriptions still active by 30 day periods since the subscription was started.

Common Use Cases

  1. Churn by product subscribed to.
  2. Churn by TOB.

Dashboards

< insert dashboard info >  

Fields

Subscription Churn Time Series: subscription_churn_time_series
Filters, Dimensions and Measures Category Description
Subscription Churn Time Series: Churn Flag (Yes / No) dimension Did customer churn?
Subscription Churn Time Series: Product ID dimension Product ID from shopify
Subscription Churn Time Series: Product Title dimension Name of product subscribed to
Subscription Churn Time Series: SKU dimension SKU of product subscribed to
Subscription Churn Time Series: Shop ID dimension Shopify shop ID
Subscription Churn Time Series: Subscriber ID dimension The Subscriber ID from Recharge
Subscription Churn Time Series: Subscription End Date dimension Date the subscription was cancelled
Subscription Churn Time Series: Subscription End Day of Week Index dimension Date the subscription was cancelled
Subscription Churn Time Series: Subscription End Month dimension Date the subscription was cancelled
Subscription Churn Time Series: Subscription End Month Name dimension Date the subscription was cancelled
Subscription Churn Time Series: Subscription End Month Num dimension Date the subscription was cancelled
Subscription Churn Time Series: Subscription End Quarter dimension Date the subscription was cancelled
Subscription Churn Time Series: Subscription End Time dimension Date the subscription was cancelled
Subscription Churn Time Series: Subscription End Year dimension Date the subscription was cancelled
Subscription Churn Time Series: Subscription ID dimension Subscription ID from Recharge
Subscription Churn Time Series: Subscription Start Date dimension Date the subscription was started
Subscription Churn Time Series: Subscription Start Day of Week Index dimension Date the subscription was started
Subscription Churn Time Series: Subscription Start Month dimension Date the subscription was started
Subscription Churn Time Series: Subscription Start Month Name dimension Date the subscription was started
Subscription Churn Time Series: Subscription Start Month Num dimension Date the subscription was started
Subscription Churn Time Series: Subscription Start Quarter dimension Date the subscription was started
Subscription Churn Time Series: Subscription Start Time dimension Date the subscription was started
Subscription Churn Time Series: Subscription Start Year dimension Date the subscription was started
Subscription Churn Time Series: TOB dimension 30 day buckets the subscriber has been on books
Subscription Churn Time Series: TOB End Date dimension The end date of a Time on Books Period
Subscription Churn Time Series: TOB Start Date dimension The start date of a Time on Books Period
Subscription Churn Time Series: Count - Churned Subscriptions measure Total count of churns by unique subscription IDs
Subscription Churn Time Series: Count - Total Subscriptions measure Total count of unique subscription IDs


Using Explores

Exploring data can be insightful and fun! Before you start your exploration, make sure to go through our Using Explores Bootcamp

Views

View Cardinality Relationship Join
subscription_churn_time_series - self -

Flow


All content © Daasity 2021. Do not copy, share or distribute.