Automated Analytics Reporting — Zero-Touch Weekly Delivery
Built a Python-based analytics pipeline that pulls from GA4 and Google Search Console APIs, generates dark-themed HTML reports with marketing insights, and runs on Windows Task Scheduler with zero manual intervention.
The Challenge
Needed weekly analytics reports for Many Words One Voice (my wellness content platform) but manually pulling data from GA4 and Search Console, formatting it, and generating insights was eating hours that could go toward content and growth.
The Solution
Built a 637-line Python script that authenticates with both GA4 and Google Search Console APIs, pulls audience metrics, engagement data, traffic sources, top pages, and search visibility data — then generates a fully styled dark-themed HTML report with auto-generated marketing insights (not canned text — actual data-driven recommendations based on the numbers).
The report runs automatically via Windows Task Scheduler, delivering formatted analytics with sections for audience overview, search visibility, top pages by engagement, top pages by search, traffic source breakdown, device breakdown, and actionable marketing insights — all without touching a button.
What I Built
- GA4 Data API integration (sessions, users, pageviews, engagement)
- Google Search Console API integration (clicks, impressions, CTR, position)
- Auto-generated marketing insights engine
- Dark-themed HTML report generation
- Windows Task Scheduler automation
- Topic cluster detection from search queries
Want results like this for your business?
A $500 SEO Health Check gives you a clear, prioritised action plan in 30–45 minutes. No jargon. No contracts.
Book Your Health Check → ← Back to all case studiesWant results like this?
Whether you need a full SEO health check, ongoing visibility management, or someone to look at your site and tell you what’s broken — I’d love to hear what you’re working on.