Environment
Issue/Symptoms
Difference in Entries and Exits between Data Warehouse and Report Builder
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 |