Recurly: Churn Analysis

Description

• Each record represents a subscription and their churn status and details.

Supported Data Sources

• Recurly

Columns

Type	Name	Description
STRING	subscription_id	Unique identifier for the subscription.
DATETIME	activated_at	When the subscription was activated.
STRING	account_id	The account this subscription belongs to.
STRING	account_state	Current state of the account.
DATETIME	canceled_at	When the subscription was canceled. Can take future dates.
DATETIME	current_period_ended_at	Current billing period ends at.
DATETIME	current_period_started_at	Current billing period started at.
DATETIME	expires_at	When the subscription has expired. Can take future dates.
STRING	expiration_reason	Reason for subscription expiration.
BOOLEAN	has_auto_renew	Whether the subscription renews at the end of its term. Default: true
STRING	plan_name	This name describes your plan and will appear on the Hosted Payment Page and the subscriber's invoice.
STRING	plan_state	The current state of the plan. Enum: "active", "inactive"
DATETIME	subscription_end_date	When the subscription actually ends, factors in cancellations earlier than the expected end date.
INTEGER	subscription_interval_days	Subscription interval by number of days, accounting for cancelled/expired periods.
INTEGER	subscription_period	The nth subscription defined by the time period set. Subscriptions start with month 0.
STRING	subscription_state	The current state of the subscription. Enum: "active", "canceled", "expired", "failed", "future", "paused"
DECIMAL	subtotal	Estimated total, before tax.
DECIMAL	unit_amount	Subscription unit price.
STRING	churn_reason	Reason for churn. null if subscription has no expiration date. Enum: "account closed", "canceled", "gift ended", "non-payment", "non-renewing", "trial ended"
STRING	churn_reason_type	Type of churn, null if subscription has no expiration date. Enum: "involuntary", "voluntary"