Automated Analytics Pipeline for Wellness Website Insights

Python · GA4 API · GSC API · Automation

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.

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.

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.

GA4 Data API integration (sessions, users, pageviews, engagement)

Google Search Console API integration (clicks, impressions, CTR, position)

Auto-generated marketing insights engine

✓ 66.8% engagement rate (vs ~50% industry avg)

✓ 12.6 min avg session duration

✓ 21 custom MailerLite email capture embeds

✓ Automated weekly analytics via Python