Recharge: Customer Details

Description

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

Supported Data Sources

• Recharge

Columns

Type	Name	Description
INTEGER	customer_id	The unique identifier of the customer.
STRING	customer_hash	The unique string identifier used in a customer portal link.
INTEGER	external_customer_id_ecommerce	The ID for the customer in your external ecommerce platform.
STRING	email	The email address of the customer.
STRING	first_name	The customer's first name.
STRING	last_name	The customer's last name.
DATETIME	customer_created_at	The date and time the customer was created.
DATETIME	customer_updated_at	The date and time the customer was last updated.
DATETIME	first_charge_processed_at	The date and time of the customer's first processed charge.
INTEGER	subscriptions_active_count	The number of active subscriptions associated with the customer.
INTEGER	subscriptions_total_count	The total number of subscriptions associated with the customer.
BOOLEAN	has_valid_payment_method	Boolean indicating if the payment value is valid.
BOOLEAN	has_payment_method_in_dunning	Boolean indicating if the customer has a credit card in dunning.
BOOLEAN	tax_exempt	Boolean indicating if the customer is tax exempt.
INTEGER	total_orders	The total number of orders associated with the customer.
DECIMAL	total_amount_ordered	The total amount associated with the customer.
DECIMAL	avg_order_amount	The average order amount for the customer.
DECIMAL	total_order_line_item_total	The total price of all line items in the customer's orders.
DECIMAL	avg_order_line_item_total	The average price of line items in the customer's orders.
DECIMAL	avg_item_quantity_per_order	The average quantity of items per order for the customer.
DECIMAL	total_amount_charged	The total amount charged to the customer.
DECIMAL	avg_amount_charged	The average amount charged to the customer.
INTEGER	charges_count	The total number of charges made to the customer.
DECIMAL	total_amount_taxed	The total amount of tax applied to the customer's orders.
DECIMAL	total_amount_discounted	The total amount of discounts applied to the customer's orders.
DECIMAL	total_refunds	The total refunds issued for the customer.
INTEGER	total_one_time_purchases	The total number of one-time purchases made by the customer.
DECIMAL	total_net_spend	The total net spend of the customer, calculated as the total amount charged minus total refunds.
INTEGER	calculated_subscriptions_active_count	The number of active subscriptions for the customer, calculated as the sum of subscriptions with status ACTIVE. Note - this value may differ from the Recharge-provided subscriptions_active_count. See DECISIONLOG for more information.
BOOLEAN	is_currently_subscribed	Indicates whether the customer currently has an active subscription.
BOOLEAN	is_new_customer	Indicates whether the customer has made their first charge in the past 30 days.
DECIMAL	active_months	The number of months since making their first charge.
DECIMAL	orders_monthly_average	The monthly average number of orders placed by the customer.
DECIMAL	amount_ordered_monthly_average	The monthly average amount ordered by the customer.
DECIMAL	one_time_purchases_monthly_average	The monthly average number of one-time purchases made by the customer.
DECIMAL	amount_charged_monthly_average	The monthly average amount charged to the customer.
DECIMAL	amount_discounted_monthly_average	The monthly average amount discounted for the customer.
DECIMAL	amount_taxed_monthly_average	The monthly average amount taxed for the customer.
DECIMAL	net_spend_monthly_average	The monthly average net spend of the customer, calculated as the total amount charged minus total refunds, divided by the number of months since the first charge.