Recurring Subscription Payment Analysis

This dataset provides a comprehensive view of recurring finance subscription payments, including customer details, payment history, churn indicators, and retention actions. It is ideal for analyzing payment patterns, identifying churn risk, and optimizing customer retention strategies in subscription-based financial services.

  • last updated 12 Jul 2025
  • by GoMask
The brief that made it

Churn risk modeling and prediction for subscription-based services

Sample rows

preview · 8 of 110 rows · all 20 columns
subscription_idstringsubscription_planstringplan_pricefloatis_activebooleancountrystringcustomer_idstringcustomer_emailstringbilling_frequencystringsubscription_start_datedatesubscription_end_datedatelast_payment_datedatenext_payment_due_datedatepayment_methodstringtotal_payments_madeintegertotal_amount_paidfloatfailed_payment_countintegerchurn_risk_scorefloatchurnedbooleanretention_action_takenbooleanretention_action_datedate
SUB001Basic15.99trueUnited StatesCUST1001alice.smith1@gmail.commonthly2022-11-04blank2024-05-042024-06-04credit_card19303.8110.18falseblankblank
SUB002Premium39.99trueCanadaCUST1002tom.jones2@yahoo.commonthly2023-02-15blank2024-05-152024-06-15paypal15599.8500.09falsefalseblank
SUB003Enterprise199.99trueChinaCUST1003li.wei3@outlook.comquarterly2021-09-01blank2024-03-012024-06-01bank_transfer112199.8900.13falseblankblank
SUB004Basic15.99falseUnited KingdomCUST1004emily.wilson4@gmail.commonthly2023-08-192024-04-192024-04-19blankcredit_card8127.9210.82truetrue2024-03-25
SUB005Premium39.99trueItalyCUST1005mario.rossi5@gmail.itmonthly2023-01-10blank2024-05-102024-06-10credit_card16639.8400.07falsefalseblank
SUB006Basic15.99trueFranceCUST1006sophie.martin6@orange.frmonthly2024-02-10blank2024-05-102024-06-10paypal463.9600.21falseblankblank
SUB007Enterprise199.99trueSingaporeCUST1007james.wang7@hotmail.comyearly2022-05-27blank2023-05-272024-05-27bank_transfer2399.9800.17falseblankblank
SUB008Basic15.99trueUnited Arab EmiratesCUST1008fatima.ahmed8@protonmail.commonthly2023-12-01blank2024-05-012024-06-01credit_card695.9420.36falsefalseblank

What the 110 rows show

from the 110-row sample

Enterprise (subscription plan) stands out: mean plan_price is 177.6, against 33.3 for the rest.

  • 77%is_active = true
  • 40.0median plan_price
  • 3billing frequencies
  • 4payment methods
  • 7median total_payments_made
  • 299.9median total_amount_paid
Mean plan_price by subscription_plan110 rows
010020046.7Premium45 rows17.5Basic38 rows177.6Enterprise27 rows
plan_price110 rows, in bands of 25
0255038423001201410125225plan_price →

Median 40.0, from 12.5 to 210.0.

country110 rows · top 10 of 33 values
  1. United States15
  2. France8
  3. China7
  4. United Kingdom7
  5. Mexico7
  6. Italy6
  7. Germany6
  8. Poland5
  9. Brazil5
  10. Singapore4
20 columns by typefrom the column list below
  • string 7
  • integer 2
  • float 3
  • date 5
  • boolean 3

Columns

20 columns in four groups
blueprint · 20 columns
columntypedescriptionexample
Text 7 columns
subscription_idstringUnique identifier for each subscription instance.uniqueSUB001
customer_idstringUnique identifier for the customer associated with the subscription.CUST1001
customer_emailstringEmail address of the customer.alice.smith1@gmail.com
subscription_planstringName or code of the subscription plan (e.g., Basic, Premium, Enterprise).3 plansBasic
billing_frequencystringFrequency of billing for the subscription (e.g., monthly, quarterly, yearly).monthly · quarterly · yearlymonthly
payment_methodstringPayment method used for the subscription (e.g., credit_card, paypal, bank_transfer).credit_card · paypal · bank_transfer · othercredit_card
countrystringCountry of the customer.optionalUnited States
Numbers 5 columns
plan_pricefloatRecurring price of the subscription plan per billing period.0 or more15.99
total_payments_madeintegerTotal number of successful recurring payments for this subscription.0 or more19
total_amount_paidfloatCumulative amount paid for this subscription.0 or more303.81
failed_payment_countintegerNumber of failed payment attempts for this subscription.0 or more1
churn_risk_scorefloatCalculated risk score (0-1) indicating likelihood of churn, where 1 is highest risk.0 to 1 · optional0.18
Dates and times 5 columns
subscription_start_datedateDate when the subscription started.2022-11-04
subscription_end_datedateDate when the subscription ended or is scheduled to end. Null if active.optional2024-04-19
last_payment_datedateDate of the most recent successful recurring payment.optional2024-05-04
next_payment_due_datedateDate when the next payment is scheduled.optional2024-06-04
retention_action_datedateDate when the most recent retention action was taken.optional2024-03-25
True or false 3 columns
is_activebooleanIndicates whether the subscription is currently active.true
churnedbooleanIndicates if the subscription has churned (true if ended and not renewed).false
retention_action_takenbooleanIndicates if a retention action (e.g., offer, outreach) was taken for this subscription.optionalfalse

Use it for

  • is active77%85 of 110 rowsmean plan price by su…46.7Premium17.5Basic177.6Enterp…

    A finance dashboard

    The is_active rate, plan_price by subscription_plan and a breakdown of country. Excel, Power BI or Tableau.

  • Why do the 27 Enterprise rows have a mean plan_price of 177.6?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable subscriptions with customer_id, customer_email and subscription_plan to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 20 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset110 rows20 columns
Yours1,000 rows20 columnscountry: UK only

blueprint · recurring-subscription-payment-analysis

Behind this dataset

Same schema. As many rows as you need.

These 110 rows came out of a blueprint — 20 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Each subscription must show payment status
  • Flag missed payments for follow-up
  • Track subscription tenure in months
  • Segment by subscription type
  • Calculate average revenue per user
Rows
Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
recurring-subscription-payment-analysis

More in Finance

Browse all
Also in FinanceCredit Default Early WarningFinance Expense Categorization DatasetBank Transaction Categorization SampleAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.