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 |
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 |