[ARCHIVED] Tracking Faculty Communication Response Time

[gary]

I'm trying to use Canvas Data to determine how long, on average, it takes for a teacher or TA to respond to a student communication. I've checked the following tables:

• communication_channel_dim
• communication_channel_fact
• conversation_dim
• conversation_message_dim
• conversation_message_participant_fact

But I can't find anything that indicates whether the message was read or when.  Has anyone else tried anything similar?

[robotcars]

Nothing in those tables is a read receipt.

The only thing I've been able to do is group or partition conversations by id, and count whether there are replies and then count the span between replies if any exist.

For read receipts, you could join the Requests table and look for first (minimum) user access to the conversation_id.

edit: just ran a small test, and while I can join conversations/participants to requests, there's no way to match individual message ids.