🎯 আজকের Smart Call List
এই ১০ জনকে আজকেই call করুন — সবই A+ Hot Lead
| # | Company | Contact | Mobile | Location | Score | Status | Action |
Executive Summary
4,479
Unique ISPs
from 8,141 raw
1,477
Duplicates Merged
3,662 rows collapsed
2,060
Contactable
phone/email present
3,957
NO Website
88% — prime targets
522
Has Website
364 live · 158 dead
1,611
A+ Hot Leads
call immediately
📊 Revenue Forecast Calculator — Adjust Close Rate
৳32.3M
Expected Booking
646.2M × 5%
৳2.7M
Monthly Target
÷ 12 months
27
Deals Needed/Month
@ avg ৳100k/deal
1
Deals/Day Needed
working days
💰 Revenue Pipeline
৳ 158.3M
New Website Pipeline
3,957 × ৳40k · click →
৳ 8.9M
Website Upgrade Pipeline
253 × ৳35k · click →
৳ 479.0M
Automation/ERP Pipeline
3,992 × ৳120k · click →
৳ 646.2M
TOTAL PIPELINE
gross · 5–10% close rate → click →
⚠️ Gross pipeline — apply realistic close rate (use calculator above). ৳32–65M realistic at 5–10% close.
Portfolio Breakdown
🔥 Top 5 Hottest Leads (A+)
| Company | Contact | Mobile | Location | Score | WhatsApp |
|---|
| Miad's Enterprise | Md. Mas-Udur Rahman | 01717258390 | Dhaka | 87.2 | 💬 Chat |
| Net Café | Kazi Md Mahbub | 01919195787 | Dhaka | 87.2 | 💬 Chat |
| MKZ Online | MD.Kadiruzzaman | 01711122036 | Dhaka | 87.2 | 💬 Chat |
| Meghna Online | Salah Ahammed | 01765101011 | Dhaka | 87.2 | 💬 Chat |
| S.M.G.internet Service | Nur-A-Shah Alam | 01627284979 | Dhaka | 85.9 | 💬 Chat |
✅ Google Verification Sample
| Company | Status | Website Found | Note |
|---|
| MKZ Online | VERIFIED | mkzonline.net | Active ISP, Tejgaon Dhaka. CRM had no website. |
| Meghna Online | VERIFIED | meghnaonline.net | ISPAB member, Chittagong. CRM had no website. |
| Spark It | VERIFIED | sparkit.net.bd | Active ISP, Khulna. |
| Spark Online & IT Solution | VERIFIED | sparkonlinebd.net | Active ISP, Dhaka. |
| Realnet Broadband | NOT VERIFIED | — | Possible match; name mismatch. |
| Miad's Enterprise | NOT VERIFIED | — | No online footprint. |
CRM website data incomplete — MKZ Online & Meghna Online had live sites CRM missed.
532
Total ISP Clients
registered in ROBOT
291
Active Clients
billing live this month
241
Inactive / Churned
45.3% churn rate
৳4.53L
Monthly MRR
৳452,783 / month
1.19L
Total Subscribers
managed by BSD clients
20
Due Alert
clients with overdue
Total Collected (All Time)
৳29.76L
৳2,976,393 as of Aug 2026
Total Due Bill
৳9.45L
৳944,969 outstanding
Previous Due Carried
৳5.22L
৳521,936 from prior months
August 2026 Collection
৳19,050
of ৳4.23L August due
🏆 Top 15 ROBOT Clients (by subscriber count)
⚠️ Due Alert — 20 Clients Overdue
| # | Company | Previous Due | Balance | Monthly Bill | Phone | Action |
|---|
🏢 BSD ERP Intelligence — Open ERP ↗
৳4.22L
Total Sales Pipeline
৳4,21,700 all-time deals
৳2.12L
Completed Sales
50.3% win rate
৳2.10L
Pending Deals
৳2,09,700 to close
৳8,000
August 2026 Sales
this month so far
21
Active Staff
in BSD ERP roster
49.7%
Pending Rate
deals not yet closed
💰 Sales Completion Progress
৳2,12,000 / ৳4,21,700
✅ Completed ৳2,12,000
⏳ Pending ৳2,09,700
🗓️ August: ৳8,000
👥 BSD Team Roster (21 active staff)
| # | Name | Email | ERP ID |
|---|
| 1 | Faruque Masud 👑 | faruque.masud@gmail.com | EMP00014 |
| 2 | Ashik Mollik | ashikmollik.bsd@gmail.com | EMP00017 |
| 3 | Ruman Hossain | ruman.bsd@gmail.com | EMP00018 |
| 4 | Aisha Akter | aishaashabsd@gmail.com | EMP00020 |
| 5 | Md. Hasan Marouf Limon | limonbsd@gmail.com | EMP00021 |
| 6 | Tariqul Islam | tariqul.bsd@gmail.com | EMP00022 |
| 7 | Tanvir Hossain Sadi | tanvirhossainsadi.bsd@gmail.com | EMP00023 |
| 8 | Rana | ranamollabsd@gmail.com | EMP00026 |
| 9 | Rakibul Hasan | rakibulhasanbsd@gmail.com | EMP00028 |
| 10 | Moushumi | mushumi@gmail.com | EMP00029 |
| 11 | Moriom Akther | moriombsd@gmail.com | EMP00030 |
| 12 | Nova | nova.bsd26@gmail.com | EMP00031 |
| 13 | Mousumi | mousumi.bsd@gmail.com | EMP00031 |
| 14 | Dristy | dristy.bsd@gmail.com | EMP00033 |
| 15 | Shakir | shakir@gmail.com | EMP00005 |
| 16 | Tanvir | tanvirbsd@gmail.com | EMP00007 |
| 17 | Borsha | bst.bd2025@gmail.com | EMP00009 |
| 18 | Zobayer | zobayerprodhanbsd@gmail.com | EMP00010 |
| 19 | Tanha | tanha.bsd@gmail.com | EMP00011 |
| 20 | Bayazid | bayazidbsd@gmail.com | EMP00012 |
| 21 | Ataul Karim | ataul.kaarim@gmail.com | EMP00013 |
🎯 CRM & Support Intelligence — Open Support ↗
2
Critical Tickets
⚠️ Needs Boss attention
7
High Priority
open tickets
9
Open Tickets
awaiting resolution
3
In Progress
team working on it
1
Closed Today
resolved tickets
10%
Resolution Rate
1 of 10 closed ⚠️
🚨 Support Health — Action Required
10 Active Tickets
Critical 2
High 7
Med 3
Low 2
👤 Ashik: 7 tickets
👤 Ruman: 2 tickets
👤 Dristy: 1 ticket
🚨 Live Support Tickets — ISP Clients
| # | Date | Client (ISP) | Issue | Priority | Assigned To | Status | Action |
| 1 | Aug 3, 2026 |
AL-HAFIZ |
Support request |
HIGH |
Ashik |
Open |
View ↗ |
| 2 | Aug 3, 2026 |
Alliance |
Expiry date issue |
MEDIUM |
Ruman |
Open |
View ↗ |
| 3 | Aug 3, 2026 |
Air ISP |
MikroTik config issue |
HIGH |
Ashik |
Open |
View ↗ |
| 4 | Aug 3, 2026 |
i fast |
Transfer request |
HIGH |
Ashik |
Open |
View ↗ |
| 5 | Aug 3, 2026 |
Second Net |
Auto sync not working |
HIGH |
Ashik |
In Progress |
View ↗ |
| 6 | Aug 1, 2026 |
Alliance |
Temporary disable date |
MEDIUM |
Ashik |
Open |
View ↗ |
| 7 | Jul 30, 2026 |
2jtech |
Reseller entry option |
HIGH |
Ashik |
Open |
View ↗ |
| 8 | Jul 29, 2026 |
Mashra |
Inventory issue |
HIGH |
Ruman |
Open |
View ↗ |
| 9 | Jul 20, 2026 |
— |
Reseller availability |
LOW |
Dristy |
Open |
View ↗ |
| 10 | Jul 19, 2026 |
Global Net 🔴 |
Auto sync — 103+ users affected |
CRITICAL |
Ashik |
In Progress |
View ↗ |
🚨 Boss — Immediate Action Items
🔴 Global Net — CRITICAL
Auto sync 103+ users affected · 16 days open · Ashik handling but still In Progress
Open Ticket ↗
⚠️ Ashik Overloaded
7 out of 10 tickets assigned to Ashik. Consider redistributing to Ruman or Tanvir.
Manage Team ↗