A manager opens Bitrix24, goes to CRM analytics, and sees charts that don't answer his questions. He can't see how many deals each manager closed, the average deal duration, or how many leads went stale without processing. Standard reports show aggregate numbers but don't provide management answers. Configuring Bitrix24 reports for managers is not about pretty graphs—it's about precise data for decisions. For example, a client company was losing 30% of leads due to lack of analytics; after report setup, conversion increased by 15%. In 70% of our projects, we identify suboptimal funnel stages, yielding an additional 10–20% conversion lift.
Our team has set up reporting for 55 companies, reducing weekly report preparation time by an average of 8 hours. Each report is validated against the data: we double‑check queries and groupings. The manager's time savings after implementation reach 200,000 ₽ per year. Contact us for an assessment of your data—we'll show which metrics you should track.
What built‑in CRM analytics provides
Bitrix24 offers several analytics tools. The choice depends on the required depth of detail and flexibility.
CRM analytics — built‑in reports: sales funnel, deal dynamics, sales plan, manager efficiency. Filterable by period, responsible person, and funnel. Limitations: no custom fields, cannot change grouping, no cross‑tabulation. Typical case: a company with 500 deals per month can't see distribution by manager—after funnel setup, analysis time is cut by 3x.
BI constructor — available on Professional and higher plans. Access via CRM → Analytics → BI constructor. Bitrix24 generates an OData endpoint, which connects to external BI tools: Google Looker Studio, Power BI, Yandex DataLens. This is the most flexible path for non‑trivial reports. We use it in 85% of projects that require custom analytics. Detailed documentation can be found at Bitrix24 Helpdesk.
Lists and smart processes are not reports in the usual sense, but they are sortable and filterable lists with Excel export. They cover some tasks with minimal effort.
Configuring built‑in reports for your KPIs
Before building a custom solution, check the built‑in reports after proper configuration. Often the problem is not the tool but the semantics of the data.
Sales funnel: Shows conversion between stages. Works correctly only with proper stage semantics (STAGE_SEMANTIC_ID). If all stages are "In progress," the funnel shows a single bar. Check: CRM → Settings → Dictionaries → Deal stages. Stages with semantics "Success" (S) and "Failed" (F) form funnel exits. Configuration takes 30 minutes.
Manager efficiency: Calculates the count and amount of closed deals. Filters by period and direction. Useful for weekly meetings. Limitation: it does not consider custom fields—if KPIs depend on a custom field like "Service type," this report is useless. Solution: move to the BI constructor.
Sales plan: Set up in CRM → Analytics → Plan. A monthly target amount for each manager. Bitrix automatically calculates the percentage of completion based on successful deals. Simple, but only tracks the deal amount (OPPORTUNITY). Not suitable for multi‑currency or product‑based KPIs.
What to do when standard reports aren't enough?
For managers who need non‑trivial reports, the BI constructor is the most flexible tool. Compared to built‑in reports, it offers 10 times more data fields and 5 times faster report generation. Let's look at connecting to Google Looker Studio.
- CRM → Analytics → BI constructor → create an access key
- Copy the OData endpoint, e.g.,
https://your-portal.bitrix24.ru/rest/{user_id}/{key}/bi.dataset.data.json - In Looker Studio: Add data source → JSON connector → paste the URL
- Configure the dataset: fields are mapped automatically
Available data includes: deals, leads, contacts, companies, product positions, activities (calls, emails, meetings). Custom fields (UF_CRM_*) are included in the export.
Example report: "Average deal cycle by manager"
- Source: deals with S (success) semantics - Calculated field: `DATE_CLOSE - DATE_CREATE` (days) - Grouping: responsible manager - Aggregation: AVG - Visualization: horizontal bar chartSuch a report reveals which managers close deals faster and where the cycle drags—a cue for training or funnel adjustment. After implementation, the average deal cycle was reduced by 5 days.
Comparison of reporting approaches
| Approach | Setup time | Flexibility | Cost |
|---|---|---|---|
| Built‑in reports | from 1 hour | low | included in tariff |
| BI constructor (Looker Studio) | 1–3 days | high | BI subscription + labor |
| Custom development (REST/PHP) | from 5 days | maximum | from 50,000 ₽ |
The choice depends on KPI complexity and budget. For quick solutions, built‑in reports suffice; for deep analytics, the BI constructor; for unique scenarios, custom development, which is 2 times more flexible but costs 5 times more. However, built‑in reports are 3 times faster to set up than the BI constructor, making them ideal for initial needs.
Five reports every manager needs
| Report | Source | Tool |
|---|---|---|
| Plan execution (actual/plan by manager) | Deals | Built‑in "Sales plan" |
| Funnel conversion by stage | Deals | Built‑in "Funnel" |
| Unprocessed overdue leads | Leads | BI constructor or filter + export |
| Average check and deal cycle by channel | Deals + UTM | BI constructor |
| Manager activity (calls/emails/meetings) | CRM activities | BI constructor |
Automatic report distribution
A manager shouldn't have to log into Bitrix24 every morning. Looker Studio and DataLens have a scheduled send feature—a PDF report arrives on email on Monday morning. Bitrix24 itself has no automatic CRM report distribution—only manual export. We set up distribution for any schedule.
What's included in turnkey report setup?
- Audit of current reports and manager needs
- Configuration of built‑in CRM analytics (funnel, efficiency, plan)
- Connection of BI constructor and integration with Looker Studio / Power BI / DataLens
- Creation of custom dashboards with the required metrics
- Employee training on using reports
- Documentation and instructions
- Automatic scheduled report distribution
We guarantee that every report answers a management question. Request a consultation—we'll tell you which reports will benefit your business and offer a pilot project on your data.