Start for free

Verified by Fetch Hive

Cohort Analysis SQL From Event Schema

For analysts, product managers, and operators, this template turns a cohort question and pasted event schema into explicit membership rules, a dialect-specific analysis query, and duplicate- and missing-event checks. It flags undocumented fields and evidence gaps instead of inventing columns or running SQL.

Use this template

Opens in Fetch Hive. Free to clone, change anything, run it on your own account.

Tools used

OpenAI

Published by

Fetch Hive

Type

Workflow

How it works

Paste your cohort question, event schema, and SQL dialect. The workflow maps documented fields and interprets the cohort definition, then returns membership rules, an analysis-ready SQL query, and separate checks for duplicate and missing events, with unresolved schema gaps clearly labeled. It never executes SQL.

Good for

Analysts and product teams designing auditable cohort queries.

What runs, step by step

Provide your input

Event schema, Cohort question, and SQL dialect

Map supplied event schema

Capture documented tables, columns, event names, and gaps

Interpret cohort question

Identify entry event, period, outcomes, and ambiguities

Write cohort rules and SQL

Return dialect-specific query plus duplicate and missing-event checks

Use this template

Opens in Fetch Hive. Free to clone, change anything, run it on your own account.

Tools used

OpenAI

Published by

Fetch Hive

Type

Workflow

More templates like this

Browse all templates

Workflow

Verified by Fetch Hive

uses

AI Visibility Checker

Runs a customer question through ChatGPT and Gemini, looks up tracked ChatGPT conversations and AI search volume for the topic, and extracts the brands and sources in each answer. Returns one JSON object per data source.

tom_alan

Use template

Workflow

Verified by Fetch Hive

AI & API Dependency Change Watch

For engineers, engineering managers, and QA, this workflow checks the AI models, APIs, and data sources their product relies on against official vendor change notices. It produces an as-of-dated, source-linked brief of deprecations, retirements, price changes, and breaking API updates, ranked by urgency with a practical next action for each finding.

Fetch Hive

Use template

Workflow

Verified by Fetch Hive

AI Model Test Scores to Buyer Decision Memo

For analysts, product managers, and operators choosing among tested AI models, this template compares pasted quality, cost, latency, and failure evidence against a buyer priority. It produces a one-page decision memo with transparent scores out of 100, a recommendation, cited trade-offs, caveats, and a first re-test.