Subscription reports¶

The Odoo Subscriptions app provides a series of reporting pages to help companies analyze how subscriptions are performing.

On the Subscriptions Analysis reporting page, users can view specific data related to recurring subscriptions, quantity of subscriptions, in-progress or paused subscriptions, and more.

The Retention Analysis reporting page provides an organized table of subscription retention percentages over any period of time.

The MRR Breakdown reporting page clearly divides MRR and ARR metrics for subscriptions into various graphs, lists, and charts.

And the MRR Analysis reporting page offers a time-based collection of analytics showcasing how subscription MRR and ARR have changed over the course of any given period of time.

Reporting page elements¶

All subscriptions-based reporting pages can be accessed via the Reporting header menu in the Subscriptions app.

The following sections describe elements found on each reporting page.

Filters and Group By¶

Filters are used to narrow down metrics to show specific analytics, whereas groupings (via the Group By option) are used to gather the data from specific sections into groups for more organized analysis.

This section refers to both filters and groupings, as a combination of the two can be saved in the Favorites section.

To modify the results being shown on any reporting page, click the (down arrow) icon to the right of the search bar. Doing so reveals a drop-down menu of detailed filter and grouping options.

If desired, a filter or grouping (or combination of filters and/or groupings) can be saved in the Favorites section of that drop-down menu. To do so, click the (down arrow) icon beside Save current search, located beneath the Favorites section.

This reveals a field to assign a title to the favorite filter. Two options are also found beneath the title field: Default filter and Shared.

Ticking the checkbox beside Default filter makes the newly-favorited filter the default option for that reporting page.

Ticking the checkbox beside Shared makes the newly-favorited filter available to other users in the database.

To save the filter, click Save in the Favorites section of the drop-down filter menu.

When clicked, that saved filter appears beneath the Favorites column of the drop-down filter menu, and a (gold star) icon appears beside the favorite filter’s name in the search bar.

Views¶

On the Subscription Analysis, MRR Breakdown, and MRR Analysis reporting pages, three different view options are located in the upper-right corner.

The available view options, from left to right, are:

• Graph

• List

• Pivot

Each view has its own series of related view-specific visual options.

Graph view¶

With the graph view selected, the following options appear between the search bar and visual representation of the data. These graph-specific options are located to the right of the Measures and Insert in Spreadsheet buttons.

The first three options, from left to right, represent different graph-related views. The remaining options represent different ways to organize and visualize that specific graph-related data.

From left to right, the specific graph-related view options are:

• Bar Chart: showcases the data in a bar chart format.

• Line Chart: showcases the data in a line chart format.

• Pie Chart: showcases the data in a pie chart format.

Each graph view option has its own series of specific visual options, which are represented by the available buttons that appear to the right of the selected graph-related view option.

When the Bar Chart graph view is selected, the following visual options are available:

• Stacked: showcases the data in a stacked visual format.

• Descending: showcases the data in descending order.

• Ascending: showcases the data in ascending order.

When the Line Chart graph view is selected, the following visual options are available:

• Stacked: showcases the data in a stacked visual format.

• Cumulative: showcases the data in accumulated, increasing format.

• Descending: showcases the data in descending order.

• Ascending: showcases the data in ascending order.

When the Pie Chart graph view is selected, there are no additional visual options.

List view¶

With the list view selected, the subscription metrics being analyzed are displayed in a simple list, which can be fully customized by using any of the available filters or groupings in the drop-down filter menu (accessible via the (down arrow) icon to the right of the search bar).

Pivot view¶

With the pivot view selected, the subscription metrics are displayed in a data table, which can be fully customized.

The pivot data table can be customized using the options available in the Measures drop-down menu, and/or the filter grouping options available in the filter drop-down menu (accessible via the (down arrow) icon to the right of the search bar).

Three pivot-specific options are available, located to the right of the Measures drop-down menu and Insert in Spreadsheet button.

From left to right, those pivot-specific view options are:

• Flip axis: the x and y axis of the pivot data table flip.

• Expand all: all the available rows and columns of the pivot data table expand fully.

• Download .xlsx: the pivot data table is downloaded as an .xlsx file.

Measures¶

