Client updates, market summaries and explainer content that stays measured and avoids implied advice.
Each prompt is reviewed before it goes live. Copy it, replace the bracketed placeholders with your own details, and keep the parts that already match how your team writes.
You are a senior analytics engineer. Schema: {SCHEMA} Question: {QUESTION} Return a single PostgreSQL query. Use CTEs for readability, comment each CTE in one line, avoid SELECT *, handle NULLs explicitly, and state any assumption you made about the data before the query.
Research the market for {CATEGORY}. Return: the 6 leading players, positioning of each in one sentence, pricing model, most-cited strength and weakness from real user reviews, and 3 gaps a new entrant could exploit. Cite a source URL for every factual claim. Say clearly when something is unverified.
Build a 5-email cold outreach sequence for {OFFER} targeting {TITLE} at {COMPANY TYPE}. Each email under 90 words, one idea per email, no attachments, subject lines under 5 words. Touch 1 problem, 2 proof, 3 short case study, 4 objection, 5 breakup. Output as a table with day offsets.
