Introduction
The ACES Awards Lead Management System represents a comprehensive approach to managing award nomination campaigns at scale. As organizations across the APAC region seek recognition through prestigious awards programs, the need for sophisticated lead tracking and team coordination becomes paramount.
The Challenge
Award nomination campaigns involve complex multi-stage processes where leads progress through numerous touchpoints—from initial outreach to final nomination submission. Traditional CRM systems failed to capture the nuanced stages of award nominations, leading to missed follow-ups, unclear team responsibilities, and ultimately, lower conversion rates. The challenge was to build a system that could handle 24 distinct funnel stages while providing real-time visibility for executives, managers, and individual callers.
The Solution
We developed a purpose-built CRM platform with role-based dashboards that cater to different organizational levels. C-level executives get strategic overviews with conversion analytics, managers receive team performance metrics and workload distribution, while callers focus on their daily tasks with automated reminders and communication tools.
Technical Deep Dive
Implemented Supabase Row Level Security (RLS) policies to ensure data isolation between user roles while maintaining seamless data access patterns
Built a reactive 24-stage funnel system using React Query for optimistic updates and real-time synchronization across all connected clients
Designed a PostgreSQL schema with efficient indexing for lead queries, supporting filtering by stage, assignee, overdue status, and date ranges
Created automated reminder system using Supabase Edge Functions and cron jobs to detect overdue follow-ups and send notifications
Integrated email template management with variable substitution for personalized outreach at scale
Key Features
24-Stage Lead Funnel
Granular tracking from initial contact through nomination submission with stage-specific actions and requirements
Role-Based Dashboards
Tailored views for C-Level (strategic metrics), Managers (team oversight), and Callers (daily tasks)
Communication Hub
Unified logging for calls, emails, and WhatsApp interactions with full conversation history
Bulk Operations
CSV import/export, bulk lead assignments, and mass status updates for efficient data management
Real-Time Analytics
Live conversion rates, team performance comparisons, and funnel bottleneck identification
Results & Impact
- ✓Reduced lead response time by 60% through automated reminder systems
- ✓Increased nomination conversion rate by 35% with better stage tracking
- ✓Enabled team of 50+ callers to manage 10,000+ leads efficiently
- ✓Decreased manager oversight time by 40% through automated reporting
Lessons Learned
"Role-based access control should be designed early in the architecture phase to avoid costly refactoring"
"Real-time features require careful consideration of database indexing and query optimization"
"User training and documentation are as important as the technical implementation for enterprise adoption"
Conclusion
The ACES Awards Lead Management System demonstrates how purpose-built solutions can dramatically improve specialized business processes. By understanding the unique requirements of award nomination campaigns and building features specifically for that workflow, we achieved significant improvements in conversion rates and team efficiency.
Interested in a Similar Project?
Let's discuss how I can help bring your ideas to life.
Get in Touch