How to calculate unique product views per logged-in unique visitor? | Community
Skip to main content
aagk123
Level 5
May 24, 2023 12:22 PM UTC
Solved

How to calculate unique product views per logged-in unique visitor?

How to calculate unique product views per logged-in unique visitor?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Jennifer_Dungan
Jennifer_DunganAccepted solution
Level 2
May 24, 2023 6:40 PM UTC

You should be able to do a calculated metric using the Approximate Count Distinct function...

 

 

Approximate Count Distinct

     Product

÷

Container - Segment (UV ID Exists)

     Approximate Count Distinct

          Logged in UV ID

 

 

(this is assuming you are tracking an ID or GUID for your Unique Logged in Users)

The inclusion of the segment (simple Hit Level Segment where UV ID exists) ensures that you don't count all the UVs without an ID as a single user in your distinct count logic.

View reply

3 replies

Jennifer_Dungan
Jennifer_DunganAccepted solution
Level 2
May 24, 2023 6:40 PM UTC

You should be able to do a calculated metric using the Approximate Count Distinct function...

 

 

Approximate Count Distinct

     Product

÷

Container - Segment (UV ID Exists)

     Approximate Count Distinct

          Logged in UV ID

 

 

(this is assuming you are tracking an ID or GUID for your Unique Logged in Users)

The inclusion of the segment (simple Hit Level Segment where UV ID exists) ensures that you don't count all the UVs without an ID as a single user in your distinct count logic.

Translate
edwardg5146728
edwardg5146728
Level 2
May 9, 2024 10:11 AM UTC

I'm trying to do something similar and this solution appears wrong to me.

This would give you the ratio if products to unique visitors.

 

E.g. if the site had 100 products - let's assume all of them occurred in a prodview in the time range - and 1000 Visitors, you'd get a value of 0.1.

 

In the user's scenario, you might be able to approximate the ratio they actually want by creating a calculated metric for the average of the above metric and adding it to a table with the GUID dimension.

But otherwise, I think the general solution should be that it's not possible to calculate unique values of a dimension per visit/visitor for anything other than Pages per Visit (using the OOTB Visit Depth dimension).

Translate
    Jennifer_Dungan
    Jennifer_Dungan
    Level 2
    May 9, 2024 2:20 PM UTC

    You're right.

     

    It probably should have been more:

     

    Product Views

    ÷

    Container - Segment (UV ID Exists)

         Approximate Count Distinct

              Logged in UV ID

     

     

    (Assuming that Product Views was only triggering where needed - or that could be swapped out with a custom metric that fires on the product detail page, or whatever is being considered a "view")

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...