Home Datasets ds_cust_churn_2024q3

Customer Churn Analysis Q3 2024

Active v2.4.1

Comprehensive dataset tracking subscription lifecycles, usage metrics, support tickets, and behavioral signals to predict churn probability and identify at-risk segments.

PostgreSQL 1.2M Rows Analytics Private
Data Preview
Schema & Fields
Metadata & Lineage
Activity Log
customer_id region plan_type usage_score support_tickets last_login churn_prob
cust_8842NA-EastEnterprise87.412024-09-120.08
cust_1103EU-WestPro42.152024-08-030.89
cust_5590AP-SouthBasic65.822024-09-100.34
cust_3321NA-WestEnterprise91.202024-09-140.04
cust_7712EU-CentralPro38.572024-07-280.94
Showing 5 of 1,240,852 records

Data Structure

customer_id
Unique identifier for each account
VARCHAR(32)
region
Geographic market segment
ENUM
plan_type
Current subscription tier
VARCHAR(20)
usage_score
Normalized engagement metric (0-100)
DECIMAL(5,2)
support_tickets
Count of open/closed tickets in 90d window
INT
last_login
Timestamp of most recent platform access
TIMESTAMP
churn_prob
Model-derived probability of cancellation
FLOAT

Dataset Information

This dataset is aggregated daily via an Apache Airflow pipeline pulling from Salesforce, Mixpanel, and our internal support DB. It is versioned using DVC and undergoes automated quality checks before publication to the analytics layer.

CreatedAug 15, 2024
Last Refreshed2 hours ago
Data SourceMulti-Source Pipeline
Retention24 Months
Owner TeamData Science
SLADaily 08:00 UTC

Recent Activity

Pipeline Run #8842✓ Success
Schema Validation✓ Passed
Query by @j.rodriguez14:32 UTC
Export CSV✓ Downloaded
Pipeline Run #8841✓ Success

Quick Stats

Dataset IDds_cust_churn_2024q3
Total Size482 MB
FormatParquet / CSV
LicenseInternal Only
API Endpointv2/datasets/:id

API Access

Fetch this dataset programmatically:

GET /api/v2/datasets/ds_cust_churn_2024q3
Authorization: Bearer <token>

Related Datasets

customer_segments_2024

RFM clustering & cohort tags

support_interactions

Ticket resolution & sentiment

billing_cycles_q3

Invoice & payment history
"}