Single Page Visits calculation

[StevenSmartChen]

Hello,

About the "Single Page Visits" calculation, the doc says:

This metric counts the number of visits where the 'Page' dimension item contained (1)only a single unique value for the entire visit. (2)If a visitor reloads the page or fires link tracking calls, it still counts as a single page visit. As soon as the Page dimension changes to a second unique value, the visit no longer qualifies as a single page visit.

In fact, the above description seems very clear, however, I still have a few questions:

1. How to define "a single unique value" in (1)?

My assumption is something like "Select DISTINCT(PageName) From XX". Is it correct?  

2. Based on (2), "If a visitor reloads the page or fires link tracking calls, it still counts as a single page visit. As soon as the Page dimension changes to a second unique value, the visit no longer qualifies as a single page visit.", I define 4 test cases and execute them today, the following are my expected and actual results:

[TC1] Visit1: PV(Luma Home) + Link Tracking Call(When viewing Featured Product Section, the call will be fired)

Expected: SPV + 1

Actual: SPV + 1(Pass)

[TC2] Visit2: PV(Luma Women) + Refresh PV two times(Luma Women)

Expected: SPV + 1. Although the visit has 3 PVs, the visit only has a single unique value for Page(that is "Women").

Actual: No SPV occurred

[TC3] Visit3: PV(Luma Equipment) + Refresh PV only one time(Luma Equipment)

Expected: SPV + 1. Although the visit has 2 PVs, the visit only has a single unique value for Page(that is "Equipment").

Actual: No SPV occurred

[TC4] Visit4: PV(Luma Home) + Link Track(Featured Product) + Refresh PV(Luma Home)

Expected: SPV + 1. Although the visit has a link tracking call and 2 PVs, the visit only has a single unique value for Page(that is "Home").

Actual: No SPV occurred

Could someone answer me why the above TC2/3/4 have no SPV occurred? or if my understanding of SPV calculation is wrong, what is the correct? Thanks

Steven

[Ishan_Sinha_ · Accepted solution]

Hi @StevenSmartChen ,

The Distinct query might not provide the result as it's possible that there are multiple distinct page names captures in a single visit. Your understanding of SPV is absolutely correct. It's a single unique value of any variable captured during the entire visit.

The 2nd, 3rd and 4th condition should have SPV recorded against those Page Names. Are you sure that it was indeed a new Visit and not continuation of the earlier Visit?

In case you find a different behavior than your understanding, please reach out to Adobe Client Care with the example server calls for us to look into it further.

Thanks!

[StevenSmartChen]

Hi @Ishan_Sinha_,

"The 2nd, 3rd and 4th condition should have SPV recorded against those Page Names. Are you sure that it was indeed a new Visit and not continuation of the earlier Visit?"

Yes. The 2nd/3rd/4th visits are all new Visits.