Canvas Data Page Views

audra_agnelly
Community Champion

We're looking at some metrics of user activity, one of which is page views. The wiki_page_fact table has a measure called 'view_count'. I assume this is the number of times a page has been viewed but the numbers I'm pulling from Canvas Data are vastly different from Google Analytics data and the page views on a course's analytics page. For example, using Canvas Data, the total number of view_counts's for all published pages in one course adds up to 436,000, while using the data in that course's analytics page, I get a page view total of 68,000. I thought perhaps this was tie to the requests, so I looked at the requests table and calculated the total number of requests made to the course and got 330,000 which is closer to the view_count total but still falls short and it tabulating items other than Canvas pages. What is the view_count value in Canvas Data counting, which value is an accurate reflection of total page views, and what's the best way to get total page view?

Users who also had this question