A Deep Dive into Analytics

An Odoo subscription report is an indispensable tool for any business leveraging a recurring revenue model. Furthermore, understanding how to generate and interpret these reports within Odoo 18 can significantly impact your strategic decisions and foster sustainable growth. This tutorial will guide you through creating two critical types of Odoo subscription reports: one for analyzing monthly customer churn and another for a comprehensive subscription health check based on product performance. Consequently, you will gain actionable insights directly from your Odoo platform.

Understanding the Power of Odoo Subscription Reports

In today’s competitive market, subscription-based businesses thrive on predictability and strong customer relationships. Therefore, an Odoo subscription report offers a clear window into the health and trajectory of your recurring revenue. Moreover, these reports allow you to track vital metrics, identify trends, and make data-driven decisions. For instance, you can monitor Monthly Recurring Revenue (MRR) to gauge your current income stream, analyze churn rates to understand customer attrition, and assess Customer Lifetime Value (CLV) to determine long-term profitability. Additionally, by using Odoo’s robust reporting features, you can transform raw data into strategic intelligence, helping you optimize your offerings and enhance customer retention.

Key Metrics You Can Track with an Odoo Subscription Report

Effectively, several key metrics provide a snapshot of your subscription business’s health, all of which can be monitored using your Odoo subscription report tools.

• Monthly Recurring Revenue (MRR): This metric represents the predictable revenue your business can expect to receive every month. Consequently, tracking MRR helps you understand your company’s financial stability and growth rate.
• Churn Rate: This indicates the percentage of subscribers who cancel or do not renew their subscriptions over a specific period. Therefore, a high churn rate can signal issues with customer satisfaction or product value.
• Customer Lifetime Value (CLV or LTV): This metric predicts the total revenue your business can expect from a single customer account throughout your relationship. Thus, understanding CLV helps in making informed decisions about customer acquisition costs and retention efforts.
• Average Revenue Per User (ARPU): This calculates the average revenue generated per customer, typically on a monthly or yearly basis. As a result, ARPU can help you identify trends in customer spending and the effectiveness of upselling or cross-selling strategies.
• Net New Subscribers: This simple count shows the number of new subscriptions added minus the number of subscriptions churned in a given period. Subsequently, it provides a clear view of your subscription base’s growth.

By consistently monitoring these metrics through your Odoo subscription report, you can proactively address challenges and capitalize on opportunities.

Your First Odoo Subscription Report: Mastering Monthly Customer Churn Analysis

Churn, which signifies customer attrition, stands as a critical metric because it directly impacts your revenue and growth. Therefore, learning to create an Odoo subscription report focused on churn will empower you to identify patterns and implement retention strategies. This section meticulously guides you through each step.

Step 1: Navigating to Your Subscription Analysis Dashboard in Odoo

First, you must access the correct area within Odoo to begin building your churn-focused Odoo subscription report.

1. Initially, log into your Odoo 18 instance.
2. Then, from the main Odoo dashboard, locate and click on the “Subscriptions” application module. This action takes you to the primary dashboard for managing all your subscription activities.
3. Next, look for the “Reporting” menu item, typically found in the top navigation bar of the Subscriptions module. Click on it.
4. Subsequently, from the dropdown or submenu that appears under “Reporting,” select “Subscriptions.” This selection will load the main subscription analysis view, which serves as the canvas for your Odoo subscription report.

You should now see a default report view, which might be a graph or a list.

Step 2: Switching to the Pivot Table View for Enhanced Data Insights

While the default view offers some information, the pivot table view provides a more dynamic and detailed way to analyze data for your Odoo subscription report. Pivot tables allow you to summarize, group, and rearrange data for deeper insights.

1. Once you are in the subscription analysis section, look towards the top right corner of the screen. You will typically find a set of icons representing different view types (e.g., graph, list, kanban, pivot).
2. Then, click on the icon that resembles a small grid or table, often referred to as the “Pivot Table” view. The VTT transcript mentions it looking like a “meja” (table).
3. As a result, the display will change, presenting your subscription data in a customizable pivot table format, which is highly beneficial for a detailed Odoo subscription report.

This view is crucial for dissecting churn data effectively.

Step 3: Selecting Key Metrics (Measures) for Your Churn Report

To analyze churn, you need to tell Odoo what specific data points (measures) to calculate and display in your Odoo subscription report.

