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

​
GTM Container Configuration

We provide:
  • GTM event tags for CTA view/click tracking
  • DataLayer variables for attribution ID
  • Trigger configurations
You must deploy the GTM container to your website.

​
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.

​
Attribution Tracking Script

We provide:
  • elementor/utils/attribution-tracker.js - Client-side script that:
    • Generates and stores cr_attrib in cookies/localStorage
    • Rewrites CTA links to append cr_attrib + UTMs
    • Handles HighLevel iframe forms
    • Pushes attribution ID to GTM dataLayer
You must include this script on your website pages.

​
WordPress ACF Field Checker

We provide:
  • API endpoint to check/create required ACF fields
  • Documentation on required field structure
ACF fields must exist in WordPress for CTA data to be stored.

​
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.