Pular para o conteúdo
Kitbay
Skill

bigquery

MITAtualizado em 11 de nov. de 202693Estrelas no GitHub

A skill in henkisdabro's wookstar Claude Code plugin collection for answering questions from the Google Analytics 4 export in BigQuery.

O que a skill ensina

A skill in henkisdabro's wookstar Claude Code plugin collection for answering questions from the Google Analytics 4 export in BigQuery. It first checks that a BigQuery MCP server is connected, naming Google's MCP Toolbox plugin and the hosted BigQuery endpoint, then finds the analytics dataset and date range of the export shards. Cost rules come next: always filter by table suffix, name columns, filter event names early and extract parameters with scalar subqueries, followed by a dry run before the real query. It covers sessionisation, time-zone gotchas and why numbers differ from the GA4 interface, with a reference file of query patterns.

O que faz

  • Find the GA4 export dataset and date range in BigQuery
  • Write cost-aware SQL against date-sharded event tables
  • Dry-run queries before running them
  • Rebuild sessions and landing pages from raw events