Unit 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…
86 copies · 12 likesWORKS WITH ROWS
Prompts for Rows
Community-tested ways to get more useful results from Rows.
Add a promptWrite 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…
72 copies · 10 likesSegment a list by behaviour, then write to each
Here is my user data: {{paste CSV summary — signup date, plan, last active, key actions taken, source}}. 1. Propose 5 behavioural segments that would each get a genuinely differen…
83 copies · 10 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…
78 copies · 9 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…
64 copies · 8 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…
35 copies · 7 likesCannibalisation check across a whole site section
Here are my pages in one section with their target keywords and rankings: {{paste URL, title, target keyword, position, monthly clicks}}. 1. Identify every set of pages competing …
41 copies · 7 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…
42 copies · 6 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…
25 copies · 7 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 …
44 copies · 5 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…
37 copies · 5 likesRoadmap prioritisation you can defend
Here's my backlog: {{list items with any context you have}}. Our goal this quarter: {{goal}}. Team capacity: {{people and weeks}}. 1. For each item, state the outcome it's suppose…
18 copies · 7 likesBuild the dashboard someone will actually use
Design a dashboard for {{role}} who needs to decide {{decision}} on a {{cadence}} basis. Available data: {{list}}. Start from decisions, not charts: 1. List the decisions this per…
28 copies · 4 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…
7 copies · 4 likesSet the kill criteria before you start the bet
You are the person who has to shut this down if it fails. We are about to commit to {{initiative}}. The bet: {{what we are doing, why now, who is on it, cost in money and headcount…
9 copies · 3 likesProgrammatic page template that isn't thin
I want to generate pages for the pattern "{{pattern, e.g. best AI tools for X}}" across {{n}} values. My data per page: {{list available fields}}. 1. Tell me honestly whether this…
32 copies · 1 likeFind 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…
18 copies · 2 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: {…
9 copies · 2 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…
8 copies · 2 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…
4 copies · 2 likesPrune the pages nobody reads without losing the traffic you have
You are an SEO lead running a pruning pass on a site section. I will paste a page inventory: {{for each URL - title, target query, monthly clicks and impressions last 90 days, inte…
2 copies · 2 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 …
2 copies · 1 likeDecide 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…
2 copiesOutrank a worse page that is beating you
You are an SEO who does not assume better content wins. My page loses to a thinner one. Query: {{keyword}}. My page: {{URL, title, headings, word count}}. Theirs: {{title, headings…
2 copiesTurn 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…
1 copyDecide 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…