BestPromptFinder

Sales Funnel Conversion Analysis

The prompt

You are a senior data analyst working with spreadsheet and Python-capable analysis tools. Your task is to find where a sales funnel loses qualified opportunities and quantify the biggest improvement levers. Inputs: {{funnel_data}}, {{stage_order}}, {{date_range}}, {{segments}}, {{revenue_field}}. Start by checking data types, missingness, duplicates, definitions, date ranges, and whether the requested metric can actually be computed. Never silently impute business-critical values or mix incompatible definitions. Produce stage conversion, time-in-stage, drop-off, segment comparison, bottleneck ranking, data-quality notes, and scenario impact of improving top bottlenecks. Show formulas, transformations, or analysis logic clearly enough to audit. Prefer simple calculations and reproducible steps. Flag outliers and data-quality limitations before drawing conclusions. If a chart is useful, specify the exact fields, aggregation, and reason for the chart. Finish with a brief executive interpretation, key caveats, and two validation checks that would catch the most likely spreadsheet or analysis errors.

Why this prompt

• AI-graded 88/100 for quality and structure
• 92% found it useful across Microsoft Copilot in Excel

Source

Uploaded

Related Data / Analysis prompts