📎 Reference for the build — the current data feed and where each credential lives. (This is the keeper from the old "PM Start Here" page; the rest moved into Build Phases.)
Each school's sheet ID + tab names live in schools/<slug>.json under school.coefficient_sheet_id + coefficient_tabs. Tab names are inconsistent across schools — part of the clunk the migration removes.
| School | Type | Sheet ID | Google tab | Meta tab | GA4 tab |
|---|---|---|---|---|---|
| Lauralton Hall | Traffic | 13UYVIzRB5mq-cLUaceU5hJAgv0zuudcyIBVu78ifKtI |
New Daily GAds | New Daily FB | GA4: Total users by Date |
| Maclay | Lead | 11MdwRLYVtwmjJ1kwota_alkn33sg5TdT0dl5eArcLFY |
Google Ads | FB Ads | GA4: Total users by Date |
| Sacred Heart | Lead | 1xBmGJ7qzluf1cdExfnneauyI5If2Lilfjn-0rdZIobk |
Google Ads | GA4 | |
| Quaker | Traffic | 1MG-qS_IjqRL0i_Sy27PvXkh3byi6B3GLw4mWIN9A6xU |
New Raw Google Ads | New Raw Meta Ads | GA4: Total users by Date |
⚠️ The per-school API IDs are not in the repo — they're Vercel env vars.
| Channel | Auth status | Env vars (Vercel) |
|---|---|---|
| Google Ads | ✅ done & verified | GOOGLE_ADS_DEVELOPER_TOKEN, _CLIENT_ID, _CLIENT_SECRET, _REFRESH_TOKEN, _LOGIN_CUSTOMER_ID, _CUSTOMER_IDS |
| GA4 | 🟡 partial (Lauralton only; key value needs fixing) | GA4_SERVICE_ACCOUNT_KEY, GA4_PROPERTY_IDS |
| Meta | ⏳ token check pending | META_ACCESS_TOKEN, META_AD_ACCOUNTS |