Time to 1st response - Find specific topic

Community Building Data & reporting

AI-generated summary

The discussion revolves around trying to find a specific topic that has a very late first response time, as indicated by a report. Here are the key points:

  • per_coh is looking at the Time to 1st Response report which shows a topic with an extremely late response, but the report only provides numbers, not the specific topic.

  • Firepup650 suggests either using a URL with the topic ID or modifying the SQL query to get a link to the topic.

  • per_coh clarifies they don’t have access to SQL and are just using the admin reports.

  • Firepup650 realizes the report likely doesn’t provide individual topic details.

  • Jagster questions if such a report showing individual topics exists.

  • per_coh laments that knowing the overall time to first response is pointless without being able to identify the problematic threads.

  • Firepup650 suggests filtering topics by creation date as a potential workaround to find the slow response topics.

The crux is finding a way within the available reports or tools to pinpoint the specific topics with very delayed first responses in order to improve that metric.

1

Hi folks. Just looking at the Time to 1st response report and it says there’s a topic with a very late response time, but the report only gives me numbers.
How do I find that specific topic?

2

You could either go to https://your.forum/t/-/NUMBERHERE, or add as topic_id to wherever your SQL query selects the topic id, which will cause it to become a link to that topic automatically.

3

What if I don’t have SQL? I’m just using the reports from the admin section.

4

I don’t think that report reports on individual topics, right? Doesn’t it just list dates?

5

Is there such report :thinking: The only 1st respond report I’m aware of shows per day average time (in 1/100 when it should show hh:mm because 2.78 just looks bad :smirking_face:)

6

Yeah, just dates and times.
Knowing the tfr is kind of pointless if I can’t find the thread and figure out how to improve.

7

I wonder if you could somehow filter topics by date created, then you could find the topics that are slow response times based off of that.