Adobe Workspace & Data Warehouse Counts are not matching | Community
Skip to main content
SrividyaVenkat
Level 3
August 26, 2022
Solved

Adobe Workspace & Data Warehouse Counts are not matching

  • August 26, 2022
  • 1 reply
  • 1652 views

Hi There,

 

When I was exploring on Adobe Analytics I tried to check if the counts which I get from Data Warehouse matches with Adobe Workspace but it is not matching especially when I had a segment corresponding to it. The value which I got was almost double the time the one in workspace. 

 

Is there any reason behind 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 Jennifer_Dungan

Which metrics are you looking at?

 

Remember that if you are using something like Visits or Unique Visitors, and you break those down, the total shown in Workspace will be de-duplicated.... this is not the case for Data Warehouse.

 

Data Warehouse will only export out the individual rows of data based on your column configurations. If you try to add all these rows together you can easily get higher counts.

 

Without seeing the specifics, this would be my best guess as to what you are seeing and why the values aren't matching.

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
August 26, 2022

Which metrics are you looking at?

 

Remember that if you are using something like Visits or Unique Visitors, and you break those down, the total shown in Workspace will be de-duplicated.... this is not the case for Data Warehouse.

 

Data Warehouse will only export out the individual rows of data based on your column configurations. If you try to add all these rows together you can easily get higher counts.

 

Without seeing the specifics, this would be my best guess as to what you are seeing and why the values aren't matching.

SrividyaVenkat
Level 3
September 1, 2022

Thank you @jennifer_dungan