Main app database plus separate traffic database.

Platform data

Core platform Table Group Readiness

Accounts, users, roles, clients, contacts, sessions, password resets, login attempts, and audit records. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.

Open guide

Platform data

Client portal Table Group Readiness

Portal users, sessions, permissions, notes, and client-facing data access. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.

Open guide

Platform data

CRM and leads Table Group Readiness

Lead sources, leads, lead events, estimates, follow-ups, and sales pipeline state. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.

Open guide

Platform data

Projects and tasks Table Group Readiness

Projects, milestones, tasks, blockers, approvals, and launch execution records. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.

Open guide

Platform data

Client services Table Group Readiness

Services, service subscriptions, service areas, deliverables, and managed scope. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.

Open guide

Platform data

Automation operations Table Group Readiness

Automations, triggers, destinations, versions, runs, provider status, and QA records. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.

Open guide

Platform data

Messages Table Group Readiness

SMS, email, owner notifications, approval language, templates, and delivery records. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.

Open guide

Platform data

Content and SEO Table Group Readiness

Pages, content approvals, local SEO work, page refreshes, FAQ updates, and publishing workflow. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.

Open guide

Platform data

Audits Table Group Readiness

Website audits, automation audits, form checks, technical reviews, and remediation notes. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.

Open guide

Platform data

Reports Table Group Readiness

Monthly reports, weekly updates, report sections, report metrics, and handoff notes. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.

Open guide

Platform data

Metrics and baselines Table Group Readiness

Metric definitions, snapshots, baseline values, current values, and movement over time. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.

Open guide

Platform data

Search Console Table Group Readiness

Search Console properties, query snapshots, page snapshots, and organic visibility deltas. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.

Open guide

Platform data

Integrations Table Group Readiness

Provider accounts, sync jobs, import batches, webhook logs, field mappings, and connection state. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.

Open guide

Platform data

Campaigns Table Group Readiness

Campaign plans, landing pages, events, attribution, experiment notes, and results. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.

Open guide

Platform data

Approvals Table Group Readiness

Client approvals, internal approvals, change requests, content decisions, and due dates. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.

Open guide

Platform data

Maintenance Table Group Readiness

Recurring checks, backups, provider status, technical health, and ongoing care. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.

Open guide

Platform data

Incidents Table Group Readiness

Incident reports, impact notes, fixes, verification, and recurrence monitoring. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.

Open guide

Platform data

Events and activity Table Group Readiness

Admin actions, portal activity, customer events, operational logs, and activity timelines. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.

Open guide

Traffic data

traffic_sites Design Guide

One row per tracked website or landing page property. This guide explains how the high-volume traffic database should use this table without slowing the primary app database.

Open guide

Traffic data

traffic_client_links Design Guide

Maps traffic sites to primary client records in the main database. This guide explains how the high-volume traffic database should use this table without slowing the primary app database.

Open guide

Traffic data

traffic_visitors Design Guide

Anonymous visitor IDs and first/last seen timestamps. This guide explains how the high-volume traffic database should use this table without slowing the primary app database.

Open guide

Traffic data

traffic_sessions Design Guide

Session-level source, medium, device, landing page, and campaign metadata. This guide explains how the high-volume traffic database should use this table without slowing the primary app database.

Open guide

Traffic data

traffic_pageviews Design Guide

High-volume pageview log partitionable by date. This guide explains how the high-volume traffic database should use this table without slowing the primary app database.

Open guide

Traffic data

traffic_events Design Guide

CTA taps, form starts, form submits, calls, portal views, and custom events. This guide explains how the high-volume traffic database should use this table without slowing the primary app database.

Open guide

Traffic data

traffic_conversions Design Guide

Qualified conversion events connected to leads or manual review. This guide explains how the high-volume traffic database should use this table without slowing the primary app database.

Open guide

Traffic data

traffic_provider_imports Design Guide

Raw import batch summaries from external providers. This guide explains how the high-volume traffic database should use this table without slowing the primary app database.

Open guide

Traffic data

traffic_webhook_events Design Guide

Webhook receipt, status, dedupe key, and payload summary. This guide explains how the high-volume traffic database should use this table without slowing the primary app database.

Open guide

Traffic data

traffic_rollups_daily Design Guide

Daily aggregated reporting table for fast admin and portal views. This guide explains how the high-volume traffic database should use this table without slowing the primary app database.

Open guide

Traffic data

traffic_retention_policies Design Guide

Retention and archive rules for high-volume activity tables. This guide explains how the high-volume traffic database should use this table without slowing the primary app database.

Open guide

Traffic data

Phone CTA Tap Traffic Event Map

Phone CTA Tap tracking plan for high-volume event logging, daily rollups, admin diagnosis, and client-safe reporting.

Open guide