adswerve

adswerve/ga4-bigquery-agent-skill

Skill Claude CodeCodex

Build ML-ready datasets in BigQuery using SQL. Covers dataset architecture (lookback/lookahead windows, user pools, snapshot dates), feature engineering patterns (cumulative metrics, recency, site content, traffic/geo encoding), leakage prevention, deterministic splits, training vs inference modes. GA4-specific…

adswerve/ga4-bigquery-agent-skill

Skill Claude CodeCodex

Write SQL queries for Google Analytics 4 (GA4) data exported to BigQuery. Covers schema knowledge, event parameter extraction, session/user metrics, traffic source attribution (all 4 scopes), ecommerce analysis, funnel/path analysis, custom attribution models, and cost optimization patterns.