Data and Analytics Discussions

Discuss, share tips, and ask questions about data and analytics across all our products

We are working on some data models to be displayed in PowerBI. I have a question regarding assignments when there is not a submission type, the assignment table will have a value of None. So, I can ca...

Community Novice Data and Analytics Group
  • 0 Likes
  • 0 Replies

Hi all, According the datasets from CD2, https://data-access-platform-api.s3.eu-central-1.amazonaws.com/tables/catalog.html#schemas.canvas_logs.web_logs.It states that web_logs defines as follow:Store...

Community Member Data and Analytics Group
  • 0 Likes
  • 2 Replies

Hi all,My institution starts to use Canvas since 2014, and now we focus on CD2 web_logs. As I know that the DAP API can only retrieve the latest 30 days data. May I ask is it possible way to get back ...

Community Member Data and Analytics Group
  • 0 Likes
  • 4 Replies

Hi all,   I refer the section 'Getting latest changes with an incremental query' from the link https://data-access-platform-api.s3.amazonaws.com/client/README.html#command-line-usage and program the c...

Community Explorer Data and Analytics Group
  • 0 Likes
  • 1 Replies

Hi everyone,does anyone have any experience or lessons learned in regards to processing the CD2 web_logs table in AWS (Glue / Athena / etc)?We don't have any immediate specific use cases, but we know ...

Community Member Data and Analytics Group
  • 0 Likes
  • 18 Replies

Greetings, I'm curious how others are using and managing the Canvas web_logs data and activity reporting. There's a lot of, often vague but genuine, interest in this data for things like, Querying cou...

Community Explorer Data and Analytics Group
  • 1 Likes
  • 1 Replies

I have an instructor that uses both PDFs and links to websites for students to access and read.  The analytics will show if they downloaded the PDFs but not if they accessed the links.  Is there a way...

Community Member Data and Analytics Group
  • 0 Likes
  • 1 Replies

Our organization would like to have access to Canvas Data 2. Going through Canvas Data 2 blogs, it says to contact the Customer Success Manager to get unboarded. I have no direct contact with CSM wher...

Community Member Data and Analytics Group
  • 0 Likes
  • 1 Replies

I'm working with exported data from CD2.  I'm trying to understand how a version of a quiz submission (QUIZ_SUBMISSIONS.QUIZ_VERSION) relates to the version of the quiz.  I don't see a version assigne...

Community Explorer Data and Analytics Group
  • 0 Likes
  • 0 Replies

Good Morning, I'm an LMS Admin trying to assist my BI Systems Director with our transition to Canvas Data 2.0 and Managed Teaching & Learning. We pull submission data to share with our campuses and pr...

Community Explorer Data and Analytics Group
  • 0 Likes
  • 2 Replies

I have a question relating to Canvas data 2.0. Will this result in any changes/updates to the admin reports - meaning the student submissions report, grade export, user course log, etc.?Will there be ...

Community Novice Data and Analytics Group
  • 0 Likes
  • 3 Replies

We want to do some statistics on the use of "Act as ...", and try to do this by checking the CD2 web_logs (/dap/query/canvas_logs/table/web_logs/data). When we look in the column "value.real_user_id" ...

Community Participant Data and Analytics Group
  • 1 Likes
  • 2 Replies

Wondering if anyone can suggest how to extract the equivalent of the grade book total letter grade? In the scores table, scores.course_score is a boolean value where true "represents the overall score...

Community Participant Data and Analytics Group
  • 0 Likes
  • 2 Replies

Hi -- I'm trying to run my DAP init/sync process in AWS Lambda which does not have a writable filesystem by default. This had been working fine as of DAP Client version 0.3.15, but more recent version...

Community Champion Data and Analytics Group
  • 1 Likes
  • 6 Replies

We're trying to find the course publish date and who published over a range of courses.  We know we can use the Course Audit API - https://canvas.instructure.com/doc/api/course_audit_log.html Checking...

Community Contributor Data and Analytics Group
  • 0 Likes
  • 0 Replies

I am attempting to use SQL to query the tables to identify the current score or points/points possible by student for each class and for each assignment as well as any quizzes (etc...). If there is a ...

Community Member Data and Analytics Group
  • 0 Likes
  • 2 Replies

Good morning, we were looking at Canvas Data 2, and at the data available to us. We do not have access to web_logs.   We have found out that we do not have web_logs because we subscribed to the servic...

Community Participant Data and Analytics Group
  • 0 Likes
  • 1 Replies

