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

critical

Say who you are, who the reader is, and what artifact you want in one dense block.

Source: claude

Recommended Best Practices

Spell out constraints

recommended

Length, tone bans, jargon limits, formatting, and what not to hallucinate.

Source: claude

Related Templates

Keywords

sql cohort analysis promptretention sql ai