textAnalysisintermediate
SQL cohort exploration draft
CTEs for retention scaffold—tune windows and placeholder table names.
Suggested model: Claude Sonnet 4.6Estimated length: 450 tokens
Customize this template
Build your prompt
Generate Your Prompt
Fill in the required details first. Optional controls help you fine-tune the result.
See a completed example
Draft
Input Variables
dialect:bigquery
business_question:30-day retention of workspace cohorts activating MCP integrations
event_grains:workspace_created, integration_enabled, retained_active_daily
allowed_tables_placeholder:dim_workspace, fact_activity_daily — or UNKNOWN (use TODO stubs)
kpi_sentence:rolling 7-day activation rate vs baseline signup week
Questions about this prompt
Best Practices
Critical Best Practices
Lead with role and scope
criticalSay who you are, who the reader is, and what artifact you want in one dense block.
Source: claude
Recommended Best Practices
Spell out constraints
recommendedLength, tone bans, jargon limits, formatting, and what not to hallucinate.
Source: claude
Related Templates
Keywords
sql cohort analysis promptretention sql ai