[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_179":180,"_181":182},"routes/_app.x.$handle.$name",{"_96":95,"_31":43,"_105":86,"_26":106,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":24,"_120":121,"_122":24,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":-5,"_55":24,"_56":-5,"_57":-5,"_58":59,"_60":61,"_62":63,"_64":65,"_66":67,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":24},"version",3,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","db.ts","latestPath","fileId","a019aea8-fa75-11f0-8990-42dde27851f2","name","fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst RESPONSES_TABLE = \"pmf_survey_responses\";\nconst INSIGHTS_TABLE = \"pmf_survey_insights\";\n\nawait createTables();\n\nexport interface SurveyResponse {\n id: number;\n timestamp: number;\n disappointment: \"very\" | \"somewhat\" | \"not\";\n user_type: string;\n main_benefit: string;\n improvement: string;\n email?: string;\n persona?: string;\n analysis?: string;\n}\n\nexport interface Insights {\n id: number;\n timestamp: number;\n pmf_score: number;\n segmented_pmf_score: number;\n total_responses: number;\n very_disappointed_count: number;\n somewhat_disappointed_count: number;\n not_disappointed_count: number;\n hxc_profile: string;\n top_benefits: string;\n top_improvements: string;\n roadmap_double_down: string;\n roadmap_address_gaps: string;\n personas_in_segment: string;\n}\n\nexport async function storeResponse(\n response: Omit,\n): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${RESPONSES_TABLE} \n (timestamp, disappointment, user_type, main_benefit, improvement, email, persona, analysis)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n Date.now(),\n response.disappointment,\n response.user_type,\n response.main_benefit,\n response.improvement,\n response.email || null,\n response.persona || null,\n response.analysis || null,\n ],\n );\n return result.lastInsertRowid as number;\n}\n\nexport async function updateResponseAnalysis(\n id: number,\n persona: string,\n analysis: string,\n): Promise {\n await sqlite.execute(\n `UPDATE ${RESPONSES_TABLE} SET persona = ?, analysis = ? WHERE id = ?`,\n [persona, analysis, id],\n );\n}\n\nexport async function getAllResponses(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${RESPONSES_TABLE} ORDER BY timestamp DESC`,\n );\n return rowsToResponses(result);\n}\n\nexport async function getResponseById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${RESPONSES_TABLE} WHERE id = ?`,\n [id],\n );\n const responses = rowsToResponses(result);\n return responses[0] || null;\n}\n\nexport async function getResponsesByDisappointment(\n level: \"very\" | \"somewhat\" | \"not\",\n): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${RESPONSES_TABLE} WHERE disappointment = ? ORDER BY timestamp DESC`,\n [level],\n );\n return rowsToResponses(result);\n}\n\nexport async function getResponseCounts(): Promise<{\n very: number;\n somewhat: number;\n not: number;\n total: number;\n}> {\n const result = await sqlite.execute(\n `SELECT disappointment, COUNT(*) as count FROM ${RESPONSES_TABLE} GROUP BY disappointment`,\n );\n\n const counts = { very: 0, somewhat: 0, not: 0, total: 0 };\n for (const row of result.rows as any[]) {\n const level = row[0] as \"very\" | \"somewhat\" | \"not\";\n const count = row[1] as number;\n counts[level] = count;\n counts.total += count;\n }\n return counts;\n}\n\nexport async function storeInsights(insights: Omit): Promise {\n await sqlite.execute(\n `INSERT INTO ${INSIGHTS_TABLE} \n (timestamp, pmf_score, segmented_pmf_score, total_responses, \n very_disappointed_count, somewhat_disappointed_count, not_disappointed_count,\n hxc_profile, top_benefits, top_improvements, roadmap_double_down, \n roadmap_address_gaps, personas_in_segment)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n Date.now(),\n insights.pmf_score,\n insights.segmented_pmf_score,\n insights.total_responses,\n insights.very_disappointed_count,\n insights.somewhat_disappointed_count,\n insights.not_disappointed_count,\n insights.hxc_profile,\n insights.top_benefits,\n insights.top_improvements,\n insights.roadmap_double_down,\n insights.roadmap_address_gaps,\n insights.personas_in_segment,\n ],\n );\n}\n\nexport async function getLatestInsights(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${INSIGHTS_TABLE} ORDER BY timestamp DESC LIMIT 1`,\n );\n const insights = rowsToInsights(result);\n return insights[0] || null;\n}\n\nexport async function getAllInsights(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${INSIGHTS_TABLE} ORDER BY timestamp DESC`,\n );\n return rowsToInsights(result);\n}\n\nfunction rowsToResponses(result: { columns: string[]; rows: unknown[] }): SurveyResponse[] {\n return result.rows.map((row: any) => {\n const obj: Record = {};\n result.columns.forEach((col, idx) => {\n obj[col] = row[idx];\n });\n return obj as SurveyResponse;\n });\n}\n\nfunction rowsToInsights(result: { columns: string[]; rows: unknown[] }): Insights[] {\n return result.rows.map((row: any) => {\n const obj: Record = {};\n result.columns.forEach((col, idx) => {\n obj[col] = row[idx];\n });\n return obj as Insights;\n });\n}\n\nasync function createTables() {\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${RESPONSES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n timestamp INTEGER NOT NULL,\n disappointment TEXT NOT NULL,\n user_type TEXT NOT NULL,\n main_benefit TEXT NOT NULL,\n improvement TEXT NOT NULL,\n email TEXT,\n persona TEXT,\n analysis TEXT\n )`,\n );\n\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${INSIGHTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n timestamp INTEGER NOT NULL,\n pmf_score REAL NOT NULL,\n segmented_pmf_score REAL NOT NULL,\n total_responses INTEGER NOT NULL,\n very_disappointed_count INTEGER NOT NULL,\n somewhat_disappointed_count INTEGER NOT NULL,\n not_disappointed_count INTEGER NOT NULL,\n hxc_profile TEXT NOT NULL,\n top_benefits TEXT NOT NULL,\n top_improvements TEXT NOT NULL,\n roadmap_double_down TEXT NOT NULL,\n roadmap_address_gaps TEXT NOT NULL,\n personas_in_segment TEXT NOT NULL\n )`,\n );\n}\n","createdAt",["D",1769404355241],"branchVersion","branchId","7d938fa2-fa75-11f0-aded-42dde27851f2","id","7d9310a4-fa75-11f0-aded-42dde27851f2","pmf-survey",["D",1769404297336],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Superhuman PMF Framework - measure product-market fit","imageUrl","9319c175-2593-4f88-ba21-04f2ef7b1c28","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","d663a026-6449-42f6-9156-1d4a2d64d38c","tursoName","7d9310a4fa7511f0aded42dde27851f2","tursoHostname","7d9310a4fa7511f0aded42dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789446061244],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_104":100},"org",{"_96":95,"_97":98,"_99":100,"_18":53,"_101":102,"_103":24},"branch",{"_13":85,"_31":86,"_41":40,"_87":42,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":43,"_94":95},"isOwned",21,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","dcm31","handle","displayName","Charlie","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/3e904faa-3764-4629-c475-f561a49b0000/square512?exp=1789527599&sig=51499146c4fdfaf91edf1ed334b7605df7afc0bcd16381bafc7eeee3eae1de47","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_41":42,"_31":43,"_36":174,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":-5,"_55":24,"_56":-5,"_57":-5,"_58":59,"_60":61,"_62":63,"_64":65,"_66":175,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":176,"_80":177,"_82":178,"_84":24},"tree",[161,162,163],"files",[161,162,163],"counts",{"_151":59,"_152":139,"_153":59,"_154":155,"_156":157},"contents",[127,128,129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":143,"_31":144,"_29":145,"_131":-5,"_39":40,"_38":146,"_132":147,"_36":148,"_13":59,"_32":20,"_34":149,"_23":24,"_134":-5,"_26":150},{"_41":136,"_31":137,"_29":138,"_131":-5,"_39":40,"_38":139,"_132":24,"_36":140,"_13":59,"_32":20,"_34":141,"_23":24,"_134":-5,"_26":142},{"_41":130,"_31":27,"_29":30,"_131":-5,"_39":40,"_38":14,"_132":24,"_36":133,"_13":59,"_32":33,"_34":35,"_23":24,"_134":-5,"_26":135},"a019acdc-fa75-11f0-8990-42dde27851f2","parentId","latest",["D",1769404355241],"label",[27],"88f3af6c-fa75-11f0-831a-42dde27851f2","README.md","88f3b05c-fa75-11f0-831a-42dde27851f2",1,["D",1769404316408],"# PMF Survey\n\nMeasure and optimize your product-market fit using the Superhuman framework from [First Round Review](https://review.firstround.com/how-superhuman-built-an-engine-to-find-product-market-fit/).\n\n## What this does\n\n1. Collect survey responses with the 4 proven PMF questions\n2. AI automatically analyzes responses and assigns personas\n3. Calculate your PMF Score (benchmark: 40%)\n4. Generate actionable insights:\n - High-Expectation Customer (HXC) profile\n - What users love (from \"very disappointed\" responses)\n - What holds users back (from \"somewhat disappointed\" responses)\n - Roadmap recommendations (50% double down / 50% address gaps)\n\n## The Framework\n\nThe Superhuman PMF engine uses Sean Ellis's leading indicator: **% of users who would be \"very disappointed\"** without your product.\n\n**Benchmark:** Companies with strong traction exceed **40%**. Companies struggling to grow are below 40%.\n\n### The 4 Survey Questions\n\n1. **How would you feel if you could no longer use [product]?**\n - Very disappointed\n - Somewhat disappointed\n - Not disappointed\n\n2. **What type of people do you think would most benefit from [product]?**\n\n3. **What is the main benefit you receive from [product]?**\n\n4. **How can we improve [product] for you?**\n\n### The 4-Step Process\n\n1. **Segment** to find supporters and paint a picture of your high-expectation customers\n2. **Analyze** feedback to convert on-the-fence users into fanatics\n3. **Build roadmap** by doubling down on what users love AND addressing what holds others back\n4. **Repeat** and track your PMF score over time\n\n## Getting started\n\n1. Click [**Remix**](/?intent=remix)\n2. Store your `OPENAI_API_KEY` as an environment variable\n3. Customize [`PROMPT.txt`](./PROMPT.txt) with your product name and context\n4. Share the survey link with your users\n5. Watch insights populate in your dashboard\n\n## How it works\n\n**Survey**\n- Users complete the 4-question survey\n- Responses are stored with timestamp\n\n**AI Analysis**\n- Each response is analyzed to assign a persona\n- Personas are inferred from the \"type of people\" answer (Q2)\n- Main benefits and improvement requests are extracted\n\n**Dashboard Insights**\n- **PMF Score**: % of \"very disappointed\" responses\n- **Segmented PMF**: Score filtered to personas from the \"very disappointed\" group\n- **HXC Profile**: AI-generated High-Expectation Customer description\n- **Benefits Word Cloud**: What your happiest users love (from Q3)\n- **Improvements Word Cloud**: What holds \"somewhat disappointed\" users back (from Q4)\n- **Roadmap Recommendations**: Split 50/50 between doubling down and addressing gaps\n\n## Key Insights\n\nFrom the original Superhuman article:\n\n> \"If you only double down on what users love, your product-market fit score won't increase. If you only address what holds users back, your competition will likely overtake you.\"\n\nThe framework teaches you to:\n- **Ignore** \"not disappointed\" users entirely - they won't convert\n- **Focus on** \"very disappointed\" users to understand what to double down on\n- **Convert** \"somewhat disappointed\" users who value your main benefit\n",[137],"93ab5522-fa75-11f0-bd78-42dde27851f2","PROMPT.txt","93ab55ea-fa75-11f0-bd78-42dde27851f2",2,true,["D",1769404334403],"You are an expert product analyst specializing in the Superhuman PMF (Product-Market Fit) framework.\n\nYour job is to analyze survey responses and extract key insights for product-market fit optimization.\n\n## Your Product Context\n\nProduct Name: [YOUR PRODUCT NAME]\nProduct Description: [Brief description of what your product does]\n\n## Survey Response Analysis\n\nFor each survey response, you will:\n\n1. **Assign a Persona** based on the user's answer to \"What type of people would benefit most?\"\n - Extract the most relevant professional role or user type\n - Examples: \"Founder\", \"Manager\", \"Engineer\", \"Sales Rep\", \"Designer\", \"Executive\"\n - Keep personas concise (1-3 words)\n\n2. **Extract Key Themes** from the main benefit (Q3) and improvement requests (Q4)\n - Identify the core value propositions mentioned\n - Note specific features or capabilities valued\n - Flag concrete improvement requests\n\nReturn your analysis as JSON:\n\n{\n \"persona\": string,\n \"themes\": {\n \"benefits\": string[],\n \"improvements\": string[]\n },\n \"sentiment_notes\": string\n}\n\n## Aggregate Analysis\n\nWhen analyzing all responses together for insights, follow the Superhuman framework:\n\n### PMF Score Calculation\n- Count responses by disappointment level\n- PMF Score = (Very Disappointed / Total) × 100\n- Benchmark: 40% indicates strong product-market fit\n\n### Segmentation Strategy\n1. Identify all personas from \"very disappointed\" responses\n2. Filter to only include users with those personas\n3. Recalculate PMF Score for segmented group\n4. This reveals true fit within your ideal user base\n\n### High-Expectation Customer (HXC) Profile\nUsing ONLY \"very disappointed\" responses to Q2 (\"What type of people...\"):\n- Users describe themselves when answering this question\n- Synthesize into a rich, detailed persona description\n- Include: role, work patterns, pain points, goals, mindset\n\n### Benefits Analysis (What to Double Down On)\nFrom \"very disappointed\" users' Q3 answers:\n- Identify the most common benefits mentioned\n- These are your core value propositions\n- These should inform 50% of your roadmap\n\n### Improvements Analysis (What Holds Users Back)\nFrom \"somewhat disappointed\" users who value your main benefit:\n- First filter to those whose Q3 answer mentions your core benefits\n- Then analyze their Q4 answers\n- These are the barriers to deeper adoption\n- These should inform the other 50% of your roadmap\n\n### Roadmap Recommendations\nSplit evenly:\n- **Double Down (50%)**: Features/improvements that enhance what users already love\n- **Address Gaps (50%)**: Features that remove barriers for almost-fans\n\n### Important Notes\n- IGNORE \"not disappointed\" users entirely - they won't convert\n- The \"somewhat disappointed\" group matters only if they value your main benefit\n- Track PMF Score over time to measure progress\n",[144],"pulls","branches","forks","envVars",{"_158":59,"_160":59},"connections",{"_158":59,"_159":59},"count","unfilledCount","emptyCount",{"_41":143,"_31":144,"_29":145,"_131":-5,"_39":40,"_38":146,"_132":147,"_36":171,"_13":59,"_32":20,"_34":149,"_23":24,"_134":-5,"_165":172,"_26":173},{"_41":136,"_31":137,"_29":138,"_131":-5,"_39":40,"_38":139,"_132":24,"_36":168,"_13":59,"_32":20,"_34":141,"_23":24,"_134":-5,"_165":169,"_26":170},{"_41":130,"_31":27,"_29":30,"_131":-5,"_39":40,"_38":14,"_132":24,"_36":164,"_13":59,"_32":33,"_34":35,"_23":24,"_134":-5,"_165":166,"_26":167},["D",1769404355241],"children",[],[27],["D",1769404316408],[],[137],["D",1769404334403],[],[144],["D",1769404297336],["D",1789446061244],{"_96":95,"_104":100},{"_96":95,"_97":98,"_99":100,"_18":53,"_101":102,"_103":24},{"_13":85,"_31":86,"_41":40,"_87":42,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":43,"_94":95},"ctx",{"_78":-5,"_124":212,"_213":214,"_215":216,"_217":24,"_218":24,"_219":24,"_220":147,"_221":-5,"_222":-7,"_223":-7,"_224":59,"_225":24,"_226":24,"_227":-5,"_228":24,"_229":24,"_230":24,"_231":-5},"ENV",{"_183":184,"_185":186,"_187":86,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v3