Stripe: Daily Overview

Description

• Each record represents, per account per day, a summary of daily totals and rolling totals by transaction type (balances, payments, refunds, payouts, and other transactions).

Supported Data Sources

• Stripe

Columns

Type	Name	Description
STRING	account_id	The ID of the account tied to the balance.
STRING	account_daily_id
DATE	date_day	Day of record, taken from the date of each balance transaction.
DATE	date_week
DATE	date_month
DATE	date_year
INTEGER	date_index
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.
DECIMAL	total_daily_sales_amount	Total amount for when transaction type is a charge or payment.
DECIMAL	total_daily_refunds_amount	Total amount for when transaction type is payment_refund or refund.
DECIMAL	total_daily_adjustments_amount	Total amount for when transaction type is adjustment
DECIMAL	total_daily_other_transactions_amount	Total amount for when transaction type is not of the prior types.
DECIMAL	total_daily_gross_transaction_amount	Total amount for when transaction type is not payout or transfer
DECIMAL	total_daily_net_transactions_amount	Total net for when transaction type is not payout or transfer.
DECIMAL	total_daily_payout_fee_amount	Total fee for when transaction type is payout or transfer.
DECIMAL	total_daily_gross_payout_amount	Total amount for when transaction type is payout or transfer.
DECIMAL	daily_net_activity_amount	Net amount minus fees from payouts and transfers.
DECIMAL	daily_end_balance_amount	daily_net_activity_amount + total_daily_gross_payout_amount
DECIMAL	total_daily_sales_count	Count of total balance transactions where type is payment or charge.
DECIMAL	total_daily_payouts_count	Count of total balance transactions where type is payout.
DECIMAL	total_daily_adjustments_count	Count of total balance transactions where type is adjustment.
DECIMAL	total_daily_failed_charge_count	Count of incomplete charges.
DECIMAL	total_daily_failed_charge_amount	Total amount of incomplete charges.
DECIMAL	rolling_total_daily_sales_amount	Rolling total of total_daily_sales_amount
DECIMAL	rolling_total_daily_refunds_amount	Rolling total of total_daily_refunds_amount
DECIMAL	rolling_total_daily_adjustments_amount	Rolling total of total_daily_adjustments_amount
DECIMAL	rolling_total_daily_other_transactions_amount	Rolling total of total_daily_other_transactions_amount
DECIMAL	rolling_total_daily_gross_transaction_amount	Rolling total of total_daily_gross_transaction_amount
DECIMAL	rolling_total_daily_net_transactions_amount	Rolling total of total_daily_net_transactions_amount
DECIMAL	rolling_total_daily_payout_fee_amount	Rolling total of total_daily_payout_fee_amount
DECIMAL	rolling_total_daily_gross_payout_amount	Rolling total of total_daily_gross_payout_amount
DECIMAL	rolling_daily_net_activity_amount	Rolling total of daily_net_activity_amount
DECIMAL	rolling_daily_end_balance_amount	Rolling total of daily_end_balance_amount
DECIMAL	rolling_total_daily_sales_count	Rolling total of total_daily_sales_count
DECIMAL	rolling_total_daily_payouts_count	Rolling total of total_daily_payouts_count
DECIMAL	rolling_total_daily_adjustments_count	Rolling total of total_daily_adjustments_count
DECIMAL	rolling_total_daily_failed_charge_count	Rolling total of total_daily_failed_charge_count
DECIMAL	rolling_total_daily_failed_charge_amount	Rolling total of total_daily_failed_charge_amount