google-analytics
Installation
SKILL.md
Google Analytics 4 SQLite Ingestion & SQL Analytics
The google-analytics skill ingests Google Analytics 4 (GA4) traffic, reading depth, acquisition channels, event streams, and outbound clicks into a local SQLite analytics database (google_analytics.db or $XDG_DATA_HOME/google-analytics/analytics.db) without data loss, preserving raw JSON payloads on all records, and providing a fast SQL interface for website analytics.
Available scripts
scripts/google_analytics.py: Automated sync, reporting, and annotation CLI for Google Analytics 4. Executed viauv run scripts/google_analytics.py(requires Google Cloud ADC or OAuth credentials).scripts/test_google_analytics.py: Unit and regression test suite validating schema, query extraction, and CLI flags.
⚡ Quick Start & Primary Actions
All operations are driven via the bundled Python CLI script:
# 1. Authorize OAuth 2.0 (with analytics.edit & readonly scopes)
uv run scripts/google_analytics.py auth --port 8080