# Question for fellow Data people here
**URL:** https://meta.discourse.org/t/question-for-fellow-data-people-here/258382
**Category:** Data & reporting
**Tags:** dashboard-reports
**Created:** [March 16, 2023, 3:08pm UTC](https://meta.discourse.org/t/question-for-fellow-data-people-here/258382 "2023-03-16T15:08:25Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@jeremiahworkman](https://meta.discourse.org/u/jeremiahworkman)
#### Post date: [March 16, 2023, 3:08pm UTC](https://meta.discourse.org/t/question-for-fellow-data-people-here/258382/1 "2023-03-16T15:08:25Z")
I’m looking for documentation/logic on how the metrics in the admin section of our Discourse site are defined (users of different trust levels, views, webcrawler views specifically).
I’m a data engineer whose company([Bubble.io](http://Bubble.io)) self-hosts a Discourse forum. I’m an admin on that site. We currently pull in all of the Discourse data through a reliable industry ETL tool called Stitch. My issue is, the data I am seeing in my data warehouse in the appropriate schema does not match what Discourse reports in its admin section, so I’m trying to locate some documentation on how those metrics are calculated.
For example, discourse tells me I have 56k trust level 0 users. What is that number? How are they defining it? It does not match the data I am seeing for unique users, registered users, unique IPs, unique usernames, unique emails, etc.
As for page views, Discourse is reporting wildly different numbers than the TOPIC\_VIEWS table I am getting through Stitch. And, how is Discourse defining a regular page view versus a webcrawler pageview? There is no metadata in the TOPIC\_VIEWS table which defines each page view type.
Any help you can provide here would be appreciated
---
### Author:  [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [March 20, 2023, 12:59pm UTC](https://meta.discourse.org/t/question-for-fellow-data-people-here/258382/2 "2023-03-20T12:59:26Z")
I’m not sure if these are helpful but there’s:
> [@Admin dashboard report reference guide](https://meta.discourse.org/t/admin-dashboard-report-reference-guide/240233):
>
> bookmark This is a reference guide for describing how the Admin Dashboard Reports function, the data they’re displaying, the corresponding [Data Explorer](https://meta.discourse.org/t/32566?silent=true) SQL queries, and where to find the Ruby code for each report. person_raising_hand Required user level: Staff Discourse contains several built-in admin dashboard Reports that can be useful for exploring stats about a community. To access these reports, you can visit discourse.example.com/admin/dashboard/reports on your site ( or click the…
> [@Trying to understand pageviews](https://meta.discourse.org/t/trying-to-understand-pageviews/255130):
>
> [This thread](https://meta.discourse.org/t/which-tables-is-the-data-for-consolidated-pageviews-report-stored/168792) tells me which table to look in for pageview data & how to understand it (what each request\_type means). I used that to write some year-over-year reports. I was looking at them today and started wondering about the numbers versus what’s reported on the admin homepage. So I started digging in a little. Here’s what a direct DB query tells me about yesterday: Versus the reporting on the admin homepage: I don’t know how to map the last two counts f…