Power BI
Marketing performance and budget dashboard for JTX Fitness
Consolidated Google Ads and Google Analytics in BigQuery and built a Power BI dashboard for campaign performance and spend-versus-budget tracking.
- Client
- JTX Fitness
- Industry
- Fitness / e-commerce, United Kingdom
- Status
- Delivered
- Duration
- 2 months
The problem
Ads and analytics data were separate, so spend could not be tied to results or checked against budget.
What we built
- BigQuery as the central marketing data store
- Aligned campaign, session and conversion definitions
- Power BI dashboard with budget tracking and drill-down
Challenges we solved
- Different metric definitions across sources
- Dashboard performance
Results
- Delivered and in use
- One view of marketing performance and budget
Technology stack
- BigQuery
- Google Ads
- Google Analytics
- Power BI
“Working with [the West AI team] was an absolute pleasure. Communication throughout the project was clear, timely and professional. I initially approached them with an idea for an Excel dashboard, but they thoughtfully suggested an alternative approach using Google BigQuery and Power BI. The solution provided full automation and far more flexibility in data manipulation.”
Need something similar?
Free 30-minute scoping call. We reply within 24 hours.
Talk to us about Power BI