CRM Systems Research: Data Models, UI Patterns & Automation

Research Date: 2026-01-02
Version: 2.0
Scope: Salesforce, HubSpot, Pipedrive, Bitrix24

Резюме

Исследование анализирует четыре ведущих CRM-системы по следующим аспектам:
- Модели данных: Основные сущности и связи между ними
- UI паттерны: Pipeline views, управление контактами, timeline активностей
- Управление документами: Контракты, предложения, шаблоны, email интеграция
- Автоматизация: Workflow, email последовательности, lead scoring
- Аналитика и отчёты: Reports, dashboards, notifications
- Permissions: RBAC и управление доступом

Каждая система балансирует разные приоритеты:
- Salesforce — максимальная гибкость для enterprise
- HubSpot — simple UI + marketing-sales integration
- Pipedrive — sales-first, простота использования, отличные документы
- Bitrix24 — all-in-one платформа для mid-market, автоматизация

1. SALESFORCE

1.1 Data Model

Core Entities:

Entity Relationships:

Lead → (convert) → Contact → linked to → Account
                                    ↓
                                Opportunity
                                    ↓
                                Activity

Key Model Characteristics:
- Lead is separate from Contact (conversion workflow exists)
- Opportunities must be attached to an Account
- Multiple Contacts can be associated with one Account
- Standard objects can be extended with custom fields and custom objects

Standard Objects in Salesforce:
- Account, Contact, Lead, Opportunity
- Task, Event (activities)
- Custom objects for specialized workflows

1.2 UI Patterns

Pipeline Management:
- Opportunity-based pipeline view
- Drag-and-drop stage management
- Customizable pipeline stages per sales process
- Multiple pipeline support

Contact Management:
- Contact card with linked Account information
- Related lists for Opportunities, Activities, Cases
- Email and phone tracking
- Custom field display

Activity Timeline:
- Chronological view of all interactions
- Email sync with Gmail/Outlook
- Task and Event logging
- Document attachments

1.3 Document Management

Native Capabilities:

• Salesforce Contracts Module:
• Document template designer for contract management
• Microsoft 365 Word integration via Salesforce Contracts Connector

• Template-based document generation

• Proposal Generation:

• Quote to Cash (Q2C) workflow
• CPQ (Configure, Price, Quote) system
• PDF or Microsoft Word format generation

• E-signature integration support

• Document Storage:

• Attachments linked to records (Opportunities, Accounts)
• File size and storage limits
• Version tracking capability

Third-Party Integrations:
- PandaDoc: Advanced proposal management with dynamic fields
- Proposify: Complete proposal lifecycle management
- Integration with e-signature solutions

1.4 Automation

Workflow Automation:
- Process Builder for multi-step workflows
- Flow designer for complex automation
- Approval processes with conditional logic
- Scheduled actions and time-based workflows

Lead Scoring:
- Lead Score field with manual or formula-based calculation
- Behavioral tracking via Einstein Analytics
- Custom lead qualification rules

Email Sequences:
- Salesforce DX for email templates
- Integration with third-party email sequence tools
- Campaign management for mass email sends

2. HUBSPOT

2.1 Data Model

Core Objects:

Relationships (Associations):

Contact ←→ Company (N-to-1)
    ↓
  Deal ←→ Company
    ↓
  Ticket/Activity
    ↓
  Conversation

Model Characteristics:
- Flat structure with association rules
- All standard objects have shared identifiers
- Properties store individual data fields
- No mandatory hierarchy (unlike Salesforce)

2.2 UI Patterns

Pipeline View:
- Kanban board with Deal stages
- Drag-and-drop card movement
- Real-time property updates on stage change
- Pipeline customization per team/process

Contact Management:
- 360-degree contact view
- Associated Company information embedded
- Engagement timeline showing:
- Emails sent/received
- Website visit tracking
- Form submissions
- Associated deals

Activity Timeline:
- Chronological activity log
- Email sync with Gmail/Outlook (two-way)
- Automatic email logging
- Task and meeting scheduling
- Built-in email tracking (open/click)

2.3 Document Management

Native Capabilities:

• Quotes Module:
• Quote templates with custom branding
• Line item templates
• Approval workflows
• Quote PDF generation

• Email sending with tracking

