Unified Analytics Platform / Webpulse Analytics Dashboard
A private internal product demonstrating applied AI, analytics engineering, search intelligence, and global marketing operations leadership. The detailed mockups below are preserved from the original project page so the case study shows the actual dashboard views, workflows, and reporting concepts.
Challenge
Marketing insight was spread across analytics, search, and regional reporting workflows, making page-level decisions slower than they needed to be.
Solution
Webpulse unified GA4, Google Search Console, Bing Webmaster data, exports, and AI-assisted analysis into one internal dashboard experience.
Role
Product strategy, architecture, API integration, interface design, analytics workflows, and AI-enabled reporting direction.
Webpulse Analytics Dashboard
A single-pane analytics platform aggregating Google Search Console, GA4, and Bing Webmaster Tools — built for a global marketing team managing 30+ regional web properties.
Screens
Dashboard overview
Cross-source KPI view — GA4 sessions, GSC clicks/impressions, and Bing performance in one page with period-over-period comparison.
Overview
Search Console
Full GSC data with period comparison, trend charts, device split, and a sortable query/page/country/device table. Exports to a 4-sheet XLSX workbook.
Search Console
GSC| Query | Clicks | Impressions | CTR | Position |
|---|---|---|---|---|
| endpoint security | 14.8K | 2.11% | 3 | |
| ai security platform | 11.2K | 2.21% | 4 | |
| threat detection software | 9.4K | 2.07% | 6 |
Page Analysis
Enter any URL — the tool auto-detects the matching GSC property and returns a side-by-side comparison of GSC and GA4 metrics for that specific page.
Page Analysis
URL LOOKUPEnter specific page URLs to compare their GSC and GA4 metrics side-by-side.
Ask AI
Natural language analytics chat powered by GPT-5.4. Pre-fetches live GSC and GA4 context before every message — so the model answers about your actual data, not generic advice.
Capabilities
What it does
Built around the specific reporting needs of a global marketing team — not a generic analytics wrapper.
Unified Dashboard
Cross-source KPI overview pulling GA4 sessions, GSC clicks/impressions, and Bing performance with period-over-period comparison in a single view.
Search Console Deep Dive
Full GSC analytics with sortable tables for queries, pages, countries, and devices. One-click export to a 4-sheet XLSX workbook via SheetJS.
Page Analysis
Enter any URL — the tool auto-detects the right GA4 property and GSC site, normalizes locale variants, and shows side-by-side metrics for that page.
AI Analytics Chat
GPT-5.4 chat interface that pre-fetches live GSC + GA4 context before every message. Ask in plain English about rankings, traffic trends, and CTR gaps.
Domain Scanner Report
Reproduces a PowerBI security scanner report inside the dashboard. Tracks CTA tile interactions via GA4 event parameters across all locale sites.
Verticals Report
Side-by-side GSC + GA4 comparison across 6 solution vertical pages across all regional sites. One-click interactive HTML report export.
Technical
How it's built
Modular FastAPI backend with a zero-dependency vanilla JS frontend. Runs in Docker with OAuth 2.0 and service account authentication to Google APIs.
- ✦ Modular FastAPI routers — one file per data source
- ✦ Same URL normalization logic in frontend and backend for consistent GSC lookups
- ✦ GA4 hostname + path-prefix filtering prevents cross-domain data bleed in shared properties
- ✦ OAuth 2.0 Web App flow for GSC with auto-refresh; Service Account for GA4
- ✦ Corporate SSL proxy handled via
REQUESTS_CA_BUNDLE+NO_PROXY
- ✦ Microsoft Clarity integration (parked — awaiting API fix on Microsoft's end)
- ✦ BrightEdge SEO data integration
- ✦ Expanded custom report library
- ✦ Scheduled email digests