Involve Asia

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.

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.

There is a publisher account named "Cashiu" on the Involve Asia affiliate platform (publisher='Cashiu', affiliate_id=1016390). This generates ~MYR 170/day on average over 15 days observed — also small. DO NOT conflate the two: - **Cashiu the product** — Commerce Media Ventures' cashback app. Its KPIs (installs, orders, DAU, revenue) come from `productnation-data-analytic.cashiu.*` tables. Real scale: dozens of installs/day. - **"Cashiu" the publisher** — an affiliate account on Involve Asia's network. Generates ~MYR 170/day in commissions. Appears in `jimmy.conversion_agg_offfer_promotion_country` with affiliate_id 1016390. Different thing. When the brief says "Cashiu revenue X" it must be unambiguous about which is meant.

Razzak Alkel has left Involve Asia. **Stop flagging "Razzak sole owner of five tech KT items"** as a single-point-of-failure — those KT items either need new ownership or are being formally closed. Treat his name appearing in any tracker as legacy data, not active assignment.

Feb–Apr 2026 figures numerically identical to Involve Asia — data integrity error blocking March P&L