Data Warehouse Deduplication | Community
Skip to main content
R
rabisaab
June 18, 2020
Solved

Data Warehouse Deduplication

  • June 18, 2020
  • 2 replies
  • 1769 views

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? 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by khurshid

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.

2 replies

khurshid
Adobe Employee
khurshidAdobe EmployeeAccepted solution
Adobe Employee
July 15, 2020

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
Kanishka_Bajaj
Level 2
May 15, 2024

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

  1.  Definition of Metric
  2. Segment Consistency
  3. Time Period Consistency
  4. 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

 

Terms & ConditionsAccessibility statement

Loading footer...