1. Within the pivot table view, locate the “Measures” button. This button is usually positioned above the pivot table or as part of its control panel.
2. Next, click on the “Measures” button. A dropdown list of available metrics will appear.
3. For churn analysis, you primarily want to track the number of subscriptions that have ended. Therefore, select “Count” from the list. This action will configure your Odoo subscription report to display the quantity of subscriptions.
4. Additionally, the transcript mentions keeping “Monthly Recurring Revenue” checked. If you also want to see the MRR associated with churned subscriptions, ensure this option remains selected or select it if it’s not. This provides context on the financial impact of churn.
5. After making your selections, click outside the dropdown to close it. The pivot table will update to reflect these chosen measures.

Your Odoo subscription report will now show counts and potentially MRR values, ready for further refinement.

Step 4: Customizing Filters for a Focused Churn Analysis (Optional)

Sometimes, Odoo applies default filters to reports. For a specific Odoo subscription report like churn analysis, you might want to start with a clean slate or apply your own precise filters.

1. Observe the search bar area, usually located at the top of the report view. Default filters, if any, will be displayed here as tags or text.
2. If you wish to remove these default filters to build your own, click the ‘x’ icon next to each filter tag in the search bar.
3. Alternatively, you might want to modify existing filters. For instance, if there’s a filter for “Active Subscriptions,” you might need to adjust it later to see “Closed” or “Expired” subscriptions to analyze churn. For now, the tutorial suggests removing them to create custom ones.

This step ensures your Odoo subscription report is tailored to your specific analytical needs for churn.

Step 5: Filtering Your Odoo Subscription Report for Churn Insights

Now, you will apply filters to specifically isolate data relevant to churn in your Odoo subscription report. The tutorial suggests breaking down churn by salesperson.

1. Click into the search bar at the top of the reporting interface. This activates the filtering options.
2. Then, type “Salesperson” or look for it in the suggested filter fields. Select it.
3. Subsequently, you can choose specific salespeople if you want to analyze churn for individuals, or you can leave it to group by all salespeople, which the pivot table will handle if “Salesperson” is added as a grouping dimension. The transcript implies using it as a breakdown, so adding it as a row or column grouping in the pivot table itself (if not directly a filter for a specific salesperson) is the goal.
4. To analyze churn, you are interested in subscriptions that are not active. You might need to add a filter for “Status” and select statuses like “Closed,” “Expired,” or deselect “Active.” The transcript focuses on “churn” which implies subscriptions that didn’t renew, often captured by their end date passing without renewal.

The key here is to configure your Odoo subscription report to show subscriptions that have churned, potentially segmented by salesperson.

Step 6: Grouping Data by End Date (Monthly) for Trend Spotting

To understand churn trends over time, grouping the data by the subscription end date is crucial for your Odoo subscription report.

1. Still within the pivot table view or using the search bar’s “Group By” options, find the functionality to add groupings.
2. First, ensure your primary grouping (e.g., rows) might be “Salesperson” as per the previous step’s implication for breakdown.
3. Next, you need to add a grouping for the “End Date.” Click on the “Group By” option or the appropriate section in the pivot table controls.
4. Then, select “End Date” from the available fields.
5. After selecting “End Date,” Odoo will often give you sub-options for the granularity of this date grouping (e.g., Day, Week, Month, Quarter, Year). For monthly churn analysis, choose “Month.”
6. As a result, your Odoo subscription report will now display churned subscriptions (the “Count” you selected earlier) broken down by salesperson and then by the month in which the subscriptions ended.

This temporal view is vital for identifying seasonal churn or the impact of specific events.

Step 7: Saving Your Customized Odoo Subscription Report for Future Use

Once you have configured this valuable churn analysis Odoo subscription report, you should save it for easy access in the future.

1. Look for a “Favorites” or “Save current search” option. This is often represented by a star icon or a dropdown menu near the search bar, typically on the right-hand side.
2. Then, click on this “Save current search” (or similarly named) option.
3. A dialog box will appear, prompting you to name your saved report. Enter a descriptive name, such as “Monthly Customer Churn Analysis by Salesperson.”
4. You might also see an option like “Use by default.” The tutorial suggests not making it the default filter unless you always want to see this specific view.
5. Finally, click “Save.”

Now, you can quickly access this customized Odoo subscription report from your “Favorites” list whenever you need to analyze customer churn, saving significant setup time.

Creating a Comprehensive Subscription Health Report: Analyzing Product Performance with Your Odoo Subscription Report

Beyond churn, understanding how your different subscription products are performing is essential. This section guides you in creating an Odoo subscription report that offers a comprehensive health check focused on product performance over time.

Step 1: Resetting Your View for a New Odoo Subscription Report

To begin creating a new type of Odoo subscription report, it’s best to start from a clean or default state.

