Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new

Learn more

View all

Sign in to view all badges

Data Discrepancy: Data Warehouse and AA Workspace/Adhoc

Level 8
Level 8

Hello everyone,

It's found a big data discrepancy between in Data Warehouse and in AA Workspace/Adhoc for "Internal Search" related dimension/metric.

For example:

A segemtn is set:

URL (evar) start with

Search Location (evar) equals to: HomePage

Search Type (evar) contains: Product Search

in AA Workspace, the result is:


But when export from Data Warehouse: every week will be 1.5 to 2 times than in AA Workspace. (Week 27 is the one at same duration of in AA Workspace).


When breakdown by the search terms (evar or prop), I can clearly see differences among AA Workspace, Adhoc and Data Warehouse


Do you have any idea about the possible reason and how to make them aligned?

It seems not because of the <low-traffic> issue.

Thank you.


1 Reply
Level 8
Level 8

Is there anyone or Adobe Experts could help to this?

The differences are getting much bigger.

Take another example here:

In Adhoc, from 2019-01-01 to 2019-09-30, 780K searchs in total while 100K click-through.

In Data Warehouse, exact same segments applied in same duration, 3 million searches with 500K click-thourgh.



Under this situatio, we are not able to create a easy to generated and delivered report by using Ad-hoc or workspace.

Your input will be appreciated.

Thank you.