data_architecture — v1

Back to project
IDc9527975-a8c5-4f6f-a1d7-e8aa1fae703a
Lensdata_architecture
Functioninventory
Phasediscovery
Topicsdata-pipeline, signal-inventory
Versionv1
Created2026-04-21T08:08:26+00:00

Content

{
  "data_stores": [
    {
      "id": "gtm_web",
      "name": "Google Tag Manager \u2014 Web Container (GTM-MDRNZRFX)",
      "type": "tag_manager",
      "collection_method": "client_side_pixel",
      "evidence": "Request to www.googletagmanager.com/gtm.js?id=GTM-MDRNZRFX loaded as the central tag orchestrator",
      "data_types": [
        "page_views",
        "events",
        "scroll_depth"
      ],
      "confidence": "high"
    },
    {
      "id": "ga4_primary",
      "name": "Google Analytics 4 \u2014 Primary Property (G-1FEEBQNV0D)",
      "type": "analytics",
      "collection_method": "client_side_pixel",
      "evidence": "Requests to region1.google-analytics.com/g/collect with tid=G-1FEEBQNV0D sending page_view events",
      "data_types": [
        "page_views",
        "events",
        "user_properties"
      ],
      "confidence": "high"
    },
    {
      "id": "ga4_secondary",
      "name": "Google Analytics 4 \u2014 Secondary Property (G-26T311XVNT)",
      "type": "analytics",
      "collection_method": "client_side_pixel",
      "evidence": "Requests to region1.google-analytics.com/g/collect with tid=G-26T311XVNT sending page_view events",
      "data_types": [
        "page_views",
        "events",
        "user_properties"
      ],
      "confidence": "high"
    },
    {
      "id": "google_ads",
      "name": "Google Ads (AW-17010514678)",
      "type": "ad_platform",
      "collection_method": "client_side_pixel",
      "evidence": "Conversion pixel fires to googleads.g.doubleclick.net and googleadservices.com with conversion label NeCfCNuMwOkaEPa1n68_ and bttype=purchase",
      "data_types": [
        "conversions",
        "page_views",
        "remarketing"
      ],
      "confidence": "high"
    },
    {
      "id": "meta_pixel",
      "name": "Meta Pixel (498148151146096)",
      "type": "ad_platform",
      "collection_method": "client_side_pixel",
      "evidence": "fbevents.js loaded via GTM with config request to connect.facebook.net/signals/config/498148151146096",
      "data_types": [
        "page_views",
        "events"
      ],
      "confidence": "high"
    },
    {
      "id": "linkedin",
      "name": "LinkedIn Insight Tag (Partner ID 7288028)",
      "type": "ad_platform",
      "collection_method": "client_side_pixel",
      "evidence": "Requests to px.ads.linkedin.com/collect and /attribution_trigger with pid=7288028 and conversionId=20244068",
      "data_types": [
        "page_views",
        "conversions"
      ],
      "confidence": "high"
    },
    {
      "id": "twitter_ads",
      "name": "Twitter/X Ads Pixel (txn_id: pfume / tw-pfume-pyq3r)",
      "type": "ad_platform",
      "collection_method": "client_side_pixel",
      "evidence": "Requests to t.co/1/i/adsct and analytics.twitter.com/1/i/adsct with integration=gtm and txn_id values",
      "data_types": [
        "page_views",
        "events"
      ],
      "confidence": "high"
    },
    {
      "id": "bing_ads",
      "name": "Microsoft Advertising / Bing UET (Tag ID 97194847)",
      "type": "ad_platform",
      "collection_method": "client_side_pixel",
      "evidence": "Requests to bat.bing.com/actionp/0 and bat.bing.com/p/action/97194847.js with ti=97194847 and pageLoad event",
      "data_types": [
        "page_views",
        "conversions",
        "events"
      ],
      "confidence": "high"
    },
    {
      "id": "reddit_pixel",
      "name": "Reddit Ads Pixel (a2_gws68xi53fgh)",
      "type": "ad_platform",
      "collection_method": "client_side_pixel",
      "evidence": "Requests to alb.reddit.com/rp.gif with id=a2_gws68xi53fgh and custom page_view event via GTM integration",
      "data_types": [
        "page_views",
        "events"
      ],
      "confidence": "high"
    },
    {
      "id": "hubspot",
      "name": "HubSpot Analytics & CRM (Portal 244051090)",
      "type": "crm",
      "collection_method": "client_side_pixel",
      "evidence": "HubSpot tracking script js-na2.hs-scripts.com/244051090.js loaded via GTM, pageview pixel to track-na2.hubspot.com/__ptq.gif with a=244051090",
      "data_types": [
        "page_views",
        "user_properties",
        "events"
      ],
      "confidence": "high"
    },
    {
      "id": "posthog",
      "name": "PostHog Product Analytics (via first-party proxy)",
      "type": "analytics",
      "collection_method": "client_side_pixel",
      "evidence": "Requests to kilo.ai/ingest/ endpoints including config, flags, recorder, surveys, and dead-clicks-autocapture with token phc_GK2Pxl0HPj5ZPfwhLRjXrtdz8eD7e9MKnXiFrOqnB6z",
      "data_types": [
        "page_views",
        "events",
        "user_properties",
        "session_recordings",
        "surveys"
      ],
      "confidence": "high"
    },
    {
      "id": "sentry",
      "name": "Sentry Error Monitoring",
      "type": "other",
      "collection_method": "client_side_pixel",
      "evidence": "Session data sent to kilo.ai/monitoring proxying to Sentry org 4509356317474816 project 4509803388796928 via sentry.javascript.nextjs SDK v10.42.0",
      "data_types": [
        "events"
      ],
      "confidence": "high"
    },
    {
      "id": "impact",
      "name": "Impact.com Affiliate/Partnership Tracking",
      "type": "ad_platform",
      "collection_method": "client_side_pixel",
      "evidence": "Script loaded from utt.impactcdn.com/A7138521-9724-4b8f-95f4-1db2fbae81141.js which subsequently loads fast.ssqt.io/squatch-js@2",
      "data_types": [
        "events",
        "conversions"
      ],
      "confidence": "medium"
    }
  ],
  "data_flows": [
    {
      "source": "gtm_web",
      "destination": "ga4_primary",
      "mechanism": "pixel_fire",
      "latency": "real_time",
      "data_carried": "Page view events with page location, title, client ID, session parameters, and user agent hints",
      "evidence": "GTM container triggers gtag/js for G-1FEEBQNV0D which fires page_view to region1.google-analytics.com/g/collect"
    },
    {
      "source": "gtm_web",
      "destination": "ga4_secondary",
      "mechanism": "pixel_fire",
      "latency": "real_time",
      "data_carried": "Page view events with page location, title, client ID, and session data",
      "evidence": "GTM container loads AW-17010514678 gtag which also fires GA4 collect for G-26T311XVNT"
    },
    {
      "source": "gtm_web",
      "destination": "google_ads",
      "mechanism": "pixel_fire",
      "latency": "real_time",
      "data_carried": "Conversion events with label NeCfCNuMwOkaEPa1n68_, bttype=purchase, value=0, and remarketing/config signals",
      "evidence": "GTM triggers Google Ads conversion pixel via googleadservices.com and doubleclick.net with conversion and gtag.config events"
    },
    {
      "source": "gtm_web",
      "destination": "meta_pixel",
      "mechanism": "pixel_fire",
      "latency": "real_time",
      "data_carried": "Pixel initialization and configuration for pixel ID 498148151146096",
      "evidence": "GTM loads connect.facebook.net/en_US/fbevents.js which fetches pixel config for domain kilo.ai"
    },
    {
      "source": "gtm_web",
      "destination": "linkedin",
      "mechanism": "pixel_fire",
      "latency": "real_time",
      "data_carried": "Page view insight tag and conversion event with conversionId=20244068 for partner ID 7288028",
      "evidence": "GTM loads LinkedIn insight.min.js which fires attribution_trigger and collect requests to px.ads.linkedin.com"
    },
    {
      "source": "gtm_web",
      "destination": "twitter_ads",
      "mechanism": "pixel_fire",
      "latency": "real_time",
      "data_carried": "Page view events with page title, URL, and two transaction IDs (pfume, tw-pfume-pyq3r)",
      "evidence": "GTM loads static.ads-twitter.com/uwt.js which fires pixel requests to t.co and analytics.twitter.com"
    },
    {
      "source": "gtm_web",
      "destination": "bing_ads",
      "mechanism": "pixel_fire",
      "latency": "real_time",
      "data_carried": "PageLoad event with page title, URL, keywords, consent signals, and session/visitor IDs",
      "evidence": "GTM loads bat.bing.com/bat.js which fires actionp requests and UET pageLoad to bat.bing.com"
    },
    {
      "source": "gtm_web",
      "destination": "reddit_pixel",
      "mechanism": "pixel_fire",
      "latency": "real_time",
      "data_carried": "Custom page_view event with pixel ID a2_gws68xi53fgh via GTM integration",
      "evidence": "GTM loads redditstatic.com/ads/pixel.js which fires rp.gif to alb.reddit.com with event=Custom and customEventName=page_view"
    },
    {
      "source": "gtm_web",
      "destination": "hubspot",
      "mechanism": "pixel_fire",
      "latency": "real_time",
      "data_carried": "Page view tracking with portal ID 244051090, page URL, title, visitor ID, and browser fingerprint",
      "evidence": "GTM loads hs-scripts.com/244051090.js which triggers analytics script and __ptq.gif pageview pixel to track-na2.hubspot.com"
    },
    {
      "source": "posthog",
      "destination": "posthog",
      "mechanism": "pixel_fire",
      "latency": "real_time",
      "data_carried": "Feature flags, session recordings, surveys, and dead-click autocapture data via first-party proxy",
      "evidence": "PostHog JS SDK sends requests through kilo.ai/ingest/ proxy including flags, recorder, surveys, and autocapture endpoints"
    },
    {
      "source": "gtm_web",
      "destination": "impact",
      "mechanism": "pixel_fire",
      "latency": "real_time",
      "data_carried": "Partnership/affiliate tracking initialization",
      "evidence": "Impact script loaded from utt.impactcdn.com which triggers SaaSquatch referral SDK from fast.ssqt.io"
    }
  ],
  "joinability": [
    {
      "system_a": "ga4_primary",
      "system_b": "ga4_secondary",
      "join_keys": [
        "client_id",
        "session_id"
      ],
      "joinability": "strong",
      "notes": "Both GA4 properties share the same client_id (826842155.1776757741) and session_id (1776757740) set by the same gtag instance, enabling reliable cross-property joins"
    },
    {
      "system_a": "ga4_primary",
      "system_b": "google_ads",
      "join_keys": [
        "gclid",
        "client_id",
        "auid"
      ],
      "joinability": "strong",
      "notes": "GA4 and Google Ads share the same Google cookie space and auid (854434084.1776757741); gclid linking enabled for paid traffic attribution"
    },
    {
      "system_a": "ga4_secondary",
      "system_b": "google_ads",
      "join_keys": [
        "gclid",
        "client_id",
        "auid"
      ],
      "joinability": "strong",
      "notes": "Both fired from the same AW-17010514678 gtag config sharing auid and cookie space"
    },
    {
      "system_a": "ga4_primary",
      "system_b": "hubspot",
      "join_keys": [
        "user_id"
      ],
      "joinability": "weak",
      "notes": "No visible shared identifier between GA4 and HubSpot; joining would require a custom user_id or email passed to both systems, which was not observed in the scan"
    },
    {
      "system_a": "ga4_primary",
      "system_b": "posthog",
      "join_keys": [
        "user_id"
      ],
      "joinability": "weak",
      "notes": "PostHog uses its own distinct_id (019daf03-9457-7098-b835-904f5dca0dd1) with no observed shared key to GA4; joining requires a custom user_id implementation"
    },
    {
      "system_a": "google_ads",
      "system_b": "meta_pixel",
      "join_keys": [],
      "joinability": "none",
      "notes": "No shared identifiers between Google Ads and Meta Pixel; each operates in its own cookie/ID space with no server-side bridging observed"
    },
    {
      "system_a": "google_ads",
      "system_b": "linkedin",
      "join_keys": [],
      "joinability": "none",
      "notes": "No shared identifiers between Google Ads and LinkedIn; cross-platform attribution would require a CDP or manual export workflow"
    },
    {
      "system_a": "hubspot",
      "system_b": "linkedin",
      "join_keys": [
        "email"
      ],
      "joinability": "partial",
      "notes": "HubSpot CRM and LinkedIn can theoretically be joined by email via HubSpot-LinkedIn integration, but no server-side connection or email passing was observed client-side"
    },
    {
      "system_a": "posthog",
      "system_b": "hubspot",
      "join_keys": [
        "user_id"
      ],
      "joinability": "weak",
      "notes": "Both systems maintain independent visitor/user identifiers; no shared key observed in the scan, would require explicit user_id or email integration"
    },
    {
      "system_a": "google_ads",
      "system_b": "bing_ads",
      "join_keys": [],
      "joinability": "none",
      "notes": "Separate ad platforms with independent click IDs (gclid vs msclkid); no cross-platform join path visible"
    },
    {
      "system_a": "ga4_primary",
      "system_b": "meta_pixel",
      "join_keys": [],
      "joinability": "none",
      "notes": "No shared identifiers between GA4 and Meta Pixel; each operates independently with no fbclid-to-GA4 linking observed"
    }
  ]
}