analytics-workaroundslisted

# Analytics Workarounds ## Purpose Enable product managers to access, analyze, and report on analytics data even when they lack direct access to tools like GA4, Looker, or BigQuery. Uses Zapier MCP as a data bridge to extract metrics into Google Sheets, then analyzes with Claude. ## When to Use - You need GA4 data but don't have direct console access - Looker dashboards are admin-gated and you need metrics now - Building a recurring analytics pipeline without engineering help - Pulling data for a stakeholder update or sprint review - Comparing metrics across time periods for trend analysis ## Examples **Example 1: GA4 via Zapier MCP** ``` User: "Pull last week's page views for the courses section" Claude: [Uses analytics-workarounds] Using Zapier MCP → Google Analytics 4 → Run Report... Courses pageviews (Feb 10-16, 2026): | Page | Views | Avg Time | Bounce | |:----------------------|:-------|:---------|:-------| | /courses | 12,450 | 2:34 | 32% | | /courses/intro-101 | 8,230 | 4:12 | 18% | | /dashboard | 6,890 | 1:45 | 41% | Week-over-week: +8% total views, -3% bounce rate. Writing to "Analytics Exports" Google Sheet... ``` **Example 2: Subscriber Metrics** ``` User: "How are our subscriber numbers trending?" Claude: [Uses analytics-workarounds] Reading from "Subscriber Tracking" sheet via Zapier MCP... | Month | Total Subs | Net New | Churn | MRR | |:--------|:-----------|:--------|:------|