MCB Data Collection System

This is a backend data collection system. It doesn't have a user interface - it just captures events from webhooks and stores them in the database.

Active Webhooks

Duplicate Prevention Strategy

ManyChat: Uses MC_ID (unique) - prevents duplicates within ManyChat

GHL: Smart matching - tries GHL_ID → Email → Phone (links to existing ManyChat contacts)

Stripe/Denefits: Email matching across all 3 email fields (creates orphan payments if no match)

Each contact can have one MC_ID and one GHL_ID, preventing duplicates across platforms.

System running on Vercel. Data stored in Supabase. Last deployed: Nov 5, 2025.