Kit: Monthly marketing campaign pack for the Direksi (Zava Connect telco, September 2026)
=========================================================================================

FICTIONAL DEMO DATA. Not a real document. Any resemblance to real organisations or people is coincidental.

Scenario: https://hmarofiq.github.io/copilot-scenarios-asean/scenarios/tel-mkt-board-016/

CONTENTS
  - 01_Email_CMO_Board_Pack_Sep2026.docx: the CMO's request, the Direksi's questions from August and the deadline
  - 02_Marketing_Tracker_2026.xlsx: the tracker with Rules, budgets, FTTH history, August scorecard, and the empty Scorecard_Sep and Checks sheets (open this one in Excel)
  - 03_Meta_Ads_Export_Sep2026.xlsx, 04_Google_Ads_Export_Sep2026.xlsx, 05_TikTok_Ads_Export_Sep2026.xlsx: platform exports as downloaded
  - 06_BI_Extract_Campaign_Activations_Sep2026.xlsx: backend activations, orders, installs and RAFM flags
  - 07_WideWorld_Invoice_Recap_Sep2026.pdf: agency invoice (final media) and the agency's own recap
  - 08_Email_Malaysia_5G_Sep2026.docx: the Malaysian team's September update
  - 09_Notes_RAFM_Legal_FieldOps_Sep2026.docx: RAFM, Legal and Field Operations notes
  - 10_Zava_Connect_Board_Template.pptx: the board deck template (start Part B here)

SETUP (demo tenant only, never a customer or production tenant)
  1. Upload all files to one OneDrive folder in a demo or test tenant and open each once.
  2. Apply a non-encrypting sensitivity label if your tenant asks for one.
  3. Keep an untouched copy of the tracker before each run.

PRESENTER ANSWER KEY (what the seeded data should surface)
  - Rumah Terhubung: spend IDR 3,852.5 m vs budget 3,400.0 m (113.3%); installs 6,515 vs 7,200 (90.5%, Amber); cost per install IDR 591,325 vs 480,000 (+23.2%, Red); pacing 57.7% spent at 50% time (+7.7 pts, Amber). Overall Red. Backlog 2,870 orders over 14 days.
  - Merdeka Unlimited: spend IDR 4,665.8 m; activations 172,460 minus flagged 31,880 = valid 140,580 (93.7%, Amber); cost per valid add IDR 33,190 (+3.7%, Amber); pacing Green. Overall Amber. Agency's CPA 19,079 uses 228,550 summed platform conversions (132.5% of real activations).
  - Hari Malaysia 5G: RM 1,021,680 incl. SST -> net RM 946,000 x 3600 = IDR 3,405.6 m (not 3,823.1 m at spot incl. SST). New lines 6,480 (92.6%, Amber), not 16,200; cost per new line RM 146 (Green). Overall Amber.
  - Total three campaigns: IDR 11,923.9 m vs budget 11,820.0 m (100.9%). Brand Always-On IDR 226.8 m is other spend.
  - Google credit -38,450,000 belongs to August: do not net it (else MU spend 4,627.4 m). TikTok export is 22,384,600 (RH) and 51,570,000 (MU) below the invoice because it was pulled at 18:12.
  - FTTH CAGR 2021-2025 = 23.2% (4 years), not 18.1% (August deck used 5). Using 2026 YTD as a year gives 20.4% (wrong).
  - Concerns: FTTH overspend and install backlog; referral bonus farming in Karawang (47% of referral activations flagged); FUP line missing on 2 of 6 TikTok creatives, complaints 96 -> 412; Malaysian port-in spike may not repeat.
