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? 

    A
    aravinds7786334Author
    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.


    Right. I use the same segments as I use in the workspace. 

    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...