Module 1: Authorization (The Keys)
Checks if ClickCatalyst has valid OAuth2 tokens for Google Ads API, GA4 Data API, and BigQuery API.
Status indicators:
Green: All tokens valid, expiry is 45+ days away
Amber: Token expires in less than 14 days — click "Refresh Token"
Red: Token expired or revoked — click "Reconnect Account"
Module 2: Data Pipeline (The Flow)
Verifies that BigQuery is receiving fresh data:
Last Sync Time: When the most recent data was pulled (should be within 24 hours)
Row Count: Total rows in your BigQuery dataset (grows with each sync)
Sync Status: "Active" means data is flowing. "Initializing" means the first 90-day hydration is still in progress.
Status indicators:
Green: Data synced in last 24 hours
Amber: Last sync was 24-48 hours ago (possible API throttling)
Red: No sync in 48+ hours — pipeline is broken
Module 3: Signal Linkage (The Bridge)
Tests if Google Ads and GA4 are communicating properly:
GCLID Pass Rate: Percentage of ad clicks that successfully pass the Google Click ID to GA4 (Healthy: above 95%)
Session Match Rate: Percentage of ad clicks that become GA4 sessions (Healthy: above 85%)
Conversion Import: Whether GA4 conversions are being imported into Google Ads
Status indicators:
Green: All metrics within healthy range
Amber: Session Match Rate between 70-85% (some data loss)
Red: GCLID Pass Rate below 90% (critical linkage failure)
Module 4: Conversion Data (The Heartbeat)
Scans for active conversion tracking:
Total Conversions (30 days): How many conversions were recorded (minimum 30 needed for Smart Bidding)
Primary Action Status: Whether at least one conversion action is set to "Primary"
Conversion Lag: Median time between click and conversion (should be under 7 days for optimal Smart Bidding)
Status indicators:
Green: 30+ conversions, primary action set
Amber: 10-29 conversions (limited learning data)
Red: Fewer than 10 conversions or no primary action (Smart Bidding will fail)