Good question! So in the post export, you will find some interesting metrics which might give you all that you need. The field you are looking for is “moderate_timeread”:

It actually also shows when a post has been read by a Moderator, even which Moderator it was. Now I have not tested this myself but this should give you the info when a Moderator arrived at the flagged post. If you combine this with the information when a post has been flagged, you might be able to calculate the time difference.

An edge case might be if a Moderator first checks a reply which then is being flagged afterwards - I am not sure which of the two dates would be displayed here.

Another possible way to identify how long it took for a Moderator to actually respond in the topic would be to locate the response of a Moderator in this post export and then match the timestamp of a post with the corresponding flag timestamp. Of course I do not know how often this happens, I do also not know the quickest way to do this in an excel sheet. But there should be a way via Lookup function or something alike.

There might be a way to also extract this via the API, but I am not an expert in this area. If this all fails, our support team probably can extract this information directly from the database and provide it for you.

Thanks Julian! Unfortunately, our team enters the reported topics directly from the email which is why I think I can’t see anything in the Timeread column. Ill have to look into trying your option #2. Was just hoping there was an easier way. Thanks!