Read a survey without fooling yourself
Here are survey results: {{paste questions, response counts, and open-text answers}}. It was distributed via {{channel}} to {{who}}, with {{n}} responses out of {{invited}}. 1. St…
132 copies · 15 likesWORKS WITH JULIUS
Prompts for Julius
Community-tested ways to get more useful results from Julius.
Add a promptUnit economics that survive scrutiny
Work out the unit economics for {{business}}. Inputs: {{price, COGS components, CAC by channel, churn, expansion, gross margin, payback expectations}}. 1. Define each metric expli…
65 copies · 10 likesWrite the query and the caveat for a stakeholder question
A stakeholder asked: "{{their question, verbatim}}". Available data: {{schema summary}}. 1. Restate what they're actually trying to decide — the question behind the question. If t…
60 copies · 9 likesCohort retention analysis in plain language
Here's my signup and activity data: {{describe columns or paste sample}}. 1. Build monthly signup cohorts and show retention by month-since-signup as a triangle table. State clear…
61 copies · 8 likesBuild an ICP from your best and worst customers
Here are my customers: {{paste list with size, industry, use case, ACV, tenure, expansion, churn, support load, satisfaction}}. 1. Define "best" explicitly — retention, expansion,…
38 copies · 7 likesClean a messy spreadsheet reproducibly
Here's a messy export: {{paste 20-30 sample rows with headers}}. 1. Diagnose every problem you can see: inconsistent date formats, numbers stored as text, mixed units, trailing wh…
50 copies · 6 likesExplain a metric move without inventing a story
{{Metric}} moved from {{before}} to {{after}} between {{dates}}. Context: {{what you know — launches, campaigns, seasonality, outages}}. Data available: {{list dimensions you can s…
39 copies · 5 likesDesign an experiment that can actually conclude
I want to test {{change}} on {{surface}}. Baseline: {{metric and current value}}, traffic {{volume per week}}. Design the test: 1. State the hypothesis as a mechanism, not a hope:…
28 copies · 5 likesWrite the SQL, then explain what it will cost
Write the query for this question: {{describe what you need to know}}. Schema: {{paste DDL or table and column list with row counts}} Database: {{engine and version}} Requirement…
23 copies · 4 likesBuild the annual budget from drivers
Build a {{year}} operating plan for {{company}}. Current: {{revenue, growth rate, headcount, cash, burn, margins}}. Plans: {{hiring, launches, pricing changes}}. 1. Model revenue …
24 copies · 5 likesForecast with the uncertainty attached
Forecast {{metric}} for the next {{horizon}}. History: {{paste time series}}. Known future events: {{launches, seasonality, pricing changes}}. 1. Describe the series honestly firs…
24 copies · 5 likesInterrogate a dataset before you trust it
Here's a dataset: {{paste sample rows plus column list, row count, and how it was collected}}. Before any analysis, audit it: 1. For each column: type, unit, expected range, % mis…
16 copies · 4 likesTurn one dataset into a linkable asset
I have this dataset: {{describe columns, size, source, time range}}. 1. List the 10 most link-worthy findings this data could support — each stated as a headline claim with the ex…
17 copies · 3 likesChurn post-mortem from cancellation data
Here are recent cancellations: {{paste reasons given, plan, tenure, usage before churn, support history}}. 1. Cluster by the real reason, not the stated one. Stated reason "too ex…
6 copiesFind the story in a metric that moved
You are a data analyst. A metric moved and I need to know why before I report it. I will give you the metric, the period, the change, and any breakdowns I have. Work in this orde…
Decide which campaign to kill this month
You are a paid media analyst. I have a fixed budget and too many live campaigns. Below are the numbers per campaign. Work in this order: 1. For each campaign, state spend, the res…
Reconcile two reports that disagree about the same number
Two sources report different values for the same metric and I have to explain the gap today. Metric: {{name}}. Source A: {{tool, value, how it is defined if you know}}. Source B: {…