Menu
BigQuery: Query GMP export data (GA4, Ads, GSC) with pre-built templates and custom SQL.
Instalar com Codex ou Claude Copie este prompt, cole no Codex, Claude ou outro assistente e deixe que ele revise a página da skill e instale para você.
Baseado na classificação ocupacional SOC
Google Tag Manager: Accounts, containers, tags, triggers, variables, and versions.
BigQuery: Run pre-built query templates against GMP export datasets.
Recipe: GA4 funnel analysis via BigQuery — session_start → page_view → add_to_cart → checkout → purchase.
Google Ads: Campaign performance reports with date ranges and status filters.
Google Ads: Campaigns, ad groups, keywords, search terms, and raw GAQL queries.
GSC: Search analytics reports with dimensions, filters, and date ranges.
| name | gmp-bq |
| version | 1.0.0 |
| description | BigQuery: Query GMP export data (GA4, Ads, GSC) with pre-built templates and custom SQL. |
| metadata | {"openclaw":{"category":"analytics","requires":{"bins":["gmp"]},"cliHelp":"gmp bq --help"}} |
PREREQUISITE: Read
../gmp-shared/SKILL.mdfor auth, global flags, and output formats.EXTRA AUTH: BigQuery requires the
bigquery.readonlyscope. If you authenticated before this feature was added, rungmp auth loginagain to grant the new scope.
gmp bq <command> [flags]
| Command | Description |
|---|---|
templates | List available pre-built query templates |
query | Run a pre-built query template |
explore | List tables and schema in a BigQuery dataset |
custom | Run a custom SQL query |
gmp bq templates
gmp bq templates --service ga4 -f table
gmp bq templates --service ads -f json
gmp bq templates --service gsc
gmp bq query -t ga4-events-flat --project my-project --dataset analytics_123456789 -r 30d
gmp bq query -t ads-wasted-spend --project my-project --dataset my_ads_dataset -r 90d -f table
gmp bq query -t gsc-top-pages --project my-project --dataset searchconsole -r 2024-01-01..2024-03-31
# 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
gmp bq custom --project my-project -q "SELECT event_date, COUNT(*) FROM \`my-project.analytics_123456789.events_20240101\` GROUP BY event_date"
| Template | Description |
|---|---|
ga4-events-flat | Flatten nested event_params into columns |
ga4-funnel | Funnel analysis from event sequences |
ga4-attribution | Multi-touch attribution (source/medium per session) |
ga4-user-journey | Session-level page paths |
ga4-ecommerce | Purchase/revenue with product-level detail |
ga4-retention | Weekly cohort retention from first visit |
| Template | Description |
|---|---|
ads-wasted-spend | Search terms with spend and zero conversions |
ads-quality-trend | Keyword quality score over time |
ads-cross-campaign | Cross-campaign performance comparison |
| Template | Description |
|---|---|
gsc-top-pages | Top pages by clicks with CTR/position |
gsc-query-clusters | Top queries by volume (excludes anonymized) |
gsc-cannibalization | Queries with multiple competing pages |
| Format | Example | Description |
|---|---|---|
| Relative | 30d, 7d, 90d | Last N days |
| Keywords | today, yesterday | Single day |
| Absolute | 2024-01-01..2024-03-31 | Custom range |
Dates are converted to YYYYMMDD format for GA4 _TABLE_SUFFIX and to YYYY-MM-DD for GSC/Ads _DATA_DATE partitions.
gmp bq explore first to discover what tables/datasets are available.analytics_<PROPERTY_ID>.searchdata_site_impression and searchdata_url_impression tables.ads_Campaign_<CUSTOMER_ID>, ads_CampaignBasicStats_<CUSTOMER_ID>, etc.-f table for human-readable output.LIMIT and date ranges to control scan size.