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…
225 copies · 25 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…
113 copies · 16 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…
109 copies · 18 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…
110 copies · 16 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,…
78 copies · 18 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…
121 copies · 13 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…
71 copies · 14 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 …
86 copies · 15 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…
59 copies · 15 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:…
78 copies · 11 likesDiagnose an ad set whose cost per acquisition doubled this week
You are a paid media analyst. My CPA jumped and I need to know where to look before I start changing things. The campaign: {{platform, objective, daily budget, audience, bid strate…
51 copies · 16 likesDecide whether to build it, buy it, or leave it alone
You are a pragmatic operator deciding between building, buying, and doing nothing. The capability: {{what it must do and for whom}}. Why it is on the table now: {{the trigger - cus…
46 copies · 16 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…
86 copies · 10 likesFind the duplicate records ruining your counts
My count is wrong: {{what you expected versus what you got}}. Here's the data: {{schema and 15 sample rows, including a few you suspect}}. Work through duplicate types in this ord…
65 copies · 9 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…
80 copies · 9 likesPick the right chart for the point you are making
Here's my data: {{describe the columns, the row count, and what each row represents}}. The point I want to land: {{the one sentence a reader should take away}}. Audience: {{who}}. …
65 copies · 8 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…
70 copies · 9 likesExplain a statistical result to a non-technical exec
Here's the result: {{paste the numbers — effect size, confidence interval, p-value, sample size, whatever you have}}. Method: {{what you did}}. Audience: {{role}}, who will use it …
54 copies · 9 likesEstimate what a price change will really do to revenue
You are a pricing analyst. I am considering the price change described below. Using only my data, build the revenue case honestly. Output: 1. BASELINE — current customers, ARPU, …
35 copies · 10 likesDecide 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…
66 copies · 9 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…
57 copies · 8 likesDecide which customer segment to stop serving
You are an operator who has had to narrow a business before. Segments we serve: {{for each: who they are, revenue, share of support tickets, churn, sales cycle, gross margin if kno…
47 copies · 9 likesTurn a churn export into the three cancel reasons you can act on
You are a retention analyst. Here is an export of customers who cancelled: {{paste rows — signup date, cancel date, plan, price, usage in the last 30 days, stated cancel reason, an…
49 copies · 9 likesFind 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…
66 copies · 8 likesReconcile 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: {…
55 copies · 8 likesChoose between raising now and cutting to default alive
You are a CFO who has taken two companies through a tight funding market. Be exact, not encouraging. Cash in the bank, monthly net burn for the last 6 months, and current MRR/ARR …
30 copies · 8 likesWrite the memo that kills a project you championed
You are helping me write an internal memo announcing that we are stopping a project I personally pushed for. The project: {{what it was, when it started, what we promised}}. What a…
23 copies · 8 likesDecide which numbers belong on a dashboard nobody asked to see
You are an analyst cutting a bloated dashboard down to what changes decisions. Who reads it and what they decide: {{audience, the decisions they own, how often they look}}. Current…
44 copies · 7 likesDiagnose a traffic drop that started with a Google update
You are an SEO doing incident analysis, not writing a recovery fantasy. The drop: {{when it started, total change in clicks and impressions, which countries and devices}}. Page-lev…
41 copies · 7 likesFind 15% of spend to cut without breaking anything
You are a CFO who has done this before and does not enjoy it. Cut roughly {{target}}% of {{annual or monthly}} spend without damaging what earns revenue. Spend list: {{paste line i…
50 copies · 7 likesPick the twenty-five accounts worth your quarter
You are a sales leader helping me cut a bloated territory down to what I can actually work. My list: {{paste accounts - name, industry, size, current status, last touch, any signal…
32 copies · 7 likesSanity-check a spreadsheet model before you present it
You are a skeptical reviewer. Below is a spreadsheet model I did not build and have to present on Thursday. Find what would embarrass me. Return: 1. ASSUMPTIONS — table with Cell…
35 copies · 6 likesDecide where the next ten thousand of ad budget goes
You are a paid media planner. I have {{amount}} of incremental budget for the next {{number}} weeks and have to place it. Current channels: {{paste per channel — spend, impressions…
35 copies · 6 likesWrite the data dictionary nobody wants to write
Here's a table: {{paste the schema, plus 10-20 sample rows}}. Team context: {{what the table is used for, who queries it}}. For every column produce: the plain-English meaning, th…
30 copies · 4 likesWork out how much of last month's growth was real
You are a skeptical analyst. Here is the metric that moved: {{name, last 13 months of values, and the definition}}. What else changed: {{launches, pricing, campaigns, tracking chan…
34 copies · 5 likesDecide the sample size before you run the test
I want to test {{change}} on {{surface}}. Current baseline: {{metric and its current rate or mean, plus its variance if you have it}}. Traffic: {{visitors or events per day eligibl…
29 copies · 5 likesDecide which pages to translate first for a new market
You are an SEO lead planning a first localisation push on a fixed budget. Target market and language: {{country, language, any local competitor you know of}}. My current pages with…
35 copies · 5 likesSegment your customers by what they are actually worth to you
You are an analyst who knows revenue and value are not the same number. Customer export: {{paste or describe columns - revenue, tenure, plan, usage, support tickets, discount}}. W…
18 copies · 5 likesTurn a Search Console export into next quarter's content plan
You are an SEO lead building a content plan from evidence I already have, not from a keyword tool's wish list. I will paste query-level rows: {{query | landing page | clicks | impr…
35 copies · 4 likesRescue a campaign that got clicks and no signups
You are a direct response strategist. The campaign: {{objective, audience, budget, dates}}. The ads: {{paste headlines, primary text, and creative descriptions}}. The destination: …
38 copies · 4 likesWork out whether a dip is seasonal or something breaking
You are an analyst who refuses to call something seasonal without checking. My metric dropped and half the team says it is the time of year. Below is the history and what changed. …
13 copies · 5 likesTurn a support ticket export into the five fixes worth making
You are a support operations analyst. Attached is a ticket export: {{columns present, date range, row count, and any fields for handling time, plan tier or resolution}}. I want to …
23 copies · 4 likesTurn a raw event log into a funnel with the drop-off explained
You are a product analyst. I have raw event data and need a funnel I can defend. Event schema: {{table name, columns, event names, and what each one fires on}}. The journey I care …
46 copies · 3 likesAnswer your biggest customer's off-roadmap request
You are an operator who has seen one large customer quietly become a product team's roadmap. What they asked for, in their words: {{paste the request or email}}. What they pay us …
12 copies · 4 likesAnswer a vendor who just raised your price 40%
You are my procurement lead. A vendor has raised our renewal price and I need a position before the call, not a rant. Produce exactly five sections: 1. WHAT WE ACTUALLY BUY - wha…
14 copies · 4 likesDecide whether to chase a market that keeps knocking
You are a skeptical strategy partner. We keep getting inbound from a segment we never targeted: {{who they are, how many have come in, what they asked for, what we sold them, what …
31 copies · 3 likesReforecast a quarter you already know you will miss
You are a finance-literate operator rebuilding a forecast mid-quarter. Original plan: {{targets by month and the assumptions behind them}}. Actuals to date: {{revenue, pipeline, sp…
32 copies · 3 likesWork out which customers are quietly about to leave
You are a data analyst who has seen too many churn models that only fire after the customer has already gone. The export: {{paste usage or account data - columns and 20+ rows, or …
23 copies · 3 likesDecide whether an A/B test result is safe to ship
You are a sceptical experimentation reviewer. I want to ship a test result and need to know if it holds. The test: {{what changed, primary metric, hypothesis}}. Numbers: {{per vari…
40 copies · 2 likesChoose between building a channel and hiring your own reps
You are an operator who has run both a partner channel and a direct sales team, and knows which one hides its costs. Compare both routes using only my numbers. 1. WHAT THIS DECISI…
12 copies · 3 likesWork out what your data can honestly answer before you promise an analysis
You are a senior analyst scoping a request before committing to it. Half of these questions cannot be answered with what we actually collect, and finding that out in week two is th…
13 copies · 3 likesPlan for the platform your business quietly depends on
You are a strategy advisor. One platform - an app store, a marketplace, an API, a single channel - can change terms and take a chunk of our business with it. The dependency: {{nam…
16 copies · 2 likesWork out whether a broken dashboard number is data or reality
You are a data lead. A number on our dashboard looks wrong. Before anyone panics, separate pipeline breakage from a real business change. Output four sections. 1. FIRST FIVE CHECK…
11 copies · 2 likesDecide what to instrument before you ship the feature
You are a product analyst reviewing a tracking plan before code freeze. Missing events cannot be backfilled, and extra events cost review time forever. The feature and how a user …
12 copies · 2 likesDecide whether to take the big custom deal that bends your product
You are an operator deciding on one large deal that requires custom work. Below are the contract value and term, what they are asking us to build or change, our roadmap for the sam…
7 copies · 2 likesAnswer a competitor who just undercut your price by half
You are my pricing lead. A competitor has gone in far below us and my sales team is already panicking in the group chat. Their pricing and what it includes: {{paste}}. Our pricing…
11 copies · 1 likeCut your cloud bill without breaking the service
You are a pragmatic infrastructure engineer. I need to cut spend without a reliability incident that costs more than the savings. Cost breakdown by service or line item, last full…
9 copies · 1 likeWork out whether your free plan is paying for itself
You are a finance-literate operator reviewing a free tier nobody has questioned since launch. Below are my plan limits, free and paid user counts, conversion and cost data. 1. WHA…
6 copies · 1 likeFind the cost lines worth cutting in a year of spend
You are a finance analyst. Below is an export of spend (vendor, category, date, amount) and a target saving. Find the cuts, not a generic cost-cutting essay. 1. SHAPE OF SPEND - t…
9 copiesDecide whether to keep the office, shrink it, or drop it
You are a pragmatic operator advising on a lease decision, not a workplace-culture consultant. The lease: {{cost per month, term remaining, break clause, sublet rules}}. Actual us…
11 copiesSet the alert thresholds that catch a real problem, not noise
You are an analyst setting up alerting on business and product metrics. Below is recent history for each metric and what the on-call person can actually do about it. Design alerts …
2 copies · 1 likeGet fluent in the numbers your company runs on
You are a tutor teaching me the metrics my own company lives by, so I stop nodding along in meetings. Below are the metric names I hear, any definitions or dashboards I have, and m…
8 copiesRetire an old pricing plan without churning the people still on it
You are an operator sunsetting a legacy plan. Below is the plan, who is still on it, what they pay, the current plans, and why we want it gone. 1. WHO IS AFFECTED - table: Segment…
7 copiesWork out whether a new feature changed behaviour or just moved it around
You are an analyst checking whether a shipped feature created new activity or cannibalised existing activity. Below is usage data before and after launch, plus what the feature doe…
6 copiesDecide what to do with the outliers before they decide for you
You are a careful analyst. Below is my dataset description, the extreme values I found, and the question the analysis has to answer. Decide how each outlier should be handled. 1. …
2 copiesWork out whether your discounts are buying revenue or giving it away
You are a revenue analyst. Below is a deal-level or order-level export with discount amounts, plus my cost and retention notes. Tell me what the discounting is actually doing. 1. …