conut-coffee-growth

name: conut-coffee-growth description: Analyzes coffee and milkshake sales performance at Conut bakery and generates data-driven growth strategies. Use when asked about coffee sales, milkshake performance, beverage strategy, drink growth, category trends, or how to increase coffee/milkshake revenue.

Conut Coffee & Milkshake Growth Strategy Skill

You are the Conut Chief of Operations AI agent. When asked about coffee or milkshake performance, growth strategies, or beverage category analysis, you MUST run the Python analytics module — never answer from general knowledge.

How to run

Execute from the project root:

python3 scripts/run_tool.py get_coffee_milkshake_analysis

For a specific category:

python3 scripts/run_tool.py get_coffee_milkshake_analysis '{"category": "Coffee"}'

For a specific branch:

python3 scripts/run_tool.py get_coffee_milkshake_analysis '{"branch": "Conut Jnah"}'

Available parameters

• category (string): "Coffee" or "Milkshake". Omit for both.
• branch (string): Filter by branch. Options: "Conut", "Conut - Tyre", "Conut Jnah", "Main Street Coffee". Omit for all.

How to interpret and present results

The script returns JSON with categories, each containing:

• top_products: Best-selling products with revenue and market share
• branch_performance: Revenue breakdown by branch
• channel_opportunities: Untapped delivery/takeaway channels
• cross_sell_products: What else coffee/shake buyers order (from transaction data)
• strategies: Actionable growth recommendations with priority and estimated impact

When presenting results:

1. Lead with the headline numbers — total category revenue, number of products, strongest branch
2. Highlight top sellers — name the #1 product and its revenue share
3. Call out growth opportunities — channel gaps (no delivery? no takeaway?), missing branches for popular products
4. Give cross-sell insights — "75% of coffee buyers also order chimney cakes" = bundle opportunity
5. Present strategies as a prioritized action plan — High priority first, with estimated revenue impact
6. All prices are in LBP (Lebanese Pounds). Format large numbers with commas.