Overview

Required plan

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

Prerequisites

Please reach out to your Recurly account manager or [email protected] to have this feature activated in your account.

Definition

The “Subscriptions - History” section enables users to view the history of each subscription including all versions created following any change to a subscription. This includes monitoring various movements such as upgrades, downgrades, cancellations, trial conversions, and more, facilitating in-depth tracking of a subscriber's lifecycle. It is essential to note that the subscription history export only tracks the changes post the activation of a subscription.

Filters

Subscription Status Filter

All: Displays all subscription history status.
Trial: Displays all subscription history respective to trial status.
Open: Displays all subscription history respective to open status.
Canceled: Displays all subscription history respective to canceled status.
Expired: Displays all subscription history respective to expired status.

Date Range Filters

Activated

Use this filter to view past versions of activated or reactivated subscriptions within a specified timeframe, utilizing the subscription_activated_at column.

Created

View recent creations to all subscriptions within a chosen time range, referring to the version_created_at column.

Modified

View recent alterations to all subscriptions within a chosen time range, referring to a combination of version_state and version_created_at columns.

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
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
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.
tax_inclusive	false	Boolean (TRUE/FALSE) flag to indicate whether subscription is tax inclusive.

Version changelog

Version 6 - 1/28/2022

Added columns for tax_inclusive.

Version 5 - 12/7/2021

Added columns for pricing_model and current_ramp_id.

Version 4 - 5/12/2021

Removed concatenation in columns: version_add_on_codes, version_add_on_types, version_add_on_unit_amounts.

Version 3 - 3/25/2020

Introduced a new column: version_add_on_tier_types.

Version 2 - 1/9/2020

Incorporated columns for shipping method and amount.