Cherry Seed

How do I create one source of truth?

Quick Answer

Build a first-party data warehouse that collects raw event data server-side before it reaches any third-party platform. Use a Customer Data Platform (CDP) or server-side tracking to capture events at the source, then distribute to analytics and advertising platforms. Accept that platform-reported numbers will always differ, but your server-side data becomes the authoritative baseline.

Full Answer

Building a single source of truth: The architecture: 1. Purchase occurs in WooCommerce 2. Server captures all event data 3. Server sends to BigQuery (your data) 4. Server sends to GA4, Facebook, Google Ads 5. Platforms interpret differently 6. BigQuery remains authoritative What BigQuery stores:

  • Transaction ID (unique)
  • Timestamp (exact moment)
  • Revenue (accurate amount)
  • Original UTM source
  • Customer identifiers (hashed)
  • Complete product data Why BigQuery is truth:
  • You control it, no platform bias
  • No ad blocker data loss
  • No attribution window...

Sources

Programmatic Access

GET https://seresa.io/wp-json/cherry-tree-by-seresa/v1/seeds/104

Cite This Answer

Cherry Tree by Seresa - https://seresa.io/seed/common-tracking-problems/numbers-never-match-s7