Portfolio / January Spring
Marketing Customer Portal
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
- Marketing data scattered across multiple platforms and sources, causing inconsistent reporting.
- Complex KPIs involving diverse metrics required precise data modeling
- 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.
- Developed customized data models and automated transformation routines that deliver trustworthy KPIs and agents
- Created role-based dashboards with segmented user access, enhancing security and providing relevant insights tailored to each audience.
How we did it
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.
Data Modeling
We built data transformation routines and workflows that cleaned, structured, and prepared data to align with defined KPIs, ensuring accuracy and performance.
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.
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.
Payfacto · Payment Solutions · Canada
Travcoding · Travel Tech · United States
CDX Data · Research Solutions · United States