This article contains the object model used to generate the ARR Momentum and other ARR metrics.  

ARR by Period

Overview

The ARR by Period table is a time series table, storing the Opening and Closing ARR values for each fiscal month, of each active order product, constituting a substantial dataset. This information serves as the foundation for generating various reports on ARR trends and other essential booking metrics.

The ARR by Period table operates on a strictly incremental basis. Once generated, the records within this table remain static and are not subject to updates. When a new change order is initiated and activated, fresh ARR by Period records are generated specifically for this newly activated order.

To answer this question, let's first take a look at all the 3 orders Chloe created:

Upon the activation of every order, Nue generates ARR by Period records for each product within the order on a monthly basis, aligning with the company's fiscal year.

Therefore, the following ARR by Period records are generated (A full description of the object can be found later in this article): 

The table above provided displays the Opening CMRR, Closing CMRR, Opening ARR, and Closing ARR generated by each order product on a monthly basis throughout the entire subscription term. This detailed breakdown enables us to analyze and manipulate the data in various ways, facilitating comprehensive aggregation and analysis.

For the above example, If I want to calcualted the Opening and Closing ARR contributed by Chloe for each fiscal quarter, I can simply find the ARR by Period records with Start Date on the following start dates of each quarter: 

• 01/01/2023
• 04/01/2023
• 07/01/2023
• 10/01/2023 

The records retrieved are as follows: 

Now we can do a simple aggregation, and get the following results: 

To accommodate the potential volume of data, we utilize the ARR by Period big object within Salesforce. Salesforce permits storage of up to 1 million records for each Big Object. If your organization maintains a significant number of subscriptions (for instance, if the average subscription term spans 12 months, surpassing 83,333 subscriptions would likely exceed the Big Object storage limit), please contact Salesforce to raise the limit of the storage capacity.

In addition to ARR by Period big object table, we also provide ARR by Period by Customer big object table.  The field definitions for these two big objects are identical, with the only distinction lying in their indexes.  The ARR by Period table is tailored for efficient querying by Start Date, while the ARR by Period by Customer table is optimized for queries based on Customer and Subscription parameters.

Nue also generates an ARR by Period view within our Snowflake data warehouse, enabling the creation of more sophisticated metrics and analytics. For further insights into analytics within Revenue Lifecycle Intelligence, please refer to this article.  

Field Definitions

Object Name: ARR By Period

API Name: ArrByPeriod (Salesforce: Ruby__ArrByPeriod__b)