Page view vs Participation

Canvas has this definition (see below) for page views vs participation. I'm trying to figure out how to determine this within the Canvas Data 2 data set? What tables and filters are needed to determine this?

====================================================
from Canvas (https://community.canvaslms.com/t5/Canvas-Basics-Guide/What-is-New-Analytics/ta-p/73)

What are Page Views and Participations?

A "page view" is when you open a page in a course. Page views can indicate how a user has been accessing course resources. However, because page view data is based on requests to the server, use page view data only as a good approximation to activity and not an absolute metric. Page view data is most valuable for understanding whether activity occurred, and to make comparisons across students within a course or when viewing trends week to week.

Several actions define "participation" in Canvas and collectively describe events where a user takes an action within a course. The following student actions generate analytics course participation:

Announcements: posts a new comment to an announcement
Assignments: submits an assignment
Collaborations: loads a collaboration to view/edit a document
Conferences: joins a web conference
Discussions: posts a new comment to a discussion
New Quizzes: submits a new quiz
Pages: creates a page
Quizzes: submits a quiz
Quizzes: starts taking a quiz

Find more posts tagged with

Admin

Accepted answers

All comments

dbrace

Hi @ShellieBrattain,

I believe the exact answer depends on the type of content. With that said, if you go to https://developerdocs.instructure.com/services/dap/dataset/dataset-namespaces/dataset-canvas/dataset-canvas-types, there are several references to "participate" and "participation".

-Doug

Gergely Schmidt

Hey @ShellieBrattain,

Page views is an aggregation of mobile and web server logs. Currently we only expose web logs through CD2 and only for the last 30 days: https://developerdocs.instructure.com/services/dap/dataset/dataset-namespaces/dataset-canvaslogs

phanley

Like @dbrace said, it depends on the type of content -- depending on what you were looking for (e.g. date of last participation in a specific course?) I think you will have to do some sort of rollup query combining something like the assignment query below with similar queries for the other activity types. You can use the GREATEST(COALESCE(...)) AS last_type_participation row statement when there's multiple possible dates being recorded (or not) for a single participation type

select course_id, workflow_state, id as "submission_id", assignment_id, submission_type, user_id
       , GREATEST(
COALESCE(created_at, '1900-01-01'::timestamp),
               COALESCE(posted_at, '1900-01-01'::timestamp),
               COALESCE(updated_at, '1900-01-01'::timestamp),
               COALESCE(submitted_at, '1900-01-01'::timestamp)
       ) AS last_assignment_participation
from canvas.submissions
where course_id = xxxxx
  and workflow_state not in ('deleted')
  and assignment_id = xxxxx
limit 20;

Unanswered Questions

EDUCAUSE Insights: Data and Decision-Making
EDUCAUSE is full of inspiration, whether you’re onsite or following from afar. Join the evolution by sharing what sparks your curiosity, the questions you have, and the insights you discover. We'll learn from each other, expand our networks, and strengthen our Community. Your perspective matters, and the more we share,…
Problems with GraphQL in User Pageviews reports
Prompted by the most recent Canvas release notes, we looked into the Page Views feature, and we were happy with the new documented changes. However, we notice that more user actions are done by GraphQL API, which does not provide details in the page view report, either in the GUI or in the CSV file download. We and most…
Metrics Easy Button
I am currently teaching five courses this semester with more than 70 students. To track their progress, I currently have to review each course and section individually, which is very time-consuming. Ideally, I would like to consolidate key information for all students into a single Excel file—showing class attendance…
Analytics API / Metrics calculation logic
Hello, We are currently using the Analytics API provided in the Instructure Developer Documentation Portal to retrieve certain metrics-related data. We would like to know if it’s possible to replicate these datasets using the Canvas Data Platform (CDP), instead of relying on API calls. For example, could you please advise…
CD2: Enhanced Rubrics
Is there a way to tell via CD2 if a course is using Enhanced Rubrics? I didn't see it in the entity diagram for Rubrics table, but I might have missed something... Thanks Ian