Search: "text functions"

data Advanced

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

data Advanced

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

#javascript #refactoring #es2024

coding Advanced

Refactor Legacy JavaScript to Modern ES2024 Standards

Refactor the following legacy JavaScript code to modern ES2024 standards: [PAST...

#marketing #instagram #content calendar

marketing Intermediate

30-Day Content Calendar for Instagram

Create a 30-day Instagram content calendar for [BRAND] in the [NICHE] niche, pos...

#writing #editing #clarity

writing Beginner

Convert Long Sentences to Punchy Prose

Take my draft text and rewrite it to cut average sentence length to under 18 wor...

#excel #xlookup #index match

excel Beginner

ChatGPT prompt for fixing broken Excel lookup formulas across multiple sheets

Act as a senior Excel troubleshooting expert. I have a workbook where lookup fo...

#data #machine learning #classification

data Advanced

Machine Learning Model Selection Guide for Classification

Help me select the right machine learning model for a classification problem. My...

productivity intermediate

Project Kickoff Planning Checklist: Deliverables, Milestones & RACI

Create a comprehensive project planning and kickoff package. My project: Projec...

#project-management #kickoff #raci

#typography #type-scale #design-system

design intermediate

Typography Hierarchy & Type Scale System for Digital Products

Help me design a robust typography system for my digital product. Context: Prod...

writing Intermediate

Long-Form Blog Post Outline With Search Intent and SERP Gap Analysis

Build a detailed outline for a long-form blog post (2,500-3,500 words) targeting...

#writing #seo #blog

#writing #editing #executive-summary

writing Intermediate

Convert a Dense Whitepaper Into a Plain-English Executive Summary

Read the whitepaper text below and produce a 1-page executive summary written fo...

#excel #pivot-table #calculated-field

excel Intermediate

Excel Pivot Table Calculated Field for Margin Percentage by Segment

I have a sales table with columns: order_id, date, customer_segment, product, re...

#socratic method #discussion #teaching

education Intermediate

Generate Socratic Questions for Class Discussion

Generate 12 Socratic questions for a class discussion on [TEXT/TOPIC]. Mix quest...

excel Advanced

Excel VBA Macro to Auto-Format Monthly Reports

Write a VBA macro that, when run, formats the active sheet as a monthly report: ...

#excel #vba #macros

#excel #power-query #unpivot

excel Intermediate

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

design Intermediate

Get Structured UX Feedback on a Screen or Flow

You are a senior UX designer conducting a heuristic review. I will describe (or ...

#design #ux #usability

#youtube #seo #video-marketing

marketing intermediate

YouTube Video SEO Strategy and Script Optimization Guide

Optimize a YouTube video for search and discovery on the topic: [video topic]. P...

#XLOOKUP #INDEX MATCH #multi-criteria lookup

excel advanced

Excel XLOOKUP Multi-Condition: Advanced Lookup Formulas Guide

I need to look up values in Excel using multiple conditions. My dataset has colu...

#SQL #GROUP BY #window functions

data intermediate

SQL Advanced Queries: GROUP BY, HAVING, and Window Functions

Help me write advanced SQL queries for [database: PostgreSQL/MySQL/BigQuery/SQL ...

excel Advanced

Excel VBA Macro to Automate Repetitive Report Formatting

Write an Excel VBA macro that automates the formatting of a weekly report I rece...

#VBA #macro #automation

excel Beginner

ChatGPT Prompt: Excel SUMIFS Formula Builder for Multi-Condition Aggregation

You are an Excel formula expert. I need to build a SUMIFS formula that totals va...

#excel #sumifs #formulas

#marketing #content #repurposing

marketing Intermediate

ChatGPT Prompt: Content Repurposing Plan Turning One Long Post Into Ten Pieces

You are a content marketer. Take one long-form post and produce a 10-piece repur...

#excel formulas #dynamic arrays #dashboard

excel Intermediate

ChatGPT Prompt: Excel Dynamic Array Formulas for Reporting Dashboards

Build a reporting dashboard using Excel 365 dynamic array formulas (FILTER, SORT...