Data Discrepancy - Workspace report Vs Data Warehouse report | Community
Skip to main content
A
Ajay_Bhandari
September 23, 2022
Solved

Data Discrepancy - Workspace report Vs Data Warehouse report

  • September 23, 2022
  • 1 reply
  • 1449 views

Hi Team,

We are trying to check data for Report Suites “Delta – Polaris” and could notice that the values for “Visits” metric is different when checked under “Workspace report” as compared to the values in scheduled reports under “Data Warehouse”.

Please see below example for one of the tracking code “dipd-n4tdhc” :

For Aug 1-31,2022, the tracking code shows 2952 Visits in Workspace report:

Whereas, if we check the same tracking code in the scheduled reports (Aug 16-31 & Aug 1-15) from Data Warehouse the values for Visits is 3116 :

Can you please suggest us why there is discrepancy between both the reports.

 

Thanks & Regards,

Ajay Bhandari

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

What other data are you pulling via your Report Builder call? Is it possible you are pulling both page views and events into separate rows in Excel, therefore, when you sum the Visits you are duplicating some of the visit metrics?

 

I can only see the final result via a pivot table, but my guess is that you likely are pulling in multiple rows for a single visit, then taking those values and adding them together resulting in an over counting... this is something you need to be very mindful off when you take the data outside of workspace, as the rows become "flat" and no longer have access to Adobe's de-duplication logic across metrics like Visits and Visitors....

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
September 23, 2022

Possibly some visits actually ran over your date change (midnight)?

 

In your Workspace you are pulling the data aggregated for the entire month... but in your Report Builder you are pulling by day.

 

If a user's Visit started on Aug 20 and finished on Aug 21, then they would show a visit count for both days when the data is broken out daily.

A
Ajay_BhandariAuthor
September 26, 2022

Hi Jennifer,

 

Thank you so much for the response.

 

Even if I breakdown the Workspace data pull by daily, the numbers do not match with the Warehouse report. Please see below screenshots for comparison of first 4 days :

Can you please suggest if there is any other solution for this issue?

 

Regards,

Ajay Bhandari

 

 

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

What other data are you pulling via your Report Builder call? Is it possible you are pulling both page views and events into separate rows in Excel, therefore, when you sum the Visits you are duplicating some of the visit metrics?

 

I can only see the final result via a pivot table, but my guess is that you likely are pulling in multiple rows for a single visit, then taking those values and adding them together resulting in an over counting... this is something you need to be very mindful off when you take the data outside of workspace, as the rows become "flat" and no longer have access to Adobe's de-duplication logic across metrics like Visits and Visitors....

Terms & ConditionsAccessibility statement

Loading footer...