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…
264 copies · 29 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…
126 copies · 22 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…
128 copies · 23 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,…
100 copies · 26 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…
130 copies · 20 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…
73 copies · 24 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…
141 copies · 17 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…
89 copies · 17 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…
79 copies · 19 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…
103 copies · 16 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:…
90 copies · 16 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 …
109 copies · 15 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}}. …
83 copies · 13 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…
67 copies · 18 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 …
74 copies · 14 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…
83 copies · 13 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…
89 copies · 10 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…
100 copies · 11 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, …
54 copies · 16 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…
79 copies · 15 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…
79 copies · 13 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…
50 copies · 13 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 …
48 copies · 13 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…
64 copies · 13 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…
68 copies · 12 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…
60 copies · 11 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…
47 copies · 9 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…
80 copies · 9 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…
57 copies · 9 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…
56 copies · 9 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…
52 copies · 9 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…
58 copies · 9 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…
51 copies · 9 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…
64 copies · 9 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…
57 copies · 7 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…
49 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: {…
63 copies · 8 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…
61 copies · 7 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 …
68 copies · 7 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: …
59 copies · 7 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…
34 copies · 7 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…
42 copies · 7 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 …
47 copies · 6 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…
28 copies · 7 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. …
38 copies · 7 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 …
36 copies · 6 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…
30 copies · 6 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…
51 copies · 5 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…
38 copies · 5 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…
56 copies · 5 likesFind 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…
19 copies · 5 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 …
57 copies · 4 likesWork 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…
17 copies · 5 likesDecide 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…
20 copies · 5 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 …
40 copies · 4 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 …
35 copies · 5 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…
30 copies · 4 likesSet 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 …
18 copies · 5 likesDecide 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. …
23 copies · 5 likesWork out how many support people you need from your ticket data
You are an operations analyst who has staffed support teams. Below is ticket data with timestamps and handle times, our response-time target, and current headcount. Tell me how man…
23 copies · 5 likesRetire 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…
27 copies · 4 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…
23 copies · 4 likesSet next quarter's targets from what your history can actually support
You are a planning analyst who has seen too many targets set by adding 20% to last quarter. Below is my metric history and the target leadership has floated. Tell me what is realis…
20 copies · 4 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…
31 copies · 3 likesLearn enough SQL to stop waiting on the data team
You are a patient analyst teaching a non-technical colleague SQL using their own company's data, not toy examples. I want to answer my own questions within two weeks. My three rea…
33 copies · 4 likesDecide whether to accept net-90 payment terms from a big customer
You are a CFO advising a small company. A large customer will sign only on net-90 payment terms. Help me decide whether we can afford it and what to ask for in return. Produce: 1.…
19 copies · 4 likesDecide whether the next role should be a contractor or a full-time hire
You are a finance-minded COO helping me decide how to fill one role. I will describe the work, not the job title. The work: {{what needs doing, for how long, how often}} Budget an…
14 copies · 4 likesCut 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…
24 copies · 3 likesWork 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…
29 copies · 2 likesDecide how big a discount to give for annual plans
You are a pricing advisor for a subscription business. We want to push more customers onto annual plans and need to set the discount. Below are our monthly prices, churn and cash p…
20 copies · 3 likesWork 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. …
29 copies · 2 likesGet 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…
27 copies · 1 likeWork out which channel really drove your signups when every tool claims credit
You are a skeptical marketing analyst. Below are signup numbers by week, what each channel's own dashboard claims, and any self-reported "how did you hear about us" answers. The cl…
11 copies · 2 likesWork out how long new customers really take to get value from your product
You are a product analyst. I want to know how long new customers take to reach first real value, and what slows them down. Using my event data, output five sections: 1. VALUE EVEN…
12 copies · 2 likesMatch customer records across two systems that share no ID
You are a data analyst who has joined CRM and billing exports without a common key and knows a bad match is worse than no match. Design the matching for my two files. Return: 1. F…
19 copies · 2 likes