Question for fellow Data people here

Community Building Data & reporting

AI-generated summary

jeremiahworkman is seeking documentation on how metrics in the Discourse admin section are defined, specifically for users of different trust levels and views, including webcrawler views. He’s experiencing discrepancies between the data in his data warehouse and the metrics reported in Discourse. He’s looking for clarification on how metrics like trust level 0 users and page views are calculated. JammyDodger provided potential resources to help answer these questions, including the Admin Dashboard Report Reference Guide and a discussion on Trying to Understand Pageviews.

1

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) 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

2

I’m not sure if these are helpful but there’s: