# Old webinars → funnel Journey: one-command backfill (2026-10-14)

Goal: the ~12k legacy leads never came through the landing page, so the Stage 1 board shows them all as "Not
registered for Preview". Filing the old Zoom webinars they attended as completed history Sessions puts each one in
the right box. The match uses the Zoom attendee email or linked lead, so no UTM is needed. Feature handbook:
`docs/modules_handbook/manage/zoom/legacy-webinar-sessions.md`.

Instead of clicking **Assign to funnel** 85 times, one command reads a reviewed plan:

- Command: `php artisan zoom:import-legacy-webinars` (`app/Console/Commands/ImportLegacyWebinars.php`)
- Plan: `database/data/legacy_webinars/2026-10-14-plan.csv`. It has one row per webinar, giving funnel, Slot,
  Project and the reason.

## Run on production (after dev-shawn is deployed)

| Step | Command | Check |
|---|---|---|
| 1 | `php artisan zoom:import-legacy-webinars` | Preview only. The last lines must show **no error**, 9 "Slot to create (paused)" lines, and "Import 85 webinar(s)". |
| 2 | `php artisan zoom:import-legacy-webinars --apply` | Ends with "Imported 85 webinar(s); 0 failed." |
| 3 | Run step 1 again | Every row now shows `refresh`; nothing new would be created. |

If a row shows an error (e.g. "starts …, the plan says …"), stop and send the output: `--apply` refuses to start
while any error exists. Re-running `--apply` is safe — it refreshes, never duplicates.

It **sends nothing** — no WhatsApp, AI call, reminder, task or Journey. It changes no lead's source. On the dev
database (2026-10-06 snapshot) the preview showed 0 errors, 4,260 customers, 3,546 of them in a Stage 1 / 2 Session
for the first time.

## Owner decisions (2026-10-14)

| Group | Webinars | Goes to |
|---|---|---|
| Weekly AI买房 webinars (2024-11 → 2026-06: 数据为王, New Project vs Bulk Purchase, 2025 weekly, 训练营, 冲刺挑战营) | 31 | 1. Trust Nurturing › `History · AI买房训练营` |
| AI Prompt Class ×6, ChatGPT / Level 2 AI for Property Investment, AI Prompt Webinar | 9 | 1. Trust Nurturing › `History · AI Prompt Class` |
| 90% loan quota, Subsales, Airbnb, 投资房产101 | 4 | 4. Property Knowledge Sharing › `History · Knowledge Sharing` |
| KLCC, Grade A, KLCC Investment Blueprint | 16 | 2. Property Closing › `History · Sutera KLCC` (offer: Sutera KLCC) |
| JB CIQ Briefing, Johor CIQ Non-HDA | 2 | 2. Property Closing › `History · Exsim CIQ` (offer) |
| Peellane Project Briefing | 1 | 2. Property Closing › `History · Peel Lane` (offer) |
| Cochrane & TRX, Cochrane & Velocity | 2 | 2. Property Closing › `History · Binastra Cochrane` (offer) |
| Member deal sharing ×9, JB ×2, Johor comparison, My Webinar (12 Apr) | 13 | 2. Property Closing › `History · Project unknown` |
| Post-VP (Belfield, Velocity 2, Maxim Risen), Velocity tenant ×2, Landlord Pro, Renovation | 7 | 3. After Sales Service › `History · After Sales talks` |
| Paid daytime classes (AI for Wealth ×2, AI for Employee ×2, 1-Day Masterclass, AI Wealth Summit), Member Q&A ×2, Unit Selection Briefing, Jhou Lee students, Exsim client meeting, two tiny ones | 13 | skip |
| Duplicate records #12, #40, #77 + 13 tests | 16 | skip |

Why the Project offers: the Stage 2 board takes a Session's Project only from its Slot's offer. The KLCC group's
evidence is the deals its attendees opened within 30 days: Sutera KLCC led every time, with 16–18 deals on the April
and June KLCC webinars. Weaker cases go to "Project unknown".

Funnels 3 (After Sales) and 4 (Knowledge Sharing) track no Journey. Their attendees count in that funnel only and do
not appear on the Journey boards, which is intended.

## Notes

- Every history Slot is created **paused**; live Slots are not touched.
- Slot #21 `Legacy Project Webinar` (made by hand on 2026-10-14) is not used by the plan. Delete it or leave it.
- Attendees who become "Ready for Stage 2" appear in their account manager's My Work → **Extra**, not To do. They
  were already in Extra as "Invite to a Preview webinar".