• Document Attachments:

• File size limit: 20 MB per email attachment
• Attachments automatically logged to records
• No automatic attachment sync from emails (limitation)

• Internal use only (no external sharing link)

• Email Templates & Snippets:

• Email templates for standard messages
• Snippets: pre-written text blocks with keyboard shortcuts
• Template personalization with contact properties
• Character limits on snippets (affects long terms/conditions)

Approach to Contracts:
- Common methods:
1. Upload executed contracts as Deal attachments
2. Use HubSpot Quotes with embedded contract language
3. Integrate third-party solutions for complex contracts

Third-Party Integrations:
- PandaDoc: Dynamic proposal generation
- Proposify: End-to-end proposal management with e-signature
- Better Proposals: Custom branded proposals
- Integration via Zapier or native connectors

2.4 Automation

Workflows:
- Visual workflow builder
- Trigger conditions:
- Form submissions
- Email clicks/opens
- Contact property changes
- Website visits
- Time-based events
- Multi-step actions with branches

Email Sequences:
- Automated email series based on conditions
- Enrollment via workflow automation
- Personalization tokens
- A/B testing support
- Unsubscribe handling

Lead Scoring:
- Positive/negative scoring based on:
- Demographic attributes
- Behavioral signals (email opens, page visits)
- Form submissions
- Engagement level
- Custom scoring rules via workflows

Marketing Automation:
- Lead nurturing campaigns
- Multi-channel personalization
- Attribution reporting
- Lifecycle stage automation

3. PIPEDRIVE

3.1 Data Model

Core Entities:

Entity Relationships:

Person ←→ Organization (N-to-1)
    ↓
  Deal
    ↓
  Activity (Phone, Email, Meeting, Task)
    ↓
  Timeline

Lead → (qualified) → Person

Key Characteristics:
- All entities visually connected in UI
- Activities always linked to Person, Organization, Deal, or Project
- Multiple pipelines for different sales processes
- No forced Account-Deal hierarchy (flexible)

3.2 UI Patterns

Pipeline Kanban Board:
- Visual stages as columns
- Deal cards showing key information
- Drag-and-drop to move stages
- Color-coded status indicators:
- Red: Missed activities
- Yellow: No planned activities
- Green: Healthy (planned activities, no misses)
- Customizable card fields and information display

Contact Management:
- Person card with:
- Basic info (name, title, email, phone)
- Job title and company
- Contact history and interactions
- Associated Deals
- Scheduled activities (meetings/calls)
- Timeline of all activities

Activity Timeline:
- Chronological view of all person/deal interactions
- Visual graph showing:
- Calls (count and dates)
- Deals (active and closed)
- Emails (sent and received)
- Two-way email sync with Gmail/Outlook
- Automatic message logging under relevant contact/deal

3.3 Document Management

Smart Docs Feature:

• Document Creation:
• Create proposals or quotes from Deal or Contact view
• Auto-population with relevant deal/contact/project data
• Template library for reuse
• Field mapping: Copy Pipedrive fields and paste into template

• Fields display in brackets [field] and replace with data when used

• Document Types:

• Documents (proposals, contracts)
• Spreadsheets (pricing, inventory)

• Presentations (pitch decks)

• Cloud Integration:

• Google Drive
• Microsoft OneDrive

• SharePoint

• Document Tracking:

• Trackable links for sharing
• Notifications when prospects open documents
• Engagement alerts for follow-up timing

Use Case Example:
- Redlist: 15-minute proposal generation with Smart Docs templates
- 4x increase in daily activities

Third-Party Integrations:
- Proposify: Proposal creation and e-signature
- Better Proposals: Branded proposal management
- Marketplace apps for additional document solutions

3.4 Automation

Workflow Automation:
- Automation Builder (available on Advanced+ plans)
- Triggers:
- Deal stage changes
- Activity completion
- Custom field updates
- Conditions and branches

Email Automation:
- Advanced plan: Full email sync with templates
- Group email campaigns
- Email sequence capabilities through automation

Lead Scoring:
- Custom scoring rules via workflows
- Activity-based scoring
- Engagement tracking

Activity Templates:
- Community feature requests for templates
- Allows scheduling predefined meetings/activities
- Status: Under discussion in community

4. BITRIX24

