Scaling Your CRM Reporting
Creating a comprehensive, cross-module report in Perfex CRM is incredibly valuable. But once you’ve built the perfect "Monthly Sales by Agent & Region" report using Data Builder's visual query interface, how do you share it? How do you organize dozens of these reports? And crucially, if you manage multiple Perfex CRM instances, how do you deploy that report without rebuilding it from scratch?
Data Builder solves this with a robust ecosystem of Report Templates, DB-backed Template Groups, and JSON Portability.
1. Built-in Report Templates
Don't want to start with a blank canvas? Data Builder comes with a suite of Built-in Report Templates designed for common business use cases. You can instantly generate reports for:
- Daily Sales by Invoice Item
- Overdue Invoices by Client
- Project Hours vs. Billed Hours
- Support Ticket Resolution Times
These templates utilize Dynamic Date Macros ({{CURDATE}}, {{CURYEAR_Q1}}), ensuring that your dashboards are always pulling the right timeframe without manual intervention.
2. Save as Template & Template Groups
When you build a custom report tailored to your specific business logic (or involving third-party module tables), you can now use the Save as Template workflow. This promotes a one-off report into a reusable asset for your entire team.
As your library of templates grows, managing them via a flat list becomes chaotic. Data Builder introduces Template Groups, allowing you to categorize reports into logical domains:
- Financial Reports
- HR & Timesheets
- Sales & Lead Conversion
Because these templates and groups are database-backed (polydb_template_groups, polydb_templates), they bypass filesystem permission errors, support rapid searching, and scale securely even in enterprise deployments with thousands of saved reports.
3. JSON Export / Import: True Portability
The most powerful feature for agencies, developers, and multi-tenant CRM operators is JSON Export / Import.
Every report view and template you create in Data Builder can be exported as a lightweight .json file. This JSON file contains the complete blueprint of your report: the selected columns, the JOIN relationships, the WHERE conditions, and the sorting preferences.
How you can use this:
- Staging to Production: Build and test complex queries in your staging CRM. Once verified, export the JSON and import it directly into your live production environment.
- Agency Deployments: If you run an agency configuring Perfex CRM for multiple clients, you can create a "Master Library" of JSON reports. Deploying advanced analytics to a new client is now a 10-second import process.
- Version Control & Backups: Store your JSON reports in a Git repository to track changes over time or keep safe backups of your most critical business dashboards.
Stop Rebuilding. Start Scaling.
Reporting shouldn't be a repetitive task. By utilizing Templates, Groups, and JSON Portability, Data Builder transforms your reporting from isolated, one-off queries into a scalable, distributable analytics asset.