From scattered sheets to a real system.
A full-stack advertising platform built for Eastern Idaho's leading news outlet - replacing hours of manual work with live dashboards, a dynamic media kit, and clean data for 200+ advertisers.
A thriving news outlet running its
ad business on spreadsheets.
East Idaho News is the dominant digital news outlet in Eastern Idaho, 14.7 million annual visitors, 117.4 million pageviews, and a growing advertising business serving over 200 clients.
But behind the scenes, the operation was fragile. Performance reports were assembled manually. The media kit was a static PDF that went stale the moment it was exported. Spreadsheets were scattered across inboxes.
Sales reps were spending hours on tasks that should take seconds. Clients received inconsistent reports. Pricing updates required developer involvement. The tools didn't match the size of the business.
- Manual report generation, hours of work per client, per month
- Static PDF media kit, outdated the moment it was shared with a prospect
- Fragmented spreadsheets, no single source of truth for ad data
- Pricing bottlenecks, any update required a developer
- No client transparency, advertisers had no visibility into performance
One platform.
Every tool they needed.
A full-stack web application using React, TypeScript, Supabase, and Tailwind CSS - the single source of truth for East Idaho News's advertising business.
Dynamic Media Kit
A 10+ page interactive report covering traffic, demographics, ad pricing, and packages. Selectable PDF export, choose which sections to include. Every stat editable from an admin panel, no developer needed.
Client Performance Dashboards
Per-client dashboards pulling live data from Supabase, impressions, clicks, CTR, and trends over configurable date ranges. Interactive charts and one-click branded PDF export.
Ad Manager Dashboard
Centralized view across all 200+ advertisers. Filter by client, view aggregate metrics, and import bulk data via CSV from Google Ad Manager exports. No more switching between files.
Custom Account Reports
Dedicated report pages for key accounts, Saatchi, Teton, and Sports Sponsorship, each tailored to the specific client's needs, data, and branding requirements.
Security & Access Control
Role-based access with Supabase RLS policies. Admin-only routes, session timeout, CSRF protection, input sanitization, rate limiting, and a pending user approval workflow.
UX & Polish
Dark/light theme toggle, animated backgrounds, fully responsive across desktop and tablet. Searchable client selector with lazy loading for large advertiser lists.
Same data.
Completely different experience.
This is what an advertiser used to receive, versus what they get now.
Operations that finally
match the scale.
Real outcomes for the sales team, the advertisers, and the business.
Sales Enablement
Sales reps generate a customized, professional media kit PDF in seconds. Previously a manual process taking hours per prospect.
Real-Time Pricing
Ad package pricing and availability can be updated instantly by non-technical staff, eliminating developer bottlenecks completely.
Client Transparency
Advertisers get clear, data-driven performance reports that build trust and drive renewals. No more "trust us", now it's show me the numbers.
Operational Efficiency
CSV import and centralized dashboards replaced scattered spreadsheets. Hours saved per week across the advertising team.
Built to Scale
The platform supports 200+ advertisers and growing, with paginated data loading and optimized queries. Infrastructure that grows with the business.
Production-grade tools.
No shortcuts.
Every technology choice was made for a reason, reliability, developer experience, and the ability to maintain and extend the platform without starting over.
Supabase handles auth, database, RLS policies, and edge functions. React 18 with TypeScript keeps the UI fast and the codebase maintainable. jsPDF + html2canvas powers the PDF exports with pixel-perfect fidelity.
Keep exploring the work.
Need a platform
built properly?
Whether it's a web app, a website, or a full visibility system - we build things that work and keep working.