KK Digital Media is a web-based digital signage and fleet advertising management system that connects administrators, fleet partners, and customers on a single platform, digitizing core operations, screen monitoring, impression tracking, ad campaign management, ride/vehicle logging, packages, subscriptions, billing, and reporting.
Admins can manage users and groups with granular role-based permissions, track live impressions across screens on a geographic heatmap, upload and schedule ad creatives, configure packages and currencies, monitor vehicle rides, and review a full activity log of every system action, all from a centralized, dark-themed dashboard built around a secure server with role-based access and APIs.
The Issue At Hand
Before this portal, monitoring screens, impressions, ad campaigns, fleet rides, and billing relied on disconnected spreadsheets and manual reconciliation, with no centralized place to manage users, permissions, or content across a growing partner and customer base.
The platform needed granular role-based access, distinguishing internal admins, fleet partners, and customers, along with reliable handling of bulk data imports (Excel-based impression and ride files) without breaking under load.
No centralized dashboard for screens, impressions, ads, and rides, data spread across spreadsheets
Role-based access control needed for internal admins, fleet partners, and customers
Manual ad creative uploads and package/subscription tracking with no automation
Bulk Excel imports for impressions and rides required flexible column mapping
No unified activity log to audit administrative actions across the system
Currency and regional package configuration needed for multi-market billing
Geographic visibility into screen locations and audience heatmaps was missing
Reliable, scalable handling of large file uploads and concurrent admin sessions
Our Collaboration
Phase 1
Discover
Phase 2
Design
Phase 3
Build
Phase 4
Launch
While analyzing the requirements, the core challenge identified was handling large media and Excel-based data imports efficiently while keeping the portal responsive. Research showed we needed a clear separation between media storage and the application database, with the database holding only metadata, and an extensible role-based permissions model.
Key Activities
Storage vs Database Separation
Identified that cloud/object storage should hold ad creatives and media while the database holds only metadata for performance.
Extensible Role-Based Model
Designed the access model to support internal admins, fleet partners, and customers, flexible enough to add new roles later.
Bulk Import Architecture
Researched flexible column-mapping strategies so Excel impression and ride files could be imported without rigid schema constraints.
Comparable System Research
Reviewed similar fleet and signage platforms to settle on a modular API structure, pagination, and caching for read-heavy reporting pages.
Delivered
Live Overview Dashboard
Real-time revenue, CPM, distance, viewers, hours online, and active screens with a geographic audience heatmap and PDF export.
Users & Groups Management
Role-based user management with company, contact, and status details, plus a Groups module for granular permission control across Admin, Fleet Partner, and Customer tiers.
Vehicles & Rides Tracking
Vehicle records linked to license plates and screen IDs, paired with a Rides module showing total, valid, invalid, and today's rides at a glance.
Impressions Dashboard & Column Mapping
Live impressions analytics with date-range and screen filtering, plus a configurable column-mapping tool for importing Excel impression data.
Ad Creative Management
Upload, edit, download, and organize ad creatives by label, file type, size, and subscription with full version control.
Packages, Subscriptions & Currencies
Configure packages by duration, plays/hour, reach, and price, manage regional subscriptions, and support multiple currencies for global billing.
Documents & Activity Log
Centralized document storage tied to subscriptions, alongside a full activity log auditing every region, currency, and subscription change with timestamps.
Screens & Geographic Mapping
Screen-level monitoring with locality, region, country, status, and speed, visualized on an interactive map with bulk event-trigger and data tools.
Gallery
Built with:
“
We worked with MangoCoders on a full product development project that included development, server deployment, AI integration, web security, and database implementation. We are really happy with the outcome as they quickly understood the requirements and delivered a well-structured, stable, and scalable solution. Communication was smooth and consistent throughout, and they were responsive to feedback and changes. We would happily recommend MangoCoders at any time.
— Jens M.
This project is part of our web development work. See what we can build for you.
