Page view vs Participation

[ShellieBrattain]

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

[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..., there are several references to "participate" and "participation".

-Doug

[sgergely]

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;