4.1 Модель данных

Основные сущности

Режимы CRM и структура данных

Два режима:
- Classic CRM: Lead → Contact + Deal
- Simple CRM: Direct Deal (без Lead, по умолчанию)

Company (1)
├── Contact (M)
│   ├── Deal (M)
│   │   ├── Activity (M)
│   │   ├── Quote (M)
│   │   └── Invoice (M)
│   └── Activity (M)
├── Deal (M)
└── Activity (M)

Lead (в Classic CRM)
├── Activity (M)
└── (конвертируется в Contact + Deal)

Custom Entity (SPA - Pro+)
├── Association с Deal (M)
├── Association с Contact (M)
└── Activity (M)

Особенности Bitrix24

• Unified Platform: CRM + Project Management + Tasks + Chat + Email
• Custom Fields: До 1,016 per entity
• Business Processes: Visual workflow automation
• CRM Robots: Pre-built automation templates
• Pipeline-specific Fields: Custom fields для определённых pipelines
• Flexible Associations: N-to-M relationships through associations

4.2 UI Паттерны

Pipeline Management

Kanban Board (основной view):

┌──────────┬──────────┬──────────┬──────────┐
│  Новое   │ Влечение │ Презент  │ Согласие │
├──────────┼──────────┼──────────┼──────────┤
│ ┌──────┐ │ ┌──────┐ │ ┌──────┐ │ ┌──────┐ │
│ │Deal1 │ │ │Deal3 │ │ │Deal6 │ │ │Deal8 │ │
│ │50000 │ │ │25000 │ │ │75000 │ │ │100000│ │
│ │ABC   │ │ │XYZ   │ │ │LMN   │ │ │PQR   │ │
│ └──────┘ │ └──────┘ │ └──────┘ │ └──────┘ │
│ ┌──────┐ │ ┌──────┐ │          │          │
│ │Deal2 │ │ │Deal4 │ │          │          │
│ │15000 │ │ │60000 │ │          │          │
│ │MNO   │ │ │RST   │ │          │          │
│ └──────┘ │ └──────┘ │          │          │
└──────────┴──────────┴──────────┴──────────┘

Функции:
- Drag & drop между stages обновляет status
- Customize fields на карточке
- Quick actions: Call, Email, Task
- Deal ownership и color tags
- Real-time updates для других пользователей

Contact Management

Contact Card включает:
- Базовая информация (имя, должность, email, phone)
- Associated Company
- Active и closed Deals
- Activity history и timeline
- Communication preferences

Deal Detail View

┌──────────────────────────────────┐
│ DEAL DETAIL                      │
├──────────────────────────────────┤
│ Deal Name: Enterprise Solution   │
│ Company: ABC Corp                │
│ Contact: John Smith              │
│ Amount: 75,000 RUB               │
│ Stage: Presentation              │
│ Responsible: Alex Smith          │
│ Expected Close: Jan 31, 2026     │
├──────────────────────────────────┤
│ Sections:                        │
│ • Details (custom fields)        │
│ • Timeline (activities)          │
│ • Associated Contacts            │
│ • Associated Company             │
│ • Notes & Comments               │
│ • Files & Attachments            │
│ • Connected SPA Entities         │
│ • Products/Services              │
│ • Events & Reminders             │
└──────────────────────────────────┘

Activity Timeline

┌─────────────────────────────────┐
│ TIMELINE                         │
├─────────────────────────────────┤
│ Email: Demo scheduled - Jan 2   │
│ To: john@company.com             │
│ Subject: Follow-up meeting      │
│ [Attachment: presentation.pdf]  │
├─────────────────────────────────┤
│ Call: 25 minutes - Jan 1        │
│ Participant: John Smith          │
│ Notes: Discussed pricing        │
│ [Recording attached]             │
├─────────────────────────────────┤
│ Task: Prepare proposal          │
│ Assigned to: Alex               │
│ Status: Not started             │
│ Due: Jan 5, 2026                │
├─────────────────────────────────┤
│ Event: Client Meeting           │
│ When: Jan 3, 2:00 PM            │
│ Where: Conference Room          │
└─────────────────────────────────┘

Фильтрация: All, Emails, Calls, Notes, Tasks, Field changes, Meetings

Calendar View

