Data Warehouse Deduplication

Question

I'm trying to match up a Data Warehouse report to an Adobe Analytics Workspace, but the values aren't matching. I'm using 5 dimensions and 1 metric. When I filter for the same Dimensions on both, the Data Warehouse reports back a much higher number (2x-5x). I'm assuming that the Data Warehouse data hasn't been deduplicated but the Workspace data has. Is this the case? Is there a way I can dedupe the data before pulling it?

khurshid · Accepted Answer

There are some basic difference between how Data Warehouse and Workspace data is processed. It depends on the metric/dimension which are used. Since, you cannot share the report here, the best way to troubleshoot would be to contact Customer Care.

Kanishka_Bajaj · Answer

Yes @rabisaab , that is true that deduplication could be one reason

but other can also be processing time and data latency , any filters/segments used and attribution

Here are other few pointers that you should ensure

Definition of Metric
Segment Consistency
Time Period Consistency
Check for Bots and Internal Traffic

Run a simple comparison report in both Workspace and Data Warehouse using the same unique visitor metric without any additional dimensions. This helps isolate if the discrepancy is due to the metric calculation itself

Sign up

Login with SSO

Login to the community

Login with SSO