Workspace vs Data warehouse visits/visitors discrepancy | Community
Skip to main content
A
aravinds7786334
September 28, 2022
Solved

Workspace vs Data warehouse visits/visitors discrepancy

  • September 28, 2022
  • 2 replies
  • 2781 views

Hi Adobe Community,

 

I'm seeing data discrepancies with Visits/Visitors in Workspace and the data warehouse. Analytics workspace has more visits and visitors than a data warehouse, I'm using the same segments in both. The reservation/revenue looks identical but visits are a lot lower in data warehouse reports. I tried Visits and "Visits - All Visitors" in the Data warehouse. Any suggestions on what should I look for? Thank you. 

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

Your Data Warehouse setup may be creating multiple rows for the same visit / visitor... when you get the total from here, you aren't getting de-duplicated values...  You need to be very careful when exporting this type of information as it's very easy to over count metrics that should collapse (which Workspace does automatically)

2 replies

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

Your Data Warehouse setup may be creating multiple rows for the same visit / visitor... when you get the total from here, you aren't getting de-duplicated values...  You need to be very careful when exporting this type of information as it's very easy to over count metrics that should collapse (which Workspace does automatically)

    A
    aravinds7786334Author
    September 29, 2022

    It explains if the Data warehouse has more visits, for me the data warehouse has fewer visits than the workspace. Why is that? 

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

    Oops, sorry, I mis-read that...

     

    Do you have any segments applied to your Data Warehouse?

     

    Sadly, this may end up being a question for client care who can do a deeper dive into your data... rather than the surface level suggestions I can make...

     

    I hope you figure it out.

      Benjienen
      Community Advisor
      BenjienenCommunity Advisor
      Community Advisor
      September 30, 2022

      Hi Aravinds, I think the advice in this thread may be helpful,

      "You may need to check the implementation. Could be something wrong with the data capture. You can reach out to the person who manages the implementation within the company." Solved: Data Warehouse and Workspace reports help - Adobe Experience League Community - 252785

        Terms & ConditionsAccessibility statement

        Loading footer...