• Activity Calendar (все scheduled activities)
• Drag-to-reschedule
• Color coding по типу
• Week/Day/Month views

4.3 Document Management

File Management

• File Upload: К Deal, Contact, Company, Quote, Invoice
• File Types: Все стандартные форматы (PDF, DOC, XLS, PPT, и т.д.)
• File Limit: Зависит от плана
• Document Library: Организация в папки
• Version Control: Версионирование документов
• Sharing: С пользователями и команды
• Cloud Integration: Google Drive, Dropbox, OneDrive (зависит от плана)

Email Integration

• Email Connection: Подключение email/calendar (Outlook, Gmail)
• Email Sync: Двусторонняя синхронизация с CRM
• Email Templates: Встроенные и кастомные шаблоны
• Bulk Email: Массовая отправка email
• Email Tracking: Отслеживание открытий
• Auto-Logging: Автоматическое логирование email в Deal/Contact

Document Templates

• Quote Templates: Для генерации предложений
• Invoice Templates: Для счётов-фактур
• Custom Templates: Создание собственных шаблонов
• Merge Fields: Автоматическая подстановка данных

4.4 Workflow & Automation

Business Processes

Visual Process Designer:

Start → Condition → Action → Decision → End
         │         │        │
         └─────────┴────────┘

Возможности:
- Trigger-based automation (record creation, field update)
- Multiple branches (if/then/else logic)
- 40+ pre-built action blocks
- Email notifications
- Task creation
- Field updates
- Delay/wait actions
- Parallel flows
- Loop support

CRM Robots

Pre-built Automation Templates:
- Lead assignment rules
- Stage transition automation
- Reminder creation
- Email notifications on deal changes
- Task creation for sales reps
- Connection of CRM entities to SPA flows

Automation Rules

Email Sequences

• Автоматизированные email последовательности
• Trigger на actions (deal stage, field change)
• Personalization tokens
• Scheduling capabilities
• Unsubscribe handling

5. СРАВНИТЕЛЬНЫЙ АНАЛИЗ

5.1 Сравнение моделей данных

Лучший по юз-кейсам:
- Простота: Pipedrive
- Гибкость: HubSpot
- Enterprise: Salesforce
- All-in-one: Bitrix24

5.2 Сравнение UI паттернов

Лучший по юз-кейсам:
- Visual Simplicity: Pipedrive
- Contact Intelligence: HubSpot
- Enterprise Customization: Salesforce
- Balanced: Bitrix24

5.3 Сравнение управления документами

Лучший по юз-кейсам:
- Автозаполнение предложений: Pipedrive (Smart Docs)
- Email Templates: HubSpot
- Управление контрактами: Salesforce (CLM)
- Простота: HubSpot

5.4 Сравнение автоматизации

Лучший по юз-кейсам:
- Email Marketing Automation: HubSpot
- Sales Process Automation: Pipedrive
- Enterprise Workflows: Salesforce
- Полная автоматизация: Bitrix24

6. FEATURE MATRIX

6.1 Матрица основных возможностей

┌────────────────────────────────────────────────────────────────────┐
│                    MATRIX ОСНОВНЫХ ФУНКЦИЙ                        │
├──────────────────────┬──────────┬─────────┬──────────┬──────────┐
│ Функция              │ Salesforce│ HubSpot │Pipedrive │ Bitrix24 │
├──────────────────────┼──────────┼─────────┼──────────┼──────────┤
│ Contact Management   │  ✓✓✓    │  ✓✓✓   │   ✓✓    │  ✓✓✓    │
│ Pipeline Management  │  ✓✓     │  ✓✓    │   ✓✓✓   │  ✓✓✓    │
│ Activity Tracking    │  ✓✓     │  ✓✓✓   │   ✓✓✓   │  ✓✓✓    │
│ Email Integration    │  ✓      │  ✓✓✓   │   ✓✓✓   │  ✓✓✓    │
│ Proposal Generation  │  ✓✓     │  ✓     │   ✓✓✓   │  ✓✓     │
│ Document Tracking    │  ✓      │  ✓     │   ✓✓✓   │  ✓✓     │
│ Automation           │  ✓✓✓    │  ✓✓✓   │   ✓✓    │  ✓✓✓    │
│ Lead Scoring         │  ✓✓     │  ✓✓✓   │   ✓     │  ✓      │
│ Quotes/Invoices      │  ✓✓     │  ✓     │   ✓✓    │  ✓✓     │
│ Customization        │  ✓✓✓    │  ✓     │   ✓     │  ✓✓     │
│ All-in-One Features  │  —      │  —     │   —     │  ✓✓✓    │
│ Unified Chat/Project │  —      │  —     │   —     │  ✓✓✓    │
└──────────────────────┴──────────┴─────────┴──────────┴──────────┘
Легенда: ✓ = Базовый | ✓✓ = Хороший | ✓✓✓ = Отличный | — = Нет

