# Content Audit : Report to pull Categories, Topics and Replies

**URL:** <https://meta.discourse.org/t/content-audit-report-to-pull-categories-topics-and-replies/349354>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [January 28, 2025, 11:33am UTC](https://meta.discourse.org/t/content-audit-report-to-pull-categories-topics-and-replies/349354 "2025-01-28T11:33:58Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![RachFeverBee](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/rachfeverbee/32/484490_2.png) [@RachFeverBee](https://meta.discourse.org/u/RachFeverBee)\
**Post date:** [January 28, 2025, 11:33am UTC](https://meta.discourse.org/t/content-audit-report-to-pull-categories-topics-and-replies/349354/1 "2025-01-28T11:33:58Z")

</div>

I’m working with a client to complete a Content Audit. I’d like to run a query to pull all categories, topics and replies from 2023 to now. Ideally, I’d like the report to include dates, poster, titles, links and full text.

I assume Discourse [Data Explorer](https://meta.discourse.org/t/32566?silent=true) is the best option. I’m looking at these posts :

> [@Dashboard Report - Topics](https://meta.discourse.org/t/dashboard-report-topics/288446):
>
> This is an SQL version of the Dashboard Report for Topics. This report provides a count of new topics created on a daily basis within a specified date range. The report does not include personal messages, only regular topics that are visible on the forum. --[params] -- date :start\_date -- date :end\_date SELECT p.created\_at::date as day, COUNT(p.id) AS topics\_created FROM posts p INNER JOIN topics t ON t.id = p.topic\_id AND t.deleted\_at ISNULL WHERE p.created\_at::date BETWEEN :start\_…

> [@How to get reports for just a specific category?](https://meta.discourse.org/t/how-to-get-reports-for-just-a-specific-category/155703/6):
>
> I have been looking for this too- I have a category for Spanish language discussions and my facilitator is curious about who is reading content. The only way to find out which reports have filters fo category is to click through them all - so far I have found the ones with this feature include: Posts Post Edits Bookmarks Likes e.g. all the things users do to interact with a post. I cannot find anything that lets me understand traffic within a category

Has anyone run a similar report? Could you offer best practice from your own experience? Cheers!

---

_[View the full topic](https://meta.discourse.org/t/content-audit-report-to-pull-categories-topics-and-replies/349354)._