> For the complete documentation index, see [llms.txt](https://endash-guidance-docs.gitbook.io/cigro-data-templates/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/recharge-customer-daily-rollup.md). # 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. |