6.2 Сравнение общих компонентов

7. РЕКОМЕНДАЦИИ ПО ВЫБОРУ CRM

7.1 Для малых sales teams (<10 человек)

Рекомендуется: Pipedrive или HubSpot (free tier)

Причины:
- Быстрое внедрение
- Ясная видимость pipeline
- Минимальная конфигурация
- Доступная цена

7.2 Для растущего B2B бизнеса

Рекомендуется: HubSpot CRM + Marketing Hub

Причины:
- Unified marketing-sales workflow
- Отличная email автоматизация
- Хороший потенциал кастомизации
- Разумная стоимость при масштабировании

7.3 Для сложных sales cycles

Рекомендуется: Salesforce или Bitrix24

Причины:
- Гибкие структуры сделок
- Advanced workflow automation
- Custom objects/entities
- Поддержка многоуровневых процессов

7.4 Для e-commerce / Order Management (Пиротехника)

Рекомендуется: Pipedrive + Zapier ИЛИ Bitrix24

Причины:

Pipedrive + Zapier:
- Простейший UI для order pipeline
- Smart Docs для генерации счётов
- Zapier интеграции с Pochta, 1C, inventory
- Нижняя стоимость
- Быстрое внедрение
- Отличное отслеживание документов

Bitrix24:
- All-in-one платформа (CRM + Project + Tasks + Chat)
- Visual workflow automation (Business Processes)
- Встроенная email/calendar синхронизация
- Лучшая для distributed teams
- Unlimited custom fields
- Team collaboration features

7.5 Для enterprise компаний (500+ сотрудников)

Рекомендуется: Salesforce

Причины:
- Максимальная гибкость и power
- Advanced security features
- Масштабируемость
- Мощная экосистема
- Возможность глубокой кастомизации

8. АРХИТЕКТУРНЫЕ ПАТТЕРНЫ ДЛЯ СОБСТВЕННОЙ CRM

8.1 Рекомендуемая структура данных

// Основные сущности
interface Contact {
  id: string;
  firstName: string;
  lastName: string;
  email: string;
  phone: string;
  companyId: string;
  properties: Record<string, any>;
  createdAt: Date;
  updatedAt: Date;
}

interface Company {
  id: string;
  name: string;
  industry: string;
  size: "small" | "medium" | "large" | "enterprise";
  properties: Record<string, any>;
}

interface Deal {
  id: string;
  name: string;
  amount: number;
  stage: string;
  pipelineId: string;
  contactId: string;
  companyId: string;
  probability: number;
  expectedCloseDate: Date;
  ownerId: string;
  properties: Record<string, any>;
}

interface Activity {
  id: string;
  type: "email" | "call" | "meeting" | "task" | "note";
  subject: string;
  description: string;
  entityType: "contact" | "deal" | "company";
  entityId: string;
  relatedTo: string[];
  createdBy: string;
  createdAt: Date;
  metadata: Record<string, any>;
}

interface Pipeline {
  id: string;
  name: string;
  stages: Stage[];
  properties: Record<string, any>;
}

interface Stage {
  id: string;
  name: string;
  order: number;
  probability?: number;
  color?: string;
}

8.2 Ключевые UI компоненты

CRM Dashboard
├── Kanban Board (Pipeline)
│   ├── Stage Columns
│   ├── Deal Cards (with quick actions)
│   └── Summary (total value per stage)
├── Activity Timeline
│   ├── Chronological list
│   ├── Type filtering
│   ├── Inline editing
│   └── Attachments
├── Contact/Deal Details Panel
│   ├── Property editor
│   ├── Related records
│   ├── Activity history
│   └── Files
└── Reports & Analytics
    ├── Pipeline analysis
    ├── Forecasting
    ├── Performance metrics
    └── Funnel visualization

