Productivity
Segmentation Framework and SQL Outline
Segmentation Framework and SQL Outline turns goals and constraints into a structured, actionable response with clear constraints and an explicit output.
The prompt
Segmentation Framework and SQL Outline guides the model through a defined task while preserving the source prompt's useful structure and constraints. Use it when planning work, making decisions, or organizing complex information and you want a response that is easier to evaluate and act on.
text prompt
You are a data analyst.
Model guidance (Claude 4.6):
- Use extended thinking and set effort to high or max for complex synthesis.
- When given long context, cite specific excerpts by quoting short phrases and referencing their location (ex: section name) so humans can verify.
Task:
Design a segmentation framework for {{goal}}. Define segment rules, required fields, and outline SQL logic to compute segments.
Inputs:
- Segmentation goal (retention, upsell): {{goal}}
- Core entities (users, accounts): {{entities}}
- Tables and key fields: {{dataSources}}
Output requirements:
- Use Markdown.
- Keep the top summary concise, then go deep.
- If key inputs are missing, list precise questions, then proceed with best-effort assumptions.
Output sections:
- Segmentation approach
- Segment definitions
- Data requirements
- SQL outline and pseudocode
- Validation checks
- How to use segments operationally
Tune the prompt, not the plumbing.
Every control comes from this prompt’s content schema. Changes stay in your browser and update instantly.
Customized prompt1003 characters
You are a data analyst.
Model guidance (Claude 4.6):
- Use extended thinking and set effort to high or max for complex synthesis.
- When given long context, cite specific excerpts by quoting short phrases and referencing their location (ex: section name) so humans can verify.
Task:
Design a segmentation framework for increase qualified trial sign-ups. Define segment rules, required fields, and outline SQL logic to compute segments.
Inputs:
- Segmentation goal (retention, upsell): increase qualified trial sign-ups
- Core entities (users, accounts): a specific entities
- Tables and key fields: Paste the relevant source material and context here.
Output requirements:
- Use Markdown.
- Keep the top summary concise, then go deep.
- If key inputs are missing, list precise questions, then proceed with best-effort assumptions.
Output sections:
- Segmentation approach
- Segment definitions
- Data requirements
- SQL outline and pseudocode
- Validation checks
- How to use segments operationally
Useful structure, room to move.
Segmentation Framework and SQL Outline guides the model through a defined task while preserving the source prompt's useful structure and constraints. Use it when planning work, making decisions, or organizing complex information and you want a response that is easier to evaluate and act on.
The prompt establishes the job first, then supplies concrete decisions a model can act on. The variables preserve that structure while letting you change the subject, context, or output.
Related prompts
Brand Positioning Refresh Workshop Guide
Brand Positioning Refresh Workshop Guide turns goals and constraints into a structured, actionable response with clear constraints and an explicit output.
ChatGPTClaudeGemini
Experiment Results Table Interpreter
Experiment Results Table Interpreter analyzes supplied material for patterns, evidence, and decision-ready findings with clear constraints and an explicit output.
ChatGPTClaudeGemini
Objection Handling Library for an ICP
Objection Handling Library for an ICP turns goals and constraints into a structured, actionable response with clear constraints and an explicit output.
ChatGPTClaudeGemini
Policy Text to Control Table Mapper
Policy Text to Control Table Mapper turns goals and constraints into a structured, actionable response with clear constraints and an explicit output.
ChatGPTClaudeGemini