Carlos's frustration: Salespeople without direction and scattered data
Carlos, sales manager at an industrial supplies distributor, was looking at his inbox with discouragement. It was the 25th of the month and three of his five salespeople were below 60% of their targets. The reports he received were outdated Excel files, each salesperson sent different formats, and he had no clear view of which products or categories were underperforming. Follow-up meetings turned into discussions about the validity of the data, not strategies to improve sales. Carlos needed a system that would show him, in real time and visually, his team's performance against the set targets. His problem was not a lack of information, but the inability to turn scattered data into actionable insights.
The first fundamental step: recording targets in a structured way
Before creating any dashboard, you need to have targets recorded in an organized way. In Odoo, you can use specialized modules that allow defining targets per salesperson, period, product or category, both in quantities and monetary value. The system automatically calculates the percentage of achievement with each recorded sale.
Applied example: Carlos implemented a system where each salesperson has monthly global targets (for example, $400,000), product-specific targets (100 units of product X) and category targets ($150,000 in the "Power Tools" category). The most valuable part was that, when working with Ganemo on the implementation, he found out that this target control module was already included in his maintenance plan. He did not have to look for third-party applications on his own or worry about compatibility, since the Ganemo team took care of configuring it according to his industry's specific needs.
Dashboard 1: Target per product in units
This dashboard answers the question: Which specific products are driving or hindering target achievement? It is built using Odoo's target analysis, filtering by "product" type and grouping by salesperson. The key measures are the quantity target and the percentage achieved, displayed in a pivot table and a complementary chart.
Applied example: In Carlos's dashboard, he could identify that salesperson Martínez had only 30% achievement on the "Industrial Pro Drill" product. By clicking the chart, he saw that this was because sales were concentrated in April, while the target was monthly. This allowed him to talk with Martínez about strategies to better distribute his efforts throughout the month. The ease of building this dashboard, using Odoo's native tools with guidance from Ganemo, saved him hours of manual work in Excel and gave him reliable, real-time information.
Dashboard 2: Target per category in monetary value
This indicator lets you see financial performance by product families. It is configured by changing the filter to "categories" and using the monetary execution percentage measure. You can choose to show just a visual chart (such as horizontal bars) that highlights achievement per category for each salesperson, making the information very easy to digest.
Applied example: Carlos noticed in his bar chart that the "Industrial Safety" category was at 120% achievement, while "Measuring Equipment" was at 45%. This allowed him to reallocate resources and promotions toward the underperforming category. A key lesson the Ganemo consultants shared was the importance of naming and organizing the sheets within the dashboard (for example, "Dashboard" for the main view and "Tables" for the detail), keeping everything tidy and easy to maintain in the long run.
Dashboard 3: Overall sales target with monthly evolution
This is the executive report par excellence: it shows the overall target, what was achieved and the percentage of attainment, broken down by salesperson and month. It is built directly from the target records (not from the detailed analysis), allowing an aggregated and time-based view. It is crucial to add date filters (such as "last 12 months" or "current year") and freeze the first columns so the salesperson's name stays visible when scrolling horizontally.
Applied example: Carlos's dashboard now shows a table where each row is a salesperson and each column a month, with three data points per cell: target, achieved and percentage. In the monthly review with management, Carlos can clearly demonstrate how the team has evolved, which months were critical and which salespeople are consistent. When he needed to adjust the measures to show only the percentage (without absolute values), he recalled the support from Ganemo, which is always available to help him customize these reports without needing to be a technical expert.
When default measures are not enough
You may need KPIs very specific to your business that are not predefined. Odoo offers options: from creating custom measures in dashboard spreadsheets to developing advanced reports that feed the dashboards.
Applied example: Carlos wanted a "sales efficiency" indicator that divided the total sales value by the number of sales visits. This measure did not exist by default. Instead of looking for costly external solutions, his account manager at Ganemo explained that, as part of his ongoing implementation, they could develop that custom measure and leave it ready to use in his dashboards. This flexibility, guided by experts who understand his business, is what makes the difference between having a standard system and a tool that truly adapts to your unique commercial challenges.
Turn data into decisions, not discussions
Carlos's story is no longer one of frustration, but of proactive control. His dashboards in Odoo, implemented and optimized with the support of Ganemo, allow him to anticipate problems, recognize opportunities and lead his team based on clear, visual evidence. It is not just about having data, but about having the right data, presented the right way, at the right time. If your sales management is lost in disorganized reports, it is time to take the step toward professional dashboards that put your salespeople — and your results — on the path to sustainable growth.