Prompts that write and review marketing SQL against your real schema, with dialect, cost and validation requirements.
4 prompts
Gets a correct, cost-aware GA4 export query by giving the model your table path, session definition, window and required columns.
BigQuery / SQL · Google Analytics 4 · Any capable chat model (ChatGPT, Claude, Gemini, others)
A prompt for a user- or session-level funnel query that respects event order and time windows, with explicit decisions about what counts as a step.
BigQuery / SQL · Google Analytics 4 · Any capable chat model (ChatGPT, Claude, Gemini, others)
Produces a transparent CAC-by-channel query once you describe spend and customer tables, with attribution rules stated explicitly rather than assumed.
BigQuery / SQL · Any capable chat model (ChatGPT, Claude, Gemini, others)
A code-review prompt for existing SQL: correctness first, then cost and readability, with changes explained and a test for equivalence.
BigQuery / SQL · Any capable chat model (ChatGPT, Claude, Gemini, others)