Profitability by Customer Segment Prompt
Prompt
Analyze profitability by customer type. Customer segments: [RESIDENTIAL/COMMERCIAL/PROPERTY MANAGERS, PRICE-SENSITIVE/PREMIUM]. Data: [LAST 12 MONTHS: customers, revenue, jobs/customer, margin]. Output: Ranked by profitability. Which segment should you grow? Which should you exit? Pricing strategy by segment.
Why it works
Profitability ranking by customer segment reveals whether the businesses that require the most service complexity (commercial, property managers) actually generate sufficient margin to justify that complexity. The jobs-per-customer and lifetime value metrics reveal the difference between high-revenue single-visit customers and lower-revenue but recurring customers whose lifetime profitability is superior. The 'which segment to grow vs. exit' output produces a customer acquisition strategy, not just a financial analysis.
Watch out for
Customer segment profitability must account for acquisition cost — a high-margin commercial customer that required significant business development effort may have a lower lifetime return than a lower-margin residential customer acquired through referral at near-zero cost. Build acquisition cost per segment into the profitability model to get a complete picture of which segments to invest in for growth.
Used by