-
Average number of students viewing at least 1 page per week?
I'm trying to calculate the average number of students who have viewed at least 1 page on the site per week. So far, not getting anywhere because I need to be able to see unique page views rather than just 'page views'. Any ideas how to get this out of New Analytics?
-
Time series analysis for enrollments.total_active_time and active user counts
Wondering if anyone has any suggestions regarding some "time series-like" analytics for enrollments total_activity_time and active user counts? I'm conscious that CD2 is "eventual consistency" so time series analysis of things like weekly total_activity_time and overall active user count trends arent possible. There's no…
-
CD2 Course Level Participation
Hi all! I'm trying to identify a path forward for my institution to leverage the Canvas Data 2 API to obtain data around course level participation. From what I've gathered, it seems to have been possible in v1 of the API but I'm not immediately seeing anything analogous in CD2. I do see the canvas_logs.web_logs table but…
-
Does it matter who generates DAP API client keys?
I know that you can only see and manage the keys that you generate within the Identity Services, so they must be associated to the user. But do they also inherit the Canvas User's status, roles, and permissions? Or, once generated, are they independent credentials with their own expiration and all with the same (full)…
-
Canvas Data 2 - User Time Zone Code
Hi Instructure! Is there a way to access the time zone code for the user's set time zone? Example: * Right now, a user can set their time zone in the LMS to Eastern Time (US & Canada) (-06:00/-04:00)at /profile/settings. * The time zone value for this user via Canvas Data 2 looks like this: Eastern Time (US & Canada)…
-
New Analytics Query
I am being tasked with creating a Tableau dashboard that looks at New Analytics at a more global/course level scale. Does anyone know if there is a backend query that drives the New Analytics data that I could fork as way to improve my query?
-
Canvas Data 2 - New installation GCC Error
I'm updating our init and sync code to reflect what is prescribed in the documentation's Instructions and I am receiving the following error when i run pip install × Building wheel for tsv2py (pyproject.toml) did not run successfully. │ exit code: 1 ╰─> [26 lines of output] compiling with AVX2 compiling with limited C API…
-
Viewing new enrollments by date
I need to find data from a course on the number of new enrollments in the course within a certain timeframe. Is there a report I can run that will give me that information? Thanks!
-
The "read" data in Canvas Data2 (discussion related)
Hi, currently I am working on Canvas Data2 bulk data and I noticed that there is data related to which user has read the topics or replied posted by other users. Does anyone know by what action/criterion that the topic/reply is considered as read already by others, such as when users scroll through or click on the content…
-
CD2 API - Get All Users that are displayed in Users List UI
Hello, Using the CD2 API, what is the suggested way to get the Users from the User's List on UI? I have tried using Users and Pseudonyms but I am receiving more results compared to my original logic on CD1. Also, according to the documentation * Users says "Not all users are displayed in users list on UI." *…
-
New Quizzes CD2
Hello! I am new to developing with Canvas data and had two questions: 1. I saw a question from January about new quizzes and the response was that New quizzzes are not in the CD2 data. Is that still the case? For our own analytics we are pulling this data and right now using the API is quite cumbersome. 2. In regards to…
-
DAP SQL Causing Poor Performance
Note: Relying on my DBA since some of this is a bit over my head. Our scheduled "dap syncdb" process keeps blowing up our CPU. Our DBA used an "explain plan" to see where our performance issue are. Below is the SQL running a loop while sorting through a huge number of rows (18,589,175,389,900). Any assistance with this…
-
Page_view looping the first 100 results
Hello All, I'm hoping someone can help me understand something that I can seem to get my head around. I'm trying to see a list of a users page views past the last 100 entries. I have the following query entered through the URL /api/v1/users/xxx/page_views?per_page=100&page=y So my thought was I'll just view it through my…
-
"Malformed HTTP response"
Just this morning 5/13, we began to sporadically receive the error below when running our table syncs. We have changed nothing on our servers. Has anyone else seen this? ERROR - malformed HTTP response: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "<A href="http://www.w3.org/TR/html4/loose.dtd"…
-
Canvas New Analytics Not Working
I have a professor who teaches a course that runs from May to June, so not the full Summer term. When they go to New Analytics it shows that there is no new analytics. We waited the 24 hours like it said and there are submissions from students within the course. I have attached a screenshot of the screen we see. I also…