TD: Zuora Revenue Waterfall
Goal of this Page:
- Help you understand how to navigate the Zuora Revenue Waterfall.
Waterfall Report
The waterfall report allows us to understand when revenue from a given transaction will be recognized over time. This will be timed differently for various products in our catalog and is defined by the contract’s particular schedule. The waterfall report is a powerful tool to see how much revenue will be recognized in a given month as well as the amount previously recognized for a specific transaction.
Since the nature of a given contract may change over time, the waterfall report has the ability to look back at an historical period and view the deals as they stood then. In v1.0, we are taking live data from Zuora Revenue, which will cause a diversion from the waterfall report in the UI because it is a snapshotted version taken at month-end-close, while the data warehouse is live and will reflect changes made to contracts after month-end-close. For example, the UI would maintain a record of contracts that are deleted while the warehouse will not. In the future there will be a snapshotted version of the report in the warehouse as well so we can tie out to the source report.
Release Train Cadence:
- Coming Soon
Maintenance Schedule:
- As needed, Scheduled Maintenance will be performed every two weeks on Friday, from 9am to 11am EST.
Quick Links
Getting Started
To get started we want to make sure you understand:
- What KPIs/PIs are supported using this report
- Key terms that will explain how we account for the metrics
- The data source behind the report
- To explore further, you can create visual and analysis yourself in Sisense. A great way to start is using the Sisense Discovery tool. Want to get started in Sisense head here.
- To go even deeper, you can explore data in snowflake. The benefit of exploring in Snowflake is you can join to additional information (i.e. other data sources). Additional information on exploring in Snowflake can be found here.
Key Terms, Metrics, KPIs/PIs, and Key Field and Business Logic
Key Terms
Dimensions:- Coming soon
Key Metrics, KPIs, and PIs
Facts:- Coming Soon
Key Fields and Business Logic
- as_of_period_id: key filter to show the waterfall report as it was for a past time period
- revenue_contract_line_attribute_16: indicates if a line has been adjusted through a manual true-up
- revenue_contract_schedule: The performance obligations are recognized over time based on the rules for the performance obligation type. These rules are expressed as a schedule, which states when and what percent of a contract obligation can be recognized. This is the basis for the waterfall report
Understanding the Data Sources and Data Models
Zuora Billing is our enterprise solution for tracking subscriptions. It is the basis for many of our important financial metrics, like ARR. Zuora Revenue is a tool used by the Corporate Finance team to recognize our subscription revenue based on both GAAP and non-GAAP rules.
Data Lineage
Data is sourced from Zuora Revenue. The dbt solution generates a dimensional model from revenue contract lines, schedules, as well as other pertinent details about a given contract to generate a report containing all deals being recognized in a given period. It will allow users to view these deals at various points in time (`as_of_period_id`) since a given deal may be modified between its start and end dates.Example Queries
Revenue recognized from October 2021, as it was known in October 2021
SELECT
SUM("OCT-21") AS october_revenue
FROM prod.restricted_safe_common_mart_finance.mart_waterfall
WHERE as_of_period_id = 20211001
Additional Resources
Trusted Data Solution
ARR models use the zuora_revenue tags for Trusted Data tests and their results. This can be seen most easily using the Trusted Data Dashboard
See overview at Trusted Data Framework
dbt guide examples for details and examples on implementing further tests
EDM Enterprise Dimensional Model Validations
The [(WIP) Enterprise Dimensional Model Validation Dashboard](https://app.periscopedata.com/app/gitlab/760445/WIP:-Enterprise-Dimensional-Model-Validation-Dashboard) reports on latest Enterprise Dimensional model test and runs.RAW Source Data Pipeline validations
[Data Pipeline Health Validations](https://app.periscopedata.com/app/gitlab/715938/Data-Pipeline-Health-Dashboard)Data Security Classification
Coming Soon
ORANGE
-
Description: Customer and Personal data at the row or record level.
-
Objects:
YELLOW
-
Description: Denomas Financial data, which includes aggregations or totals.
-
Objects:
Solution Ownership
* Source System Owner: * Salesforce: `@jbrennan1` * Zuora: `@andrew_murray` * Source System Subject Matter Expert: * Salesforce: `@jbrennan1` * Zuora: `@andrew_murray` * Data Team Subject Matter Expert: `@michellecooper`17188382)
