Mismatch in Entries and Exits between Data Warehouse and Report Builder

Description description

Environment

  • Adobe Analytics

Issue/Symptoms

Difference in Entries and Exits between Data Warehouse and Report Builder

Resolution resolution

Due to the difference in the pipeline between Workspace and Report Builder, some variation is expected. When comparing Entries and Exits, the variation is huge.
This is an expected behavior based on how Entries and Exits are counted across these platforms in Adobe Analytics. The difference in calculation occurs when NONE is added to the dimension for which Entries and Exits are being reported. In the case of Report Builder, NONE is added before anything else in the Entries and Exits calculation whereas, in the Analysis Workspace, NONE is added after the calculation of Entries and Exits. This led to a huge difference in the count.

Example:

hit
hit 1
hit 2
hit 3
product
A
B
Raw data
ENTRYproduct
A
A
A
NONEENTRYproduct
A
A
A
← What AW does
NONEproduct
NONE
A
B
ENTRYNONEproduct
NONE
NONE
NONE
← What RB does
recommendation-more-help
3d58f420-19b5-47a0-a122-5c9dab55ec7f