Subscriptions — churned - export

Track and export data on churned Recurly subscriptions with ease.

Overview

Required plan

This feature or setting is available to all customers on any Recurly subscription plan.

Definition

In the Recurly platform, a "Churned Subscription" refers to subscriptions that have churned and are no longer active. This information is vital in understanding subscription lifecycles and trends in user retention.

Filters

Time Range Filter

To get specific data, use the Time Range Filter which exports all the subscriptions that expired during a selected time frame. This filter uses the "expired_at" column in the export. Note that a subscription does not churn until it has expired, and the "canceled_at" and "expired_at" dates are not the same.

Exports table

Download Button Download our complete export schema

To help you identify and organize information effectively, the export provides a structured table that contains the following columns:

Column Name	Example	Description
uuid	5eg5bcc7ef8211e0a908005056b00005	Unique identifier for a specific subscription plan.
account_code	123456789, test@example.com	Account associated with a given subscription UUID.
email	test@example.com	Email address associated with a given subscription UUID.
plan_code	basic	Plan that the customer is subscribed to with this UUID.
state	pending, modified, converted, active, canceled, expired	Current state of the subscription. Modified and converted are depreciated states
auto_renew	TRUE	Defaults to TRUE for auto-renewing subscriptions. FALSE if subscription set to expire at end of current term.
currency	USD	Identifies the currency being charged with this subscription.
quantity	1	Identifies the quantity of the subscription purchase.
unit_amount	99	Identifies the base price of 1 quantity of the subscription.
add_on_amount	15	Identifies any additional charges to the subscription base fee from add_ons.
total_recurring_amount	114	Identifies total recurring charges - unit_amount x quantity + add_on_amount.
current_period_started_at	2009-12-04 00:46:59 PST	Date and time that the current billing period started. *
current_period_ends_at	2009-12-04 00:46:59 PST	Date and time that the current billing period ends at.
trial_started_at	2010-03-24 17:18:46 PDT	Date and time that a trial period began on the subscription.
trial_ends_at	2010-04-23 17:18:46 PDT	Date and time that a trial period ends on the subscription.
total_billing_cycles	1	This is the total number billing periods in the subscription term.
remaining_billing_cycles	0	Number of remaining billing periods in the subscription’s current term. Will always be 0 if subscription term has 1 billing period
renewal_billing_cycles	1	Number of billing periods in the subscription’s next term. Will default to plan’s total_billing_cycles unless customized. Nil if auto_renew = false
current_term_started_at	2018-09-02 15:53:18 UTC	Start date of the subscription’s current term
current_term_ends_at	2018-10-02 15:53:18 UTC	End date of the subscription’s current term.
activated_at	2010-03-24 17:18:46 PDT	Date and time the subscription was added to the account.
modified_at	2010-03-24 17:18:44 PDT	Date and time the subscription was last updated.
canceled_at	2010-03-28 22:54:46 PDT	Date and time the subscription was canceled.
expires_at	2010-04-23 22:51:53 PDT	Date and time the subscription was terminated. Used for date range filter
maintenance_url	app.recurly.com/account/sdasdasdad213525asdad	Link to the customer's hosted account maintenance URL.
net_terms	on-receipt	Identifies the net_terms agreement associated with the subscription.
po_number	213123	For manual invoicing, this identifies the PO number associated with the subscription.
collection_method	automatic/manual	Identifies whether the subscription fees are collected via manual or automatic invoicing
plan_name	Basic Plan	The plan name of the subscription at the time the subscription expired
expiration_reason	Canceled, Non-payment, Fixed billing cycles, Tax Location Invalid, Nonpayment_gift, Nonpayment_trial	The reason that the subscription expired. Note that nonpayment_Trial only relates to cardless subscriptions trials
ship_address_id	2019760433389770000	The unique ID assigned to the shipping address
ship_address_nickname	Julie	The nickname given to the shipping address
ship_address_firstname	Julie	The first name associated with the shipping address
ship_address_lastname	Smith	The last name associated with the shipping address
ship_address_company_name	Big Company	The company name associated with the shipping address
ship_address_street1	321 Michigan Street	The first line of the street address for the shipping address
ship_address_street2	Apt 1	The second line of the street address for the shipping address
ship_address_city	West Bloomfield	The city for the shipping address
ship_address_state	MI	The state for the shipping address
ship_address_zip	48322	The zip or postal code for the shipping address
ship_address_country	US	The country for the shipping address
ship_address_vat	123456789	The VAT number associated with the shipping address
ship_address_email	jsmith@example.com	The email address associated with the shipping address
ship_address_phone	248-555-1212	The phone number associated with the shipping address
started_with_gift	TRUE, FALSE	`TRUE` if the subscription was started with a gift card, whether or not billing information was collected.
converted_at	2016-09-02 15:53:18 UTC	Date of the first successful transaction for the subscription. This field is only used for gifts cards and cardless free trial conversions. In other words, it will only have a value if started_with_gift is `TRUE` OR no_billing_info_reason is "plan_free"trial." Converted_at compared to the subscription's activated_at will give you the time to conversion.
no_billing_info_reason	plan_free_trial	Identifies the reason why a subscription did not have billing information at time of renewal/activation.
shipping_amount_in_cents	500	The amount of the shipping fee on the subscription, in cents.
shipping_method_code	usps_overnight	The code of the Shipping Method from configuration.
pricing_model	ramp	Pricing model of the subscription. Will be either fixed or ramp.
current_ramp_id	pz82514rbd3s	The id of the current ramp interval.
subscription_api_id	e28zov4fw0v2	Subscription API ID

Version changelog

Version 4 - 2/5/2025

Addition of subscription_api_id.

Version 3 - 12/7/2021

Column added for pricing_model
Column added for current_ramp_id

Version 2 - 5/2/2019

Column added for Shipping Cost
Column added for Shipping Method

Updated 9 days ago