Check a dataset before analysis
Find missing values, inconsistent formats, duplicates, and questions that could invalidate results.
An MCP server that provides on-demand skill loading for AI coding assistants.
---
name: ga-deep-dive-43de0b5458e7
displayName: GA4 Deep Dive
version: 1.0.3
description: Comprehensive Google Analytics 4 analysis β extracts EVERYTHING the API offers. Health scores, scroll depth, cohorts, demographics, and more.
triggers:
- analytics
- ga4
- google analytics
- traffic
- engagement
- bounce rate
- sessions
- users
- metrics
- deep dive
- report
---
# GA4 Deep Dive π
**The Owner's War Room** β Everything GA4 can tell you about your product.
## What You Get
| Script | Purpose |
|--------|---------|
| `deep_dive_v3.py` | Executive summary with 7 health scores |
| `deep_dive_v4.py` | THE FULL MONTY β scroll depth, cohorts, demographics |
| `send_report_email.py` | Bi-weekly email reports |
### Health Scores
- **Engagement** β Are users engaged?
- **Traffic Diversity** β Too reliant on one channel?
- **Retention** β Do users come back? (DAU/MAU)
- **Growth** β Are you growing?
- **Content** β Any problem pages?
- **Mobile** β Mobile-ready?
- **Geo Diversity** β Global reach?
### Deep Analysis (v4)
- π **Scroll Depth** β How far users actually READ
- π **Outbound Links** β Where users click out to
- π **Site Search** β What users search for
- π₯ **Demographics** β Age, gender, interests
- π **Search Console** β Organic search performance
- π **Cohort Retention** β Week-over-week retention
- π― **Audiences** β Custom audience performance
---
## Quick Start
**Ask your OpenClaw:**
> "Help me set up the ga-deep-dive skill for my website"
Your agent will guide you through:
1. Creating Google Cloud OAuth credentials
2. Getting your GA4 property ID
3. Running your first analysis
---
## Manual Setup
### 1. Install Dependencies
```bash
cd ~/.openclaw/skills/ga-deep-dive
python3 -m venv .venv
source .venv/bin/activate
pip install -r requirements.txt
```
### 2. Get Google OAuth Credentials
1. Go to [Google Cloud Console](https://console.cloud.google.com/)
2. Create a project (or use existing)
3. Enable **Google Analytics Data API**
4. Create **OAuth 2.0 Client ID** (Desktop app)
5. Download JSON β save as `~/.config/ga-deep-dive/credentials.json`
### 3. Get Your GA4 Property ID
1. Open [Google Analytics](https://analytics.google.com/)
2. Go to **Admin** β **Property Settings**
3. Copy the **Property ID** (9-digit number)
### 4. First Run (Auth)
```bash
source ~/.openclaw/skills/ga-deep-dive/.venv/bin/activate
python3 scripts/deep_dive_v3.py YOUR_PROPERTY_ID
```
It will open a browser for OAuth consent. Approve and you're set!
---
## Usage
### Run Analysis
```bash
# By property ID
python3 scripts/deep_dive_v3.py 123456789
# By name (if configured)
python3 scripts/deep_dive_v3.py mysite
# Full monty
python3 scripts/deep_dive_v4.py 123456789
# Custom period
python3 scripts/deep_dive_v3.py mysite --days 60
```
### Configure Property Names
Edit `scripts/deep_dive_v3.py` and add to `PROPERTIES`:
```python
PROPERTIES = {
'mysite': '123456789',
'blog': '987654321',
}
```
### Email Reports (Optional)
Configure via environment variables:
```bash
# Required for email functionality
export GA4_REPORT_RECIPIENTS="you@example.com,team@example.com"
export AGENTMAIL_INBOX="youragent@agentmail.to"
export AGENTMAIL_API_KEY="am_your_key_here"
```
Run with:
```bash
# Generate and send report
python3 scripts/send_report_email.py mysite --days 14
# Dry run (generate report only, no email)
python3 scripts/send_report_email.py mysite --dry-run
```
Set up cron for bi-weekly reports:
```bash
# Mondays & Thursdays at 9am (adjust env vars path)
0 9 * * 1,4 source ~/.ga4-env && cd ~/.openclaw/skills/ga-deep-dive && .venv/bin/python3 scripts/send_report_email.py mysite
```
---
## GA4 Setup Tips
For best results, enable these in GA4 Admin:
| Feature | Where | Why |
|---------|-------|-----|
| Google Signals | Data Settings β Data Collection | Demographics |
| Search Console | Product Links β Search Console | Organic search data |
| Enhanced Measurement | Data Streams β Web β Enhanced | Scrolls, outbound clicks |
| Key Events | Events β Mark as key event | Track conversions |
---
## Example Output
```
π₯ HEALTH SCORES
β
Engagement ββββββββββββββββββββ 81/100
β Traffic Diversity ββββββββββββββββββββ 27/100
β
Mobile ββββββββββββββββββββ 90/100
π― OVERALL: 66/100 (Grade B)
π‘ ACTIONABLE INSIGHTS
π΄ 72% traffic from Direct β DIVERSIFY NOW
π¨ Fix /agents/me/claim β 100% bounce rate
π’ China has highest quality traffic β consider localization
```
---
## Troubleshooting
**"Token expired"**
```bash
rm ~/.config/ga-deep-dive/token.json
# Run again to re-auth
```
**"No demographic data"**
- Enable Google Signals in GA4
- Need 50+ users per segment (privacy threshold)
**"No Search Console data"**
- Link Search Console in GA4 Admin β Product Links
- Wait 24-48h for data sync
---
## License
MIT β Built by [ClaudiusThePirateEmperor](https://solvr.dev/agents/agent_ClaudiusThePirateEmperor) π΄ββ οΈ
Repository: https://github.com/fcavalcantirj/ga-deep-dive
---
name: ga-deep-dive-43de0b5458e7
displayName: GA4 Deep Dive
version: 1.0.3
description: Comprehensive Google Analytics 4 analysis β extracts EVERYTHING the API offers. Health scores, scroll depth, cohorts, demographics, and more.
triggers:
- analytics
- ga4
- google analytics
- traffic
- engagement
- bounce rate
- sessions
- users
- metrics
- deep dive
- report
---
# GA4 Deep Dive π
**The Owner's War Room** β Everything GA4 can tell you about your product.
## What You Get
| Script | Purpose |
|--------|---------|
| `deep_dive_v3.py` | Executive summary with 7 health scores |
| `deep_dive_v4.py` | THE FULL MONTY β scroll depth, cohorts, demographics |
| `send_report_email.py` | Bi-weekly email reports |
### Health Scores
- **Engagement** β Are users engaged?
- **Traffic Diversity** β Too reliant on one channel?
- **Retention** β Do users come back? (DAU/MAU)
- **Growth** β Are you growing?
- **Content** β Any problem pages?
- **Mobile** β Mobile-ready?
- **Geo Diversity** β Global reach?
### Deep Analysis (v4)
- π **Scroll Depth** β How far users actually READ
- π **Outbound Links** β Where users click out to
- π **Site Search** β What users search for
- π₯ **Demographics** β Age, gender, interests
- π **Search Console** β Organic search performance
- π **Cohort Retention** β Week-over-week retention
- π― **Audiences** β Custom audience performance
---
## Quick Start
**Ask your OpenClaw:**
> "Help me set up the ga-deep-dive skill for my website"
Your agent will guide you through:
1. Creating Google Cloud OAuth credentials
2. Getting your GA4 property ID
3. Running your first analysis
---
## Manual Setup
### 1. Install Dependencies
```bash
cd ~/.openclaw/skills/ga-deep-dive
python3 -m venv .venv
source .venv/bin/activate
pip install -r requirements.txt
```
### 2. Get Google OAuth Credentials
1. Go to [Google Cloud Console](https://console.cloud.google.com/)
2. Create a project (or use existing)
3. Enable **Google Analytics Data API**
4. Create **OAuth 2.0 Client ID** (Desktop app)
5. Download JSON β save as `~/.config/ga-deep-dive/credentials.json`
### 3. Get Your GA4 Property ID
1. Open [Google Analytics](https://analytics.google.com/)
2. Go to **Admin** β **Property Settings**
3. Copy the **Property ID** (9-digit number)
### 4. First Run (Auth)
```bash
source ~/.openclaw/skills/ga-deep-dive/.venv/bin/activate
python3 scripts/deep_dive_v3.py YOUR_PROPERTY_ID
```
It will open a browser for OAuth consent. Approve and you're set!
---
## Usage
### Run Analysis
```bash
# By property ID
python3 scripts/deep_dive_v3.py 123456789
# By name (if configured)
python3 scripts/deep_dive_v3.py mysite
# Full monty
python3 scripts/deep_dive_v4.py 123456789
# Custom period
python3 scripts/deep_dive_v3.py mysite --days 60
```
### Configure Property Names
Edit `scripts/deep_dive_v3.py` and add to `PROPERTIES`:
```python
PROPERTIES = {
'mysite': '123456789',
'blog': '987654321',
}
```
### Email Reports (Optional)
Configure via environment variables:
```bash
# Required for email functionality
export GA4_REPORT_RECIPIENTS="you@example.com,team@example.com"
export AGENTMAIL_INBOX="youragent@agentmail.to"
export AGENTMAIL_API_KEY="am_your_key_here"
```
Run with:
```bash
# Generate and send report
python3 scripts/send_report_email.py mysite --days 14
# Dry run (generate report only, no email)
python3 scripts/send_report_email.py mysite --dry-run
```
Set up cron for bi-weekly reports:
```bash
# Mondays & Thursdays at 9am (adjust env vars path)
0 9 * * 1,4 source ~/.ga4-env && cd ~/.openclaw/skills/ga-deep-dive && .venv/bin/python3 scripts/send_report_email.py mysite
```
---
## GA4 Setup Tips
For best results, enable these in GA4 Admin:
| Feature | Where | Why |
|---------|-------|-----|
| Google Signals | Data Settings β Data Collection | Demographics |
| Search Console | Product Links β Search Console | Organic search data |
| Enhanced Measurement | Data Streams β Web β Enhanced | Scrolls, outbound clicks |
| Key Events | Events β Mark as key event | Track conversions |
---
## Example Output
```
π₯ HEALTH SCORES
β
Engagement ββββββββββββββββββββ 81/100
β Traffic Diversity ββββββββββββββββββββ 27/100
β
Mobile ββββββββββββββββββββ 90/100
π― OVERALL: 66/100 (Grade B)
π‘ ACTIONABLE INSIGHTS
π΄ 72% traffic from Direct β DIVERSIFY NOW
π¨ Fix /agents/me/claim β 100% bounce rate
π’ China has highest quality traffic β consider localization
```
---
## Troubleshooting
**"Token expired"**
```bash
rm ~/.config/ga-deep-dive/token.json
# Run again to re-auth
```
**"No demographic data"**
- Enable Google Signals in GA4
- Need 50+ users per segment (privacy threshold)
**"No Search Console data"**
- Link Search Console in GA4 Admin β Product Links
- Wait 24-48h for data sync
---
## License
MIT β Built by [ClaudiusThePirateEmperor](https://solvr.dev/agents/agent_ClaudiusThePirateEmperor) π΄ββ οΈ
Repository: https://github.com/fcavalcantirj/ga-deep-dive
Imported from the listed AgentSkill.sh category. Complete supplied package files and notices are retained. Includes source scripts; review them before use. Required external tools and credentials are not installed. No bundled code was executed during import. Individual agent task behavior has not been tested.