BillboardIQ
A Precision-Engineered Management Ecosystem for Out-of-Home Advertising
A comprehensive, end-to-end management platform that handles the entire campaign lifecycle—from initial briefing and inventory site selection to real-time availability tracking and multi-format financial reporting. Built for data accuracy, role-based visibility, and high-fidelity automated exports.
Industry
Out-of-Home (OOH) Advertising
Client
Multi-Country OOH Media Operator
Engagement
End-to-end Platform Architecture & Production
Outcome
80%+ reduction in reporting time
Tech Stack
React 18, TypeScript, Vite, Tailwind CSS, Shadcn UI, Supabase (PostgreSQL), Recharts
The Business Problem
Before BillboardIQ, managing large-scale OOH inventory across multiple countries faced critical operational bottlenecks that threatened efficiency and accuracy.
The client needed a single source of truth that could handle inventory fragmentation, complex availability logic, reporting bottlenecks, and role-based visibility—all in real time.
01.
Inventory fragmentation across Australia and New Zealand with varying regional rules
02.
Manual lunar-period availability calculations prone to human error and booking overlaps
03.
Reporting bottlenecks—hours spent on PDF contracts, Excel summaries, PowerPoint proposals
04.
Visibility control—management lacked a bird's-eye view; sales needed focused territory views
Our Approach
We implemented a cloud-native architecture using a modern TypeScript stack—React, Supabase, and Tailwind—to ensure precision and real-time responsiveness.
The platform emphasizes data accuracy, role-based visibility, and high-fidelity automated exports across thousands of advertising sites.
01.
Intelligent inventory and geo-visualization
02.
Automated financial reconciliation engine
03.
Lunar-period availability tracking (13 periods × 28 days)
04.
Multi-format export engine (Excel, PDF, PowerPoint)
05.
Role-based command center dashboards
The Solution: BillboardIQ Platform
Intelligent Inventory & Geo-Visualization: Custom geo-logic tags sites by country, with distinct color-coded analytics for AU and NZ revenue splits.
Automated Financial Reconciliation: Logic layer calculates Gross Media, Net Media, and costs—handles proportional distributions for multi-month campaigns and tracks Closed Won revenue against targets.
Lunar-Period Availability Engine: Custom Avails engine on 13-period lunar cycles with slot summation and conflict detection across thousands of digital and static faces.
Multi-Format Export Engine: Excel workbooks, automated PDF contracts with dynamic data, and PowerPoint proposals for sales agents to export campaign site lists into branded decks.
Role-Based Dashboards: Stacked performance charts (Booked vs. Draft media vs. budgets), real-time sales pipeline status, and tailored visibility—Super Admins see global data, Sales Agents see individual metrics.
Technical Architecture
React 18, TypeScript, Vite, Tailwind CSS, Shadcn UI (Radix). Supabase with PostgreSQL, Row Level Security, and Edge Functions. Recharts for financial visualization. Supabase Realtime for instant sync.
Business Impact
From fragmentation to unified control—a single source of truth for OOH advertising operations across Australia and New Zealand.
01.
Unified inventory management for AU and NZ in one platform
02.
80%+ reduction in reporting time via automated exports
03.
Zero booking overlaps through automated slot-summation logic
04.
Real-time visibility into international revenue splits
Why This Matters
At Tech Emulsion, we build precision-engineered management platforms that turn operational complexity into scalable, data-driven systems. BillboardIQ demonstrates how the right architecture can unify fragmented inventory, automate reporting, and empower teams with real-time visibility.