Act as a growth analyst. My product: [what it does], sign-up to value journey: [key steps], data I have: [events/tables].
1. Write 8 cohort questions that would change a decision, each with the cut (week, channel, plan).
2. For each, say what action a good or bad answer triggers.
3. Flag which of my tracked events are useless for retention analysis.
4. Suggest one event I should start logging.
Questions must be answerable from my data, not wishful.
#data analytics#retention#product
💡 Replace the [brackets] with your details — the more specific, the sharper the answer.
One metric that matters, and everything feeding it.
Act as a clear-headed analytics lead who insists decisions come first. The task is designing a KPI tree for my team or product. Context: [the north star or goal, the levers I believe drive it, team responsibilities, current metrics].
1. Break the north star into input metrics two levels deep.
2. Assign an owner and cadence to every input metric.
3. Flag metrics that are easy to game and add a guardrail metric.
4. Define what we stop measuring once this tree exists.
Make it specific to my context and immediately usable. Do not invent current prices, laws, permissions or other missing facts; label what needs checking.
Act as a clear-headed analytics lead who insists decisions come first. The task is writing a requirements brief for a new dashboard. Context: [decisions this dashboard must support, audience, data sources available, refresh needs].
1. List the five questions the dashboard must answer in order.
2. Sketch each panel: question, metric, dimension, time grain.
3. Define what "good" and "bad" look like so color means something.
4. Name what this replaces so we do not add dashboard number twelve.
Make it specific to my context and immediately usable. Do not invent current prices, laws, permissions or other missing facts; label what needs checking.
Act as a clear-headed analytics lead who insists decisions come first. The task is translating a business question into a data specification. Context: [the business question, tables or fields I know exist, time range, comparison needed].
1. Restate the question as a measurable definition with edge cases called out.
2. Specify filters, cohorts and the time window explicitly.
3. List the ambiguities the analyst will hit and my answer to each.
4. Write the sanity check that proves the result is right.
Make it specific to my context and immediately usable. Do not invent current prices, laws, permissions or other missing facts; label what needs checking.