One Dashboard.
Five Data Sources. Zero Guesswork.
How we built Active Iron a real-time marketing intelligence platform that unified GA4, Google Ads, Meta Ads, Shopify, and MailerLite - replacing scattered spreadsheets with instant, actionable clarity across Ireland and the UK.
The Impact
From siloed platforms to a unified command centre. Real-time data driving real decisions.
Industry
- Health & Wellness
- DTC eCommerce
- Supplements
Integrations
- Google Analytics 4
- Google Ads
- Meta Ads
- Shopify
- MailerLite
Capabilities
- Real-Time Reporting
- Multi-Market Analysis
- AI-Powered Insights
- Revenue Attribution
Deliverable
- Custom Web Dashboard
- Live at activeiron.lovable.app
- Status: Ongoing
The Challenge
Active Iron's marketing data was scattered across five disconnected platforms - and nobody had the full picture.
The team was toggling between Google Analytics, Google Ads, Meta Ads Manager, Shopify admin, and MailerLite - each with its own interface, its own date ranges, and its own version of the truth. Reporting was manual: exported CSVs stitched together in spreadsheets, always a week behind.
Operating across Ireland and the UK added another layer of complexity. Performance metrics needed to be segmented by country, but doing so manually was time-consuming and error-prone. The team couldn't quickly answer basic questions: "How did our Irish campaigns perform vs. UK this week?"
They needed a single source of truth - a real-time, always-on platform that could pull every channel together, filter by market, and surface the metrics that actually mattered. Not another static PDF. A living dashboard.
The Solution
Unified Marketing Command Centre
We designed and built a custom web application that pulls live data from all five marketing platforms via secure API integrations. No more tab-switching. No more stale exports. One URL, every metric, always current.
Multi-Market Filtering
Every data view supports country-level filtering - Ireland, UK, or combined. Shopify orders, GA4 traffic, ad performance - all segmented by market at the click of a button.
Campaign Objective Splits
Meta Ads metrics are split by campaign objective - Awareness vs. Conversions - so CPC and CTR are only shown where they're meaningful. No more muddied averages across ad types.
AI-Powered Analysis
Built-in AI generates written performance summaries and strategic recommendations based on live data - for Google Ads, Meta creative performance, and cross-channel trends.
Intelligent Traffic Classification
Raw GA4 source/medium data is automatically cleaned, relabelled, and grouped - ChatGPT and Perplexity visits are classified as "AI" traffic, LinkedIn referrals as "Organic Social", and subscription platform hits are properly attributed. Duplicate sources are merged. The result: a clean, accurate traffic breakdown without manual intervention.
Visual Proof
Data Architecture
Five platform APIs feed into a single, always-live dashboard. No exports. No delays. No guesswork.
Monthly Snapshot
Every key metric - from 22.8K website users to 186 Shopify orders to 57% email open rates - visible instantly.
The Results
Before vs. After
- ✗ Manual CSV exports from 5 platforms
- ✗ Reporting always a week behind
- ✗ No country-level segmentation
- ✗ Awareness and Conversion metrics muddled together
- ✗ No AI-powered analysis or recommendations
- ✗ Messy traffic source attribution
- ✓ One live dashboard, all platforms unified
- ✓ Real-time data, always current
- ✓ Instant Ireland vs. UK filtering
- ✓ Meta metrics split by campaign objective
- ✓ AI-generated insights and strategic recommendations
- ✓ Clean, intelligent traffic source classification
Built to Scale, Not to Break.
This isn't a static report or a one-off build. It's a living product - architected with secure backend functions, date-range filtering, and intelligent data processing that evolves with the business.
Secure Edge Functions
All API keys and credentials stored securely in cloud functions - never exposed to the browser.
Flexible Date Ranges
Custom date picker with presets (7d, 14d, 30d, 90d) - every section responds to the selected period instantly.
AI That Reads Your Data
Not generic summaries - AI models consume live campaign data and generate specific, actionable recommendations.
What the Dashboard Delivers
Every view is purpose-built for a specific decision the team needs to make.
Consolidated Overview
Cross-channel funnel from total users → sessions → orders → revenue. Includes GA4, Shopify, and ad spend in one view.
Google Ads Performance
CPC, CTR, conversions, ROAS - with campaign-level breakdown and AI-generated strategic recommendations.
Meta Ads (Split by Objective)
Awareness shows reach, impressions, thruplays. Conversions shows CPC, CTR, cost per conversion. Clean separation, clean decisions.
Shopify Revenue
Orders, revenue, AOV, top products - filterable by Ireland or UK. Visual trends over time with daily granularity.
Email Performance
MailerLite campaign metrics: open rates (57%+), CTR, subscriber counts, and individual campaign breakdowns.
Traffic Analysis
Intelligent source/medium classification - with AI traffic detection, duplicate merging, and clean attribution across all channels.
"We went from toggling between five platforms every morning to opening one dashboard. Everything we need is right there - live, segmented by market, and with AI telling us what to do next."
Need a dashboard like this?
We build custom marketing intelligence platforms that replace spreadsheet chaos with real-time clarity.
Let's Talk