Marketing and Inventory Dashboard Solution
Transforming scattered data into actionable insights through connected dashboards, delivering 80% time savings and preventing costly stock issues for a leading UK pharmaceutical marketing agency.
Project Overview
£104,081
Ad Sales Tracked
895,558
Inventory Units
67.7%
Stock Health Score
80%
Time Reduction
The Challenge
A UK pharmaceutical marketing agency was struggling with fragmented data systems that prevented them from making informed decisions about their Amazon operations.
No Amazon Ad Visibility
Unable to track Amazon advertising performance or ROI across campaigns.
Poor Inventory Tracking
No real-time visibility into stock levels across 895,558 inventory units.
Scattered Data Sources
Data spread across multiple systems with no unified view.
Stock Management Issues
Overstocking and stockouts causing financial losses (54,291 excess units).
Our Solution
We designed and implemented two connected dashboards using BigQuery and Looker Studio, providing real-time insights and automated reporting
Marketing Analytics Dashboard
Real-time Amazon ads performance tracking with comprehensive KPI monitoring including ACoS, TACoS, and conversion rates.
Automated Data Pipeline
Both dashboards update automatically to maintain data freshness and provide real-time insights.
Inventory Management Dashboard
Custom health score system for each product with automated alerts to prevent stock issues and optimize inventory levels
Unified Data Source
Single source of truth for both marketing and operations teams to make data-driven decisions
Technology Stack
Measurable Results
80% Time Reduction
Dramatic decrease in manual reporting time, freeing up resources for strategic activities
Complete Visibility
Clear insights into ad performance and inventory status across all product lines
Stock Issue Prevention
Eliminated costly overstocking and stockout problems through predictive analytics.
Faster Decision Making
Real-time data enables quick, informed decisions for both marketing and operations teams
CONVERSION RATE
23.82%
Marketing campaign effectiveness
STOCK HEALTH
67.7%
SKUs sold & in stock
£104,081
Total revenue tracked