1. If you are still in the previously saved churn report view, navigate away and back to the base subscription reporting section.
2. Specifically, click on “Reporting” in the top menu of the Subscriptions module.
3. Then, select “Subscriptions” again. This action typically resets the view to its default state, clearing previous filters and groupings, allowing you to build your new Odoo subscription report for product performance.

This ensures no settings from the previous report interfere with your new analysis.

Step 2: Adding Subscription Status Filters for Active Subscriptions

For a product performance health check, you are generally interested in currently active subscriptions, as these contribute to your ongoing MRR.

1. In the search bar at the top of the reporting interface, click to activate filtering options.
2. Then, look for or type “Status” to add a filter for the subscription status.
3. Next, configure this filter to include only “Active” subscriptions. The transcript mentions removing “Paused” subscriptions, so ensure your filter focuses on statuses that represent ongoing, revenue-generating subscriptions. You might need to select “In Progress” or similar terms depending on your Odoo version’s specific status labels.
4. Apply the filter. Your dataset for the Odoo subscription report will now only include active subscriptions.

This focus ensures your performance analysis is based on your current, healthy subscriber base.

Step 3: Grouping Data by Product for Detailed Performance Metrics

To analyze how each subscription product contributes to your business, you need to group the data by product in your Odoo subscription report.

1. Locate the “Group By” option, which can usually be found in the search bar area or as part of the pivot table controls.
2. Then, click on “Group By” and select “Product” from the list of available fields.
3. As a result, the report will now organize the data, showing metrics for each of your subscription products separately. This is a fundamental step for creating a product-centric Odoo subscription report.

This grouping allows you to compare performance across your different subscription offerings.

Step 4: Leveraging the Pivot Table View for Product Analysis

Just as with the churn report, the pivot table view is highly effective for analyzing product performance in your Odoo subscription report.

1. If you are not already in it, switch to the “Pivot Table” view. Click the pivot table icon (often resembling a grid or table) in the top right corner.
2. Consequently, your product-grouped data will be displayed in the flexible pivot table format, allowing for multi-dimensional analysis.

This view facilitates the addition of multiple metrics and further time-based groupings for your Odoo subscription report.

Step 5: Choosing Metrics (Measures) for Product Performance

For your product performance Odoo subscription report, you’ll want to see both the revenue generated and the number of subscriptions for each product.

1. Within the pivot table view, click on the “Measures” button.
2. From the dropdown list, select “Recurring Revenue” (or “Monthly Recurring Revenue” / MRR). This will show the financial contribution of each product.
3. Additionally, select “Count.” This will display the number of active subscriptions for each product.
4. After selecting these, the pivot table in your Odoo subscription report will update to show columns for both recurring revenue and the count of subscriptions, broken down by product.

These two measures provide a balanced view of both the financial success and popularity of each product.

Step 6: Incorporating Time-Based Grouping (Contract Date by Month)

To understand how product performance has evolved, you should add a time-based grouping to your Odoo subscription report. The tutorial suggests using the contract start date.

1. In the pivot table view, you often have options to add column groupings. The transcript mentions clicking “Total” and then adding a new grouping. Look for a ‘+’ icon on the column headers or a specific section for adding column dimensions.
2. Then, select “Contract Date” (or “Start Date”) as the field for this new grouping.
3. Subsequently, Odoo will likely offer options for the granularity of this date grouping. Choose “Month.”
4. As a result, your Odoo subscription report will now display product performance (Recurring Revenue and Count) not only by product but also broken down month by month based on the contract start date. This shows trends in new sign-ups and revenue generation for each product over time.

This detailed breakdown helps identify growing or declining products and seasonal trends.

Step 7: Saving Your Product Performance Odoo Subscription Report

Finally, save this comprehensive product performance Odoo subscription report for easy future access and regular review.

1. Click on the “Favorites” or “Save current search” option (often a star icon or a dropdown near the search bar).
2. When prompted, give your report a descriptive name, such as “Monthly Product Performance Analysis” or “Subscription Health – Product Breakdown.” The transcript suggests “kinerja produk ini sebagai analisis kata bisnis” which translates roughly to “this product performance as a business word analysis” – you’ll want a clear English name. “Monthly Product Performance Insights” could work well.
3. Again, decide if you want this to be a default view (likely not).
4. Then, click “Save.”

You now have another powerful, customized Odoo subscription report ready to provide ongoing insights into your product strategy.

Advanced Tips for Your Odoo Subscription Reports

Once you have mastered creating basic churn and product performance reports, you can explore more advanced functionalities to further enhance your Odoo subscription report capabilities.

