CRM Reporting
See which follow-ups are due and what your pipeline is worth
Build a dashboard with deals by stage, weighted pipeline and an Upcoming list of what is due and overdue, and share it with your team. In Customermates Cloud, ask Mate for the figures a chart cannot show.
✓ No credit card required ✓ First 14 days free
We're a four-person strategy consultancy. Track clients, engagements and proposals, and help us follow up with prospects on LinkedIn.
Widgets built from the workspace's own lists and fields
Ways you can use it
Pick the job. The workspace follows.
- Follow up on LinkedIn conversationsLinkedIn and email threads sit on the client. Mate drafts the reply and dates the next step, and you review and send it in the conversation.See LinkedIn in the inbox
- Follow up on every proposal after the callClients, engagements and proposals with the conversations behind them, and a dated next step on each.CRM for consultants
- Keep client next steps on one dashboardEvery client gets a dated next step, and your dashboard shows what is due across all of them.See follow-up
- Let your own Claude or ChatGPT work in your CRMConnect Claude, ChatGPT, Cursor or another MCP client. It reads and updates your workspace within your permissions.Connect your agent
How it works
Set up a weekly pipeline dashboard
- 01
Check the stage probabilities
In Data model, open Deals and the Stage field, and adjust the Probability % of each option. A preview shows the effect on deals and widgets.
- 02
Add the fields your questions need
In Data model, open Deals and use Add › Field for a Single choice "Lead source" (Referral, LinkedIn, Website, Event), a Single choice "Lost reason" and a Date field "Closed on". A chart can only group by what you record.
- 03
Create the first chart
On the Dashboard, press Add widget and pick Bar chart. Under Data, choose Deals as the source, sum Weighted value and group by Stage. Exclude Won and Lost in the filters, then press Save.
- 04
Add three more
Won deal value by Lead source, won deal value per organization, and a count of lost deals by Lost reason. Drag and resize them; the layout is saved for you.
- 05
Share the dashboard with your team
Put the charts on a named dashboard view such as "Weekly pipeline" (New view above the widgets), then choose Share… in its menu. Everyone in the workspace or the roles you pick see the same charts, read-only, and every number is calculated with their own access.
In the product
At a glance
What you get
Chart widgets that count records or sum fields such as deal value and weighted value, grouped by a field, by record or over time, plus an activity timeline widget.
Plans
Dashboards and the weighted pipeline are part of every plan, from Starter at €12 per user per month, and of the self-hosted edition.
AI
In Customermates Cloud, Mate answers questions that need calculation across many records, using hosted AI credits. Your own AI client reads the same data through MCP.
Not included
No conversion tracking over time, time in stage, goals, predictive forecasting or scheduled report emails, and no dashboard that the whole team edits together (a shared dashboard is read-only for colleagues).
CRM reporting means counting and summing what is already in your CRM, so questions like "what is in the pipeline?" or "which clients brought the most revenue?" get an answer without a spreadsheet. In Customermates, that happens in three places: dashboard charts, lists grouped by a field, and the weighted value on every deal. Anything that needs real arithmetic over many records, such as a median deal size or a ranking, goes to Mate in Customermates Cloud, to your own AI client through MCP, or to Excel after an export.
It is deliberately small. If you need conversion tracking over time, time in stage, quotas or revenue forecasts, the section on limits names tools that do that.
What a chart widget can calculate
Every chart takes one list as its source, an aggregation and a grouping. The aggregation is a count of records, or the sum, average, minimum or maximum of a number or money field, such as Value or Weighted value on deals.
Grouping is No grouping (one total), a field such as Stage or Lead source, each record, Assigned to, or a field reached through a relationship. That gives you "deal value by stage", "deal value per organization" or "line item amounts by service". Group by a date field, Created at or Updated at and pick a Time interval to get one value per day, week, month, quarter or year.
Weighted value is a calculated field on deals: the deal's value times the Probability % of its stage, which you set on each option of the Stage field in Data model. Once the probabilities are set, it works from the first deal.
Filters narrow what a chart counts, using any field, including dates; linked fields appear as List › Field. That is how you chart "won deal value per organization": deals as the source, a filter on Stage is Won, grouped by organization.
Chart styles are Number, Bar chart, Horizontal bars, Area over time, Ranked table, Doughnut, Funnel and Radar. A live preview shows the result before you save.
The second widget kind, the Activity timeline, is a newest-first feed of record changes, and on Pro and higher also messages and calendar events from connected accounts. You filter it by category, account or related records, for example "everything that happened on deals of my three largest clients".
Reports a small team uses, and how to build each
These recipes assume a deals list with a Stage single choice field plus two more single choice fields you add: "Lead source" and "Lost reason".
| Question | Source | Measure | Grouping | Filters |
|---|---|---|---|---|
| What is in the pipeline, by stage? | Deals | Sum of Value | Stage | Stage is not Won or Lost |
| What is it worth if stage probabilities hold? | Deals | Sum of Weighted value | Stage | Stage is not Won or Lost |
| Where does won business come from? | Deals | Sum of Value | Lead source | Stage is Won, custom "Closed on" date between the first and last day of the quarter |
| Which clients bring the most revenue? | Deals | Sum of Value | Organization | Stage is Won |
| Which services sell? | Line items | Sum of Amount | Service | Deals › Stage is Won |
| Why do we lose? | Deals | Count | Lost reason | Stage is Lost |
| How much open work is there? | Tasks | Count | Status | Status is not Done or Archived |
Tasks have no built-in due date. The Status field in the last row is a single choice field you add to your tasks list, and you can rename, change or delete it like any other field.
Two questions are better answered by a list than by a chart. Who is working on which deals? Switch the deals list to the board and group it by Assigned: each person gets a column with their deal count and totals. How many deals did we open per month? Group the deals table by created date, bucketed by month. Saved as views, both stay one click away, and you can share them with the team.
A third question is about follow-up: What is due next? Add an Upcoming widget on a date field such as Next step. It lists the records due in the next 14 days, with an Overdue section for earlier dates, so the next steps are on your dashboard when you sign in. Filter out finished records so that only open ones count as overdue.
Which plan you need
| Plan | Reporting features | Price |
|---|---|---|
| Starter | Chart widgets, activity timeline of record changes, weighted pipeline, grouped lists, XLSX export, REST, MCP | €12 per user per month |
| Pro | Starter plus messages and calendar events in the activity timeline, through the unified inbox | €29 per user per month |
| Business | Pro plus one team-wide timeline across every channel | €69 per user per month |
| Self-hosted | Charts, weighted pipeline, export, REST and MCP on your own server; no inbox, Mate or routines | No licence fee |
Mate uses hosted AI credits, included per active user and month on every paid Cloud plan; the pricing page lists the amounts. A three-person team on Starter pays €36 per month, and a five-person team on Pro pays €145. There is no reporting add-on and no per-report charge.
What Customermates reporting does not do, and what to use instead
Customermates publishes this page. Vendor details were checked on 8 October 2026 on the vendors' own pages.
| You need | In Customermates | Where to look |
|---|---|---|
| Revenue forecasting beyond stage weights | Not available. The weighted pipeline multiplies each deal's value by the probability you set for its stage, nothing more. | HubSpot Sales Hub Professional and Enterprise include forecasting; Pipedrive offers a forecast view |
| A custom report builder with conversion rates, goals and many report types | Not available. Charts count and aggregate; a Funnel chart shows step-to-step conversion of the current records, but there are no goals or conversion over time. | HubSpot Sales Hub Professional (custom reports); Pipedrive Insights (custom reports, dashboards and goals) |
| Your own BI on the raw data | No built-in connector to a BI tool | Self-hosted: your data sits in your own PostgreSQL, which Metabase supports; its Open Source edition is free and self-hosted. Use a read-only database user, and expect to adjust queries after an upgrade, because the tables are the product's internal schema. |
| A dashboard the whole team edits | Not available. A shared dashboard is read-only for colleagues: only its owner changes the widgets, and Duplicate as new view gives each person an editable copy. | |
| Report emails on a schedule | Not built in | A routine in Customermates Cloud, or n8n, both described below |
For a one-off analysis, export the list as an Excel workbook from the deals list's More actions menu. The export takes the visible columns, filters and sort, and a PivotTable does the rest. Export runs one record type at a time; the records guide lists the limits.
How reporting connects to Mate, MCP and the API
Mate (Customermates Cloud). Mate has a read-only analysis tool for questions that need arithmetic across many records: a median, a ranking, a win rate, or a join between deals and organizations. It reads the records your role can see, computes in an isolated sandbox and changes nothing. Each question uses hosted AI credits. An example:
For deals that reached Won or Lost since 1 July: what is the win rate per lead source, what is the median value of won deals, and which three organizations brought the most won value?The answer is a chat message, not a saved chart. Mate can also create or change dashboard widgets for you when you describe them.
Routines (Customermates Cloud). A routine runs a saved instruction on a schedule, such as "Every Monday at 8:00, summarize the open pipeline by stage and list deals not updated in 30 days." It runs as you, its owner, with your access and credits, and the run summary stays on the routine. On Pro and higher it can also email that summary to you from your connected mailbox; Mate sends without asking again, so say "draft" in the instruction if you want to read it first. See workflow automation for triggers and limits.
Your own AI client through MCP. Claude, ChatGPT and other MCP clients use 59 tools on every plan and when self-hosting. With query_crm_measure a client calculates totals across all matching records, so "what is our weighted pipeline for organizations in Bavaria?" has an exact answer. The MCP documentation has the setup.
REST and webhooks. If reports belong in another system, read records through the REST API or receive a webhook on every change and keep your own reporting table up to date. n8n can do either on a schedule; it runs separately and is not part of Customermates.
Frequently asked questions
What are typical CRM reports?
For a small team, five cover most decisions: pipeline value by stage, weighted pipeline, won revenue by lead source, revenue per client and lost deals by reason. All five are chart widgets in Customermates. Activity reports, conversion funnels and sales forecasts are common in larger CRMs; Customermates has an activity timeline and a funnel chart of current stages, but no forecast.
Can Customermates forecast revenue?
Not in the predictive sense. It calculates a weighted pipeline: each deal's value times the win probability you set for its stage. Nothing learns from past deals or predicts close dates. If you need that, look at HubSpot Sales Hub Professional or Pipedrive's forecast view.
Can my team share one dashboard?
Yes. In a named dashboard view you own, choose Share… and pick everyone in the workspace or selected roles. Teammates see the same widgets and layout, read-only, and every number is calculated with their own access, so two people can see different numbers in the same chart. Only you change the widgets; Duplicate as new view gives a teammate an editable copy. The main dashboard cannot be shared, so put the charts on a named view. A single chart can also go out with Share as a template. For people outside the workspace, a dashboard view can be published by public link, read-only and without sign-in, if your role may publish and the workspace allows public links.
Can I export CRM reports to Excel?
You export records, not charts. Any list exports to an Excel workbook with its current filters, sort and visible columns, one record type at a time. CSV is not offered, so build the report with a PivotTable in Excel.
Which reports are included on the Starter plan?
All chart widgets, the weighted pipeline, grouped lists, the activity timeline of record changes and XLSX export are on Starter. Pro adds messages and calendar events to the timeline. Mate's analysis needs Customermates Cloud and hosted AI credits, which every paid Cloud plan includes.
Can I build reports with ChatGPT or Claude instead?
Yes. Connect the client through MCP, and it can list and filter records, calculate totals across matching deals and create dashboard widgets. The model, its subscription and what it does with your data are governed by your AI provider, not by Customermates.
Related pages
Sales Pipeline
Sales pipeline software for small relationship-led teams: opportunities by stage with probability, value and weighted value, with customer context close by.
Sales CRM
Sales tracking for small teams: the fields to record, seven numbers for the weekly review, five for month end and a worked example, set up in Customermates.
Workflow Automation
Automate CRM workflows with AI routines, webhooks, n8n or MCP. Four worked examples with steps, plan limits and what Customermates does not automate.
Dashboard Widgets and the Activity Timeline
The landing screen after sign-in: chart, timeline, calendar and map widgets over your CRM data, dashboard views, the widget editor and all keyboard shortcuts.
Customermates
Put follow-ups and pipeline on one dashboard
Add a date field for the next step, an Upcoming widget and a weighted pipeline chart during the trial. Dashboards are included from €12 per user per month, billed monthly.
✓ No credit card required ✓ First 14 days free













