Use Sales and Feedback Data to Back Your Best Offerings

Data Analysis Claude advanced

Combine sales, margin and feedback evidence into a keep/grow/fix/kill call on each product or service.

When to use it: Use when deciding where to invest across your product or service range and gut feel keeps winning the argument.
You are a portfolio analyst for an Australian small business. Use the sales and feedback evidence below to work out which offerings deserve investment — a keep / grow / fix / kill call per offering, with the reasoning shown.

<context>
OFFERINGS: [LIST EACH PRODUCT/SERVICE]
SALES DATA: [PER OFFERING, WHATEVER YOU HOLD — units/jobs, revenue, margin or your best margin estimate labelled as estimate, over what period]
FEEDBACK SIGNALS: [PER OFFERING — review mentions, complaints, repeat purchases, what customers ask for]
EFFORT TO DELIVER: [PER OFFERING — time, hassle, dependency on one person or supplier]
STRATEGY NOTES: [CAPACITY LIMITS, SUPPLIER RISK, WHERE YOU WANT THE BUSINESS TO GO]
</context>

Before judging, normalise the comparison: same period for all offerings, revenue separated from margin (a bestseller can be a margin sinkhole), and effort counted as a cost. Where margin is missing, the analysis says [NEEDED: margin for X] and proceeds on revenue with that caveat visible.

<task>
1. Score each offering on three axes from MY data only: financial contribution, customer signal (love / indifference / friction), and effort-adjusted attractiveness.
2. Place each in keep / grow / fix / kill, with a two-line justification citing the specific numbers and feedback behind the call.
3. Handle conflicts explicitly: sells-well-but-reviews-poorly (fix or manage decline?), loved-but-barely-sells (pricing? visibility?) — name the conflict and the test that would resolve it.
4. Hidden-cost prompt: for the top 'grow' candidate, list the costs that scale with growth (time, stock, key-person load) so investment isn't decided on margin alone.
5. Sensitivity check: which single verdict is shakiest, which missing number would most change it, and how to get that number cheaply.
6. Actions: for each 'grow', the one investment to make first; for each 'fix', the specific fixable fault from the feedback; for each 'kill', the wind-down that protects existing customers.
</task>

<output_format>
Offering matrix (offering | financials | signal | effort | verdict | why) → conflict calls → hidden costs → sensitivity note → action list → data gaps.
</output_format>

Rules: no invented margins, industry benchmarks or demand claims; estimates I supplied stay labelled as estimates all the way to the verdict. En-AU spelling.

Copy the block above straight into Claude — anything in [BRACKETS] is yours to fill in.

Want it tuned to your business? Bring it to the free weekly call and we'll adapt it live.

Join the free call

More data analysis prompts

Decide Which Customer Questions Your Data Can Actually Answer

Triage your customer-behaviour questions against the data you really hold, and get spreadsheet-level recipes for the answerable ones.

Match the Right Simple Analysis to Your Business Data

Pick analysis techniques that fit your question, data shape and sample size — with spreadsheet steps and misread warnings.

Start Making Decisions With Data You Already Collect

Inventory the free data your existing tools emit and set up five 15-minute analyses plus a weekly numbers ritual.