Adobe Stack Daily #006 — CJA and AEP Are Showing Different Numbers. Both Are Correct. Here’s Why.
Summary
Adobe Stack Daily #006 addresses common discrepancies between Adobe Customer Journey Analytics (CJA) and Adobe Experience Platform (AEP) Query Service, where the same underlying data can yield vastly different metric counts. This occurs because AEP functions as a raw data platform, storing events as ingested, while CJA is an analytics layer that applies transformations like identity stitching, sessionization, attribution, and deduplication at query time. The article details four architectural reasons for these differences: CJA's person deduplication versus AEP's raw identity counts, CJA's configurable session logic versus AEP's lack of session concept, CJA's attribution and metric deduplication versus AEP's raw event storage, and CJA's exclusion of rows missing a Person ID. It also highlights data freshness gaps due to CJA's processing latency.
Key takeaway
For data analysts and engineers comparing metrics across Adobe CJA and AEP, you must understand the four architectural differences detailed. Do not assume discrepancies are bugs; instead, document CJA's Person ID configuration, stitching method, session definitions, and metric deduplication settings. This proactive approach will prevent stakeholder confusion and ensure clarity on what each system's numbers truly represent, avoiding misinterpretations of data quality.
Key insights
CJA and AEP yield different metrics from the same data due to distinct processing logic and architectural roles.
Principles
- AEP stores raw events; CJA applies transformations.
- Different systems measure different aspects of data.
- Document system logic before comparing metrics.
Method
To reconcile CJA and AEP discrepancies, define Person ID, confirm stitching, understand session definitions, and verify metric deduplication settings in CJA Data Views.
In practice
- Use AEP Audience Portal for audience sizing.
- Validate CJA Connection skip rates per dataset.
- Configure deduplication for all CJA conversion metrics.
Topics
- Adobe Customer Journey Analytics
- Adobe Experience Platform
- Data Discrepancy Resolution
- Identity Stitching
- Session Definition
Best for: Data Scientist, Data Engineer, Analytics Engineer
Related on AIssential
Editorial summary, takeaway, and curation by AIssential. Original article published by Data Engineering on Medium.