Ask AI
Natural language queries across all data sources
Pre-Sales
Which deals above RM200K are at risk this month?
Show top 10 clients by YTD revenue
Which salespeople have low activity relative to pipeline?
What changed in pipeline versus last week?
Which inactive clients have the highest recovery potential?
Post-Sales & Ads
Which ad campaign has the best ROAS this month?
Compare Google vs TikTok ad spend efficiency
Which campaigns are underperforming vs target ROI?
Show revenue breakdown by product and segment
Traffic & Social
What are the top traffic sources this week?
Which social platform has the highest engagement rate?
Forecast Q2 2025 revenue risk based on current pipeline
Data Sources
Google Sheets
Live
GA4
Live
Google Ads Mgr
Live
BigQuery
Live
TikTok Ads
Live
Sprout Social
Delayed
Recent Sessions
At-risk deals — Q1 analysis
14 mins ago
Maxis account deep-dive
2 hours ago
Ads performance Feb 2025
Yesterday
Pipeline vs last month
Yesterday
Top traffic sources — March
2 days ago
Astro One AI is ready
● All sources live
Ask me anything about your pipeline, revenue, ads, traffic, or client health.
I have live access to Google Sheets, GA4, Google Ads Manager, BigQuery, and TikTok Ads data.
Which deals above RM200K are at risk this month?
⚠ 3 deals totalling RM 8.7M are at high risk of slipping past March — all stalled beyond 25 days with no recorded CRM activity.
3
At Risk
RM 8.7M
Combined Value
32d
Avg Stall
Q1
Target Quarter
Deals flagged using three signals: days since last CRM activity, stage duration vs pipeline benchmark, and
email engagement drop-off from Google Sheets pipeline data. Ahmad R. has zero CRM entries in 5 weeks.
| Deal | Value | Stage | Owner | Stall | Competitor | Risk |
|---|---|---|---|---|---|---|
| Astro Arena | RM 2.4M | Proposal | Ahmad R. | 34d | Rumoured active | Critical |
| MyEG Services | RM 2.1M | Negotiation | James O. | 28d | None detected | High |
| Digi-X Media | RM 4.2M | Proposal | Priya S. | 25d | None detected | Medium |
Risk Rule Applied: Flagged when no CRM activity logged >21d at Proposal stage or >14d at Negotiation.
Ahmad R. has 0 CRM entries for 5 consecutive weeks — immediate escalation recommended.
Show top 10 clients by YTD revenue
📊 Top 10 clients account for RM 74.5M (78% of YTD revenue). 2 accounts showing declining trend and below-threshold engagement.
RM 74.5M
Top 10 Revenue
78%
Revenue Share
2
Declining
8
Healthy
| # | Client | YTD Revenue | vs LY | Health | Last Touch |
|---|---|---|---|---|---|
| 1 | Maxis Bhd | RM 12.4M | +18% | 92 | 2d ago |
| 2 | Celcom Axiata | RM 10.8M | +12% | 88 | 1d ago |
| 3 | Petronas | RM 9.6M | +9% | 85 | 3d ago |
| 4 | CIMB Group | RM 7.2M | +6% | 79 | 5d ago |
| 5 | Digi Telecom | RM 5.1M | −3% | 71 | 7d ago |
| 6 | TNB | RM 4.9M | +11% | 90 | 1d ago |
| 7 | RHB Bank | RM 4.2M | +2% | 68 | 12d ago |
| 8 | Watsons MY | RM 3.8M | −8% | 44 | 45d ago |
| 9 | Axiata Group | RM 3.6M | +7% | 82 | 4d ago |
| 10 | MyEG Services | RM 2.9M | −5% | 55 | 18d ago |