# 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. | --- # 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/recharge-customer-details.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.