# Discourse Reactions **URL:** https://meta.discourse.org/t/discourse-reactions/183261 **Category:** Plugin **Tags:** official, reactions, included-in-core **Created:** [March 15, 2021, 4:47am UTC](https://meta.discourse.org/t/discourse-reactions/183261 "2021-03-15T04:47:30Z") **Posts on this page:** 1 **Showing post:** 371
### Author: ![Lilly](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/lilly/32/575047_2.png) [@Lilly](https://meta.discourse.org/u/Lilly) #### Post date: [December 4, 2024, 6:13pm UTC](https://meta.discourse.org/t/discourse-reactions/183261/371 "2024-12-04T18:13:48Z")
FYI there is a dashboard report in your forum `admin dashboard - reports`: ![Screenshot 2024-12-04 at 10.11.09 AM](https://global.discourse-cdn.com/meta/original/4X/a/e/6/ae60a9f83ae8fa7f6580ab8b857d861ab84d13fe.png) you could work with the [data explorer](https://meta.discourse.org/t/32566?silent=true) version too > [@Dashboard Report - Reactions](https://meta.discourse.org/t/dashboard-report-reactions/292024): > > This is an SQL version of the Dashboard Report for Reactions. This report provides a daily count of all likes and reactions to posts across a site over a specified date range. This report helps provide a snapshot of user engagement within a Discourse community by measuring the frequency of various reaction emojis and likes on posts. By analyzing the usage of different reaction emojis, administrators can gain insights into how often users interact with content, users’ emotional responses to pos… if you search through the #data-reporting category, you might get some ideas to work with or start from. > [@Usage of emojis](https://meta.discourse.org/t/usage-of-emojis/279030): > > I’m planning to replace [retort](https://meta.discourse.org/t/retort-a-reaction-style-plugin-for-discourse/35903) with [discourse reactions](https://meta.discourse.org/t/discourse-reactions/183261). To find out which emojis to use, I wanted to know how their usage in my forum is. As I couldn’t find a query for this I share mine: Count emojis added with the retort plugin SELECT count(\*), REGEXP\_MATCHES(key, '([a-z\_+]+)|retort') emoji FROM post\_details WHERE extra = 'retort' GROUP BY key ORDER BY 1 DESC Count emojis in posts (without the system user) SELECT count(\*), REGEXP\_MATCHES(raw, ' :([a-z\_]+): ', 'g') emoji … --- _[View the full topic](https://meta.discourse.org/t/discourse-reactions/183261)._