CORRECTION

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

iPrice was acquired and subsequently shut down. The acquisition is complete — it is NOT an active Corp Dev project. The 14 open ClickUp tasks in the iPrice Deal project are stale cleanup items, not an active deal pipeline. **Stop surfacing iPrice as "80 days silent", "dormant deal", or "active" in briefings, signals, and Watch lists.** The Corp Dev section should not mention iPrice at all unless new activity actually materializes. This supersedes and clarifies the 2026-05-04 entry ("not actively maintained") — the reality is stronger: the deal closed and iPrice was shut down. The prior entries are marked HISTORICAL below.

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.

zero revenue/orders with engagement intact (50–59 installs, 163–176 DAU) — points to payment gateway or offer-configuration failure, not an app outage.

Two named publisher failures — Sam Yap's ISP ("iAds Social Project", 3.5k clicks/day, zero conv on Shein/Trip/Klook/Oppo ID) and Raja Nazaruddin's iAds Vivo (traffic dead late April). Both are PG-managed publishers. Validation pipeline itself is healthy.

Previous entries (2026-05-14 and 2026-05-15) incorrectly conflated "iAds Social Project" (aff_id 1008463) with iAds the publisher. This is wrong: - **"iAds Social Project"** is a Publisher Growth publisher managed by Sam Yap (Enterprise PG). The "iAds" in its name is misleading — it has zero operational connection to iAds as a publisher. - **iAds** is a publisher on Involve Asia's platform managed by Andrew Tay — they send traffic to platform offers just like any other publisher. - Sam's ISP and iAds publisher are unrelated entities. They both send traffic to the same platform offers (Shein, Trip, Klook, Oppo ID) but that's coincidental — any publisher can target those offers. - **Validation pipeline** is Group Services (Wing Loon), not iAds. Corrected diagnosis: Sam Yap manages an ISP publisher that is firing 3.5k clicks/day with zero conversions on Shein, Trip, Klook, Oppo ID. This is a PG ops issue — publisher traffic quality or postback misconfiguration. Nothing to do with Andrew Tay or iAds.

**CORRECTION 2026-05-15: "iAds Social Project" has no connection to iAds publisher. See full correction entry below.** Investigation 2026-05-14 BQ deep-dive: the 14-day zero-conversion period across certain publishers (last validated conversion 2026-04-29) is **not** a validation-pipeline collapse. The BUP-1 framing as "validation backlog · realization rate 5.6%" was wrong. The actual story is two distinct operational issues across two publishers: **ISP publisher "iAds Social Project" (aff_id 1008463, Sam Yap-managed, Enterprise PG)** — the dominant click source at ~3.5k/day from May 5 onward. Clicks fire on LIVE converting offers (Shein, Trip.com, Klook, Oppo ID) but produce ZERO conversions. **Smoking gun**: Shein-CPS — ISP sent 4,465 clicks; other publishers run Shein at ~3.15% conversion rate; expected ~140 conversions, actual 0. That's not variance. Almost certainly traffic-quality (bot / incentivised / misattributed audience) OR a tracking/postback misconfiguration specific to this publisher's links. **Sam Yap should be asked to verify ISP's traffic source + check postback URLs.** **iads vivo (aff_id 1065674, Raja Nazaruddin-managed)** — was healthy at 70-370 clicks/day with 1-7 conversions through April. **Late April collapse**: April 29 dropped to 3 clicks; May 1-12 just 1-3 clicks/day. This is a publisher traffic source dying, not a tracking issue. **Raja should check ivans vivo's upstream traffic source.** **Validation pipeline is fine**: in the same 14-day window, the other 88 Raja-managed publishers recorded 821k conversions on 87M clicks. Validation infrastructure is processing normally. iAds-specific zero is a real operational outcome, not a data lag. When the brief next addresses the iAds "validation collapse" item, anchor the diagnosis on these two specific operational issues, not on validation-pipeline framing. The 92.7% deep-critical backlog metric Andrew Tay's sheet shows must mean something different from what BUP-1 inferred — likely an internal iAds-team metric about offer health or postback latency, not BQ aggregate latency.

Each BU has its own performance metrics that the briefing should frame around, not generic terms like "throughput" or "collapse": - **Enterprise PG**: monthly initiatives per person (target 5/month, 60/year); new publisher sign-ups (target funnel: outreaches → pitches → onboarding → live); concentration risk - **Enterprise AG**: advertiser revenue split per account manager; offer health decay; named advertiser deals - **Subscriptions**: active account count, MRR concentration by client, integration request queue, pitch tracker - **iAds**: ROI%, offer count, publisher count, named partners (Trip, Stars, JP) - **CMV Video**: ClickUp deal pipeline (Leads → Proposal → Confirmed), billing AR, brand milestones, smartphone launch coverage - **Cashiu**: installs, DAU, signups, AOV, daily orders, daily revenue - **CMV Affiliate**: P&L by month, key publishers - **Group Services**: headcount, staff costs, marketing budget burn, payment/billing queue - **Corp Dev**: MDEC approval status, exit process milestones (iPrice deal is CLOSED — see CORRECTION 2026-06-01) Briefings should cite the SPECIFIC named publishers/advertisers/clients/initiatives — not abstract metrics. "Mind has 59 pitches, only UC Browser converted" beats "PG throughput collapsed".

iPrice is NOT being actively maintained anymore. This is a deliberate strategic posture, not an oversight. **Stop surfacing "iPrice Day N silent" or "iPrice integration stalled"** as flags — that's the current state by design. iPrice content/affiliate maintenance has been deprioritised.

50 consecutive days of Basecamp silence as of 01 May 2026