Skip to main content

Cohort / Segment Definition Draft

Draft the logic for a cohort or segment, for analyst review.

The prompt
Draft the definition for the [cohort/segment] I describe: [paste].
- The inclusion/exclusion rules in plain language
- The fields/conditions it implies
- Edge cases to decide

Mark "DRAFT — validate against the data." Do not finalize numbers; this is the logic for me to implement and test.

How to use it

  1. 1Select Copy the prompt above.
  2. 2Paste it into Microsoft 365 Copilot.
  3. 3Replace anything in brackets with your own detail, then send it.

Copilot gathers and drafts. You verify and decide. Check every figure, name and date against the system it came from before you act on it.

Written for

Data Analyst, BI Analyst, Marketing Analyst