# Zuora: Account Overview
## Description
* Each record represents an account enriched with metrics about their associated transactions.
## Supported Data Sources
* 
Zuora
## Columns
| Type | Name | Description |
| -------- | ------------------------------------------------- | ----------------------------------------------------------------------------------------------- |
| STRING | account\_id | Primary key for the account. |
| DATETIME | account\_created\_at | Creation date for the account. |
| STRING | account\_name | Account name as displayed in Zuora. |
| STRING | account\_number | Unique account number assigned to the account. |
| DECIMAL | account\_credit\_balance | Total credit balance for the account. |
| DECIMAL | account\_zuora\_calculated\_mrr | The amount of tabulated MRR as calculated by Zuora internally. |
| STRING | account\_status | Status of the account in the system. |
| BOOLEAN | is\_auto\_pay | Indicates if future payments are automatically collected when they're due during a Payment Run. |
| STRING | account\_country | The country of the contact's address associated with the account. |
| STRING | account\_city | The city of the contact's address associated with the account. |
| STRING | account\_email | The business email address of the contact associated with the account. |
| STRING | account\_first\_name | The first name of the contact associated with the account. |
| STRING | account\_last\_name | The last name of the contact associated with the account. |
| STRING | account\_postal\_code | The postal code of the contact's address associated with the account. |
| STRING | account\_state | The state of the contact's address associated with the account. |
| INTEGER | account\_active\_months | The number of months the account has been active, rounded to days. |
| DATETIME | first\_charge\_processed\_at | Time at which the first charge on the account is processed. |
| BOOLEAN | is\_currently\_subscribed | Does the account have a current active subscription associated with it? |
| BOOLEAN | is\_new\_customer | Was this account created in the past 30 days? |
| INTEGER | invoice\_item\_count | All invoice items ever associated with this account. |
| INTEGER | invoice\_count | All invoices ever associated with this account.s |
| INTEGER | active\_subscription\_count | Subscriptions currently active in this account. |
| INTEGER | total\_subscription\_count | All subscriptions ever created with this account. |
| INTEGER | total\_invoice\_amount | Total amount of all invoices associated with this account. |
| INTEGER | total\_invoice\_amount\_home\_currency | Total amount of all invoices in the home currency associated with this account. |
| INTEGER | total\_taxes | Total taxes associated with this account. |
| INTEGER | total\_discounts | Total discounts associated with this account. |
| INTEGER | total\_amount\_paid | Total amount of invoices paid associated with this account. |
| INTEGER | total\_amount\_not\_paid | Total amount of invoices unpaid associated with this account. |
| INTEGER | total\_amount\_past\_due | Total amount of past due invoices associated with this account. |
| INTEGER | total\_refunds | Total amount of refunds associated with this account. |
| INTEGER | total\_average\_invoice\_value | Total average value of the invoice associated with this account. |
| INTEGER | total\_units\_per\_invoice | Total units per invoice associated with this account. |
| INTEGER | monthly\_average\_subscription\_count | Average number of subscriptions per month for this account. |
| INTEGER | monthly\_average\_invoice\_amount | Average invoice amount per month for this account. |
| INTEGER | monthly\_average\_invoice\_amount\_home\_currency | Average invoice amount in the home currency per month for this account. |
| INTEGER | monthly\_average\_taxes | Average taxes per month for this account. |
| INTEGER | monthly\_average\_discounts | Average discounts per month for this account. |
| INTEGER | monthly\_average\_amount\_paid | Average paid amount per month for this account. |
| INTEGER | monthly\_average\_amount\_not\_paid | Average unpaid amount per month for this account. |
| INTEGER | monthly\_average\_amount\_past\_due | Average past due amount per month for this account. |
| INTEGER | monthly\_average\_refunds | Average refunds per month for this account. |
---
# 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/zuora-account-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.