# Zuora: Monthly Recurring Revenue

## Description

* Each record is an account and a month in that account, with details about its monthly recurring and non-recurring revenue in these time periods.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/zuora/resources/zuora.svg" alt="" data-size="line"> Zuora

## Columns

| Type    | Name                                | Description                                                                                                                                       |
| ------- | ----------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------- |
| STRING  | account\_monthly\_id                | The unique identifier for the account id and month.                                                                                               |
| STRING  | account\_id                         | Unique identifier of the account.                                                                                                                 |
| DATE    | account\_month                      | Month of the account where MRR is being generated.                                                                                                |
| DECIMAL | gross\_current\_month\_mrr          | Total recurring charges in the current month for the account, resulting in gross monthly recurring revenue.                                       |
| DECIMAL | discount\_current\_month\_mrr       | Total recurring discounts in the current month for the account, resulting in discount monthly recurring revenue.                                  |
| DECIMAL | net\_current\_month\_mrr            | The difference between gross monthly recurring revenue and net monthly recurring revenue in the current month.                                    |
| DECIMAL | gross\_current\_month\_non\_mrr     | Total non-recurring charges in the current month for the account, resulting in gross monthly non-recurring revenue.                               |
| DECIMAL | discount\_current\_month\_non\_mrr  | Total non-recurring discounts in the current month for the account, resulting in discount monthly non-recurring revenue.                          |
| DECIMAL | net\_current\_month\_non\_mrr       | The difference between gross monthly non-recurring revenue and net monthly non-recurring revenue in that month.                                   |
| DECIMAL | mrr\_expected\_current\_month       | Expected monthly recurring revenue based on the rate plan charges for the account.                                                                |
| DECIMAL | mrr\_expected\_previous\_month      | Expected previous month's monthly recurring revenue based on the rate plan charges for the account.                                               |
| DECIMAL | gross\_previous\_month\_mrr         | Total recurring charges in the previous month for the account, resulting in gross monthly recurring revenue.                                      |
| DECIMAL | gross\_previous\_month\_non\_mrr    | Total non-recurring charges in the previous month for the account, resulting in gross monthly non-recurring revenue.                              |
| DECIMAL | discount\_previous\_month\_mrr      | Total recurring discounts in the previous month for the account, resulting in discount monthly recurring revenue.                                 |
| DECIMAL | discount\_previous\_month\_non\_mrr | Total non-recurring discounts in the previous month for the account, resulting in discount monthly non-recurring revenue.                         |
| DECIMAL | net\_previous\_month\_mrr           | The difference between gross monthly recurring revenue and net monthly recurring revenue in the previous month.                                   |
| DECIMAL | net\_previous\_month\_non\_mrr      | The difference between gross monthly non-recurring revenue and net monthly non-recurring revenue in the previous month.                           |
| INTEGER | account\_month\_number              | The number of the month of the account, 1 being the first month the account receives revenue and the number increases with each subsequent month. |
| STRING  | net\_mrr\_type                      | The net monthly recurring revenue type, defined by best-known MRR type terminology.                                                               |


---

# 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-monthly-recurring-revenue.md?ask=<question>
```

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.