Recharge: Customer Daily Rollup

Description

• Each record provides totals and running totals for a customer's associated transaction for the specified day.

Supported Data Sources

• Recharge

Columns

Type	Name	Description
INTEGER	customer_id	The unique identifier of the customer.
DATETIME	date_day	Day the metrics were calculated.
DATE	date_week	Week the metrics were calculated.
DATE	date_month	Month the metrics were calculated.
DATE	date_year	Year the metrics were calculated.
INTEGER	no_of_orders	The number of orders for the customer on the given day.
INTEGER	recurring_orders	The number of subscriptions created for the customer on the given day.
INTEGER	one_time_orders	The number of one-time orders for the customer on the given day.
DECIMAL	total_charges	The total amount charges associated with the customer on the given day.
DECIMAL	charge_total_price_realized	Total price for successful orders by the customer on the given day.
DECIMAL	charge_total_discounts_realized	Total discounts for successful orders by the customer on the given day.
DECIMAL	charge_total_tax_realized	Total tax for successful orders by the customer on the given day.
DECIMAL	charge_total_refunds_realized	Total refunds for successful orders by the customer on the given day.
DECIMAL	calculated_order_total_discounts_realized	The charge_total_discounts_realized divided equally amongst all orders stemming from the same charge.
DECIMAL	calculated_order_total_tax_realized	The charge_total_tax_realized divided equally amongst all orders stemming from the same charge.
DECIMAL	calculated_order_total_price_realized	The charge_total_price_realized divided equally amongst all orders stemming from the same charge.
DECIMAL	calculated_order_total_refunds_realized	The charge_total_refunds_realized divided equally amongst all orders stemming from the same charge.
DECIMAL	order_line_item_total_realized	Order line item total for successful orders by the customer on the given day.
DECIMAL	order_item_quantity_realized	Total number of items successfully ordered by the customer on the given day.
DECIMAL	charge_recurring_net_amount_realized	The total net value of recurring charges, calculated as the total price minus total discounts.
DECIMAL	charge_one_time_net_amount_realized	The total net value of one-time charges, calculated as the total price minus total discounts.
DECIMAL	calculated_order_recurring_net_amount_realized	The charge_recurring_net_amount_realized divided equally amongst all orders stemming from the same charge.
DECIMAL	calculated_order_one_time_net_amount_realized	The charge_one_time_net_amount_realized divided equally amongst all orders stemming from the same charge.
DECIMAL	charge_total_price_running_total	Running total of price for successful orders by the customer.
DECIMAL	charge_total_discounts_running_total	Running total of discounts for successful orders by the customer.
DECIMAL	charge_total_tax_running_total	Running total of tax for successful orders by the customer.
DECIMAL	charge_total_refunds_running_total	Running total of refunds for successful orders by the customer.
DECIMAL	calculated_order_total_discounts_running_total	The charge_total_discounts_running_total divided equally amongst all orders stemming from the same charge.
DECIMAL	calculated_order_total_tax_running_total	The charge_total_tax_running_total divided equally amongst all orders stemming from the same charge.
DECIMAL	calculated_order_total_price_running_total	The charge_total_price_running_total divided equally amongst all orders stemming from the same charge.
DECIMAL	calculated_order_total_refunds_running_total	The charge_total_refunds_running_total divided equally amongst all orders stemming from the same charge.
DECIMAL	order_line_item_total_running_total	Order line item running total for successful orders by the customer.
DECIMAL	order_item_quantity_running_total	Running total of items successfully ordered by the customer.
DECIMAL	charge_recurring_net_amount_running_total	Running total of the net value of recurring charges.
DECIMAL	charge_one_time_net_amount_running_total	Running total of the net value of one-time charges.
DECIMAL	calculated_order_recurring_net_amount_running_total	Running total of the net value of the calculated recurring order amount.
DECIMAL	calculated_order_one_time_net_amount_running_total	Running total of the net value of the calculated one-time order amount.
DECIMAL	active_months_to_date	The number of months the customer has been active up to the given day.