Exploring Different Chart Types

While pivot tables are excellent for detailed data, charts can provide quick visual insights.

• Action: After generating your data in a pivot table, try switching to different chart views (bar chart, line chart, pie chart) available in Odoo’s reporting section.
• Benefit: For instance, a line chart can effectively show MRR trends over time for a specific product, while a bar chart can compare the churn rates of different salespeople. This visual representation makes your Odoo subscription report more accessible.

Utilizing Advanced Filters and Custom Groups

Odoo often allows for more complex filtering.

• Action: Explore creating advanced filters using custom conditions (e.g., subscriptions with a specific add-on, or customers from a particular region). You can also create custom groups within your reports if needed, beyond standard field groupings.
• Benefit: This allows for highly targeted analysis within your Odoo subscription report, helping you answer very specific business questions, such as “What is the churn rate for customers in the ‘Enterprise’ tier who signed up in the last quarter?”

Interpreting the Data: What to Look For

Generating an Odoo subscription report is only half the battle; interpreting it correctly is key.

• Trends: Look for upward or downward trends in MRR, new subscriptions, and churn over several months. Are things improving or declining?
• Anomalies: Identify any sudden spikes or drops in your metrics. Investigate the potential causes – was there a marketing campaign, a price change, or a service outage?
• Comparisons: Compare metrics across different products, salespeople, or customer segments. Which products are most profitable? Which salespeople have the lowest churn?

Using Reports for Strategic Decision-Making

The ultimate goal of your Odoo subscription report is to inform strategy.

• Customer Retention: If churn is high for a particular product, investigate why. Perhaps the product needs improvement, or the onboarding process is lacking. Use the report to pinpoint areas for retention efforts.
• Product Development: If one product consistently outperforms others in your Odoo subscription report, consider what makes it successful. Can these elements be applied to other offerings? Conversely, underperforming products might need re-evaluation or discontinuation.
• Marketing Campaigns: Analyze the impact of marketing campaigns on new subscriptions and MRR. Did a recent promotion lead to a significant increase in sign-ups for a specific Odoo subscription report segment?
• Sales Performance: Identify top-performing salespeople and understand their strategies. For those with higher churn, provide additional training or resources.

The Strategic Advantage of Regularly Reviewing Your Odoo Subscription Report

Consistently creating and reviewing your Odoo subscription report is not just an administrative task; it’s a strategic imperative for any subscription-based business.

Proactive Monitoring and Early Warning System

Regularly checking your Odoo subscription report allows you to proactively monitor the health of your business.

• Benefit: Instead of reacting to problems after they’ve significantly impacted your revenue, you can spot early warning signs, such as a slight increase in churn or a dip in new MRR for a key product. This allows for timely interventions.

Accurate Forecasting and Budgeting

Historical data from your Odoo subscription report provides a solid basis for forecasting future revenue and subscriber growth.

• Benefit: With more accurate forecasts, you can make better budgeting decisions, plan resource allocation more effectively, and set realistic growth targets. For example, understanding your average churn rate helps predict future MRR more reliably.

Enhanced Customer Understanding and Satisfaction

Analyzing data points like churn reasons (if tracked) or product popularity within your Odoo subscription report can lead to a deeper understanding of your customers.

• Benefit: This understanding can guide efforts to improve customer satisfaction, tailor offerings more closely to customer needs, and ultimately reduce churn. For instance, if many churning customers cite a missing feature, this is valuable feedback for your product team.

Optimizing Pricing and Packaging Strategies

Your Odoo subscription report can reveal insights into how different pricing tiers or product packages are performing.

• Benefit: You might discover that a particular package has a very high ARPU but low adoption, or another has high adoption but contributes less to overall MRR. This data can inform adjustments to your pricing and packaging to maximize overall revenue and customer acquisition.

Conclusion: Empowering Your Business with Odoo Subscription Insights

Mastering the creation and interpretation of an Odoo subscription report is a fundamental skill for driving success in a subscription-based business model. By following the steps outlined in this tutorial, you can effectively analyze customer churn and evaluate product performance directly within Odoo 18. Furthermore, by regularly reviewing these reports and leveraging advanced tips, you transform raw data into actionable intelligence. This data-driven approach enables you to make informed strategic decisions, optimize your offerings, enhance customer retention, and ultimately foster sustainable growth.

We encourage you to explore these reporting features within your own Odoo instance. For further information on Odoo’s capabilities, you can always refer to the official Odoo Documentation. The insights you uncover will be invaluable to your business’s journey.