Who can use this feature?
- Refer to user licenses for limitations
- Available on all plans
Revenue-related filters allow you to segment customers based on renewal and churn values for historical or future quarters.
Filter definitions
Revenue filters in segmentation may vary slightly from how Revenue Center defines these terms. Segmentation filters include the following.
1. Churned accounts
Contract was canceled within the specified forecast period.
2. Renewable accounts
- Contract start date (or create date if used instead) is prior to the forecast period AND
- Account status remains in "Paying" throughout (and before) the specified forecast period AND
- Contract renewal date:
- is not set OR
- was set prior to the current period and is within the specified forecast period OR
- is set during the current period and within the specified forecast period
-
Renewable: On June 1, you set the renewal date to Aug 1.
- Renewal date was set prior to the current period and is within the period.
-
Not renewable: On June 1, you set the renewal date to Oct 1.
- Renewal date was set prior to the current period but is not within the period.
-
Renewable: On June 1, you set the renewal date to June 2. Then on Aug 14, you updated the renewal date to Sept 1.
- Renewal date was set during the current period and within the specified period.
-
Not renewable: On June 1, you set the renewal date to June 2. Then on Aug 14, you updated the renewal date to Sept 1. A few days later, you change the renewal date to Sept 1 of the following year.
- Renewal date was set during the current period but not within the specified period (e.g., same quarters but different years).
-
Renewable: Renewal date isn't set by July 1 (start of period) and remains unset through Sept 30 (end of period).
- Contract renewal date is not set.
An account will always show as "Renewable" for the quarter if the renewal date was in the quarter on the first day of the quarter. The renewables list remains the same as it was on the first day of the quarter unless historical data was changed.
3. Renewed accounts
- Account status remains in "Paying" throughout (and before) the specified forecast period AND
- Contract renewal date:
- was prior to the end of the forecast period
- was updated during the forecast period
- the new renewal date extends beyond forecast period
- Original date: April 15 (prior to the end of the forecast period)
- Update date: Aug 1 (during the forecast period)
- New date: Nov 13 (extends beyond forecast period)
You can query specific historical periods; however, trend over time is not available for these metrics. Segments that rely on these filters are not available for reports.
Admins can set the Financial Year Settings in Settings > General, including start of year (month) and current financial year.
Create a segment with revenue filters
- Create a new account segment, or open an existing segment.
- Click+More Filters to refine the list of results.
- Choose a revenue filter, and then specify the time period to query. Available options include:
- In current <month|quarter>
- In next <month|quarter>
- In previous <month|quarter>
- In a specific <month|quarter> <year(optional)>
- Click Apply Filter. The matching records appear in the grid.
- Click Edit Columns to optionally add revenue-related columns and/or adjust time periods.
Edit revenue segment columns
Additionally, the following segment columns are available for a selected time period. These values are automatically calculated based on changes to Contract Renewal Date and Contract Value:
- Renewable Revenue: Contract value for Renewable Accounts
- Renewed Revenue: Contract value for Renewed Accounts
- Upsell Revenue: New contract value minus old contract value for Renewed Accounts
- Downgraded Revenue: Old contract value minus contract value for Renewed Accounts
- Lost Revenue: Contract value for Churned Accounts
Examples
Scenario |
Contract Value |
Renewable Revenue |
Renewed Revenue |
Upsell Revenue |
Downgraded Revenue |
Lost Revenue |
Renewed |
$100,000 |
$100,000 |
$100,000 |
- |
- |
- |
Renewed (downgrade) |
$100,000 |
$100,000 |
$80,000 |
- |
$20,000 |
- |
Renewed (upsell) |
$100,000 |
$100,000 |
$120,000 |
$20,000 |
- |
- |
Churned |
$100,000 |
$100,000 |
- |
- |
- |
$100,000 |
Additional filters are available for forecasting, including forecast state, forecast period, and forecast contract value. See forecast and analyze account revenue.