I'm looking to create a report that queries all the content types and content names across all our Canvas courses. The User Course Access Log has these two fields (Content Type and Content) and I'm looking to access them not necessarily by user but by course so I can see a list of all the different types of content our instructors have used in their courses. The User Course Access Log only pulls user data from within one month, so Content only appears on that report if it has been accessed by a user within the last month (at least to my understanding).
Ideally I would get the Course ID, Term, Content, and Content Type. It would be amazing if it could also include the page clicks somehow, though I imagine that's tied to the Users and not the Course/Content itself.
Does anyone have any recommendations on how to pull this information? Thank you in advance for any help!
