Wie wird der Suchbegriffe-Bericht erstellt?

[olegbc1 (OlegBC)]

Ich möchte eine SQL-Abfrage erstellen, um mir die meistgesuchten Begriffe für einen beliebigen Zeitraum zusammen mit der Klickrate (CTR) anzeigen zu lassen. Weiß jemand, wie der Bericht „Suchprotokolle" (unter …/admin/logs/search_logs?period=weekly) erstellt wird, und insbesondere, wie die CTR berechnet wird?

Ich sehe zwar eine Tabelle namens search_logs, bin mir aber nicht sicher, welche Daten für die CTR herangezogen werden.

Vielen Dank,
Oleg.

[loginerror (Maciej Kuźmicz)]

What an old topic without an answer, let’s bump it

I would like to find out which topics were clicked for particular search term. I found this query, which comes close, but the tables seem to be deprecated since then:

Search usability and data

We actually did complete the work of logging the information. You can try out: SELECT term, count(*) searches, sum(case when clicked_topic_id is not null then 1 else 0 end) "continued from search" from search_logs where created_at > current_timestamp - interval '30' day group by term order by count(*) desc limit 100 It Data Explorer, it will show you top 100 searches and even counts of who actually clicked through from search. I find the results super interesting. We will work on exposin…

Is there any way to achieve it on the latest version?

[j.jaffeux (Joffrey Jaffeux)]

https://github.com/discourse/discourse/blob/master/app/models/reports/trending_search.rb

and

app/models/search_log.rb

Should give you all you need to know.