Data Sync
How data would flow from GoHighLevel, Meta Ads and Google Ads into the dashboard.
GoHighLevel
Connected - DemoCRM · leads, appointments, sales
Meta Ads
Connected - DemoAd spend and campaigns
Google Ads
Connected - DemoAd spend and campaigns
Data Sync
Simulation only. No external APIs are called.
Last Sync
September 25, 2026 06:07 AM
Records Processed
12,842
New Leads
126
New Appointments
42
New Sales
8
- 1Step 1: Connecting...
- 2Step 2: Fetching data...
- 3Step 3: Normalizing records...
- 4Step 4: Calculating metrics...
- 5Step 5: Updating dashboard...
Press “Run Demo Sync” to simulate a full pipeline run.
Sync Log
Most recent runs first.
| Date | Source | Client | Records | Status |
|---|---|---|---|---|
| Sep 25 · 6:07 AM | GoHighLevel | Jamie Med Spa | 1,238 | Success |
| Sep 25 · 6:06 AM | Meta Ads | Jamie Med Spa | 42 | Success |
| Sep 25 · 6:06 AM | Google Ads | Jamie Med Spa | 17 | Success |
| Sep 25 · 6:05 AM | GoHighLevel | Client B | 604 | Success |
| Sep 25 · 6:05 AM | Meta Ads | Client B | 28 | Success |
| Sep 25 · 6:04 AM | Google Ads | Client B | 12 | Warning |
| Sep 25 · 6:04 AM | GoHighLevel | Client C | 351 | Success |
| Sep 25 · 6:03 AM | Meta Ads | Client C | 19 | Success |
| Sep 24 · 6:07 AM | GoHighLevel | Jamie Med Spa | 1,196 | Success |
| Sep 24 · 6:06 AM | Meta Ads | Jamie Med Spa | 40 | Success |
| Sep 24 · 6:06 AM | Google Ads | Jamie Med Spa | 16 | Success |
| Sep 24 · 6:05 AM | Google Ads | Client C | 9 | Success |
Production Architecture
How the demo's mock data layer maps to the real system.
Google Ads
Ads API · spend, campaigns
GoHighLevel
Contacts, appointments, opportunities
- Data Ingestion
Scheduled sync + webhooks, retries, raw landing tables
- Normalization
Unified client / treatment / campaign / date keys
- Attribution
Match lead → appointment → sale → campaign
- PostgreSQL
Daily performance + entity tables (Supabase)
- Dashboard
This application, reading the repository layer
Demo currently uses local synthetic data. Production architecture would replace the mock data layer with API integrations and a central database.