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 |
Comments
0 comments
Please sign in to leave a comment.