What data is in the Subscriptions - Churned export?

This export identifies subscriptions that have churned and are no longer active.

 

Time Range Filter

Uses the "expired_at" column. Exports subscriptions that expired during the selected time range.

Please note that the "canceled_at" and "expired_at" dates are not the same. A subscription does not churn until the subscription has expired.

 

Export Contents

Column Name Example
uuid 5eg5bcc7ef8211e0a908005056b00005
account_code 123456789, test@example.com
email test@example.com
plan_code basic
state pending, modified, converted, active, canceled, expired
auto_renew TRUE
currency USD
quantity 1
unit_amount 99
add_on_amount 15
total_recurring_amount 114
current_period_started_at 2009-12-04 00:46:59 PST
current_period_ends_at 2009-12-04 00:46:59 PST
trial_started_at 2010-03-24 17:18:46 PDT
trial_ends_at 2010-03-24 17:18:46 PDT
total_billing_cycles 1
remaining_billing_cycles 0
renewal_billing_cycles 1
current_term_started_at 2018-09-02 15:53:18 UTC
current_term_ends_at 2018-10-02 15:53:18 UTC
activated_at 2018-10-02 15:53:18 UTC
modified_at 2010-03-24 17:18:44 PDT
canceled_at 2010-03-28 22:54:46 PDT
expires_at 2010-04-23 22:51:53 PDT
maintenance_url app.recurly.com/account/sdasdasdad213525asdad
net_terms on-receipt
po_number 213123
collection_method automatic/manual
plan_name Basic Plan
expiration_reason Canceled, Non-payment, Fixed billing cycles, Tax Location Invalid, Nonpayment_gift, Nonpayment_trial
ship_address_id 2019760433389770000
ship_address_nickname Julie
ship_address_firstname Julie
ship_address_lastname Smith
ship_address_company_name Big Company
ship_address_street1 321 Michigan Street
ship_address_street2 Apt 1
ship_address_city West Bloomfield
ship_address_state MI
ship_address_zip 48322
ship_address_country US
ship_address_vat 123456789
ship_address_email jsmith@example.com
ship_address_phone 248-555-1212
started_with_gift TRUE, FALSE
converted_at 2016-09-02 15:53:18 UTC
no_billing_info_reason plan_free_trial
created_at 2016-10-02 15:00:00 UTC