Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

How to understand the inconsistent content velocity results 1)-5) listed below?

Avatar

Level 1

 

I have a free table: rows are page names,  columns are standard Adobe metrics: page view, visits, Velocity and Bounce rate,  how to understand  the results:

1) For some pages: the content velocity are non-zero(actual is  from 1 to 20, 000+) when the page views are zero and the number of visits are not zero

2) For some pages: the content velocity is infinity when page views and visits are both zero.  Is this suppose to be?

3) For some pages: the content velocity is invalid when page views and visits are both zero.  Why the content velocity is not "infinity" as in 2)

4) For some pages,  the content velocity is  null(blank) when page views and visits are both zero.   Why the content velocity is not "infinity" as in 2)

5) For unspecified,  the content velocity is zero. Is it suppose to be?

6) for page names, - the content velocity are between  1 and less than 100 when page views and visits are both non-zero

The content velocity is under default attribution model 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

I can't actually replicate this in my own data (I have no "0" page views in this scenario)

 

That said, perhaps it has something to do with the velocity being Page Views (Participation|Visit) / Visits

 

That participation attribution could be causing some oddities in the data....

 

That participation attribution may also explain why some values come out as infinity vs invalid... it's really rather annoying that we can't apply custom attribution to standard metrics to see what those values would look like... I suspect that in some cases the value is 0 (the same as Page Views) and in other cases, the custom attribution actually has a value that you can't see (and when you take a value and divide by 0 you get invalid - I guess 0/0 results in infinity rather than invalid??)

 

I can't really explain the null value... that is odd... 

 

Since you are showing "Unspecified", I am going to assume that these represent your non-page view actions (clicks and such) that are getting values due to the attribution model.... You may want to filter out unspecified.

 

 

I don't use this metric much, and in theory, the participation attribution is what you need to see the average number of pages that come after the page (by row)...  but I really don't know why you have strange results... As I said, it seems to be working for me....

 

Are you by any chance applying any segments to your panel? Perhaps something in the segment is causing the issues?? I have seen similar issues where a segment caused some of the values to return oddly (and once removed the data looked fine)

 

Basically, the segment could be filtering out the actual "page view" resulting in 0, but the participation of that page would still be included....

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

I can't actually replicate this in my own data (I have no "0" page views in this scenario)

 

That said, perhaps it has something to do with the velocity being Page Views (Participation|Visit) / Visits

 

That participation attribution could be causing some oddities in the data....

 

That participation attribution may also explain why some values come out as infinity vs invalid... it's really rather annoying that we can't apply custom attribution to standard metrics to see what those values would look like... I suspect that in some cases the value is 0 (the same as Page Views) and in other cases, the custom attribution actually has a value that you can't see (and when you take a value and divide by 0 you get invalid - I guess 0/0 results in infinity rather than invalid??)

 

I can't really explain the null value... that is odd... 

 

Since you are showing "Unspecified", I am going to assume that these represent your non-page view actions (clicks and such) that are getting values due to the attribution model.... You may want to filter out unspecified.

 

 

I don't use this metric much, and in theory, the participation attribution is what you need to see the average number of pages that come after the page (by row)...  but I really don't know why you have strange results... As I said, it seems to be working for me....

 

Are you by any chance applying any segments to your panel? Perhaps something in the segment is causing the issues?? I have seen similar issues where a segment caused some of the values to return oddly (and once removed the data looked fine)

 

Basically, the segment could be filtering out the actual "page view" resulting in 0, but the participation of that page would still be included....