Interactions Over Time Admin Analytics Report

[ShellieBrattain]

In an attempt to generate internal queries and reporting that mimic the Interactions Over Time report (in addition to the other reports on the overview dashboard) from Canvas Admin Analytics.

We have:

• Identified student enrollments for enrollment types = “StudentEnrollment” where WORKFLOW_STATE IN ('active', 'completed','creation_pending', 'inactive', 'invited');
• For these students, we’ve identified the interactions from WEB_LOGS
  • Created table WEB_APP_X that crosswalks the web_application fields to determine which combinations are used to define PAGE_VIEW vs PARTICIPATION based on Canvas documentation definitions
    • WEB_APPLICATION_CONTROLLER
    • WEB_APPLICATION_ACTION
    • WEB_APPLICATION_CONTEXT_TYPE
    • PAGE_VIEW
    • PARTICIPATION
• When we compare the aggregated results with data in our Canvas Beta environment, we end up with results that are orders of magnitude off.
   

  We narrowed down the scope of the crosswalk table, but the results still did not come out as expected.

   

  1. Is this the correct approach?
  2. Where we might have gone wrong?