8.3 MVP Features Priority

Фаза 1 (MVP - 1-2 недели):
1. Contact + Company CRUD
2. Deal + Pipeline management (Kanban)
3. Basic Activity tracking (notes, tasks)
4. Simple filtering & search
5. Basic user authentication

Фаза 2 (3-4 недели):
1. Email integration (sync)
2. Calendar & scheduling
3. Basic automation (field updates)
4. Reports & dashboards
5. File attachments

Фаза 3 (5-8 недель):
1. Advanced workflows
2. Custom fields configuration
3. Multi-user permissions & RBAC
4. Mobile app (responsive)
5. API for integrations (Zapier, 1C, Pochta)

9. ВЫВОДЫ И РЕКОМЕНДАЦИИ

Сравнительная таблица ценности

Best in Class по категориям

🏆 Best Overall UI/UX: HubSpot
- Лучший design
- Отличный onboarding
- Excellent mobile experience

🏆 Best Document Management: Pipedrive (Smart Docs)
- Автоматическое заполнение
- Отслеживание документов
- Быстрое генерирование предложений

🏆 Best Automation: Salesforce (Flow) / Bitrix24 (Business Processes)
- Мощные workflow engine
- Pre-built templates
- Complex logic support

🏆 Best for Startups: Pipedrive
- Низкая цена ($14/user)
- Быстрое внедрение
- Sales-focused
- Отличная documentation

🏆 Best for All-in-One: Bitrix24
- CRM + Project + Chat + Tasks
- Unified platform
- Хорошая стоимость ($99/месяц за команду)
- Отличная для Russian market

🏆 Best for Enterprise: Salesforce
- Неограниченная гибкость
- Enterprise security
- Масштабируемость
- Зрелая экосистема

10. ИСТОЧНИКИ И ССЫЛКИ

Salesforce

• Salesforce Leads vs. Contacts: Everything You Need to Know
• Optimize Your Sales Data with Effective Models
• Data Model in Salesforce - GeeksforGeeks
• CRM Analytics Permission Sets

HubSpot

• View a model of your CRM object and activity relationships
• A Complete Guide to the HubSpot Data Model
• HubSpot Data Model Overview
• Understanding the CRM APIs - HubSpot docs
• HubSpot Document Management
• Custom Objects and Pipelines

Pipedrive

• How Pipedrive Data is Organized
• CRM Processes & Pipeline Management
• Sales Pipeline Management
• Custom Fields Guide
• Deal Card Customization
• Effective Smart Documents

Bitrix24

• How to Create and Use Business Processes
• Bitrix24 CRM Robots: Workflow Automation
• Free Sales Automation CRM
• Workflows and Automation Rules
• Custom Fields in CRM
• Bitrix24: Better Business Processes

UI/UX Patterns

• CRM UI Patterns: Kanban Boards
• Timeline Control in Power Apps
• Activity Timelines in Dynamics 365
• Contact Activities in Real Time
• Make Better Use of CRM with Kanban Boards

11. МЕТАДАННЫЕ ДОКУМЕНТА

12. КЛЮЧЕВЫЕ ВЫВОДЫ

Основные паттерны всех CRM-систем

1. Модели данных: Все системы используют похожий набор сущностей (Contact/Person, Company/Account, Deal/Opportunity, Activity)

2. Pipeline management: Kanban board — универсальный UI pattern для управления sales pipeline

3. Activity tracking: Timeline-based visualization всех взаимодействий (email, calls, tasks, notes)

4. Automation: Все системы поддерживают workflow-based automation с triggers, conditions, actions

5. Document management: Встроенное хранилище + email templates + интеграция с облаком

6. Permissions: Role-Based Access Control (RBAC) — стандарт для всех систем

Различия между системами

Рекомендация для новых проектов

При разработке собственной CRM:
- Начните с Pipedrive как reference для простоты и UX
- Используйте HubSpot как reference для email automation
- Изучите Salesforce Flow для advanced workflows
- Применяйте Bitrix24 Business Processes для visual workflow design

Конец документа исследования