← backData & AnalyticsFounding · Free forever

Analyze Google Analytics / attribution data

Always ask for trend, not snapshot — GA4 snapshots lie.

by @whitney · recommended tool Claude Co-Work · 0 unlocks

You'll need

CLAUDE SKILLS

xlsx

EXAMPLES · WHAT THIS PROMPT PRODUCES

Sample output

**GA4 Analysis — Brightleaf Coffee (last 90 days)**

**Traffic by channel & trend**
- Organic Search: 41% of sessions, **+18% QoQ** — your fastest-growing source.
- Paid Social: 24%, **−9%** — declining efficiency, likely creative fatigue.
- Direct: 19%, flat. Email: 11%, **+22%**. Referral: 5%.

**Top converting pages**
1. /products/cold-brew-kit — 4.1% CVR
2. /bundles/starter — 3.8%
3. Homepage — 1.9% (high traffic, low CVR — opportunity)

**Funnel drop-offs**
View → Add-to-Cart: 28%. Cart → Checkout: 61%. **Checkout → Purchase: 47%** — the biggest leak. Mobile checkout completes at 38% vs. 59% desktop.

**Assisted conversion paths**
Email assists 34% of paid-social conversions — paid social is being under-credited in last-click. Organic frequently opens the path; email closes it.

**5 optimization ideas (est. impact)**
1. Fix mobile checkout friction (47%→55% could add ~$11K/mo). **High.**
2. Refresh paid-social creative — fatigue is dragging CVR. **High.**
3. Add email capture earlier — it's your closer. **Medium.**
4. Rework homepage CTA toward /cold-brew-kit. **Medium.**
5. Shift last-click budget toward organic content given its path-opener role. **Medium.**

*(Note: read as a 90-day trend, not a single snapshot — the paid-social decline only shows up in the delta.)*

PRICE HISTORY0 cr · current

PROMPT TEMPLATE · v1.0.0

Attached: GA4 export.
Analyze:
- Traffic by channel and trend (last 90 days)
- Top converting pages
- Funnel drop-offs
- Assisted conversion paths
- 5 specific optimization ideas with estimated impact.