🔧 AI Prompt Library

1,660 ready-to-use AI prompts — copy, paste, and get results instantly.

Featured Prompts

1,660 prompts

data SQL Intermediate

ChatGPT Prompt: SQL Window Function Tutorial With Practical Examples

You are a SQL teacher. Walk me through window functions using realistic examples from analytics work. My database flavor: [POSTGRES | MYSQL | BIGQUERY | SNOWFLAKE] My current SQL level (basic, intermediate): [LEVEL] The…

💡 Window functions don't reduce row count — that's why they beat GROUP BY when you need the per-row co…

👁 17 views Open prompt →

writing Business Documents Intermediate

Executive Summary for Report

Write an executive summary for a [type] report. Key findings: [finding 1, 2, 3]. Recommendations: [rec 1, 2, 3]. The summary should: 1) Start with the most important conclusion, 2) Include 2-3 key data points, 3) List ac…

💡 Write this LAST, after the full report is done. Lead with the answer, not the process.

👁 16 views Open prompt →

business Advertising Intermediate

Google Ads Copy Variations

Write 5 variations of Google Search ad copy for [product/service]. Target keyword: [keyword]. Each ad should have: Headline 1 (30 chars max, include keyword), Headline 2 (30 chars max, benefit), Headline 3 (30 chars max,…

💡 Always include the target keyword in Headline 1. Test at least 3 variations.

👁 16 views Open prompt →

business Strategy Beginner

Customer Persona Template

Create a detailed customer persona for [business/product]. Include: Name, Age, Job title, Income range, Location, Goals (3), Frustrations (3), Where they get information, Social media platforms they use, Buying triggers,…

💡 Create 2-3 different personas. Your best customer and your growing customer segment.

👁 16 views Open prompt →

coding Python Beginner

Python Script - Read and Clean CSV

Write a Python script that: 1) Reads a CSV file using pandas, 2) Shows basic info (shape, dtypes, null counts), 3) Removes duplicate rows, 4) Fills missing values (numeric with median, text with mode), 5) Strips whitespa…

💡 Add a requirements.txt with pandas version. Always check the output after cleaning.

👁 16 views Open prompt →

data Visualization Intermediate

KPI Dashboard Design

