January Spring is a marketing agency specializing in programmatic advertising, social media campaigns, and search & content advertising. They focus on bidding exclusively on premium, reputable inventory across multiple channels including web, mobile apps, local media, TV, radio, and niche ad networks.
They partnered with us to develop a client-facing data visualization platform that enables their customers to monitor marketing campaigns in real time. The platform centralizes diverse marketing metrics into interactive dashboards, allowing users with role-based access to track performance, spot trends, and gain actionable insights instantly. This self-service model empowers clients to make informed decisions while reducing dependency on manual reporting.
Designed to accommodate different user roles, the platform offers tailored dashboards for both operational teams and executives. It features scalable data pipelines, robust data modeling, and intuitive visualizations that adapt to the evolving marketing landscape. Additionally, this solution opened new revenue streams for January Spring by enabling subscription-based access for their clients, transforming campaign monitoring into a monetizable service.
Before Implementation
Marketing data scattered across multiple platforms and sources, causing inconsistent reporting.
Complex KPIs involving diverse metrics required precise data modeling and transformation for accurate reporting.
Varied user roles demanded dashboards with different levels of detail and access control.
Key Improvements
Implemented a centralized BigQuery data warehouse that integrates and harmonizes all marketing data, ensuring consistency and reliability.
Developed customized data models and automated transformation routines that deliver precise, trustworthy KPIs aligned with business goals.
Created role-based dashboards with segmented user access, enhancing security and providing relevant insights tailored to each audience.
Project Overview
1.
Data Warehouse
Secured GCP access and service accounts to connect real-time data from Google Ads, Meta Ads, Programmatic, Video, STV, Audio, Paid Social, and Paid Search. Reviewed dashboards and KPIs to define requirements for a centralized cloud data warehouse.
2.
Data Modeling
We built data transformation routines and workflows that cleaned, structured, and prepared data to align with defined KPIs, ensuring accuracy and performance.
3.
Customer Portal
We designed a branded data portal, focusing on user experience improvements including menu navigation and login functionality. This portal facilitates easy access for both internal teams and external clients.
4.
Dashboards Development
Two main dashboards were developed: the “Bold Dashboard” for detailed operational metrics and the “Executive Dashboard” for strategic overviews. Both incorporate advanced filters and row-level security to ensure data isolation.
Superset
BigQuery
Google Cloud
Fivetran
Technologies used
Christopher Tippie
Head of IT
Having our own branded marketing portal has transformed the way we serve our clients. It gives them real-time access to their campaign data with secure, role-based permissions, enhancing transparency and trust. Plus, the platform has opened a new revenue stream through subscription monetization.
