It's found a big data discrepancy between in Data Warehouse and in AA Workspace/Adhoc for "Internal Search" related dimension/metric.
A segemtn is set:
URL (evar) start with https://search.example.com
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.
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.