Design a KPI dashboard for a [type of business]. Include: 1) Define 8-10 key metrics with formulas for calculation, 2) Specify data source for each metric, 3) Suggest visualization type for each (gauge, line, bar, number…

💡 The best dashboards answer one question: Are we on track? Start with that.

👁 16 views Open prompt →

hr Onboarding Intermediate

Employee Onboarding Plan - 30/60/90

Create a 30/60/90 day onboarding plan for a new [job title]. For each phase: goals (what they should achieve), tasks (specific actions), meetings (who they should meet), training (what to learn), milestones (measurable c…

💡 Assign a buddy on day 1. New hires with buddies are 36 percent more productive after 90 days.

👁 16 views Open prompt →

email Business Development Intermediate

Partnership Proposal Email

Write a partnership proposal email that gets responses. My business: [your company name and what you do] Target partner: [their company name and what they do] Partnership type: [co-marketing/integration/referral/white-l…

💡 Research the recipient — reference a recent blog post, product launch, or interview they did. Send t…

👁 16 views Open prompt →

writing Proposals Advanced

Grant Proposal for Non-Profit Organization

Write a compelling grant proposal for a non-profit organization: - Organization name: [name] - Mission: [mission statement] - Project title: [project name] - Funding requested: [amount] - Grant source: [foundation/gover…

💡 Research the funder's priorities and tailor language to match. Use specific numbers over vague claim…

👁 16 views Open prompt →

business Customer Success Advanced

Customer Retention Strategy and Churn Analysis

Help me build a customer retention strategy based on churn analysis: My business context: - Business type: [e.g., 'B2B SaaS', 'E-commerce subscription', 'Service business'] - Current monthly churn rate: [e.g., '5%'] - A…

💡 Reducing churn by just 5% can increase profits by 25-95%. Focus on the first 30 days — that's when m…

👁 16 views Open prompt →

hr Policies Intermediate

Employee Handbook Section: Remote Work Policy

Write a comprehensive remote work policy for our employee handbook: - Company type: [e.g., 'Tech startup, 50 employees', 'Professional services firm, 200 employees'] - Remote work model: [e.g., 'Hybrid (3 office / 2 rem…

💡 Have legal counsel review the policy before publishing. Update annually as remote work norms evolve.…

👁 16 views Open prompt →

creative Video & YouTube Intermediate

YouTube Thumbnail Concept with A/B Test Variations

Act as a YouTube growth strategist and graphic designer. My video is about [topic] and the title is "[video title]". Create detailed thumbnail concepts including A/B test variations. For each concept, describe: (1) **Vis…

💡 Use YouTube's A/B thumbnail testing feature (Test & Compare) to actually test these. Run each test f…

👁 16 views Open prompt →

education study materials Intermediate

ChatGPT prompt for creating practice quiz questions from study notes

Act as a tutor who creates effective revision materials. I will paste study notes. Turn them into a quiz that helps someone actually remember the material. Requirements: 1. Create a mix of question types: - multiple…

💡 Paste complete notes rather than one paragraph. If you want exam-style questions, mention the exam b…

👁 16 views Open prompt →

excel Audit Intermediate

ChatGPT Prompt for Excel Formula Audit on a Broken Reporting Sheet

Act as an expert Excel analyst. I have a reporting workbook that suddenly shows incorrect totals and inconsistent formulas across rows. Help me audit it systematically. Context: - Workbook purpose: [describe report] - T…

💡 Mention the exact formula pattern you expect, like SUMIFS, XLOOKUP, or INDEX MATCH. Paste 3 to 5 sam…

👁 16 views Open prompt →

marketing seo advanced

SEO Content Strategy with Keyword Clustering

Develop an SEO content strategy for [website/brand] targeting [primary audience] in [industry/niche]. The strategy should include: (1) Keyword research framework — seed keywords, long-tail variations, and question-based …

💡 Prioritize keyword clusters where you have topical authority and can rank quickly. Content depth and…

👁 16 views Open prompt →

legal compliance Intermediate

Terms of Service for Online Marketplace or Platform

Draft Terms of Service for an online [marketplace/platform type, e.g., freelancer marketplace, e-commerce platform, subscription service]. Cover the following sections: (1) Acceptance of terms and eligibility, (2) Accoun…

💡 Keep your ToS honest — courts have invalidated deceptive terms. Highlight key terms with bold (espec…

👁 16 views Open prompt →

excel Reports & Templates Beginner

Monthly Financial Report Template

Act as a financial analyst. Create a detailed monthly financial report template in Excel with: revenue breakdown by category, operating expenses with SUM formulas, net profit calculation, month-over-month comparison usin…

💡 Replace category names with your actual business categories. Add your company name for a personalize…

👁 15 views Open prompt →

excel Formulas & Functions Intermediate

INDEX MATCH as VLOOKUP Alternative

Show me how to use INDEX MATCH in Excel as a more powerful alternative to VLOOKUP. Create examples for: basic left-to-right lookup, reverse lookup (looking up values to the left), two-criteria lookup using INDEX MATCH MA…

💡 INDEX MATCH is faster on large datasets and works in any direction, unlike VLOOKUP.

👁 15 views Open prompt →

email Follow-ups Beginner

Professional Follow-Up Email After Meeting

Write a professional follow-up email after a business meeting. Context: I met with [Client Name] to discuss [Topic]. Key points discussed were [Point 1, 2, 3]. Action items agreed upon were [Action 1, 2]. Next steps: [Ne…

💡 Replace the brackets with your actual details. Send within 24 hours of the meeting.

👁 15 views Open prompt →

email Customer Replies Beginner

Reply to Angry Customer Complaint

Write a professional and empathetic response to an angry customer who complained about [specific issue — late delivery / wrong product / bad service]. The reply should: 1) Acknowledge their frustration without being defe…

💡 Never blame the customer. Even if they are wrong, focus on the resolution.

👁 15 views Open prompt →