Report Builder: custom reports — save, filter and export
Build your own sales reports by choosing a metric, grouping, filters and chart type, then save them to reuse anytime.
The Report Builder lets you assemble sales reports your way, without being limited to the fixed reports. You choose what to measure, how to group it, what to filter and how to view it, then save it to run again whenever you need.
When it helps
- When the standard Sales reports don't answer your exact question.
- For recurring reports (e.g. "Won amount by rep this quarter").
- To cross two deal dimensions the fixed report won't combine.
Requirements
- CRM module enabled on your plan.
- Deals loaded in at least one pipeline.
Steps
- Open the CRM, go to Reports and click Report Builder (or go to
/crm/reports/builder). - Pick the Metric: Deal count, Total amount, Average amount, or Win rate.
- Pick Group by (dimension): Seller, Source, Stage, Pipeline, Win/loss reason, Month, or Status.
- Set the Filters: period, status (Open/Won/Lost), seller, pipeline, and minimum amount.
- Choose the Chart: Bar, Pie, Line, or Table.
- Click Run to see the result.
Save and reuse
- Type a Report name and click Save report. It appears under Saved reports.
- To view it again, open it from that list (it runs against fresh data).
- You can Update a saved report (change its config) or Delete ones you no longer need. New report clears the canvas.
Export
Switch the chart to Table to see rows with Group and Value. From there you can copy the data into your spreadsheet, or print/save as PDF using your browser's print option. Because saved reports always run on live data, they're the most reliable way to "export" the same analysis every period.
Verify
The table total should match the equivalent standard report (e.g. Total amount Won for the period should equal the Dashboard's "Won value" for the same range).
If it doesn't work
- "No data for this configuration": your filters are too tight (status + period + minimum amount combo). Loosen them.
- Your saved report doesn't appear: confirm you saved it with a name; without a name it isn't persisted.
- Odd Win rate numbers: remember it only counts closed deals (won over won+lost), not open ones.
Tips
- Start from the question ("which rep closes the most amount?") and derive the metric + dimension from it.
- Keep a small library: one per rep, one per source, one per loss reason.
Related articles
Related articles
-
How to import contacts from a CSV file
Upload your contact list in minutes by mapping your CSV columns to CRM fields.
-
Managing contacts and the CRM
In Omnifox every conversation creates a contact. Learn to use custom fields, tags, the deal pipeline and the contact 360 timeline.
-
CRM complete guide
The CRM in depth, in 46 chapters: pipeline, deals, the deal record, to-dos, dashboard and goal, settings, the contact record, contacts, import, lead forms, chat, AI and workflows.
-
Contact custom fields
Build fields tailored to your business to store exactly the information you need about each contact.
-
The sales pipeline and deals
Visualize and manage your sales process with a stage board and opportunity cards.