Ga Report

GA Report

Pull GA4 data and compile a client-ready benchmark report.

Usage

/ga-report NORE
/ga-report NORE --property 542141660
/ga-report NORE --days 30
/ga-report NORE --property 542141660 --days 90

Arguments:

• PROJECT — project prefix (required). Used to look up client name and output path.
• --property ID — GA4 property ID (numeric). If omitted, reads from project CLAUDE.md or prompts.
• --days N — reporting period in days (default: 90).

Auth setup (one-time per workspace)

The fetcher authenticates via a Google service account.

Requirements:

1. A Google Cloud project with the Google Analytics Data API enabled
2. A service account with the JSON key downloaded
3. The service account email added as a Viewer on the GA4 property
4. GOOGLE_SA_JSON=/path/to/sa.json added to studio/.env

Recommended key location: ~/.config/bain-studio/google-sa.json (outside any git repo)

If GOOGLE_SA_JSON is not set, ask Mark for the path before proceeding.

Steps

1. Parse arguments

Extract PROJECT, --property, and --days from the invocation. Uppercase the prefix.

2. Look up project details

Read the project file from docs/projects/{slug}.md (match by prefix). Extract:

• name: — client/project name for the report title
• Any GA property ID if noted

If --property was not supplied and no property ID is found in the project file, ask for it.

3. Check credentials

source /media/data/dev/bain-studio/studio/.env
echo $GOOGLE_SA_JSON

If GOOGLE_SA_JSON is empty or the file does not exist, stop and explain the one-time auth setup above.

4. Fetch GA4 data

python3 /media/data/dev/bain-studio/studio/collectors/ga4_report.py \
  --property {PROPERTY_ID} \
  --sa-json {GOOGLE_SA_JSON} \
  --days {DAYS}

If this fails with a permission error, the service account likely hasn't been added to the GA4 property. Show the service account email from the JSON file and instruct Mark to add it in GA4 → Admin → Property Access Management.

Capture the JSON output into a variable for analysis.

5. Analyse the data

Read the JSON and calculate:

Period-over-period changes — for each metric in current vs previous:

pct_change = (current - previous) / previous * 100

Format as +X.X% or -X.X% with trend arrow (↑ / ↓ / →).

Channel shares — sessions per channel as % of total sessions.

Device split — mobile/desktop/tablet as % of sessions.

Engagement summary:

• Engagement rate (GA4) = engaged sessions / total sessions
• Average session duration in minutes:seconds
• Bounce rate

6. Generate action points

Based on the data, generate 5-8 prioritised action points. Use these rules as a starting point — apply judgment:

Label each: [HIGH], [MEDIUM], or [LOW] based on impact.

7. Write the report

Determine output path:

source /media/data/dev/bain-studio/studio/.env
REPORT_DIR="$STUDIO_CONTENT_DIR/reports/{project-slug}"
mkdir -p "$REPORT_DIR"
REPORT_PATH="$REPORT_DIR/ga-benchmark-$(date +%Y-%m-%d).md"

Write a markdown report with this structure:

---
title: Analytics Benchmark — {Client Name}
subtitle: {Start Date} – {End Date} ({N} days)
date: {today}
project: {PREFIX}
---

## Executive Summary

{3-5 bullet points summarising the headline findings. Be specific — include numbers.
Example: "Organic search drives 41% of sessions, up 12% on the previous period, indicating
strong SEO performance. However, mobile users show a 58% bounce rate against a 34% desktop
rate — a gap that warrants investigation."}

## Key Metrics

| Metric | {Period} | {Prev Period} | Change |
|--------|----------|---------------|--------|
| Sessions | {n} | {n} | {±%} ↑↓ |
| Users | {n} | {n} | {±%} |
| New Users | {n} | {n} | {±%} |
| Pageviews | {n} | {n} | {±%} |
| Engagement Rate | {x}% | {x}% | {±pp} |
| Avg. Session Duration | {m:ss} | {m:ss} | {±%} |
| Bounce Rate | {x}% | {x}% | {±pp} |

## Traffic by Channel

| Channel | Sessions | Share | Users | Engagement |
|---------|----------|-------|-------|------------|
{rows sorted by sessions descending}

## Top 10 Pages

| Page | Sessions | Views | Avg. Duration | Engagement |
|------|----------|-------|---------------|------------|
{rows}

## Audience

### Devices

| Device | Sessions | Share | Engagement |
|--------|----------|-------|------------|
{rows}

### Top Countries

| Country | Sessions | Users |
|---------|----------|-------|
{top 5-8 rows}

{if events}
## Key Events

| Event | Count | Users |
|-------|-------|-------|
{rows}
{end if}

## Action Points

{For each action point:}
**{N}. {SHORT TITLE}** `[PRIORITY]`

{One or two sentences explaining what the data shows and what to do about it. Be specific.}

---
{Repeat for each action point}

8. Brand the report

/brand-doc {REPORT_PATH}

9. Confirm

Report:

GA report written: {REPORT_PATH}
PDF: {PDF_PATH}
Period: {start} – {end} ({N} days)
Sessions: {n} ({change})

Notes

• The service account email must be added to the GA4 property before running. Google shows an error 403 if not.
• Reports are written to $STUDIO_CONTENT_DIR/reports/{project-slug}/ — Dropbox-synced, gitignored.
• The --days 90 default is a good benchmark period. Use --days 30 for monthly reports.
• If the property has no data (new site), the report will note it and suggest baseline setup actions instead.