Best PromptsData analysis prompts
Help me with an A/B test. I am at stage: [DESIGN / READOUT]. **If DESIGN, give me these:** What I want to change and why I think it will work: [THE CHANGE + THE MECHANISM] Primary metric: [THE ONE METRIC THAT DECIDES THIS] Guardrail metrics that must not get worse: [e.g. refunds, support tickets, load time] Traffic or users available pe
A/B Test Design and Readout
Design an experiment with a decision rule fixed in advance, then read the result honestly, including when the answer is inconclusive.
Businessadvanced
Cohort data: """ [PASTE THE COHORT TABLE: ROWS AS SIGNUP COHORTS BY MONTH OR WEEK, COLUMNS AS PERIODS SINCE SIGNUP, VALUES AS RETAINED USERS OR REVENUE. INCLUDE COHORT SIZES.] """ Analyze the cohort data above. Business and what a retained user does: [THE PRODUCT + THE ACTION THAT COUNTS AS RETAINED] What changed and when: [PRICING, ONB
Cohort Retention Analysis
Read a cohort table properly: where retention flattens, which cohorts differ and why, and what the curve says about the business.
Businessadvanced
Data: """ [PASTE CSV, TABLE, OR EXPORTED NUMBERS] """ Analyze the data above. The question I'm trying to answer: [YOUR QUESTION] Context on where this data comes from: [SOURCE, TIME PERIOD, KNOWN QUIRKS: e.g. "Stripe export, Q2, refunds excluded"] Work in this order: 1. **Describe before analyzing**: what the columns are, row count, tim
Analyze Pasted Data
Get findings from a pasted table or CSV with magnitudes, caveats, and a clear line between what the data shows and what it can't answer.
Businessintermediate
Write a formula for [Excel / Google Sheets: pick one; the function sets differ]. What I want to calculate: [PLAIN ENGLISH, e.g. "sum column C where column A says 'West' and the date in column B falls in the current month"] My layout: [WHERE THINGS LIVE, e.g. "headers in row 1, data in A2:F500, dates in column B"] My version, if I know it
Excel or Sheets Formula From Plain English
Describe a calculation in plain words and get a working formula, a line-by-line explanation, and the edge cases that will silently break it.
Businessbeginner