STM Connectors
Replacing Supermetrics with our own data pipeline. Syncing Facebook, Instagram, LinkedIn, TikTok, and Microsoft Ads into MySQL for Looker Studio reporting.
Status: Production deployed — validating live data before switching reports from Supermetrics
Platforms
Data sources connected and syncing into MySQL.
Timeline
Key milestones from development to launch.
May 2026
Pipeline built & first syncs
Facebook, Instagram, LinkedIn, TikTok sync jobs deployed. Multi-account discovery, 7-day chunking, 30-min timeouts. First backfill for Hickory's.
Early June 2026
Views consolidated & reports connected
Facebook views reduced from 13 to 5. Hickory (3 reports), Certas, UoM, and Molnlycke reports reconnected to new data sources in Looker Studio.
Mid June 2026
Apps Script connectors for Reach
Facebook Reach and LinkedIn Reach connectors deployed to Looker Studio. Deduplicated reach that can't be summed from daily rows.
Late June 2026
Reliability & monitoring
3-strike auto-disable across all 6 platforms. Daily health check emails. Sync schedules optimised — all data ready by 9am BST. Evening restatement syncs added.
July 2026
Testing & validation
All reports validated against Supermetrics. Client accounts onboarded. Guides built for the social team. Mid-morning sync added for exact Supermetrics parity by 10:45 BST.
Late July 2026
Production environment deployed
Production server and RDS database set up. Envoyer deployment pipeline configured. Staging → main branch workflow established.
Now
Production data validation
Running syncs on production and comparing numbers against Supermetrics across all platforms before switching reports over.
Upcoming
Switch reports & decommission Supermetrics
Reconnect Looker reports to production database. Run in parallel with Supermetrics, then decommission.
Reports validated
Looker Studio reports verified against Supermetrics data.
| Client |
Report |
Platforms |
Status |
| Hickory's |
Gateshead, Gateacre, Peterborough |
Meta, TikTok |
Verified |
| Molnlycke |
Campaign report |
Meta, LinkedIn |
Verified |
| UoM |
Lead Analysis, Channel Overview |
Meta, LinkedIn |
Verified |
| Brother |
LinkedIn Essential |
LinkedIn |
Verified |
| Certas |
Campaign report |
Meta |
Verified |
How it works
Built-in reliability so reports stay accurate without manual intervention.
Automatic daily syncs
Facebook syncs 3x daily — early morning, mid-morning (exact parity by 10:45 BST), and evening restatement. Other platforms sync twice daily.
Auto-disable & recovery
Accounts with 3 consecutive auth failures are paused and retried every Monday. No broken data in reports.
New account auto-backfill
When a new ad account is detected, 90 days of historical data is automatically backfilled.
Health check emails
Daily email at 8pm UK summarising any sync failures. Silent when everything is healthy.
Sync schedule
Facebook syncs 3x daily for exact Supermetrics parity by 10:45 BST. Other platforms sync twice daily.
| Platform | Early morning (BST) | Mid-morning (BST) | Evening (UK) |
|---|
| Meta / Facebook | 07:30 → ~08:45 | 10:30 → ~11:45 | 18:00 – 19:15 |
| Instagram | 07:30 → ~08:45 | — | 20:15 – 20:30 |
| TikTok | 07:30 → ~08:15 | — | 18:00 – 18:30 |
| LinkedIn | 08:00 → ~08:45 | — | 19:30 – 20:00 |
| Microsoft Ads | 11:00 → ~11:30 | — | — |
| SEO Monitor | 03:00 → ~05:00 | — | — |
Guides & Documentation
Step-by-step guides for managing ad accounts, data sources, and Looker Studio reports.
View Guides