The graph and pivot reporting pages have their own metric-specific Measures drop-down menu of data-related options to choose from, located in the upper-left corner, above the visual representation of metrics.

When the Measures button is clicked, a series of selectable measures becomes available, via a drop-down menu. When any of the options are selected from the Measures drop-down menu, the chosen metrics related to that specific measure appear on the reporting page.

Insert in spreadsheet¶

Beside the Measures drop-down menu, there is an Insert in Spreadsheet button.

When clicked, the ability to add the configured data currently being showcased on the reporting page into a new or pre-existing spreadsheet or dashboard becomes available, via a pop-up window.

Select the desired option from this pop-up window, then click Confirm.

Reporting pages¶

In the Odoo Subscriptions app, there are four different reporting pages available.

To access, analyze, and customize various reports related to subscriptions, navigate to Subscriptions app, and click the Reporting drop-down menu in the header to reveal the following reporting pages:

• Subscriptions

• Retention

• MRR Breakdown

• MRR Timeline

Clicking any of those options reveals a separate, fully-customizable reporting page focusing on that particular aspect of subscription data.

The following is a breakdown of those four specific reporting pages.

Subscriptions analysis¶

To access the Subscriptions Analysis reporting page, navigate to Subscriptions app ‣ Reporting ‣ Subscriptions.

By default, the Bar Chart option, in the Graph view, is selected on the Subscriptions Analysis reporting page.

The following filters are also present in the search bar: In Progress or Paused and Recurring.

When the Measures button on the Subscriptions Analysis page is clicked, a series of metric-related options becomes available as a drop-down menu.

The metric-related options in the Measures drop-down menu on the Subscriptions Analysis page are:

• Monthly Recurring

• Quantity

• Recurring Revenue

• Untaxed Total

• Yearly Recurring

• Count

When any of those available measures are clicked, Odoo displays that selected data on the reporting page for further analysis.

Retention analysis¶

To access the Retention Analysis reporting page, navigate to Subscriptions app ‣ Reporting ‣ Retention.

The Retention Analysis reporting page differs from the other Subscriptions app reporting pages, in that it does not provide any additional view options. The data on this page is only presented in a customizable data chart.

When the Measures drop-down menu on the Retention Analysis reporting page is clicked, a series of metric-related options become available.

The metric-related options in the Measures drop-down menu on the Retention Analysis reporting page are:

• Amount to invoice

• Margin

• Margin (%)

• Prepayment percentage

• Shipping Weight

• Unpaid Amount

• Count

To the right of the Measures drop-down menu on the Retention Analysis page is an additional drop-down menu containing different time periods. The default time period is Month.

When clicked, a drop-down menu of various time period options become available.

The time period options are:

• Day

• Week

• Month

• Year

When a time period option from this drop-down menu is selected, the Retention Analysis reporting page showcases data for the configured measures and filters within that time period.

To the right of the time period drop-down menu, there is a download button, which allows the user to download the data presented on the Retention Analysis page as an Excel file.

MRR breakdown¶

To access the MRR Breakdown reporting page, navigate to Subscriptions app ‣ Reporting ‣ MRR Breakdown.

By default, the data displayed on the MRR Breakdown reporting page is in graph view, with the Bar Chart option and Stacked option selected.

A default filter is also available in the search bar for Event Date: Month > Event Type.

When the Measures drop-down menu on the MRR Breakdown reporting page is clicked, a series of metric-related options become available.

The metric-related options in the Measures drop-down menu on the MRR Breakdown reporting page are:

• Active Subscriptions Change

• ARR Change

• MRR Change

• Count

MRR analysis¶

To access the MRR Analysis reporting page, navigate to Subscriptions app ‣ Reporting ‣ MRR Timeline.

By default, the data displayed on the MRR Analysis reporting page is in graph view, with the Line Chart option, Stacked option, and Cumulative option selected.

A default filter is also found in the search bar for Event Date: Month.

When the Measures drop-down menu on the MRR Analysis reporting page is clicked, a series of metric-related options become available.

The metric-related options in the Measures drop-down menu on the MRR Analysis reporting page are:

• Active Subscriptions Change

• ARR Change

• MRR Change

• Count