Skip to main content
This document outlines what the system automatically creates for you during integration setup.

​
Database Tables

We create the following tables in your Supabase database:
  • tracking_events: Single source of truth for all events (CTA views, clicks, form submissions)
  • attribution_sessions: Privacy-safe attribution ID envelope
  • contact_attribution_links: Links attribution IDs to CRM contacts
  • asset_performance_daily: Materialized rollup for fast UI queries
  • tracking_event_conflicts: Queryable conflict tracking for duplicate events

​
WordPress Plugin (v3.0)

The WisePilot plugin bundles everything needed for attribution and CTA tracking:
  • Attribution script (attribution-tracker.js) — cookie generation, link rewriting, CTA view/click tracking, event delivery
  • RankMath SEO fields — exposes meta fields via REST API
  • ACF CTA field groups — auto-creates missing field groups on activation
  • REST configure endpoint — /wp-json/cr/v1/configure for auto-setup
  • Tracking token — per-site token auto-generated on plugin download
The plugin posts CTA events directly to the WisePilot API. No GTM container is required.
Download the plugin from Integrations -> WordPress -> Download Plugin. It auto-configures when your site is connected.

​
HighLevel Webhook Setup

We provide:
  • Webhook endpoint URL
  • Webhook secret for verification
  • Instructions for configuring HighLevel webhook
  • Automatic custom field creation - Button to check and create cr_attrib custom field automatically
You must configure the webhook in HighLevel (subscribe to ContactCreate/ContactUpdate events). The cr_attrib custom field can be created automatically via the integration page, or manually in HighLevel.

​
Daily Rollup Job

We provide:
  • API endpoint for daily rollup job
  • Service layer for aggregating metrics
You must configure a cron job to call this endpoint daily.