The Billboard Company
The Reality
Real-time inventory from three different systems
⚠️ What Was Actually Happening
Sales reps sell advertising space on billboards.
Availability data lived in Snowflake. Client data in AdManager. CRM in HubSpot.
Building a proposal meant checking three systems manually.
Contracts required copy-paste from proposals to their internal system.
Map visualizations lived in yet another tool.
Reps wanted one place to do their job.
The reps need to see billboard availability without leaving HubSpot.— The requirement that defined everything
📋 The Symptoms
- Sales reps context-switching between four systems
- Proposal building was manual and error-prone
- No visibility into what inventory was actually available
- Contract submission required manual data transfer
- Response time to advertisers suffered
📍 Where They Are Now
✓ What's Different
- → Three custom HubSpot UI Extensions running in production
- → Snowflake integration delivers real-time inventory availability
- → Reps build proposals without leaving the deal record
- → Map visualization embedded directly in HubSpot
- → AI-powered campaign recommendation engine in development
~ What's Still Messy
- → Complex OAuth and API authentication still fragile
- → Rate limits and timeouts need constant tuning
- → AdManager API changes can break workflows overnight
The Pattern
When your sales process requires four systems, you don't have a process — you have chaos with extra steps. Integration isn't about connecting systems. It's about making work feel like one flow.
Quick Facts
- Industry
- Outdoor Advertising / Media
- Team Size
- Multi-market sales team
- Status
- Active
- Patterns Identified
- 3
Universal Patterns
This story reveals patterns seen across industries:
More Transformation Stories
Every organization is in the middle of this.
This story is anonymized. The organization is real. The challenges are universal.