textanalysisintermediate
SQL COHORT EXPLORATION DRAFT▌
CTEs for retention scaffold—tune windows and placeholder table names.
Recommended Model: Claude Sonnet 4.6
Est. Tokens: 450
Prompt Generator
Generate Your Prompt
Fill in the fields below to generate an optimized prompt based on best practices
Examples
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
Frequently Asked Questions
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