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

Your description to Mate

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

How it works

Set up a weekly pipeline dashboard

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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 in Customermates, shown with sample dataCRM Reporting in Customermates, shown with sample data

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".

QuestionSourceMeasureGroupingFilters
What is in the pipeline, by stage?DealsSum of ValueStageStage is not Won or Lost
What is it worth if stage probabilities hold?DealsSum of Weighted valueStageStage is not Won or Lost
Where does won business come from?DealsSum of ValueLead sourceStage is Won, custom "Closed on" date between the first and last day of the quarter
Which clients bring the most revenue?DealsSum of ValueOrganizationStage is Won
Which services sell?Line itemsSum of AmountServiceDeals › Stage is Won
Why do we lose?DealsCountLost reasonStage is Lost
How much open work is there?TasksCountStatusStatus 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

PlanReporting featuresPrice
StarterChart widgets, activity timeline of record changes, weighted pipeline, grouped lists, XLSX export, REST, MCP€12 per user per month
ProStarter plus messages and calendar events in the activity timeline, through the unified inbox€29 per user per month
BusinessPro plus one team-wide timeline across every channel€69 per user per month
Self-hostedCharts, weighted pipeline, export, REST and MCP on your own server; no inbox, Mate or routinesNo 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 needIn CustomermatesWhere to look
Revenue forecasting beyond stage weightsNot 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 typesNot 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 dataNo built-in connector to a BI toolSelf-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 editsNot 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 scheduleNot built inA 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.

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