Subscriptions — History Export
View the history for each subscription. Every time a change (or multiple changes at the same time) is made to a subscription, a new version of that subscription is created. This enables you to track historic versions of subscriptions in order to track important movements in your subscriber's lifecycle, such as upgrades, downgrades, cancellations, trial conversions, etc.
The following changes will create a new version of the subscription:
- Plan changes
- Quantity changes
- Price changes (upgrade or downgrade)
- State changes including active, paused, canceled and expired states
- Trial ends
- Collection method changes
- Total billing cycles changes
The subscription history export only tracks changes after a subscription has been activated.
Please reach out to [email protected] if you'd like this export to be enabled for your site.
Version Change Log
Version 5 - 12/7/2021
- Column added for pricing_model
- Column added for current_ramp_id
Version 4
- Updated the following columns remove any concatenated: version_add_on_codes, version_add_on_types, version_add_on_unit_amounts
Version 3
- Added new column: version_add_on_tier_types
Version 2 - 1/9/2020
- Columns added for shipping method and shipping amount
Date Range Filters
Activated
This filter is useful for viewing past subscription versions of subscriptions activated/ reactivated in the specified time range. Uses the subscription_activated_at column.
Created
Returns all versions created in the specified time range. This filter is useful for viewing recent changes to all subscriptions. Uses the _version_created_at _column.
Export Contents
Export Contents
Column Name | Example | Description |
---|---|---|
subscription_uuid | 434f11do8b297982eb | Unique internal identifier for the subscription. Even if a subscription is modified, this identifier is maintained. |
version_uuid | 43509049eb30fb | Unique internal identifier for the version of a subscription_uuid. A new version is created when a change is made to a subscription. |
account_code | 123456789, [email protected] | Account associated with a given subscription_uuid. |
subscription_activated_at | 2018-03-24 17:18:46 PDT | Date and time the subscription became active (or reactivated) on an account. |
subscription_expires_at | 2018-09-24 17:18:46 PDT | Date and time the subscription was/will churn. This field is populated when a subscription cancels with the expected expiration date. |
subscription_state | active, canceled, paused, expired | State of the subscription at the time the version was active. |
version_started_at | 2018-03-20 03:22:25 EST | The date a change was made to the subscription and thus the new version was created. |
version_ended_at | 2018-07-20 03:22:25 EST | The date a version is no longer active because another change to the subscription is made and a newer version is created. |
version_state | inactive or active | Versions reflecting the current attributes of the subscription (i.e., are currently in use) are "active." All expired versions are "inactive". |
plan_code | bronze_1 | The plan that the subscription was actively on while that version was active. Codes are used internally only. |
plan_name | Bronze Plan # 1 | The name of the plan the subscriber was actively on while that version was active. |
subscription_currency | USD, GBP, CAD | The currency associated with that subscription at the time that version was active. |
version_plan_interval_unit | months, weeks, days, years | The interval type at which that subscription is billed while that version was active. |
version_plan_interval_length | any number | The length of the interval type at which the subscription is billed at while the version was active. |
version_collection_method | automatic, manual | Identifies whether the subscription fees are collected via manual or automatic invoicing. |
version_total_billing_cycles | 1 | The total number of bill cycles that the subscription will bill at the time the version was active. |
version_subscription_quantity | 1, 2 | Identifies the quantity of the subscription purchase at the time the version was active. |
version_subscription_unit_amount | 100 | Identifies the base price of 1 quantity of the subscription at the time the version was active. |
version_add_on_codes | add_on1, add_on1, add_on2 | A list of add-ons that were active on the subscription at the time the version was active. |
version_add_on_types | fixed, fixed, usage | Lists the type of add-on in corresponding order to the listed add_on_codes on the subscription at the time the version was active. |
version_add_on_unit_amounts | 10, 10, 5% | Lists the unit amount of the add-on in corresponding order to the listed add_on_codes and listed add_on_types. |
version_add_ons_total | 20 | Sums the add_on_unit_amounts on the subscription at the time the version was active. Does not include usage-based add-ons. |
version_total_recurring_amount | 120 | (version_unit_amount) * (version_subscription_quantity) + version_add_on_total |
version_in_trial | Y, N | Indicates whether or not the subscription was in trial while the version was active. |
version_auto_renew | Y, N | Indicates whether or not the subscription was set to auto renew while the version was active. |
version_renewal_billing_cycles | 1 | Identifies the number of billing cycles for renewals during the time the version was active. |
version_shipping_method_name | USPS Overnight | The shipping method name used at the time when the version was active. |
version_shipping_amount | 5 | Identifies the shipping price on the subscription at the time the version was active. |
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. |
Updated 19 days ago