Skip to Content

Sales Dashboards and KPIs in Odoo: Complete Guide to Measuring and Meeting Targets

How to define KPIs, record targets, build dashboards with Odoo's native tools and keep them up to date
August 25, 2025 by
Sales Dashboards and KPIs in Odoo: Complete Guide to Measuring and Meeting Targets
Wilfredo Fernando Pastor Avila
| No comments yet

A number without context does not tell you whether you are doing well or badly. A good dashboard shows few indicators, compared against a target or the previous period, and says which decision to take. This guide brings together the method to define KPIs, record sales targets and build dashboards in Odoo with its native tools.

Define what to measure before building

  • A KPI is only valuable when compared with a reference: a target, the previous period or an average.
  • Remove everything that does not help you decide. A dashboard with a few well-chosen indicators gets used; one with dozens of charts gets ignored.
  • Think in levels: management sees strategic indicators, regional managers see tactical metrics and operational leads see detailed data, each with the permissions that apply.
  • Design each board so that whoever looks at it knows which action to take or which question to ask their team.

Step 1: record targets in a structured way

Before the dashboard you need the targets in the system. There are four paths, which are not mutually exclusive and which many companies combine:

  1. Targets per sales team: in the CRM sales team settings you define each group's monthly invoicing target.
  2. Budgets in Documents and spreadsheets: if you need detail by salesperson or by product, you create budgets linked to sales data, with planned (manual) and actual (automatic) in the same view.
  3. Gamification: native challenges with rules, participants and rewards, to add motivation to targets.
  4. Target apps from the Odoo app store: they let you define targets per salesperson, product or category, in quantities and amounts, with built-in analysis reports.

Step 2: build the dashboard with the native tools

Identify the data sources

In Odoo the sources can be individual records, lists or, most commonly, pivot tables. Give each table the shape your analysis needs: the right measures, such as planned and actual, grouping by salesperson or month, and the initial filters.

Fixed and dynamic pivots

When inserting data into an Odoo spreadsheet you can choose between fixed and dynamic pivots. Dynamic ones, created through formulas, update their structure and content when new salespeople or products appear, which makes them easier to maintain.

Calculated measures

For metrics such as missing visits or percentage of compliance, you can create calculated measures directly in the pivot, without leaving for an external sheet.

Charts and global filters

Insert bar, line or pie charts linked to the pivots, customize colors and labels, and add global filters by date, salesperson or region that affect every source on the board.

Three target dashboards worth having

DashboardWhat it answersHow it is built
Target by product in unitsWhich products drive or hold back target achievementTarget analysis filtered by product and grouped by salesperson, with the quantity target and the execution percentage
Target by category in valueHow financial performance is going per product familySame analysis with a category filter and the monetary execution percentage measure
Global target with monthly trendHow much was achieved versus the target, by salesperson and by monthBuilt from the target records, with an aggregated and time view

Dashboard of planned and executed visits

If your team works in the field, the same method applies to visits: a pivot with planned and actual measures, grouped by salesperson and month, a calculated measure of missing visits and a chart with filters by date and salesperson. For how to organize and control visits, see the guide to sales routes and field visits.

Do not edit the native dashboards: clone them

The dashboards that ship with Odoo work as examples and references. Instead of editing them, download them as a JSON file with developer mode, create a new dashboard, import the file as a base and customize it: remove irrelevant metrics, add your own and order the display. That way you keep the original version and define your own permissions.

  1. Turn on developer mode.
  2. Open the native dashboard closest to what you need and download it as JSON from the file menu.
  3. Create a new dashboard and import the JSON as a base.
  4. Customize metrics and visualizations.
  5. Set permissions per user or group, for example each salesperson seeing only their own sales and management seeing the consolidated view.

The default dashboards are enough for a small company that is just starting or for a proof of concept.

Boards that refresh themselves

To show an Odoo view on a shared screen, such as visits completed, orders in preparation or the day's sales per branch, you can make the page reload at regular intervals with a browser extension. That way the team sees progress without refreshing manually.

When you do need Power BI

For most sales reports, Odoo's native tools are faster to implement, easier to maintain and integrate with your processes. Consider an external tool when you need to combine sources outside Odoo or run analyses that Odoo spreadsheets do not cover.

Implementing it with Ganemo

Ganemo is an Odoo partner. If you want us to review what to measure and how to build it in your database, see how we run an Odoo implementation in Peru or write to us through contact or at +51 946 377 197.

Related video

Sales Dashboards and KPIs in Odoo: Complete Guide to Measuring and Meeting Targets
Wilfredo Fernando Pastor Avila August 25, 2025
Share this post
Tags
Archive
Sign in to leave a comment
The Accounting Error That Could Be Costing Your Company Thousands: How to Automate Analytic Accounting Correctly
Discover why memorizing accounting codes is a thing of the past and how to implement a system that faithfully reflects the economic reality of your business