# Automate Google Analytics Reporting

Manual GA4 reporting requires repeated property discovery, schema checks, and pagination. This skill guides Rube MCP through reliable reporting and analysis workflows.

## Install

```bash
npx skillstore add sickn33/google-analytics-automation
```

## Metadata

- Status: approved
- Slug: sickn33-google-analytics-automation
- Skillstore revision: r2
- Version status: missing
- Tree hash: 93bbf7a5709f897e2630ebc47e008dd5d65d5cf74532d0bf3a567663c06d79e6
- Author: sickn33
- GitHub username: sickn33
- License: MIT
- Repository: https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/google-analytics-automation
- Ref: 88a8e9a07f4c54ab105c1c41b6267c287146b07b
- Supported tools: Claude, Codex, Claude Code
- Audit status: complete
- Agent install advisory: allowed
- Manual install advisory: allowed
- Artifact signature: available
- Audit attestation: unavailable
- Human verification: not\_verified
- Risk factors: external\_commands, network
- Quality score: 69
- Public page: https://skillstore.pages.dev/skills/sickn33-google-analytics-automation
- Manifest: https://skillstore.pages.dev/api/skills/sickn33-google-analytics-automation/manifest

## Capabilities

- Lists accessible Google Analytics accounts and properties.
- Runs standard GA4 reports with dimensions, metrics, filters, sorting, and pagination.
- Runs up to five reports for one property in a batch.
- Builds pivot reports with explicit dimensions and pivot definitions.
- Runs ordered funnel reports with optional breakdown dimensions.
- Lists configured key events for an authorized property.

## Use Cases

- Monitor Marketing Performance: Compare sessions, users, and revenue by source or campaign across a selected date range.
- Review Product Funnels: Measure ordered user steps and identify conversion drop-off by device or another supported breakdown.
- Automate Client Reporting: Run several recurring reports for one client property and summarize the returned metrics.

## Prompt Templates

### List My GA4 Properties

```
List my accessible Google Analytics accounts and properties. Show each display name with its full resource identifier.
```

### Run a Traffic Report

```
For property [property], report sessions and active users by date for [date range]. Check compatibility and return every page.
```

### Compare Acquisition Segments

```
For property [property], compare sessions, conversions, and revenue by source, medium, and device for [date range]. Sort by sessions.
```

### Analyze a Conversion Funnel

```
For property [property], build a closed funnel for [steps] during [date range]. Break results down by device and explain major drop-offs.
```

## Limitations

- Requires a configured Rube MCP server and an active Google Analytics connection.
- Only accesses accounts and properties allowed by the connected Google identity.
- Does not guarantee that every dimension and metric combination is compatible.
- Today's analytics data may be incomplete because Google Analytics processing can be delayed.

## Best Practices

- Search available tools first because MCP schemas can change.
- Resolve and confirm the full property resource identifier before running reports.
- Check dimension and metric compatibility before complex reports or batches.

## Anti Patterns

- Do not use a numeric property identifier without the properties prefix.
- Do not assume an empty report always includes a rows field.
- Do not request large unpaginated result sets or ignore returned page tokens.

## Security Audit

- Audited at: 2026-07-24T00:34:58.219\+00:00
- Summary: All 60 command-execution alerts are false positives caused by Markdown backticks and code fences. The skill makes an expected third-party MCP connection and delegates Google OAuth through Rube.

## Stats

- Views: 83
- Downloads: 14
- Favorites: 0
- Popularity score: 0