Search: "hr analytics"

#conversion rate drop analysis #marketing analytics prompt #funnel diagnosis

ChatGPT prompt for diagnosing a sudden drop in conversion rate from mixed-source metrics

Act as a data analyst investigating a sudden conversion-rate drop. I need a stru...

#churn reason taxonomy #open text analysis #customer exit survey prompt

data Intermediate

ChatGPT prompt for churn reason taxonomy from open-text survey responses

Act as a customer insights analyst. I need to turn messy open-text churn or exit...

#SQL #window functions #analytics

SQL Window Functions Advanced Analytics Queries

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

#tableau #churn #analytics

data intermediate

Tableau Dashboard Design for Customer Churn Analysis

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

#ab-testing #statistics #analytics

A/B Test Analysis Statistical Significance Calculator Guide

Walk through a complete A/B test analysis for [experiment, e.g., testing two ema...

#data #quality #assessment

data intermediate

Data Quality Assessment Framework and Cleaning Checklist

Act as a data quality engineer and analytics architect. Help me build a systemat...

#data #sql #cohort-analysis

Customer Cohort Analysis SQL Query Templates for Retention Insights

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

#exit interview #employee relations #hr analytics

hr Intermediate

ChatGPT Prompt: Exit Interview Script with Theme Analysis Framework

Create an exit interview process for [COMPANY] that produces actionable insights...

data Intermediate

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...

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

#excel #cohort #retention

excel Advanced

Build a Cohort Retention Heatmap in Excel

I have customer signup and activity data in Excel. Help me build a monthly cohor...

#Power BI #DAX #dashboard

Power BI Dashboard Design Executive Sales Report

Help me design a Power BI executive sales dashboard. Data sources: [CRM data / S...

coding Intermediate

Refactor a Tangled React Component Into Custom Hooks

Refactor the React component below by extracting state and side effects into cus...

#coding #react #hooks

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

#data #analytics #investigation

Data: Find the Real Cause When a Metric Drops 12% Overnight

[METRIC] dropped 12% on [DATE]. The execs want an answer by EOD. Help me investi...

#legal #privacy policy #gdpr

legal Advanced

ChatGPT prompt for writing a privacy policy compliant with GDPR and CCPA

Act as a privacy law specialist familiar with GDPR, CCPA, and general data prote...

#privacy policy #GDPR #CCPA

legal Intermediate

Privacy Policy Generator: GDPR and CCPA Compliance Template

Help me create a comprehensive privacy policy that complies with GDPR (EU) and C...

#writing #linkedin #thought-leadership

writing intermediate

LinkedIn Thought Leadership Post Writing Framework and Templates

Create a complete LinkedIn thought leadership content system for executives and ...

customer-service intermediate

Customer Journey Map Creator for UX Research

Create a detailed customer journey map for my business. Details: Business/produ...

#customer-service #journey-map #ux

#marketing #funnel #conversion

marketing Advanced

Audit a Marketing Funnel for Where Money Is Leaking

I'll share funnel data. Identify the worst-performing stage and propose the 3 mo...

#marketing #analytics #metrics

marketing Intermediate

Decide which marketing metric to obsess over for the next quarter

I'm tracking 14 marketing metrics. Some are moving, some aren't, my team can't t...