Multi-Touch Attribution Engine & Stripe Checkout Continuity for Advance Agility

                  // Production Ultimate Attribution Engine for Advance Agility (advanceagility.com)
(function() {
  // === Configuration Settings ===
  var STORAGE_DAYS = 90;
  var PARAMS = ['utm_source', 'utm_medium', 'utm_campaign', 'utm_term', 'utm_content'];
  var SEARCH_DOMAINS = ['google.', 'bing.', 'yahoo.', 'baidu.', 'yandex.', 'duckduckgo.', 'ask.', 'startpage.', 'kagi.', 'perplexity.', 'you.'];
  var SOCIAL_DOMAINS = ['facebook.', 'youtube.', 'whatsapp.', 'instagram.', 'tiktok.', 'wechat.', 'snapchat.', 'x.', 'linkedin.', 'pinterest.', 'reddit.', 'telegram.', 'threads.', 'discord.'];
  var AI_DOMAINS = ['chat.openai.', 'claude.', 'perplexity.', 'you.', 'character.'];

  // === Storage & Domain Helpers ===
  function hostOf(url) {
    var a = document.createElement('a');
    a.href = url;
    return (a.hostname || '').replace(/^www\./, '').toLowerCase();
  }
  function matchesDomain(host, domainList) {
    return domainList.some(function(dom) { return host.endsWith(dom); });
  }

  function storageAvailable(type) {
    try {
      var storage = window[type], x = '__storage_test__';
      storage.setItem(x, x); storage.removeItem(x);
      return true;
    } catch (e) { return false; }
  }
  var useStorage = storageAvailable('localStorage');
  var useCookies = navigator.cookieEnabled;

  function setStorage(key, value, isFirst) {
    if (useStorage) {
      if (isFirst && localStorage.getItem(key)) return;
      localStorage.setItem(key, value);
    }
    if (useCookies) {
      var d = new Date();
      d.setTime(d.getTime() + STORAGE_DAYS * 24 * 60 * 60 * 1000);
      var expires = "expires=" + d.toUTCString();
      if (isFirst && document.cookie.indexOf(key + "=") !== -1) return;
      document.cookie = key + "=" + value + ";" + expires + ";path=/";
    }
  }

  function getStorage(key) {
    if (useStorage && localStorage.getItem(key)) return localStorage.getItem(key);
    var nameEQ = key + "=";
    var ca = document.cookie.split(';');
    for (var i = 0; i < ca.length; i++) {
      var c = ca[i].trim();
      if (c.indexOf(nameEQ) === 0) return c.substring(nameEQ.length);
    }
    return null;
  }

  function getParam(name) {
    var regex = new RegExp("[?&]" + name + "=([^&#]*)"), result = regex.exec(location.search);
    return result ? decodeURIComponent(result[1].replace(/\+/g, " ")) : null;
  }

  // === Source / Medium Detection ===
  var ref = document.referrer || '';
  var refHost = hostOf(ref);
  var thisHost = location.hostname.replace(/^www\./, '').toLowerCase();

  function detectSourceMedium() {
    if (ref && !refHost.includes(thisHost)) {
      if (matchesDomain(refHost, SEARCH_DOMAINS)) return [refHost, 'organic'];
      if (matchesDomain(refHost, SOCIAL_DOMAINS)) return [refHost, 'social'];
      if (matchesDomain(refHost, AI_DOMAINS)) return [refHost, 'ai'];
      return [refHost, 'referral'];
    }
    return ['direct', 'direct'];
  }

  var touchData = {};
  PARAMS.forEach(function(param) {
    var value = getParam(param);
    if (value) {
      setStorage(param + '_first', value, true);
      setStorage(param + '_last', value, false);
      touchData[param] = value;
    } else {
      touchData[param] = getStorage(param + '_last') || '';
    }
  });

  var sm = detectSourceMedium();
  var fallbackSource = sm[0], fallbackMedium = sm[1];
  if (!getStorage('utm_source_first')) setStorage('utm_source_first', fallbackSource, true);
  if (!getStorage('utm_medium_first')) setStorage('utm_medium_first', fallbackMedium, true);
  setStorage('utm_source_last', getParam('utm_source') || fallbackSource, false);
  setStorage('utm_medium_last', getParam('utm_medium') || fallbackMedium, false);

  if (!getStorage('first_visit_ts')) setStorage('first_visit_ts', new Date().toISOString(), true);
  if (!getStorage('referrer_first') && ref && !refHost.includes(thisHost)) setStorage('referrer_first', ref, true);

  setStorage('utm_source_latest', getParam('utm_source') || fallbackSource, false);
  setStorage('utm_medium_latest', getParam('utm_medium') || fallbackMedium, false);
  setStorage('touch_ts_latest', new Date().toISOString(), false);

  // === Channel Classification ===
  function classifyChannel(source, medium) {
    source = (source || '').toLowerCase();
    medium = (medium || '').toLowerCase();
    if (medium.match(/cpc|ppc|paid|display|remarketing/)) return 'Paid Search';
    if (medium.indexOf('affiliate') !== -1) return 'Affiliate';
    if (medium.indexOf('email') !== -1) return 'Email';
    if (medium.indexOf('ai') !== -1) return 'AI Tool';
    if (medium.match(/social/) || source.match(/facebook|instagram|linkedin|twitter|x\.com|youtube|tiktok|threads/)) {
      return medium.match(/paid|cpc/) ? 'Paid Social' : 'Organic Social';
    }
    if (medium === 'referral') return 'Referral';
    if ((medium === 'direct' || source === 'direct')) return 'Direct';
    return 'Organic';
  }

  var channel_first = classifyChannel(getStorage('utm_source_first'), getStorage('utm_medium_first'));
  var channel_last  = classifyChannel(getStorage('utm_source_last'), getStorage('utm_medium_last'));
  setStorage('traffic_channel_first', channel_first, true);
  setStorage('traffic_channel_last', channel_last, false);

  // === Data Layer Push ===
  window.dataLayer = window.dataLayer || [];
  dataLayer.push({
    event: 'ultimate_attribution',
    utm_source_first: getStorage('utm_source_first') || fallbackSource,
    utm_medium_first: getStorage('utm_medium_first') || fallbackMedium,
    utm_campaign_first: getStorage('utm_campaign_first') || '',
    utm_term_first: getStorage('utm_term_first') || '',
    utm_content_first: getStorage('utm_content_first') || '',
    utm_source_last: getStorage('utm_source_last') || fallbackSource,
    utm_medium_last: getStorage('utm_medium_last') || fallbackMedium,
    utm_campaign_last: getStorage('utm_campaign_last') || '',
    utm_term_last: getStorage('utm_term_last') || '',
    utm_content_last: getStorage('utm_content_last') || '',
    utm_source_latest: getStorage('utm_source_latest') || fallbackSource,
    utm_medium_latest: getStorage('utm_medium_latest') || fallbackMedium,
    first_visit_ts: getStorage('first_visit_ts') || '',
    touch_ts_latest: getStorage('touch_ts_latest') || '',
    referrer_first: getStorage('referrer_first') || '',
    traffic_channel_first: channel_first,
    traffic_channel_last: channel_last,
    page_location: window.location.href
  });

  // === Global API ===
  window.getAttributionData = function() {
    return {
      utm_source_first: getStorage('utm_source_first') || fallbackSource,
      utm_medium_first: getStorage('utm_medium_first') || fallbackMedium,
      utm_campaign_first: getStorage('utm_campaign_first') || '',
      utm_term_first: getStorage('utm_term_first') || '',
      utm_content_first: getStorage('utm_content_first') || '',
      traffic_channel_first: channel_first,
      utm_source_last: getStorage('utm_source_last') || fallbackSource,
      utm_medium_last: getStorage('utm_medium_last') || fallbackMedium,
      utm_campaign_last: getStorage('utm_campaign_last') || '',
      utm_term_last: getStorage('utm_term_last') || '',
      utm_content_last: getStorage('utm_content_last') || '',
      traffic_channel_last: channel_last,
      utm_source_latest: getStorage('utm_source_latest') || fallbackSource,
      utm_medium_latest: getStorage('utm_medium_latest') || fallbackMedium,
      first_visit_ts: getStorage('first_visit_ts') || '',
      touch_ts_latest: getStorage('touch_ts_latest') || '',
      referrer_first: getStorage('referrer_first') || '',
      page_location: window.location.href
    };
  };
})();
                

                  <!-- GTM Custom HTML Tag: 30-Day First-Party UTM Cookie Setter -->
