Search: "KPI query"

#marketing #content #repurposing

marketing Beginner

Content Repurposing Plan to Turn One Long Podcast Into 12 Assets

Turn one 60-minute podcast episode (transcript pasted below) into 12 derivative ...

Define KPIs for a Product Without Falling Into Vanity Metrics

Act as a product analyst. I'll describe a product. Help me define 5-7 KPIs that ...

#data #kpis #metrics

#sql #cohort analysis #retention

SQL Query to Find User Cohort Retention by Month

Write a SQL query to compute monthly cohort retention. Tables: - users(id, signu...

#business #operations #scaling

business Advanced

Business: Diagnose Why a Process That Worked at 10 People Is Breaking at 30

Our [PROCESS] used to run smoothly. Now at [N] people, it's leaking — [SYMPTOMS]...

#data #Google Sheets #dashboard

Google Sheets Dashboard with Automated Data Import

Act as a Google Sheets expert. Create a complete marketing dashboard in Google S...

#data quality #audit #pipeline

Data Quality Audit Checklist Pipeline Reliability Framework

You are a data engineer. Audit data quality for [PIPELINE / TABLE]. Run through:...

#swot analysis #strategic planning #business strategy

business Intermediate

ChatGPT Prompt: SWOT Analysis with Strategic Action Plan and Owner Assignment

Conduct a strategic SWOT analysis for [COMPANY/DIVISION/PRODUCT] and translate i...

#excel #power-query #unpivot

Turn a wide budget sheet into a flexible pivot-ready long format

I have a budget spreadsheet in wide format: one row per account, then 12 columns...

#coding #sql #query optimization

coding Advanced

ChatGPT prompt for reviewing SQL query performance and suggesting optimizations

Act as a senior SQL performance engineer. I will share a slow SQL query, the ta...

#kpi #scorecard #dashboard

excel intermediate

Excel Dashboard KPI Scorecard with Traffic Lights

Design an Excel KPI scorecard dashboard for [department] with: 1) KPI table with...

#tableau #churn #analytics

data intermediate

Tableau Dashboard Design for Customer Churn Analysis

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

#marketing #webinar #email

marketing Advanced

Webinar Promotion Email Sequence with Multi-Touch Attribution Plan

Act as a demand-gen marketer. Build a 5-email webinar promotion sequence plus po...

Funnel Analysis Query Diagnosing the Worst Drop-Off Step

I have an events table (event_name, user_id, event_time, properties JSON). Write...

#data #funnel #sql

#excel #dashboard #slicers

Excel Dashboard with Dynamic Slicers

Help me design a single-page Excel dashboard for KPIs (revenue, orders, conversi...

#power query #excel #data combine

Excel Power Query Combine Multiple Sheets Into Master Table

You are an Excel Power Query specialist. Walk me step-by-step through combining ...

#dates #iso #data cleaning

Convert Messy Excel Date Formats to Standardized ISO

I have a column of dates in Excel with inconsistent formats: '03/15/2024', '15-M...

Write a SQL Query for Cohort Retention Analysis

Write a portable SQL query (works on PostgreSQL and BigQuery) that produces a mo...

#data #sql #cohort

#data #SQL #funnel analysis

Write a SQL Query to Find Users Stuck Mid-Funnel

Write a SQL query that finds users stuck mid-funnel for re-engagement. Schema: e...

#marketing #budget #channel-mix

marketing Advanced

Quarterly Marketing Mix Allocation Plan

Given a quarterly marketing budget and historical channel performance (CAC, conv...

#requirements #sql #stakeholders

Data: Translate a Stakeholder's Vague Question Into a Real Query

A stakeholder asked me 'how is our growth doing?' Help me turn that into a real,...

#coding #sql #readability

coding Intermediate

Write a SQL query that you'll still understand in six months

Write a SQL query that answers this question: [QUESTION]. Tables and columns I h...

#power-query #m-language #etl

excel Advanced

Excel Power Query Recipe to Clean and Unify Multi-Sheet Sales Data

You are an Excel Power Query expert. I have a workbook with 12 monthly sales she...