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

Metrics discrepancy between hour and 5 minute slices

Avatar

Level 1

I am using Adobe Analytics API (Rest interface) to fetch data from experience. I see some data discrepancy.

 

The page views count I get for the entire hour time rage doesn't match with five minutes slices. These are my steps:

1. Queried data for dateRange: 2021-11-30T10:00:00.000/2021-11-30T10:59:59.999, page views count was: 1117995.0

2. Queried data for dateRange: 2021-11-30T10:00:00.000/2021-11-30T10:04:59.999, and then again for dateRange: 2021-11-30T10:05:00.000/2021-11-30T10:09:59.999, and so on all the way till 2021-11-30T10:59:59.999 (in five minutes slices). When I added the page views count, the total doesn't match with the first query (for the entire hour).

 

What could be the issue here? Are the dates in the dateRange inclusive of the boundary or exclusive? I can provide the sample Json request if you want, please let me know.

1 Accepted Solution

Avatar

Correct answer by
Level 2

I assume that you are getting high page views when slice by 5 min. If yes, the reason is..a users page view is counted twice if the page view is active between two 5 min range. If user visiting Page A at 11:15 and continues to 11:19, it will be two page views attributed between 11:10 to 11:15 and 11:15 to 11:20 resulting total mismatch. 

View solution in original post

1 Reply

Avatar

Correct answer by
Level 2

I assume that you are getting high page views when slice by 5 min. If yes, the reason is..a users page view is counted twice if the page view is active between two 5 min range. If user visiting Page A at 11:15 and continues to 11:19, it will be two page views attributed between 11:10 to 11:15 and 11:15 to 11:20 resulting total mismatch.