Data Health
Platform-aware readiness page for Supabase, Google Ads, Meta Ads, snapshot tables, AI directions, and future sync checks.
Working in: Connected Google Ads Account
Market: Google Ads | Google Ads ID: GOOGLE_ADS_CUSTOMER_ID
Change client from the left sidebar
Platform: Google Ads · Mode: Google Mock / Test Mode
Database: Not ready · Live preview: Not connected · Save live data: Disabled · Google Ads writes: Disabled
Preview required before save
Database ENV
Checking...Waiting for health check.
Tables ready
Checking...Run missing migrations if tables are missing.
Seed data
Checking...Run migration 002 to add demo records.
Google Ads mode
Checking...Waiting for Google Ads check.
Meta Ads mode
Checking...Meta is mock-only right now.
AI directions
Checking...Platform-aware after migration 004.
Google Ads readiness
| Connection mode | Waiting for check |
| ad_snapshots | Missing / Error |
| ad_change_log | Missing / Error |
| ad_performance_snapshots | Missing / Error |
Meta Ads readiness
| Connection mode | mock_only |
| meta_ad_snapshots | Missing / Error |
| meta_change_log | Missing / Error |
| meta_performance_snapshots | Missing / Error |
Table-level checks
| Table | Status | Rows | Error |
|---|
Client records
| Name | Market | Status | Source |
|---|
Production schema readiness
| Table | Purpose |
|---|---|
| clients | Stores agency/client accounts. |
| google_ads_accounts | Maps clients to demo account IDs and future Google Ads customer IDs. |
| ai_directions | Stores platform-aware budget, CPL, approval, and recommendation guardrails. |
| ad_snapshots | Stores Google ad setup snapshots. |
| ad_change_log | Stores detected Google headline, description, and URL changes. |
| ad_performance_snapshots | Stores Google daily ad performance for before/after analysis. |
| meta_ad_snapshots | Stores Meta mock creative, copy, URL, audience, placement, and fatigue snapshots. |
| meta_change_log | Stores detected Meta primary text, headline, CTA, URL, frequency, and fatigue changes. |
| meta_performance_snapshots | Stores future Meta spend, reach, impressions, frequency, clicks, leads, CTR, CPC, CPM, and CPL. |
| ai_recommendations | Stores AI recommendations and status. |
| recommendation_results | Stores keep/test/rollback outcome analysis. |
| lead_events | Stores form/chat/call lead attribution records. |
Sync checklist
| Job | What it will do |
|---|---|
| Google setup sync | Pull current campaigns, ads, headlines, descriptions, sitelinks, callouts, snippets, and final URLs. |
| Google change detector | Compare newest Google ad snapshot to previous snapshot and log differences. |
| Meta setup sync | Future read-only pull for campaigns, ad sets, ads, creatives, copy, URLs, audiences, placements, and frequency. |
| Meta change detector | Compare newest Meta snapshot to previous snapshot and log creative/copy/fatigue differences. |
| Performance sync | Pull performance by platform after live read-only connections are enabled. |
| Before/after evaluator | Compare old vs new performance after enough time or clicks. |
What Phase 16 verifies
Phase 16 shows database status, client records, Google readiness, Meta readiness, platform-specific snapshot readiness, and platform-aware AI direction readiness.
Meta remains mock-only. The page is designed to show whether the foundations are ready before any live Meta connection is added.