📅
Current Month
loading…
CURRENT MONTH MEASURES
—
Total Measures
—
—
Unique Customers
—
—
Contracted
—
—
In Discussion
—
—
Cancelled
—
—
Conversion Rate
—
—
Cross-Sales Rate
—
orders ÷ contracted customers
Monthly Measures Trend
Total measures vs contracted
Status Distribution
Overall pipeline breakdown
Designer Performance
Click a designer to view their stats
📍 Top Areas
Click any area to see its locations
📡 Lead Sources
Click any source to see areas covered
🏆 Top Performers
Highest conversion rate
⚠ Needs Attention
Below average conversion
🤖 AI Insights
Operational intelligence
Designer Performance Tiers
Composite score: 50% volume · 50% conversion rate
Today's Measures
—
Live count
Pending Follow-up
47
↑ 5 since yesterday
Overdue (>45 days)
12
Require urgent action
Active Designers
—
Currently active
URGENT: Loading…
ATTENTION: Loading…
HIGHLIGHT: Loading…
Contracts Pipeline — Follow-up Status
From Contracts_Follow_up data
Contract Age Distribution
Days since contract date
📋 Contracts Follow-up List
| # | Customer Name | Order ID | Designer | Contract Status | Contract Date | Age (Days) | Aging Category | Action |
|---|
Total Records
1,767
Filtered Results
1,767
Total Payment ↗
—
Click for Breakdown
Repeated Customers (Unique)
—
Payment Collection — Monthly
Payment collected per month
All Measures
| Order Code | Customer | Designer | Visit Date | Month | Source | Order Type | Area | Status | Payment |
|---|
Page 1
Showing —
Active Designers
—
Best Conversion
—
—
Avg Conversion
—
Lowest Conversion
—
—
Selected Designer
—
—
—
Total Measures
—
Contracted
—
Discussion
—
Cancelled
—
Conv. Rate
Designer Conversion Rate Ranking
% contracted / total measures
Volume vs Conversion
Total measures per designer
Designer Performance Breakdown
| Rank | Designer | Total Measures | Contracted | Discussion | Cancelled | Conversion Rate | Performance |
|---|
Designer Performance Tiers
Composite score: Measures Volume 50% · Conversion Rate 50%
Overall Conv. Rate
—
Best Month Rate
—
—
Best Area Rate
—
—
Best Source Rate
—
—
Conversion Funnel
Measures → Discussion → Contract
Monthly Conversion Rate Trend
% rate per month
Conversion by Area
Top areas by contracted rate
Conversion by Order Type
Which product type converts best
Top Area
—
—
Areas Covered
—
Across Egypt
Best Conv. Area
—
—
Lowest Conv.
—
—
Measures Volume & Conversion Rate by Area (Top 12)
Bars = total measures (left axis) · Line = conversion rate % (right axis)
Area Performance Summary
| Area | Total Measures | Contracted | Conversion Rate | Performance Bar |
|---|
Best Month (Volume)
—
—
Best Month (Conv.)
—
—
Avg Monthly
—
measures/month
Worst Month
—
—
Monthly Measures — Full Year Overview
Monthly measures, contracted, and discussion pipeline
Monthly Conversion Rate
% contracted per month
Month-over-Month Growth
% change in total measures
Monthly Performance Table
| Month | Total Measures | Contracted | Discussion | Cancelled | Conv. Rate | MoM Change | Trend |
|---|
Total Sales Orders
—
active orders
عقد / CONTRACT
—
of total
اضافات / INVOICE
—
of total
Need Attention
—
not in safe zone
✅ Safe Zone
—
OTO → Delivered
CRM Status Pipeline
Contract Age Distribution
Aging brackets for open contracts
Follow-up by Designer
Open contracts per designer
Follow-up Dashboard
| # | Customer | Order ID | Designer | Contract Status | Date | Age (Days) | Category | Priority |
|---|
Top Source (Volume)
—
— measures
Best Conv. Source
—
— rate
Digital Sources
—
Insta + FB + Google
Repeat Customers
—
of total measures
Measures by Lead Source
Volume distribution
Conversion Rate by Source
Quality of each lead channel
Lead Source Performance Matrix
| Lead Source | Total | Contracted | Discussion | Cancelled | Conv. Rate | Share % | Performance |
|---|
Next Month Measures
—
predicted
Next Month Contracts
—
predicted
Predicted Conversion
—
next month forecast
6-Month Pipeline
—
total predicted measures
Measures Volume Forecast — 6 Month Outlook
Trend + Seasonality model · Shaded area = confidence band
Conversion Rate Forecast
Historical trend vs projected %
6-Month Breakdown
Predicted measures · contracts · confidence range
Forecast Methodology
Uses Trend + Seasonality decomposition. Historical monthly data is split into a linear growth trend and a calendar-month seasonal pattern. Future values are projected as trend × seasonal index. The shaded confidence band represents ±1.5 standard deviations of historical residuals. Accuracy decreases beyond 3 months.
All Time
Total Visits
—
Indiv. Projects by CRM ID
Total Customers
—
Unique CRM IDs
Contracted Orders
—
Orders with Status: تعاقد
Contracted Customers
—
Unique CRM IDs
Customer Conversion Rate
—
Contracted Customers ÷ Unique Customers
Order Conversion Rate
—
Contracted Orders ÷ Total Orders
Cross-Sales Ratio
—
Contracted Orders ÷ Contracted Customers
Latest Month
—
—
Monthly Trend
Busiest Designer This Month
—
—
Best Conversion Designer
—
—
Top Area
—
—
Top Measure Source
—
—
🔍Portal Search
Designer · Area · Source
🔍
Business Health Scorecard
Executive Intelligence — Key Findings
Top Order Type
—
—
Order Types
—
Unique types tracked
Best CVR Type
—
—
Lowest CVR Type
—
—
Volume & Conversion Rate by Order Type
Bars = total measures · Line = conversion rate %
Order Type Distribution
Share of total measures by type
Order Types Performance Summary
| Order Type | Total Measures | Contracted | In Discussion | Cancelled | CVR % | Performance |
|---|
🔧
Loading installation data…
Fetching from Google Sheets
1 / 8
← → keys · F = fullscreen
2025 vs 2026 — Year Comparison
Side-by-side KPI comparison · January–June H1 for 2026
Monthly Measures — 2025 vs 2026
Monthly CVR % — 2025 vs 2026
Designer Performance — 2025 vs 2026