Every

The May 19 briefing claimed Cashiu had "zero orders since May 13 (Day 5)" — this is incorrect as of live BQ data: - **purchase_item events** have been happening daily: 45 (May 13), 56 (May 14), 87 (May 15), 67 (May 16), 55 (May 17), 35 (May 18) - **validation_stats conversions** (with payouts): 39/10 validated/RM 59 (May 15), 142/17/RM 177 (May 16), 54/2/RM 84 (May 17), 75/0/RM 83 (May 18) - **DAU** for May 17 was 268 (session_start events), not ~170 as reported - **Signups** on May 17 = 0 (May 16 had 2 — the "2 signups" figure was from a prior day) The May 13-14 gap was real (no validated conversions those two dates) but the freeze resolved by May 15. Every day since May 15 has had purchase_item events, conversions, and cashback payouts. The "Day 5" (May 18) framing was stale — data shows 35 purchase_item events and 75 conversions on May 18 alone.

The iAds team's stated primary goal (Andrew Tay, Basecamp message) is to lift legitimate-source revenue to 30% of total, against a current baseline of 90%+ grey-area. Every iAds initiative — offer expansion, publisher recruitment, Cookie Stuffing compliance review — is framed against this 30% target. Use this as the durable iAds strategic anchor, not weekly ROI%/ROI$ tracking.

The previous `cashiu_daily.sql` query joined three Cashiu tables (`conversion_click_performance` × `install_aggregated` × `ga_aggregated_event`) on date alone, with NO foreign-key constraint. This produced a Cartesian product that multiplied row counts and inflated every SUM by 4-7 orders of magnitude. **Real Cashiu scale (verified 2026-05-13 with corrected query):** - Installs: **single-to-double digits per day** (5-68 in the last 8 days) - Orders/conversions: **30-160 per day** - Revenue: **MYR 0 – 8,900 per day** - DAU: 150-200 Cashiu is a SMALL product. Every prior briefing line citing "32M installs", "MYR 36M revenue", "100k orders" was wrong by 1,000,000×. SQL fix landed in commit (next push). When evaluating Cashiu in future briefs, anchor on the real numbers above. Cashiu's value to Involve Asia is in the product narrative + future scale, NOT current revenue magnitude.