# Search usability and data

**URL:** https://meta.discourse.org/t/search-usability-and-data/33149
**Category:** Feature
**Tags:** search
**Created:** [September 11, 2015, 11:22pm UTC](https://meta.discourse.org/t/search-usability-and-data/33149 "2015-09-11T23:22:29Z")
**Posts on this page:** 1
**Showing post:** 19

<div class="post-metadata">

### Author: ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)
#### Post date: [July 28, 2017, 8:26pm UTC](https://meta.discourse.org/t/search-usability-and-data/33149/19 "2017-07-28T20:26:37Z")

</div>

We actually did complete the work of logging the information. You can try out:

```plaintext
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](https://meta.discourse.org/t/32566?silent=true), 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 exposing some more of this via the dashboard direct.

---

_[View the full topic](https://meta.discourse.org/t/search-usability-and-data/33149)._