Agent skill · data analytics · jeremylongshore
ga4-common-reports
Copy-paste recipes for the 6-7 reports every site owner actually wants: DAU/MAU/WAU, retention cohort, top pages by source, channel attribution, conversion funnel, geo breakdown, device split. Each recipe is a fully-formed Data API request. Trigger with "GA4 DAU", "GA4 retention", "GA4 top pages", "GA4 funnel", "GA4 channel report", "common GA4 reports".
Why this skill is useful
Provides executable scripts for common GA4 reports that automate data retrieval and analysis, which the AI cannot generate on its own.
What it needs
Requires python3 installed locally. Requires google-analytics account access. About 4k tokens when loaded. Last updated 2026-08-07. 2,604 stars on the source repository.
What this skill does
GA4 Common Reports Overview Recipes for the reports that get asked for ~95% of the time. Each one is a complete runReport you can paste, change PROPERTYID, and run. Prerequisite: ga4-auth-setup done. Prerequisites A GA4 Data API credential configured by ga4-auth-setup and granted Viewer access to the target property. Python with google-analytics-data installed and GA4PROPERTYID set to the numeric property ID. A clear reporting window; use completed days for stable comparisons. Instructions The setup block (same for every recipe): Examples 1. Daily Active Users (DAU) — 30-day rolling Why yesterday, not today: today's number is incomplete and will keep climbing through the day. For a clean rolling DAU, end the window at yesterday. 2. MAU / WAU — rolling unique users GA4 doesn't expose MAU as a single metric — you compute it from the same activeUsers rolled up over a wider date range. The trick: a single-row report with no date dimension returns the unique count over the entire window (de-duplicated across days). Stickiness rule-of-thumb: WAU/MAU > 0.5 is good, > 0.7 is excellent, < 0.2 means most users visit once and bounce. 3. Top pages — last 7 days, ordered by pageviews 4. Channel attribution — where did users come from? GA4's default channel grouping has ~12 buckets: Direct, Organic Search, Paid Search, Organic Social, Paid Social, Email, Referral, Display, Video, Affiliates, Audio, etc. Use sessionSource + sessionMedium for finer-grained attribution (e.g. google / organic vs bing / organic). 5. Retention cohort — week 1 / 2 / 3 / 4 return rate GA4 has a built-in cohort exploration in the UI but the Data API doesn't expose it cleanly. The workaround: query DAU per week and compute rolling overlap. The cheap approximation: For true cohort retention (e.g. "of users acquired in week N, what % came back in week N+1, N+2, N+3"), you need event-level data — use ga4-bigquery-export and write the cohort SQL directly. The Data API can't express the join. 6. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills jeremylongshore/ga4-common-reports