Adobe Stack Daily #006 — CJA and AEP Are Showing Different Numbers. Both Are Correct. Here’s Why.

· Source: Data Engineering on Medium · Field: Technology & Digital — Data Science & Analytics, Cloud Computing & IT Infrastructure · Depth: Advanced, long

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

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

Topics

Best for: Data Scientist, Data Engineer, Analytics Engineer

Related on AIssential

Open in AIssential →

Editorial summary, takeaway, and curation by AIssential. Original article published by Data Engineering on Medium.