Data Discrepancy: Data Warehouse and AA Workspace/Adhoc

[H_L]

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 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.

Thank you.

H

[H_L · Accepted solution]

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.