Root

**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.

From Lan Zhi Xiong's Friday Tech WIP (May 15), surfaced directly by Jim in Telegram. The briefing never surfaced this properly because Management Updates project (39206207) routes to Leadership, not Engineering: **TikTok Data Integration Crisis (CRITICAL):** - TikTok = 20% of total revenue via 18 publishers - Major data accuracy issues: duplicate transactions, zero amounts, partial trust infections - Required company-wide cleanup effort lasting ~1 month - Root causes: no staging environment, insufficient monitoring, API unreliability forced switch to dashboard scraping - Fixes planned: staging env (1-2 week testing), code-level guardrails, engineering ownership of dashboard automation **Shopper platform:** - Still generating ~4-figure revenue with active users despite planned exit - Decision: move to subdomain with single landing page for cashback, not kill immediately - Target: end of Thu/Fri, internal testing next week **Weekly deployment cadence already broken:** - Missing this week due to B3 tag 4 migration complexity - UI components break when clicked despite looking correct - Advertiser dashboard: 1 onboarded user, low confidence in active usage **Security gaps ahead of audit:** - Credential management issues (passwords not in bot manager) - Need service account strategy for BigQuery and other tools - API access controls need review (self-approval currently possible) **Next Steps flagged:** - Jimmy: review security access, establish service account policies - Jimmy: get product team update from Osama (30 min weekly check-ins needed) The Tech WIP posts are in Management Updates project (39206207) under `[Tech]` tags but route to Leadership synthesis — they need to feed Engineering synthesis instead.