# 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 | --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/stripe-daily-overview.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.