HG
Tracking KPIs Intelligence Platform
Sign in to access your dashboard
Need access? Contact Hassan Elarby — 01220165689
⚙️ Admin Panel
-
Total Clients
-
Active
-
Expiring Soon
-
Expired
➕ Add New Client
1 Create user in Supabase Open Supabase →
2 Add profile below
👥 Active Clients
Loading...
⚙️ Demo Settings
📊 Activity Log
Loading...
🎯 Demo Mode — Sample data only. Admin Access →
🔒
Protected Demo Access
Tracking KPIs Intelligence Dashboard
Enter the demo credentials to view the protected experience. The page is preloaded with large synthetic data for presentation.
Demo mode is intentionally presentation-friendly. It is not a security system replacement for a backend login.
✨
Feature Locked
Unlock the full dashboard experience
This action is disabled in the demo build.
For the full dashboard with all features, protected access, and custom deployment, contact Dr. Hassan El Arby.
📞 01220165689
HG
Tracking KPIs Intelligence Platform
✦ AI-Powered Sales Intelligence ✦
○ Loading Visits Data
○ Building KPI Engine
○ Preparing Analytics
○ Initializing AI Manager
○ Ready
Version 3.0 Enterprise · Developed by Hassan Elarby
💾 Session saved
📊
Upload Your Report Data
Import your Excel visit records — all charts & filters update automatically
📂 Click to browse or drag & drop Supports .xlsx and .xls — all sheets will be imported
📋 Required Column Headers in Your Excel ✓ Auto-detected · Case-insensitive
Date Visit date — DD/MM/YYYY or YYYY-MM-DD
Employee Medical rep full name
Customer Name Doctor / customer name
Customer Type Doctor / Hospital / Distributor
Area Geographical area name
Specialty IM / GP / ENT / Surgery…
Planned Planned / Unplanned
Coached Coached / Not Coached
Approval Approved / Cancelled
Duration Visit duration in minutes
📌 Optional columns: Time, Business Unit, National Sales Manager, Regional Sales Manager, District Manager, GPS Status, Comments — included if present.
Don't have a file? Download, fill it and upload.
📋
Upload Your List
Define your target customers & frequencies — enables Coverage tracking
📋 Click to browse or drag & drop Excel file with customer names, reps & visit frequencies
📋 Required Column Headers in Your Excel ✓ Auto-detected · Case-insensitive
Customer Name Full customer / doctor name
Rep Name Assigned medical rep name
Customer Type Doctor / Hospital / Distributor
Specialty Medical specialty (e.g. IM, GP)
Area Geographical area name
New Frequency Target visits per period (number)
Type Of Activity Call / Double visit / Coaching…
Default Frequency Fallback freq if New Frequency empty
💡 How it works: Once uploaded, the Coverage vs Team Template section shows each customer's actual visits vs. their target frequency — with gap warnings, completion status, and per-rep filtering.
Download, fill with your customer list and upload.
HG Logo
Tracking KPIs Intelligence Dashboard
By Hassan Elarby 01220165689
0 visits · 0 reps · 0 days
📋 671 customers · 6 reps
No matches found
No matches found
No matches found
No matches found
No matches found
No matches found
No matches found
No matches found
No matches found
Found 0 visits
⚠️ Only 8 visits on 2025-12-31 — below daily target of 9
🧠 AI Manager Insights
LIVE
Upload data to see insights.
💬 Ask the AI Manager
0
Total Visits
All records
0
Employees
Active reps
0
Customers
Unique doctors
0
Areas
Coverage zones
0
Planned Visits
0% of total
0
Coached
0% of total
0
Cancelled
0% approved
📈 Visits Trend
--
Total Visits
--
Avg / Day
--
Active Days
--
Trend
🎯 Productivity (Visits/Day)
Total Visits 0
Working Days 0
Target / Day 9
0.0
Visits / Day
⚠️
Below Target — Need 9.0 more visits/day to reach goal of 9
📊 Market Analytics
🏥 Customer Type
🏆 Employee Ranking
Sorted by Total Visits
RankNameTotalPlanUnplCoachApprCancAvgDurCustsAreas
📍 Geographical Distribution (Areas)
🩺 Specialty Breakdown
👥 Field Force Diagnostics
📊 Performance by Employee
🔔 Alerts
❌ Cancelled Visits
0
0% of total
📋 Unplanned Visits
0
0% of total
🔁 Most Repeated Doctors (Visits > 1)
No repeated doctor visits in this period
🎯 Performance Quadrant
⭐ Star 💎 Quality 📈 Volume ⚠️ Risk
✅ Execution Compliance
📅 Planned vs Unplanned
🤝 Coaching Coverage
✅ Approval Rate
⚙️ Operations
🔥 Visit Heatmap 📋 671 template records
No data available
📅 Calendar Strip ■ Below target (<9) ■ On/above target
No data
📋 Coverage vs Team Template 0/671 visited · 0 complete · 635 gaps
Legend: Gap Warning Zero Visits Complete ✓
📋
Upload a Team Template to see coverage comparison
Showing 50 of 671
# Customer Name Rep Type Area Specialty New Freq. Visited Remaining Activity Type Visit Interval Gap Warning
1 ابرام مجدي AbdelAziz Ahmed Doctor سامستا ENT 3 0 3 — — ⚠️ Gap
2 ابن سينا بني سويف AbdelAziz Ahmed Distributor بني سويف 2 0 2 — — ⚠️ Gap
3 احمد ابراهيم فتحي AbdelAziz Ahmed Doctor الفشن ENT 2 0 2 — — ⚠️ Gap
4 احمد بهاء AbdelAziz Ahmed Doctor بني سويف Ortho 2 0 2 — — ⚠️ Gap
5 احمد حليس AbdelAziz Ahmed Doctor سامستا Surgery 3 0 3 — — ⚠️ Gap
6 احمد خلاف AbdelAziz Ahmed Doctor بني سويف IM 3 0 3 — — ⚠️ Gap
7 احمد سعيد محمود AbdelAziz Ahmed Doctor بني سويف IM 2 0 2 — — ⚠️ Gap
8 احمد علي درويش AbdelAziz Ahmed Doctor الفشن IM 2 0 2 — — ⚠️ Gap
9 احمد فتحي بدر AbdelAziz Ahmed Doctor بوش IM 2 0 2 — — ⚠️ Gap
10 احمد قرني AbdelAziz Ahmed Doctor الوسطي IM 2 0 2 — — ⚠️ Gap
11 احمد محمد يسري AbdelAziz Ahmed Doctor بني سويف IM 2 0 2 — — ⚠️ Gap
12 احمد محي الدين AbdelAziz Ahmed Doctor بني سويف IM 3 0 3 — — ⚠️ Gap
13 احمد مسعود AbdelAziz Ahmed Doctor سامستا V.Surgery 2 0 2 — — ⚠️ Gap
14 احمد يحيي اسماعيل AbdelAziz Ahmed Doctor بني سويف G.P 2 0 2 — — ⚠️ Gap
15 ارميا عايد يني AbdelAziz Ahmed Doctor الفشن IM 2 0 2 — — ⚠️ Gap
16 اسامه ربيع احمد AbdelAziz Ahmed Doctor سامستا IM 2 0 2 — — ⚠️ Gap
17 اسامه محمد يوسف AbdelAziz Ahmed Doctor بوش IM 2 0 2 — — ⚠️ Gap
18 اسامه يوسف AbdelAziz Ahmed Doctor بني سويف G.P 2 0 2 Special Request 5 k — ⚠️ Gap
19 اسلام محمد AbdelAziz Ahmed Doctor اهناسيا ENT 2 0 2 — — ⚠️ Gap
20 اشرف السيد عطيه AbdelAziz Ahmed Doctor بني سويف G.P 3 0 3 — — ⚠️ Gap
21 اشرف عبد الغني AbdelAziz Ahmed Doctor مركز ناصر Surgery 2 0 2 — — ⚠️ Gap
22 اشرف عطيه عبد التواب AbdelAziz Ahmed Doctor سامستا G.P 2 0 2 — — ⚠️ Gap
23 اشرف عمار AbdelAziz Ahmed Doctor بني سويف IM 2 0 2 — — ⚠️ Gap
24 افرام ماجد فكري AbdelAziz Ahmed Doctor بني سويف Chest 2 0 2 — — ⚠️ Gap
25 البريد بني سويف AbdelAziz Ahmed Contract بني سويف 3 0 3 — — ⚠️ Gap
26 الزهراء فهمي AbdelAziz Ahmed Doctor اهناسيا GIT 2 0 2 — — ⚠️ Gap
27 الغاز بني سويف AbdelAziz Ahmed Contract بني سويف 2 0 2 — — ⚠️ Gap
28 الكهربا بني سويف AbdelAziz Ahmed Contract بني سويف 3 0 3 — — ⚠️ Gap
29 المقاولون العرب بني سويف AbdelAziz Ahmed Contract بني سويف 2 0 2 — — ⚠️ Gap
30 اميره محمد AbdelAziz Ahmed Doctor بوش Neuro 2 0 2 — — ⚠️ Gap
31 ايهاب احمد ذكي AbdelAziz Ahmed Doctor بني سويف IM 2 0 2 — — ⚠️ Gap
32 تامين صحي بني سويف AbdelAziz Ahmed Hospital بني سويف 4 0 4 — — ⚠️ Gap
33 جرجس شاكر عجايبي AbdelAziz Ahmed Doctor بني سويف G.P 2 0 2 — — ⚠️ Gap
34 جمال طه محمد AbdelAziz Ahmed Doctor بني سويف IM 2 0 2 — — ⚠️ Gap
35 جورج رؤوف اسكندر AbdelAziz Ahmed Doctor بني سويف IM 2 0 2 — — ⚠️ Gap
36 حازم سامي مطر AbdelAziz Ahmed Doctor بني سويف Endo 2 0 2 — — ⚠️ Gap
37 حسن رمضان AbdelAziz Ahmed Doctor بيبا IM 3 0 3 — — ⚠️ Gap
38 حسناء بركات AbdelAziz Ahmed Doctor بني سويف IM 3 0 3 — — ⚠️ Gap
39 خالد خلاف AbdelAziz Ahmed Doctor بني سويف IM 2 0 2 — — ⚠️ Gap
40 خالد رفعت عبد المجيد AbdelAziz Ahmed Doctor بني سويف Cardio 2 0 2 — — ⚠️ Gap
41 رجب رضوان AbdelAziz Ahmed Doctor بني سويف V.Surgery 3 0 3 — — ⚠️ Gap
42 رفعت فتحي رمضان AbdelAziz Ahmed Doctor الوسطي Cardio 2 0 2 — — ⚠️ Gap
43 ساره المهدي AbdelAziz Ahmed Doctor بني سويف IM 3 0 3 — — ⚠️ Gap
44 شريف زكريا الزناتي AbdelAziz Ahmed Doctor بني سويف Cardio 2 0 2 — — ⚠️ Gap
45 شفيق نجيب شفيق AbdelAziz Ahmed Doctor بني سويف IM 2 0 2 — — ⚠️ Gap
46 شيماء نادي بكري AbdelAziz Ahmed Doctor بني سويف G.P 3 0 3 — — ⚠️ Gap
47 صلاح الجالي AbdelAziz Ahmed Doctor الفشن Surgery 3 0 3 — — ⚠️ Gap
48 طارق الفخراني احمد AbdelAziz Ahmed Doctor بني سويف GIT 2 0 2 — — ⚠️ Gap
49 طارق عاطف طه AbdelAziz Ahmed Doctor بني سويف IM 2 0 2 — — ⚠️ Gap
50 طارق عزت احمد عطيه AbdelAziz Ahmed Doctor الوسطي Nephro 2 0 2 — — ⚠️ Gap
Page 1 of 14
📄 Raw Visits Data
Showing 0 of 0 records
#DateTimeEmployeeCustomerSpecialtyAreaDurPlanCoachAppr
Page 1 of 1