Data Discrepancy: Data Warehouse and AA Workspace/Adhoc

H_L

28-08-2019

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:

1822496_pastedImage_0.png

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

1822497_pastedImage_1.png

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

1822505_pastedImage_1.png

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

Accepted Solutions (0)

Answers (1)

Answers (1)

H_L

27-10-2019

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.

1847359_pastedImage_0.png

1848521_pastedImage_1.png

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.