Recharge: Subscription Overview

Description

• Each record represents a subscription, enriched with customer and charge information.

Supported Data Sources

• Recharge

Columns

Type	Name	Description
INTEGER	subscription_id	The unique identifier of the subscription.
INTEGER	customer_id	The unique identifier of the customer.
INTEGER	address_id	The unique identifier of the address.
DATETIME	subscription_created_at	The date and time the subscription was created.
INTEGER	external_product_id_ecommerce	The ID of the product in your external ecommerce platform.
INTEGER	external_variant_id_ecommerce	The ID of the variant in your external ecommerce platform.
STRING	product_title	The name of the product in a shop's catalog.
STRING	variant_title	The name of the variant in a shop's catalog.
STRING	sku	The unique identifier of the item in fulfillment.
DECIMAL	price	The price of the item before discounts, taxes, or shipping have been applied.
INTEGER	quantity	The number of items in the subscription.
STRING	subscription_status	The status of the subscription. Possible values are ACTIVE, CANCELLED, EXPIRED.
INTEGER	charge_interval_frequency	The number of units (specified in order_interval_unit) between each charge.
STRING	order_interval_unit	The frequency with which a subscription should have the order created with (valid values are “day”, “week”, and “month”).
INTEGER	order_interval_frequency	The number of units (specified in order_interval_unit) between each order.
INTEGER	order_day_of_month	The set day of the month order is created. Default is that there isn’t a strict day of the month when the order is created.
INTEGER	order_day_of_week	The set day of the week order is created. Default is that there isn’t a strict day of the week order is created.
INTEGER	expire_after_specific_number_of_charges	Set number of charges until subscription expires.
DATETIME	subscription_updated_at	The date and time the subscription was last updated.
DATETIME	subscription_next_charge_scheduled_at	The date and time of the next scheduled charge for the subscription.
DATETIME	subscription_cancelled_at	The date and time the subscription was cancelled.
STRING	cancellation_reason	Reason provided for cancellation.
INTEGER	cancellation_reason_comments	Additional comments related to the cancellation of the subscription.
DATETIME	_fivetran_synced	Timestamp of when Fivetran synced a record.
BOOLEAN	is_most_recent_record	A flag indicating if the record is the most recent for the subscription.
INTEGER	count_successful_charges	The count of successful charges for the subscription.
INTEGER	count_queued_charges	The count of queued charges for the subscription.
INTEGER	charges_until_expiration	The number of charges until the subscription expires.
INTEGER	charge_interval_frequency_days	The number of days between charges for the subscription.