Search: "cohort"

#data #SQL #business intelligence

SQL for Business Intelligence

Write SQL queries for a business intelligence dashboard. Tables: orders, custome...

#cohort retention analysis #subscription churn #sql retention

ChatGPT prompt for cohort retention analysis from subscription data

You are a product data analyst. I need help analyzing subscription retention by ...

#cohort analysis #retention #sql

ChatGPT Prompt: Cohort Retention Analysis SQL with Visualization Plan

Write SQL for a cohort retention analysis and explain how to visualize it. Cont...

#business #pricing #strategy

business Advanced

Pricing Strategy Memo with Value-Based Reasoning and Test Plan

You are a pricing consultant for B2B SaaS. Draft a 2-page pricing strategy memo ...

#excel #cohort analysis #retention

excel Advanced

ChatGPT Prompt for Excel Cohort Retention Tracker from Raw Transactions

I have raw transaction data in Excel with columns for customer_id, first_purchas...

👁 10 views

coding advanced

SQL Window Functions: Advanced Analytics Query Guide

Act as a senior data engineer and SQL expert. Help me master SQL window function...

#coding #sql #window-functions

👁 10 views

finance Advanced

SaaS Unit Economics Calculator with Plain-English Narrative

Act as a SaaS finance analyst. I will paste customer cohort data and revenue fig...

#finance #saas #unit economics

👁 10 views

SQL Window Function to Find Customer Churn Cohort by First-Purchase Month

Write a Postgres query to produce a monthly cohort retention table. Source table...

#data #sql #postgres

👁 9 views

#sql #churn analysis #customer retention

ChatGPT prompt for building a SQL query to analyze customer churn patterns

Act as a senior data analyst specializing in customer retention. I need SQL que...

#SQL #window functions #analytics

data advanced

SQL Window Functions Advanced Analytics Queries

Teach me SQL window functions with practical business analytics examples. Cover:...

#finance #unit-economics #ltv

finance advanced

Unit Economics Analysis: LTV, CAC, and Payback Period

Act as a startup finance advisor and growth analyst with expertise in SaaS and s...

#A/B testing #statistical analysis #hypothesis testing

data advanced

A/B Test Results Analysis: Statistical Significance and Reporting

Help me analyze the results of an A/B test I ran: Experiment name: [name], Test ...

#tableau #churn #analytics

data intermediate

Tableau Dashboard Design for Customer Churn Analysis

Design a Tableau dashboard to analyze customer churn. Include: 1) Overall churn ...

#SaaS metrics #financial model #unit economics

finance Advanced

Financial Model Template for SaaS Business Unit Economics

Build a financial model framework for a SaaS business covering unit economics an...

#data #sql #cohort-analysis

Cohort Retention Analysis SQL Query With Visualization Stub

Write a SQL query that produces a monthly cohort retention table for [SaaS PRODU...

#data #root-cause #analysis

Investigate an Unexpected Drop in a Key Metric

You are a data detective. A key metric dropped 18% week-over-week with no obviou...

#data #sql #cohort-analysis

data advanced

Customer Cohort Analysis SQL Query Templates for Retention Insights

Build a complete SQL-based customer cohort analysis system for subscription or e...

#cohort analysis #retention #saas

Cohort Retention Analysis Framework SaaS Product Health

Act as a product analyst. Build a cohort retention analysis for [PRODUCT] using ...

#marketing #growth #funnel

marketing Advanced

ChatGPT Prompt: Marketing Funnel Diagnostic Questions for Stalled Growth

You are a growth marketing diagnostician. Help me find where my funnel is leakin...

#data #sql #window-functions

Write Window Functions That Replace a Subquery Loop

Act as a senior SQL engineer. I need to compute {{describe: e.g., 7-day rolling ...