Page Views In Adobe WorkSpace And Data Warehouse does not tally | Community
Skip to main content
B
BrendomLu
May 27, 2024
Question

Page Views In Adobe WorkSpace And Data Warehouse does not tally

  • May 27, 2024
  • 4 replies
  • 1044 views

Hi all when getting the data exported from data warehouse I have exported 2 metrics, bookings and page views. The number for the month of Jan-April 2024 for pages views is almost doubled in excel but bookings matches exactly. I am using all the same metrics and dimensions for both workspace and data warehouse what is the cause for this discrepancy?

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

    4 replies

    pradnya_balvir
    Community Advisor
    pradnya_balvirCommunity Advisor
    Community Advisor
    May 27, 2024

    Data warehouse will not de-duplicate the Visits and Visitors. 

     

    Visit Criteria Last Touch ChannelPageNamePage ViewsVisitsUnique Visitors
    Visit 1Search A111
     Search B111
     SerachC111

     

    As per workspace: for search 3 Page Views, 1 Visits and 1 Unique visitors

    In Datawarehouse report: it will give you 3 Page Views, 3 Visits and 3 unique visitors.

     

    Can you please check in your report if you are applying any segment?

      Jennifer_Dungan
      Community Advisor and Adobe Champion
      Jennifer_DunganCommunity Advisor and Adobe Champion
      Community Advisor and Adobe Champion
      May 27, 2024

      What other dimensions are a part of your exports?

       

      For instance, if you have two products (which are basically list data) each product from the same hit would count it's own booking, but might "duplicate" on the page view..

       

      For instance, in a single transaction, I book "Product A" and "Product B"... this should be 1 Page View and 2 Bookings...

       

      But in the Data Warehouse export, I would see the data like this:

       

        Page View Booking
      Product A 1 1
      Product B 1 1

       

       

      Even through these are on the same hit, the way the data is flattened would result in duplicated page views.....

      abhinavpuri
      Community Advisor and Adobe Champion
      abhinavpuriCommunity Advisor and Adobe Champion
      Community Advisor and Adobe Champion
      May 27, 2024

      Hi @brendomlu,

      Can you confirm dimensions you're comparing/ exporting with metrics (like Pageviews).

       

      Normally, In certain high cardinality variables (eVars) the data is collated under "low-traffic" which doesn't apply when exporting via Datawarehouse exports.

      Damonwhall
      Adobe Employee
      DamonwhallAdobe Employee
      Adobe Employee
      May 28, 2024

      You will need to account for deduping yourself.  

       

      Doing the same thing I had to account for visits by looking at a distinct count of [MCVISID + visit number], this provided an exact match to visits between the datawarehouse export and workspace.  

       

      similarly something similar will be needed for page views.  Example; [MCVISID + visit number + page visit number (or a similar dimension)]

      Terms & ConditionsAccessibility statement

      Loading footer...