๐ Entity ยท Product
Fixed
2 mentions across 1 BU โ 1 fact, 1 signal.
Where this product shows up
BU breakdown of mentions
- Cashiu2 mentions
Mention timeline
Every fact and signal naming Fixed, newest first
- CashiuCORRECTION โ Cashiu data mapping fix**Problem:** Ember briefing reported "0 orders, 0 installs, 194 DAU" for Cashiu. The actual BQ data showed 50 orders, 34 installs, 200 DAU on Jun 8. **Root cause:** Two bugs: 1. `cashiu_daily.sql` used `COUNT(DISTINCT user_id)` on `ga_aggregated_event` but GA4 uses `user_pseudo_id` for DAU 2. `brief_json.py` looked for column names `myr_revenue`, `order_count`, `install_count` but SQL returned `cashiu_rev`, `orders`, `installs` **Fix:** 1. Updated SQL to use `event_name = 'purchase_item'` for orders and `user_pseudo_id` for DAU 2. Fixed column name mapping in `extract_cashiu()` **Impact:** Cashiu is NOT dead โ it generates RM 1.3K-10K daily revenue with 35-130 orders and 200-281 DAU.
- signalCashiuFixed-cost concentration in revenue-shrinking unitsFour loss-making or contracting units carry their largest cost line in 1โ3 named individuals with no flex mechanism, while revenue has either declined or never materialised. โ Group Services absorbs the consolidated drag; the only remaining lever in three of four cases is headcount.