🎬 YY Video Key Bulk Assignment

Writes videoKey field to compliance_tracking records for 314 categorized YY youth.

One-time tool. Source data: YY_Outreach_Orientation_Outstanding_2026-05-14.xlsx. Delete this file from the deploy after running. Does NOT modify OY records (cohort-based routing handles those). Does NOT touch the 4 Uncategorized youth.

Planned writes

YY_BROOKLYN

—

YY_SI

—

YY_LEHMAN

—

YY_IAM

—

YY_TOTTENVILLE

—

TOTAL

—

Step 1 — Dry run (verify matches without writing)

Reads each OL from compliance_tracking. Reports which ones exist, which are missing, and any that already have a different videoKey set.

Step 2 — Apply writes

Updates each existing record with its assigned videoKey. Uses set({...}, {merge:true}) so existing fields are preserved. Skips missing records.

Progress

0 / 0

Idle. Click "Run dry run" to begin.