Installed the instructure-dap-client in Python 3.10 (tried 3.11 as well). Getting an error each time we try to invoke it:[SSLCertVerificationError: (1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate ve...

Community Member Data and Analytics Group
  • 0 Likes
  • 2 Replies

I have an instructor that created new quizzes for an entrance survey and an exit survey that gauges students' knowledge pre & post course. I've downloaded our Canvas Data 2, and loaded it all into Pow...

Community Participant Data and Analytics Group
  • 0 Likes
  • 2 Replies

I'm part of the support team at a small private college (around 1500 students) and we're working towards migrating all our courses' classic quizzes to new quizzes. I was curious if there was a way to ...

Community Member Data and Analytics Group
  • 1 Likes
  • 4 Replies

We are trying to pull rubric scores into our data lake.  We have been able to locate and pull the outcome scores, but we have not been able to find the regular rubric criterion scores anywhere.Is it p...

Community Explorer Data and Analytics Group
  • 0 Likes
  • 3 Replies

Hello, I am trying to configure DAP client on a new Windows server, followed all the instructions as per the documentation. When trying to fetch the list of tables using "dap list --namespace canvas",...

Community Member Data and Analytics Group
  • 0 Likes
  • 1 Replies

The goal is to create a SQL query to extract the student (prefer the student ID), the course, the assignment, and the associated grade.  I have the following query but it is not what I want or need.  ...

Community Member Data and Analytics Group
  • 0 Likes
  • 1 Replies

Hi Community,I am inquiring whether Canvas Data 2 is available on the self-hosted Canvas Community version. If so, how can we generate the client secret/key? It appears that the identity services for ...

Community Explorer Data and Analytics Group
  • 0 Likes
  • 5 Replies

When I run initdb on the submissions table I get a "year 0 is out of range" error. It seems like I'm dealing with a bad row of data. What are the best options for resolving this? I assume I could ask ...

Community Explorer Data and Analytics Group
  • 0 Likes
  • 5 Replies

Hello Everyone,   We use learning outcomes quite a bit in our work. Faculty add Learning outcomes to their traditional rubrics and use them for grading in speedgrader. I don't know if it matters or no...

Community Member Data and Analytics Group
  • 0 Likes
  • 0 Replies

I am working on a Python script that will download all of the files in the tables available to us in the Canvas namespace. I noticed when I unzip the .gz files, some have 1 file, the others have 2 fil...

Community Participant Data and Analytics Group
  • 0 Likes
  • 6 Replies

I have an alert in place that warns me when our CD2 data retrieval process has been unable to retrieve any given table for at least a couple of days (BTW each day we retrieve snapshot data once, and i...

Community Contributor Data and Analytics Group
  • 0 Likes
  • 4 Replies

Just got the following 503 { "error": { "uuid": "8a31f148-167e-4e83-981a-1982caf43480", "message": "DAP Querying service is overloaded or under maintenance.", "type": "Ove...

Community Contributor Data and Analytics Group
  • 0 Likes
  • 6 Replies

Data and Analytics Blog

Read tips and tricks about Instructure's data and analytics features

What tables in the Canvas Data 2 schema contain Quiz Questions and the User's Answers to Quiz Questions?

Community Member Data and Analytics Group
  • 0 Likes
  • 1 Replies

In the past two days, our weblogs (including user_agents table) data processing experienced some issues while completing the query jobs for customers in the North Virginia region. As an effort to prev...

Instructure Alumni Data and Analytics Group
  • 1 Likes
  • 16 Replies

This is a notice to customers, that our data processing experienced some issues and queries returned 502 while execution time started to increase. We have set the Canvas Data 2 status to Performance d...

Instructure Alumni Data and Analytics Group
  • 0 Likes
  • 0 Replies

What is Canvas Data 2? Canvas Data is a comprehensive analytics solution. It offers administrators and institutions the ability to access and analyze data related to student and course activities wi...

Instructure Data and Analytics Group
  • 8 Likes
  • 2 Replies

A bug fix that was released on September 22nd may affect your integrations:What was the problem that we fixed? For the tables that use the function compose_version_global, the resulting id’s can be in...

Instructure Alumni Data and Analytics Group
  • 0 Likes
  • 1 Replies

Queries for Canvas metrics.  Anyone have sql queries for clicks, views for assignments by college. And other metric queries for external ,tools used, submissions in a day by college. If you have a sta...

Community Member Data and Analytics Group
  • 0 Likes
  • 2 Replies

Back at the start of the year I had the idea to repurpose some of the reports we had previously created to support our residential campuses.  This included a modified version of an early warning repor...

Community Champion Data and Analytics Group
  • 0 Likes
  • 0 Replies

In the past two days, our Canvas Data data processing experienced some issues while building files for Canvas Data customers in the North Virginia region. Some customers might not see the latest data ...

Instructure Alumni Data and Analytics Group
  • 2 Likes
  • 1 Replies

Since Caliper events were introduced, some Caliper events have been mistakenly classified as events triggered by an application (where an agent is a software application), instead of end-user trigged ...

Instructure Alumni Data and Analytics Group
  • 0 Likes
  • 0 Replies

We have identified a root cause of the request data loss and remedied the situation. Unfortunately, the volume of requests was very high and up to 20% of request logs were omitted from the Canvas Data...

Instructure Alumni Data and Analytics Group
  • 0 Likes
  • 0 Replies

Due to the unprecedented volume of requests coming to Canvas application servers, our request data sharing process for the North Virginia region has experienced some request log data loss on 8/24, 8/2...

Instructure Alumni Data and Analytics Group
  • 0 Likes
  • 2 Replies

In the Canvas Data (2018-12-11) release, an identifier that is a reserved word in some systems (such as AWS Redshift) was introduced in some Outcomes Tables. The ‘percent’ column in the learning_outco...

Instructure Data and Analytics Group
  • 3 Likes
  • 1 Replies

We're proud to introduce a Canvas Network course being offered FREE by Jing Qi and Brian Reid of Dartmouth College. The course is titled "Analytics in Course Design: Leveraging Canvas Data," and will ...

Instructure Alumni Data and Analytics Group
  • 10 Likes
  • 1 Replies

Data and Analytics Blog

Read the latest updates for Data and Analytics products from the Product Blog.

The Data & Insights team is continuing to look at how we can improve the experience when using the Data Access Platform (DAP) Query API directly and we'd like to get your input.

(Instructure)
The Product Blog

Canvas Data

  • 2 Likes
  • 6 Replies

As the end of 2023 is approaching, we offer you a brief retrospective of what’s new with Canvas Data, an important reminder about migrating data to Canvas Data 2 as Canvas Data 1 reaches end-of-life t...

(Instructure)
The Product Blog

Canvas Data

Canvas LMS

  • 3 Likes
  • 12 Replies

In the November 8th Canvas deploy, Admin Analytics will release a new navigation.

(Instructure)
The Product Blog

Admin Analytics

Canvas LMS

  • 5 Likes
  • 5 Replies

Great news for Catalog users (and future Catalog users) : I am happy to announce that as per our commitments, Catalog data is available, labeled as BETA, via the CD2 API and CLI. Isn’t it great? 珞

(Instructure Alumni)
The Product Blog

Canvas Catalog

Canvas Data

  • 2 Likes
  • 0 Replies

TLDR: The Admin Analytics and New Analytics feature options will default ON in the December 16 Canvas release.

(Instructure)
The Product Blog

Admin Analytics

Canvas LMS

  • 3 Likes
  • 4 Replies

As we are approaching our next significant release, Canvas Data 2 will include weblogs (currently requests table in CD1). Important note:  the target release date has changed from 21 June to 5 July an...

(Instructure Alumni)
The Product Blog

Canvas Data

Canvas LMS

  • 4 Likes
  • 16 Replies

I’m excited to let you know that we’re planning to release filter updates to Admin Analytics in the July 5th Canvas deploy and changes to the Overview dashboard in the June 21st Canvas deploy. 

(Instructure)
The Product Blog

Admin Analytics

Canvas LMS

  • 2 Likes
  • 4 Replies

We've appreciated all the great feedback on Canvas Data 2 since we released it in March. Today we are going to share some updates on planned features as well as guidance related to timelines and migra...

(Instructure Alumni)
The Product Blog

Canvas Data

Canvas LMS

  • 6 Likes
  • 21 Replies

Admin Analytics will be available as a Feature Option with the March 29th Canvas deploy.

(Instructure)
The Product Blog

Admin Analytics

Canvas LMS

  • 11 Likes
  • 18 Replies

The day is fast approaching when customers can opt in to Canvas Data 2.  It’s been a major development effort and finally, the big day is the 18th of March. YEEEY. 拾 Read on to learn more about this e...

(Instructure Alumni)
The Product Blog

Canvas Data

Canvas LMS

  • 5 Likes
  • 1 Replies

We are very excited to share that Canvas Data 2 has evolved from infancy into adolescence. We started last year in June with inputs and feedback from 13 Alpha customers from two regions and have grown...

(Instructure Alumni)
The Product Blog

Canvas Data

Canvas LMS

  • 9 Likes
  • 12 Replies

It is time to share progress on the Canvas Data 2 product development.

(Instructure Alumni)
The Product Blog

Canvas Data

  • 11 Likes
  • 13 Replies

First, a big THANK YOU to all who have completed the CD2 survey. I was really excited to see how this number has been growing day by day, a number that shows a great interest in what we are building. ...

(Instructure Alumni)
The Product Blog

Canvas Data

Canvas LMS

  • 6 Likes
  • 19 Replies

As promised, in this blog post I will share some further news on our progress with Canvas Data 2. In my previous post I mentioned why we needed to re-architecture our data pipeline and what things we ...

(Instructure Alumni)
The Product Blog

Canvas Data

Canvas LMS

  • 9 Likes
  • 9 Replies

Let’s just start in medias res because I am pretty sure that most of you are curious about not just the state of the Canvas Data 2 but also about what comes next (and why it didn’t come yet). The ques...

(Instructure Alumni)
The Product Blog

Canvas Data

Canvas LMS

  • 11 Likes
  • 14 Replies

When I think about education and what it means to me, one word irrevocably comes to my mind which is “Ikigai”—the Japanese word referring to something that gives a person a sense of purpose. Let's tal...

(Instructure Alumni)
The Product Blog

Canvas Data

Canvas LMS

General Education

  • 4 Likes
  • 0 Replies

Hi, @dlyons! I am the account admin for our district. We monitor the use of accommodations for our students and would like to pull usage data for the use of the Microsoft Immersive Reader tool in Canv...

(Community Participant)
The Product Blog

Canvas

Canvas Data

Canvas Partners

  • 0 Likes
  • 0 Replies