RXL Lead Vault

⚡ Database Tables Not Created Yet

The Vercel API is live and connected to Supabase. You just need to create the tables once.

Quick fix (2 min):

  1. Open: Supabase SQL Editor
  2. Paste and click Run:
    CREATE TABLE IF NOT EXISTS rxl_leads (id BIGSERIAL PRIMARY KEY, lead_id TEXT UNIQUE NOT NULL, ip_hash TEXT, fingerprint TEXT, dwell_seconds FLOAT DEFAULT 0, scroll_pct INTEGER DEFAULT 0, income_tier TEXT DEFAULT 'Unknown', quality_score INTEGER DEFAULT 0, is_whale BOOLEAN DEFAULT FALSE, device TEXT, geo TEXT, page_url TEXT, referrer TEXT, ua TEXT, niche TEXT DEFAULT 'general', broker_route TEXT DEFAULT 'insurance', converted BOOLEAN DEFAULT FALSE, created_at TIMESTAMPTZ DEFAULT NOW()); CREATE TABLE IF NOT EXISTS rxl_conversions (id BIGSERIAL PRIMARY KEY, lead_id TEXT NOT NULL, click_id TEXT, payout FLOAT DEFAULT 0, created_at TIMESTAMPTZ DEFAULT NOW());
  3. Refresh this page — leads will appear here.

API endpoints: /api/pixel (POST)  |  /api/health  |  /api/vault