# List tables
gmp bq explore --project my-project --dataset analytics_123456789
# Show schema for a specific table
gmp bq explore --project my-project --dataset analytics_123456789 --table events_20240101
Run custom SQL
gmp bq custom --project my-project -q "SELECT event_date, COUNT(*) as events FROM \`my-project.analytics_123456789.events_20240101\` GROUP BY event_date"
Available Templates
Template
Service
Description
ga4-events-flat
GA4
Flatten nested event_params into columns
ga4-funnel
GA4
Funnel analysis from event sequences
ga4-attribution
GA4
Multi-touch attribution (source/medium)
ga4-user-journey
GA4
Session-level page paths
ga4-ecommerce
GA4
Purchase/revenue with product detail
ga4-retention
GA4
Weekly cohort retention
ads-wasted-spend
Ads
Search terms with spend, zero conversions
ads-quality-trend
Ads
Keyword quality score over time
ads-cross-campaign
Ads
Cross-campaign performance comparison
gsc-top-pages
GSC
Top pages by clicks with CTR/position
gsc-query-clusters
GSC
Top queries by volume
gsc-cannibalization
GSC
Queries with multiple competing pages
Output Formats
All commands support -f / --format:
Format
Description
json
JSON (default) — best for piping to jq or AI agents
table
Human-readable table
csv
CSV — pipe to file or other tools
What's included
Google Analytics (GA4) — accounts, properties, reports, realtime, metadata
Google Search Console — sites, search analytics, URL inspection, sitemaps
Google Ads — accounts, campaigns, ad groups, keywords, search terms, raw GAQL
Google Tag Manager — accounts, containers, tags, triggers, variables, versions
3 output formats — JSON (pipe to jq or AI agents), table, CSV
BigQuery — query GMP export data with 12 pre-built templates
AI agent skills — OpenClaw-compatible skills for all services
Google Marketing Platform CLI — GA4, Search Console, Ads, GTM. Built for AI agents and power users.
The npm package @lucianfialho/gmp-cli receives a total of 6 weekly downloads. As such, @lucianfialho/gmp-cli popularity was classified as not popular.
We found that @lucianfialho/gmp-cli demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago.It has 1 open source maintainer collaborating on the project.