28. Raporty i analityka kontaktów

Poziom trudności: Średni
Czas: 15 minut

Wprowadzenie

Analizuj dane kontaktów, źródła leadów, engagement rates i ROI. Podejmuj decyzje oparte na danych, nie przeczuciach.

Krok 1: Contacts Overview Dashboard

Reports → Contacts:

OVERVIEW THIS MONTH:
📊 Total Contacts: 1,247 (+12% vs last month)
🆕 New Contacts: 156 (avg 5/day)
🏷️ Tagged: 1,089 (87%)
📧 Email deliverable: 1,156 (93%)
📱 SMS deliverable: 987 (79%)

GROWTH TREND:
Jan: 1,091 contacts
Feb: 1,247 contacts (+14%)
Projection Mar: 1,420 contacts

Krok 2: Source attribution

Skąd przychodzą leady?

TOP SOURCES (Last 30 Days):
1. 🌐 Website Form: 45 leads (29%)
2. 📱 Facebook Ads: 38 leads (24%)
3. 🔗 Google Ads: 32 leads (21%)
4. 📧 Email Campaign: 22 leads (14%)
5. 🤝 Referral: 12 leads (8%)
6. 📞 Manual Entry: 7 leads (4%)

CONVERSION RATES BY SOURCE:
Website Form: 12% → Customer
Facebook Ads: 8% → Customer
Google Ads: 15% → Customer
Referral: 35% → Customer (highest!)

Trackowanie sources:

// Automatyczne przy dodawaniu kontaktu
contact = {
  email: "jan@example.com",
  source: "Facebook Ads",
  utm_source: "facebook",
  utm_campaign: "spring-2026",
  utm_medium: "cpc"
}

Krok 3: Engagement metrics

Email engagement:

📧 EMAIL PERFORMANCE:
Contacts with valid email: 1,156
Emails sent (30 days): 3,450
Open rate: 24% (industry avg: 21%) ✅
Click rate: 3.2% (industry avg: 2.5%) ✅
Bounce rate: 2.1% (good: <5%) ✅
Unsubscribes: 0.8%

TOP ENGAGED CONTACTS:
1. Anna Nowak - 87% opens, 45% clicks
2. Jan Kowalski - 82% opens, 38% clicks
3. Piotr W. - 79% opens, 41% clicks

SMS engagement:

💬 SMS PERFORMANCE:
Contacts with phone: 987
SMS sent (30 days): 1,234
Delivery rate: 98%
Response rate: 12% (industry avg: 8%) ✅
Opt-out rate: 0.3%

Krok 4: Segmentation analysis

Który segment najlepszy?

SEGMENT COMPARISON:
┌──────────────┬───────┬──────────┬──────────┐
│ Segment      │ Size  │ Conv.Rate│ Avg Value│
├──────────────┼───────┼──────────┼──────────┤
│ VIP          │   45  │   78%    │ 12,500zł │
│ Hot Leads    │  123  │   42%    │  5,000zł │
│ Warm Leads   │  287  │   18%    │  3,200zł │
│ Cold Leads   │  456  │    5%    │  2,800zł │
│ Inactive     │  336  │    1%    │     0zł  │
└──────────────┴───────┴──────────┴──────────┘

INSIGHT: Focus on Hot Leads (high conv + volume)
ACTION: Re-engagement campaign for Inactive

Krok 5: Lifecycle reports

Pipeline visualization:

CONTACT LIFECYCLE:
┌─────────┐    ┌──────────┐    ┌──────────┐    ┌──────────┐
│  Lead   │───→│Qualified │───→│Opportunity│───→│ Customer │
│  876    │    │   234    │    │   89      │    │   48     │
└─────────┘    └──────────┘    └──────────┘    └──────────┘
   (100%)         (27%)           (10%)           (5%)

CONVERSION FUNNEL:
Lead → Qualified: 27% (industry avg: 25%)
Qualified → Opportunity: 38% (avg: 30%) ✅
Opportunity → Customer: 54% (avg: 45%) ✅

BOTTLENECK: Lead → Qualified (need better qualification)

Krok 6: Time-based analysis

Najlepszy czas na kontakt:

BEST TIME TO CONTACT (Open Rates):
┌──────────┬────────┬────────┬────────┐
│  Time    │ Email  │  SMS   │  Call  │
├──────────┼────────┼────────┼────────┤
│ 8-10 AM  │  28%   │  45%   │  Low   │
│ 10-12 PM │  32%   │  38%   │  High  │
│ 12-2 PM  │  18%   │  25%   │  Low   │
│ 2-4 PM   │  25%   │  32%   │  Med   │
│ 4-6 PM   │  22%   │  41%   │  High  │
│ Evening  │  15%   │  52%   │  Low   │
└──────────┴────────┴────────┴────────┘

BEST DAY:
Tuesday & Thursday: highest engagement
Friday: lowest (avoid campaigns)

Krok 7: Custom reports

Tworzenie custom report:

1. Reports → Create Custom Report
2. Metrics:
   • Contacts created
   • By source
   • By assigned user
   • Conversion rate
3. Filters:
   • Date range: Last 90 days
   • Tags: lead, customer
   • City: Warszawa
4. Visualization: Bar chart
5. Save & Schedule (email daily)

Przykład: Lead quality by source

SELECT 
  source,
  COUNT(*) as leads,
  SUM(CASE WHEN customer = true THEN 1 ELSE 0 END) as customers,
  (SUM(CASE WHEN customer = true THEN 1 ELSE 0 END) / COUNT(*)) * 100 as conversion_rate,
  AVG(deal_value) as avg_value
FROM contacts
WHERE created_date >= '2026-01-01'
GROUP BY source
ORDER BY conversion_rate DESC

Krok 8: Export & sharing

Export opcje:

PDF Report:

• Professional layout
• Charts & graphs
• Summary insights
• Share with stakeholders

CSV Export:

• Raw data
• Import to Excel/Google Sheets
• Custom analysis

API Access:

// Fetch contact stats via API
const response = await fetch(
  'https://rest.gohighlevel.com/v1/contacts/stats',
  {
    headers: { 'Authorization': `Bearer ${apiKey}` },
    params: {
      dateRange: 'last_30_days',
      groupBy: 'source'
    }
  }
);

Key Performance Indicators (KPIs)

Track monthly:

GROWTH:
□ New contacts added
□ Growth rate (%)
□ Churn rate (contacts lost)

QUALITY:
□ Email deliverability (>95%)
□ Phone validity (>90%)
□ Complete profiles (>80%)

ENGAGEMENT:
□ Email open rate (>20%)
□ SMS response rate (>10%)
□ Call answer rate (>40%)

CONVERSION:
□ Lead → Qualified (>25%)
□ Opportunity → Customer (>40%)
□ Average deal size

EFFICIENCY:
□ Time to first response (<1h)
□ Sales cycle length (days)
□ Cost per lead

Podsumowanie

✅ Nauczyłeś się:

• Analizować contact growth & sources
• Mierzyć engagement metrics
• Porównywać segmenty
• Tworzyć custom reports
• Śledzić kluczowe KPIs

Następny krok: 29. DND i compliance (GDPR)