The Media Company Outdoor Advertising
Real-Time Inventory Search
Sales reps needed to check real-time billboard availability from a data warehouse without leaving HubSpot. Every proposal required switching between four systems.
⚠
The Old Way
1 Open Snowflake dashboard in another tab
2 Copy date range and market parameters
3 Run query and wait for results
4 Copy availability data back to proposal
5 Repeat for each billboard location
6 Cross-reference with map visualization tool
Every step is a chance for errors. Every context switch costs time. Every manual entry is friction your team learns to resent.
✓
The Solution
A custom UI card embedded directly on Deal records that queries Snowflake in real-time, displays availability with visual occupancy indicators, and integrates map visualization — all without leaving HubSpot.
Capabilities
✓ Real-time Snowflake data warehouse queries
✓ Date range selection with calendar UI
✓ Occupancy visualization with progress bars
✓ Multi-tab interface for different query types
✓ Embedded map integration
✓ JWT OAuth2 authentication handling
See It In Action
An interactive mockup of what this looks like inside HubSpot
Impact
15 min → 30 sec
Time to check availability
4 → 1
Systems required
Eliminated stale data errors
Proposal accuracy
Technical Highlights
- • OAuth2 token refresh with automatic retry
- • GraphQL queries to Snowflake API
- • 3,700+ lines of React with complex state management
The Pattern
"When your sales process requires checking external databases, bring the database to the CRM — not the other way around."
UI extensions are often part of larger transformation journeys.
See Active Transformations