371admin

Challenge

X-Meta operates an out-of-home advertising network on transit screens — hundreds of e-jeep devices in the field, SIMs that expire on different dates, ad campaigns with VAT and withholding tax, and a content team pushing video playlists to specific screens. The pieces lived in five different tools and three spreadsheets.

Solution

• An overview dashboard surfacing the metrics nobody had in one place before: order volume, online devices, SIM expiry alerts within 30/60/90 days, and a 30-day trend chart.
• Campaign and booking management with a 'Create Booking' form that captures the ad details on one side and the full financial side (VATABLE Sales, VAT 12%, WHT %, settlement type, payment status) on the other — calculated as you type.
• Live device monitoring grouped by transport service corporation, showing online/offline status, vehicle details, and per-device data usage.
• A program library with searchable video previews, durations, play limits, and active schedules — so the content team can audit what's deployed without calling ops.
• A 'Play Plan MVP' that imports a charge playplan and links it directly to connected screens, removing a manual mapping step that used to take hours.
• Take-away order management as a board view, plus recruitment and sales documents under the same roof.

Result

Ads ops, finance, and field operations now share one source of truth. SIM cards stop being forgotten until they fail, bookings land with their numbers already reconciled, and the playplan-to-screen handoff is a single click.