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
BedrockMission!

Learn more

View all

Sign in to view all badges

Data Discrepancy: Data Warehouse and AA Workspace/Adhoc

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

1 Reply
H_L
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.

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.