Retention Dataset

Summary - Anna to fill in

Provides:

1. An analytical look into how well subscribers were retained.

2. Insight into when and why subscribers are falling off of your file.

Use Cases for this data set:

 Dataset Details:

• The source of this dataset is Advantage.

• Data is refreshed daily.

Table of contents

Using this Dataset

Key Considerations:

• Lifecycle vs. Term Fields:

  • This dataset will include ‘Lifecycle’ fields and ‘Term’ fields. Example: Lifecycle Promo Code vs. Term Promo Code.

  • These cannot be used interchangeably.

  • Lifecycle fields will reflect the attributes of the initial subscription that began the lifecycle, and will cohort all subsequent terms of the lifecycle back to the initial purchase (similar to original retention).

  • Term fields will reflect the attributes of the individual terms within lifecycles.

  • Example:

    • If you filter to lifecycle promo code ABC, you will be able to see how the subscribers who began their subscription on this promo code were retained over time, regardless of the promo codes tied to their subsequent term purchases.

    • If you filter on term promo code ABC, you will only see the subscription details within this term. So, if customers began on this promo code BUT were retained at one year on promo code XYZ (with no lapse), you will not see the retention event since you are only looking at terms tied to that promo code.

  • Note: For general use cases (and to mimic original retention), use lifecycle fields. Term fields should be reserved for advanced use cases.

• Excluding folds:

  • Original retention excluded folds on default. To replicate in this dataset, exclude channel = V.

• Getting to ‘paid’ subscibers

• Why 14 months is an important milestone (vs. 12)

• How to analyze active subscribers (i.e. is lifecycle currently active flag)

Key Terms/Measures:

Initial Batch Subs:

• Change below to explain how you can use paid and comp flags to get to ‘paid’ subscribers like original retention

• Count of customers who subscribed to a subscription.

  • Caveat: No flag for ‘non-pay’ customers currently (so bit of a misnomer) but there are plans to add it.

    • Original retention only counted subscribers who were fully paid (i.e. excluded installment, comped or trail subscribers).

Lifecycle:

• Continuous time active on a subscription. A lifecycle will include all the terms within a subscription as long as there is no lapse.

Lifecycle Date – Start:

• Start of the subscription lifecycle. Reflects the order date vs. the date of the first issue (original retention).

Lifecycle Date – End:

• End of the subscription lifecycle. A lifecycle will end if there are no active terms tied to a subscription.

• Anything currently active has a null end date.

• No grace period; if a subscription is cancelled/expired and a subscriber re-purchases, it will start a new lifecycle*.

  • Exception: If someone gets suspended and then re-activated, we will consider them active that entire time.

  • Note that original retention had a 3 month grace period, so if a subscription ended and was restarted within 3 months of the end date, it was shown as one continuous lifecycle.

• Cancel subs use event date of the cancellation for end date.

• For non-pay cancels who were in bill suspend, their end date will be the bill suspend date vs. the true cancel date.

Term:

• The terms within a subscription/lifecycle.

• ‘Term’ fields provide the ability to analyze subscriptions at the term level and see how many terms are included in lifecycle.

• Any term that never starts (future term that gets cancelled) will have a null term start date

Days btw term order data and lifecycle start date:

• Helpful for showing the timeframe of the retention event.

Days btw lifecycle start and end dates:

• Helpful for showing length of lifecycle.

Retention Count vs. Flag vs. Rate Fields:

• Retention Count fields: Number of initial paid subs who made it to given milestone.

• Retention Rate fields: Divides initial paid subs who made it to given milestone by the initial paid subs of the cohort.

• Retention Flag fields: Applies a value of 1 to initial paid subscribers who made it to the milestone and a value of 0 those that did not.

  • Good for filtering to only include/evaluate initial paid sub who made it to that milestone.

Starter Board

Retention Starter Board

Related FAQS

Related Content

Level up with a Masterclass