Is there a way to get a complete list of searches for a given date range, instead of just the top 100?

I think this may be a candidate for a data explorer query. I’d have to have a little rummage around to build the exact query, but I think the data is in the search_logs table. Let me know if you need any extra help. :slight_smile:

I don’t know SQL, but here is what ChatGPT told me when I asked how to query search logs for the past 3 months. Would this work (I don’t have admin access to try it out, but I would like to have a solid query to pass along to my admin). To get all search log data for the past 3 months using Discou…

I don’t think that’s right. I don’t think we have an action_logs table. :thinking: Let me have a look and see what I can whip together. :+1: :slight_smile:

I think something like this should be more like it: -- [params] -- date :start_date -- date :end_date WITH results AS ( SELECT LOWER(term) AS term, COUNT(*) AS searches, SUM(CASE WHEN search_result_id IS NOT NULL THEN 1 ELSE 0 END) AS click_through FROM search_logs WHERE created_a…

This is awesome, thank you! I’ll pass along to my admin :grinning:

We ran this query and it worked perfectly, thanks again!

سجلات البحث - كيفية الحصول على قائمة كاملة لفترة زمنية معينة؟

مجتمع البيانات والتقارير

krystal (Krystal S) 1 أغسطس 2023، 3:03م 9

لقد قمنا بتشغيل هذا الاستعلام وعمل بشكل مثالي، شكرًا لك مرة أخرى!

الموضوع		الردود	مرات العرض
How is Search Terms report produced? Data & reporting dashboard-reports	2	675	23 أكتوبر 2019
Reference guide for the Search Logs page Site Management reference , reporting	0	989	29 سبتمبر 2022
Some inconsistencies in search results Support	5	697	5 يونيو 2019
Count of total searches on site in time period? Data & reporting	6	333	25 مايو 2025
Dashboard Report - Trending Search Terms Data & reporting sql-query , dashboard-reports , dashboard-sql	0	437	13 ديسمبر 2023

سجلات البحث - كيفية الحصول على قائمة كاملة لفترة زمنية معينة؟

الموضوعات ذات الصلة