<script>
(function() {
  var params = new URLSearchParams(window.location.search);
  var keys = ['utm_source', 'utm_medium', 'utm_campaign', 'utm_term', 'utm_content', 'gclid'];
  
  keys.forEach(function(key) {
    var val = params.get(key);
    if (val) {
      var expires = new Date(Date.now() + 30 * 24 * 60 * 60 * 1000).toUTCString();
      document.cookie = key + '=' + encodeURIComponent(val) + ';path=/;expires=' + expires;
    }
  });
})();
</script>
                

                  SELECT
  event_date,
  (SELECT value.string_value FROM UNNEST(event_params) WHERE key = 'utm_source_first') AS first_source,
  (SELECT value.string_value FROM UNNEST(event_params) WHERE key = 'traffic_channel_first') AS first_channel,
  (SELECT value.string_value FROM UNNEST(event_params) WHERE key = 'utm_campaign_first') AS first_campaign,
  COUNT(DISTINCT ecommerce.transaction_id) AS course_enrollments,
  ROUND(SUM(ecommerce.purchase_revenue), 2) AS total_revenue_usd
FROM `advance-agility-analytics.analytics_123456789.events_*`
WHERE event_name = 'purchase'
  AND ecommerce.transaction_id IS NOT NULL
GROUP BY 1, 2, 3, 4
ORDER BY total_revenue_usd DESC;