Retention Snapshot Report

The Retention Snapshot Report provides a compact, high-level view of your subscription retention health. Rather than listing every metric for every cycle (as the detailed retention reports do), this report summarizes key subscription performance indicators and presents per-cycle rate distributions as condensed snapshot strings. It's designed for quick health checks and executive-level visibility into how subscriptions are performing across their lifecycle.

What This Report Includes

This report analyzes all recurring subscriptions with successful, non-declined transactions, evaluated as a single point-in-time view based on the subscription's original order date.

Subscriptions Included:

Recurring subscriptions with at least one successful (non-declined) sale or capture transaction
Only the most recent transaction per billing cycle is evaluated for retention status
Skipped cycles are tracked separately from retained and churned subscriptions
Test orders are excluded
Date range is based on Subscribed Date (when the subscription was originally created)

Why This Matters: While detailed retention reports are essential for deep analysis, this snapshot gives you immediate answers to the most important questions: How long are subscribers staying? At what point do they leave? And what does the distribution of outcomes look like across early cycles?

Report Metrics

Subscriptions

The total count of unique recurring subscription offers included in the snapshot. This is derived from distinct order-offer combinations with successful transactions.

Average Renewal Cycle

The average number of renewal cycles a subscription remains active, calculated across all subscriptions in the cohort. This is one of the most important single metrics for subscription health — higher values indicate better retention and longer customer lifetimes.

Churned Subscriptions

The total count of subscriptions that have churned (been cancelled). This includes both active cancellations (customer-initiated) and passive cancellations (payment failure).

Average Churn Cycle

The average last successful billing cycle before churn, calculated only for cancelled subscriptions. This tells you the typical point at which subscribers leave. Compare this to your Average Renewal Cycle to understand whether churn is primarily early-lifecycle or distributed across the lifetime.

The following metrics present per-cycle rates for R1 through R6 as a condensed view. Each shows the rate at each of the first six renewal cycles.

Overall Pending Rate

Shows the percentage of subscriptions with pending renewal charges at each cycle (R1–R6). High pending rates at recent cycles are normal; persistent pending rates on historical data may indicate processing delays.

Overall Cancel Rate

Shows the percentage of subscriptions that actively cancelled at each cycle (R1–R6). Look for spikes at specific cycles that might indicate pricing sensitivity, product fatigue, or competitive timing.

Overall Decline Rate

Shows the percentage of subscriptions where renewal charges failed (all dunning attempts exhausted) at each cycle (R1–R6). This represents involuntary churn due to payment failure. Rising decline rates at later cycles may indicate aging payment methods.

Overall Skip Rate

Shows the percentage of subscriptions that chose to skip renewal at each cycle (R1–R6). Skip patterns may indicate that customers want to stay subscribed but at a different frequency.

Overall Churn Rate

Shows the total churn rate (combining cancellation and decline outcomes) at each cycle (R1–R6). This is the most comprehensive loss metric, showing the full picture of subscriber attrition at each stage.

Overall Retention Rate

Shows the percentage of subscriptions that remain active at each cycle (R1–R6). This is the inverse of churn — the subscribers who successfully renewed and continued. This is the most important snapshot metric, giving you a quick view of your retention curve shape.

Available Dimensions

Use these dimensions to slice and filter your retention snapshot data for deeper analysis.

