Stripe: Customer Overview

Description

• Each record represents a customer, enriched with metrics about their associated transactions.

Supported Data Sources

• Stripe

Columns

Type	Name	Description
STRING	customer_id	Unique identifier for each record from the Stripe customer object.
STRING	customer_description	An arbitrary string attached to the object. Often useful for displaying to users.
DATETIME	customer_created_at	Timestamp of when the customer entry was created.
STRING	customer_currency	Currency used by the customer.
INTEGER	account_balance
STRING	customer_address_city
STRING	customer_address_country
STRING	customer_address_line_1
STRING	customer_address_line_2
STRING	customer_address_postal_code
STRING	customer_address_state
INTEGER	customer_balance
STRING	bank_account_id
STRING	default_card_id	ID of the default card used by the customer.
BOOLEAN	is_delinquent	When the customer’s latest invoice is billed by charging automatically, delinquent is true if the invoice’s latest charge is failed. When the customer’s latest invoice is billed by sending an invoice, delinquent is true if the invoice is not paid by its due date.
STRING	email	Email address associated with the customer.
STRING	customer_name
STRING	shipping_address_city	Attribute of the customer's shipping address.
STRING	shipping_address_country	Attribute of the customer's shipping address.
STRING	shipping_address_line_1	Attribute of the customer's shipping address.
STRING	shipping_address_line_2	Attribute of the customer's shipping address.
STRING	shipping_address_postal_code	Attribute of the customer's shipping address.
STRING	shipping_address_state	Attribute of the customer's shipping address.
STRING	shipping_name	Attribute of the customer's shipping address.
STRING	shipping_phone	Attribute of the customer's shipping address.
STRING	metadata_fivetran_account_id
DECIMAL	total_sales	Sum of all charges made to this customer.
DECIMAL	total_refunds	Sum of all refunds made to this customer.
DECIMAL	total_gross_transaction_amount	Gross amount of all transactions made with this customer.
DECIMAL	total_fees	Total fees charged on all transactions made with this customer.
DECIMAL	total_net_transaction_amount	Net amount of all transactions made with this customer. This is the gross amount excluding fees, refunds, and disputes.
INTEGER	total_sales_count	The total number of sales made to this customer.
INTEGER	total_refund_count	The total number of refunds made to this customer.
DECIMAL	sales_this_month	Sum of charges made to this customer this month.
DECIMAL	refunds_this_month	Sum of refunds made to this customer this month.
DECIMAL	gross_transaction_amount_this_month	Gross amount of transactions made with this customer this month.
DECIMAL	fees_this_month	Total fees charged on transactions made with this customer this month.
DECIMAL	net_transaction_amount_this_month	Net amount of transactions made with this customer this month.
INTEGER	sales_count_this_month	The number of sales made to this customer this month.
INTEGER	refund_count_this_month	The number of refunds made to this customer this month.
DATE	first_sale_date	Date of the first time this customer was charged.
DATE	most_recent_sale_date	Date of the most recent time this customer was charged.
INTEGER	total_failed_charge_count	The total number of incomplete charges this customer has had.
DECIMAL	total_failed_charge_amount	The total amount from incomplete charges this customer has had.
INTEGER	failed_charge_count_this_month	The number of incomplete charges this customer has had this month.
DECIMAL	failed_charge_amount_this_month	The amount from incomplete charges this customer has had this month.
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.