Stripe: Subscription Details

Description

• Each record represents a subscription, enriched with customer details and payment aggregations.

Supported Data Sources

• Stripe

Columns

Type	Name	Description
STRING	subscription_id	Unique identifier for the subscription object.
STRING	customer_id	ID of the customer who owns the subscription.
STRING	customer_description	Description of the customer who owns the subscription.
STRING	customer_email	Email of the customer who owns the subscription.
STRING	status	Possible values are incomplete, incomplete_expired, trialing, active, past_due, canceled, or unpaid.
DATETIME	start_date_at	Date when the subscription was first created. The date might differ from the created date due to backdating.
DATETIME	ended_at	If the subscription has ended, the date the subscription ended.
STRING	billing	How the description is billed.
DATETIME	billing_cycle_anchor	Determines the date of the first full invoice, and, for plans with month or year intervals, the day of the month for subsequent invoices.
DATETIME	canceled_at	If the subscription has been canceled, the date of that cancellation. If the subscription was canceled with cancel_at_period_end, canceled_at will still reflect the date of the initial cancellation request, not the end of the subscription period when the subscription is automatically moved to a canceled state.
DATETIME	created_at	Time at which the subscription object was created.
DATETIME	current_period_start	Start of the current period that the subscription has been invoiced for.
DATETIME	current_period_end	End of the current period that the subscription has been invoiced for. At the end of this period, a new invoice will be created.
INTEGER	days_until_due	Number of days a customer has to pay invoices generated by this subscription. This value will be null for subscriptions where collection_method=charge_automatically.
BOOLEAN	is_cancel_at_period_end	If the subscription has been canceled with the at_period_end flag set to true, cancel_at_period_end on the subscription will be true. You can use this attribute to determine whether a subscription that has a status of active is scheduled to be canceled at the end of the current period.
DATETIME	cancel_at	A date in the future at which the subscription will automatically get canceled
INTEGER	number_invoices_generated	Number of invoices that have been generated for this subscription.
INTEGER	total_amount_billed	The total amount that has been billed to the customer for this subscription.
INTEGER	total_amount_paid	The total amount paid by the customer for this subscription.
INTEGER	total_amount_remaining	Any outstanding balance for invoices related to this subscription.
DATETIME	most_recent_invoice_created_at	The timestamp of the most recent invoice for this subscription created.
DECIMAL	average_invoice_amount	The average amount of invoices generated for this subscription
DECIMAL	average_line_item_amount	The average sum of the line items for invoices generated for this subscription
DECIMAL	avg_num_line_items	The average number of line items for invoices generated for this subscription
STRING	source_relation	The source where this data was pulled from. If you are making use of the union_schemas variable, this will be the source schema. If you are making use of the union_databases variable, this will be the source database. If you are not unioning together multiple sources, this will be an empty string.