Ask a marketing question in English, get correct GA4 BigQuery SQL back. Not GA3 SQL with the wrong table names, not a query that scans five years of data and bills you for it.
What this isA system prompt that turns plain-English marketing questions into accurate SQL against the GA4 BigQuery export, with the event-model schema baked in.
You give itYour project and dataset, a date range, and a marketing question in plain words.
You get backA ready-to-run BigQuery SQL query, a one-line explanation, and a heads-up on any sampling or attribution caveat.
Download the skill file, then paste it into your AI as a system prompt or a custom instruction.
What it does
Reads your plain-English question, asks for the dataset and date range, then writes correct event-model SQL with the right traffic-source field and a _TABLE_SUFFIX date filter, and flags anything the export cannot answer.
How to load it
Paste the skill into a custom GPT, a Claude project, or any system-prompt field, then ask your question. Give it your project and dataset and the date range when it asks.