Dimension	Description
Subscribed Date	The date the subscription was created
Subscribed Hour	Hour of day when the subscription was created (0–23)
Subscribed Day Of Week	Day of the week the subscription was created
Subscribed Week	ISO week number of subscription creation
Subscribed Month	Month and year of subscription creation
Subscribed Year	Year the subscription was created
Customer ID	The customer's ID in the system
Customer Email	The customer's email address
Customer Information	Combined customer details (name, email, phone) for searching
Connection	The connection (CRM instance) associated with the customer
Order ID	The unique order identifier
Order Offer ID	The unique identifier for a specific offer within an order
Days To Cancel	Number of days between subscription creation and cancellation
Subscription Billing Status	Current billing status of the subscription
Is Blacklist	Whether the customer is on the blacklist
Is Gift	Whether the order was marked as a gift
Offer	The offer associated with the subscription
Offer Name	Display name of the offer
Offer Code	The unique offer code
Primary Offer Category	Primary category assigned to the offer
Secondary Offer Category	Secondary category assigned to the offer
Campaign	The campaign associated with the order
Primary Campaign Category	Primary category assigned to the campaign
Secondary Campaign Category	Secondary category assigned to the campaign
Charge Frequency	How often the subscription is billed
Is Prepaid Offer	Whether the offer is a prepaid subscription
Discount Code	Discount or coupon code applied to the order
Discount Name	Display name of the applied discount
Merchant	The merchant account used for processing
First Renewal Merchant	The merchant used for the first renewal charge
Merchant Group	The merchant group the merchant belongs to
Primary Merchant Category	Primary category assigned to the merchant
Secondary Merchant Category	Secondary category assigned to the merchant
Card Bin Number	First six digits of the card number identifying the issuing bank
Card Type	Card brand (e.g., Visa, Mastercard, Amex)
Card Issuer	The bank or institution that issued the card
Card Category	Category of the card (e.g., Consumer, Business)
Card Country	Country where the card was issued
Is Prepaid Card	Whether the card is a prepaid card
Ship Country	Shipping destination country
Ship State	Shipping destination state or province

Key Business Insights

1. Quick Health Assessment

Compare Average Renewal Cycle across time periods:

Increasing → Retention is improving; your product and retention efforts are working
Decreasing → Retention is declining; investigate recent changes to product, pricing, or customer mix
Stable → Baseline established; use this as a benchmark for measuring initiative impact

2. Churn Timing

Compare Average Churn Cycle to Average Renewal Cycle:

If the churn cycle is much lower than the renewal cycle, most churners leave early (and those who stay become loyal)
If they're close together, churn is distributed more evenly across the lifecycle

3. Retention Rate Distribution

The Overall Retention Rate snapshot shows your retention curve shape at a glance:

R1: 65%, R2: 55%, R3: 50%, R4: 47%, R5: 45%, R6: 44% → Classic curve with steep early drop that flattens
R1: 65%, R2: 55%, R3: 45%, R4: 35%, R5: 25%, R6: 15% → Linear decline — systematic retention issue

4. Decline vs. Cancel Pattern

Compare the Overall Decline Rate and Overall Cancel Rate snapshots:

Decline-heavy → Payment infrastructure problem; invest in dunning and card updating
Cancel-heavy → Product/value problem; invest in engagement and retention offers

Optimization Strategies

Increase Average Renewal Cycle

Focus retention resources at the cycle with the steepest drop in the Retention Rate snapshot
Implement pre-renewal engagement campaigns targeting subscribers approaching high-churn cycles
Test loyalty incentives at critical lifecycle moments

Reduce Early Churn

Improve post-purchase onboarding and communication
Set clear expectations about billing and product delivery
Offer first-renewal incentives for high-risk segments

Address Payment Failures

Monitor the Decline Rate snapshot for increasing trends at later cycles
Implement automatic card updater services
Optimize dunning schedule timing and retry strategies

Pro Tips

Executive Reporting: This report is ideal for dashboards and executive summaries — the snapshot format gives leadership a quick retention picture without overwhelming detail
Trend Tracking: Run this report monthly with the same cohort definitions to track whether your retention metrics are improving over time
Deep-Dive Trigger: Use this snapshot to identify which cycles need attention, then switch to the 6 Cycle Retention Report to drill into the specific causes at those cycles

Frequently Asked Questions

Q: What does the snapshot rate string mean?

A: Each snapshot metric shows rates for cycles R1 through R6 in a condensed format. For example, an Overall Retention Rate snapshot might display rates like "65 | 55 | 50 | 47 | 45 | 44" representing the percentage of subscribers remaining active at each of the first six renewal points.

Q: Why does this report only show 6 cycles in the snapshots?

A: The snapshot is designed for quick reference, and the first 6 cycles capture the most critical retention dynamics. For long-term retention data beyond R6, use the 36 Cycle Retention Report.

Q: How does this differ from the 6 Cycle Retention and 36 Cycle Retention reports?

A: The 6 Cycle Retention Report gives full per-cycle detail (available, pending, cancelled, dunning, failed, skip, success) for R1–R6. The 36 Cycle Retention Report gives success rates across 36 cycles. This Snapshot Report combines high-level summary metrics (average cycles, churn metrics) with condensed per-cycle rate distributions for a quick overall assessment.