# Data & reporting **URL:** https://meta.discourse.org/c/community-building/data-reporting/148.md?page=16 [Latest](https://meta.discourse.org/latest.md) · [Categories](https://meta.discourse.org/categories.md) · [Tags](https://meta.discourse.org/tags.md) **Page:** 17 --- ## [Data Explorer query for % of topics solved by specific users group](https://meta.discourse.org/t/data-explorer-query-for-of-topics-solved-by-specific-users-group/180880)
**Author:** [@Konrad\_Sopala](https://meta.discourse.org/u/Konrad_Sopala)\ **Replies:** 7\ **Last updated:** [March 4, 2021, 11:20am UTC](https://meta.discourse.org/t/data-explorer-query-for-of-topics-solved-by-specific-users-group/180880 "2021-03-04T11:20:24Z")
Hey there everyone playing with Data Explorer! (Bear with me @michebs :smiley: - I will only have two more questions, I hope other will benefit as well) Has anyone ever created a Data Explorer query for % of topics sol… --- ## [Calculate total participation moments by month using Data Explorer](https://meta.discourse.org/t/calculate-total-participation-moments-by-month-using-data-explorer/179885)
**Author:** [@Konrad\_Sopala](https://meta.discourse.org/u/Konrad_Sopala)\ **Replies:** 12\ **Last updated:** [February 25, 2021, 8:51am UTC](https://meta.discourse.org/t/calculate-total-participation-moments-by-month-using-data-explorer/179885 "2021-02-25T08:51:04Z")
Hey there Data Explorer wizards! Has anyone ever tried creating a query that will give the count for total participation moments by moth using Data Explorer queries? I mean total number of all posts, solutions, likes b… --- ## [Trust level 0 + custom field badge](https://meta.discourse.org/t/trust-level-0-custom-field-badge/179598)
**Author:** [@cosdesign](https://meta.discourse.org/u/cosdesign)\ **Replies:** 1\ **Last updated:** [February 20, 2021, 11:19am UTC](https://meta.discourse.org/t/trust-level-0-custom-field-badge/179598 "2021-02-20T11:19:06Z")
Hi. I want to create a badge based on the trust level and the chosen option from a dropdown custom field and I keep getting this message ( also I’m not sure if the rest of the query is correct, so any help is appreciated… --- ## [How to anonymize IPs Google Analytics in 2021 on Discourse?](https://meta.discourse.org/t/how-to-anonymize-ips-google-analytics-in-2021-on-discourse/179674)
**Author:** [@AquaL1te](https://meta.discourse.org/u/AquaL1te)\ **Replies:** 3\ **Last updated:** [February 18, 2021, 4:45pm UTC](https://meta.discourse.org/t/how-to-anonymize-ips-google-analytics-in-2021-on-discourse/179674 "2021-02-18T16:45:15Z")
Continuing the discussion from How to anonymize Google Analytics?: For the GDPR it’s required to send IPs anonymized IPs because they are personal identifiable information. However, there doesn’t seem to be an option in… --- ## [Query Help: Posts Created Report filterable by title & Trust\_level](https://meta.discourse.org/t/query-help-posts-created-report-filterable-by-title-trust-level/179943)
**Author:** [@401Ott](https://meta.discourse.org/u/401Ott)\ **Replies:** 0\ **Last updated:** [February 16, 2021, 8:32pm UTC](https://meta.discourse.org/t/query-help-posts-created-report-filterable-by-title-trust-level/179943 "2021-02-16T20:32:24Z")
I’m hoping to report against when and how often only community members post. The column parameters I’m looking to see in this report would be: Username, Title, (Post create date?), and Trust\_level. I have the data explo… --- ## [Data explorer query: find posts without replies](https://meta.discourse.org/t/data-explorer-query-find-posts-without-replies/179767)
**Author:** [@Ed\_Bobkov](https://meta.discourse.org/u/Ed_Bobkov)\ **Replies:** 4\ **Last updated:** [February 15, 2021, 5:52pm UTC](https://meta.discourse.org/t/data-explorer-query-find-posts-without-replies/179767 "2021-02-15T17:52:55Z")
Following the topic: How to find topics without a reply from someone other than the topic owner? I created this query, but in my case there is a problem. PG::UndefinedTable: ERROR: missing FROM-clause entry for table … --- ## [Get member count overall by month using Data Explorer](https://meta.discourse.org/t/get-member-count-overall-by-month-using-data-explorer/178899)
**Author:** [@Konrad\_Sopala](https://meta.discourse.org/u/Konrad_Sopala)\ **Replies:** 5\ **Last updated:** [February 10, 2021, 3:00pm UTC](https://meta.discourse.org/t/get-member-count-overall-by-month-using-data-explorer/178899 "2021-02-10T15:00:05Z")
Hey there everyone! Has anyone ever written a Data Explorer query for fetching members count overall by month giving a result like this? --- ## [A badge for reading time?](https://meta.discourse.org/t/a-badge-for-reading-time/178482)
**Author:** [@cosdesign](https://meta.discourse.org/u/cosdesign)\ **Replies:** 2\ **Last updated:** [February 5, 2021, 10:00am UTC](https://meta.discourse.org/t/a-badge-for-reading-time/178482 "2021-02-05T10:00:37Z")
Hello! I came across the codecademy community and saw that they have 3 badges based on how much time a member spent reading. Does anyone have any idea how we could create a badge like that? So far I made this badge i… --- ## [How to get monthly pageviews programatically? Preferably using Data Explorer](https://meta.discourse.org/t/how-to-get-monthly-pageviews-programatically-preferably-using-data-explorer/178103)
**Author:** [@Konrad\_Sopala](https://meta.discourse.org/u/Konrad_Sopala)\ **Replies:** 7\ **Last updated:** [February 2, 2021, 3:33pm UTC](https://meta.discourse.org/t/how-to-get-monthly-pageviews-programatically-preferably-using-data-explorer/178103 "2021-02-02T15:33:39Z")
Hey there community! By any chance has anyone wrote a query using Data explorer to fetch monthly pageviews number? Is there any other programatic way to get those numbers than manually accessing my dashboard? --- ## [Times / Dates of user logins](https://meta.discourse.org/t/times-dates-of-user-logins/178115)
**Author:** [@Richie](https://meta.discourse.org/u/Richie)\ **Replies:** 0\ **Last updated:** [February 2, 2021, 2:29pm UTC](https://meta.discourse.org/t/times-dates-of-user-logins/178115 "2021-02-02T14:29:47Z")
Is it possible for the data explorer plugin to report on the times/dates a given user has logged in? For example, I’d provide a username and get a simple list back, ordered by the most recent timestamp? --- ## [Where is push notification data stored](https://meta.discourse.org/t/where-is-push-notification-data-stored/157995)
**Author:** [@amityada](https://meta.discourse.org/u/amityada)\ **Replies:** 1\ **Last updated:** [July 17, 2020, 12:55am UTC](https://meta.discourse.org/t/where-is-push-notification-data-stored/157995 "2020-07-17T00:55:33Z")
Is this data point stored in any table? --- ## [Data discrepancy in user post counts](https://meta.discourse.org/t/data-discrepancy-in-user-post-counts/177214)
**Author:** [@hollyw](https://meta.discourse.org/u/hollyw)\ **Replies:** 3\ **Last updated:** [January 26, 2021, 2:41pm UTC](https://meta.discourse.org/t/data-discrepancy-in-user-post-counts/177214 "2021-01-26T14:41:12Z")
I’m trying to figure out a potential data discrepancy I’m seeing. I’ve been doing some queries with the Data Explorer plugin to get stats on our most-frequently posting users. One query I used was the following: select … --- ## [Is there any way to pull in bulk all topics/posts and DMs with a certain keyword?](https://meta.discourse.org/t/is-there-any-way-to-pull-in-bulk-all-topics-posts-and-dms-with-a-certain-keyword/176159)
**Author:** [@KLK](https://meta.discourse.org/u/KLK)\ **Replies:** 1\ **Last updated:** [January 14, 2021, 11:09pm UTC](https://meta.discourse.org/t/is-there-any-way-to-pull-in-bulk-all-topics-posts-and-dms-with-a-certain-keyword/176159 "2021-01-14T23:09:43Z")
Hi - Is there any way, besides just using search, to pull all the conversations, topics, posts, and DMs that include specific keywords? Our legal team needs all the comments, threads, and DMs with anything referring to … --- ## [Posts under topics with nested topic\_id unincluded](https://meta.discourse.org/t/posts-under-topics-with-nested-topic-id-unincluded/90702)
**Author:** [@uptownyumiko](https://meta.discourse.org/u/uptownyumiko)\ **Replies:** 1\ **Last updated:** [June 25, 2018, 1:34pm UTC](https://meta.discourse.org/t/posts-under-topics-with-nested-topic-id-unincluded/90702 "2018-06-25T13:34:25Z")
Hi, I am trying to export the list of Like and Liked interaction by topics remixing the sample code, and realized that the topics I was particularly trying to look at seemed to not be included in the list. The code I tr… --- ## [Pageviews from Anonymous Users have exploded but Google Analytics showed no traffic growth. How to find about where the increase come from?](https://meta.discourse.org/t/pageviews-from-anonymous-users-have-exploded-but-google-analytics-showed-no-traffic-growth-how-to-find-about-where-the-increase-come-from/173892)
**Author:** [@zhenniwu](https://meta.discourse.org/u/zhenniwu)\ **Replies:** 23\ **Last updated:** [January 5, 2021, 12:29am UTC](https://meta.discourse.org/t/pageviews-from-anonymous-users-have-exploded-but-google-analytics-showed-no-traffic-growth-how-to-find-about-where-the-increase-come-from/173892 "2021-01-05T00:29:33Z")
In the last two weeks, the pageviews (PV) from anonymous users have exploded. However, Google Analytics (GA) shows a different story. As you can see, GA even showed a slight dip. I love seeing the growth but would love t… --- ## [Activity metrics updated only once per day?](https://meta.discourse.org/t/activity-metrics-updated-only-once-per-day/137689)
**Author:** [@kicolobo](https://meta.discourse.org/u/kicolobo)\ **Replies:** 13\ **Last updated:** [January 4, 2021, 8:21am UTC](https://meta.discourse.org/t/activity-metrics-updated-only-once-per-day/137689 "2021-01-04T08:21:29Z")
Hi, We are using the latest version of Discourse. Recently I noticed that the Activity Metrics reports on the administration page is being updated only once per day. Actually: only in the first time of the day that I ac… --- ## [How to get the number of mentions groups have had over the past year, and number of members](https://meta.discourse.org/t/how-to-get-the-number-of-mentions-groups-have-had-over-the-past-year-and-number-of-members/174548)
**Author:** [@traceymoko](https://meta.discourse.org/u/traceymoko)\ **Replies:** 2\ **Last updated:** [December 31, 2020, 12:43am UTC](https://meta.discourse.org/t/how-to-get-the-number-of-mentions-groups-have-had-over-the-past-year-and-number-of-members/174548 "2020-12-31T00:43:09Z")
Hi, I’m a moderator on the Hopscotch forum, and I was wondering if we could ask for help with these Data Explorer queries: How many @mentions that groups have had in the past 365 days sorted from lowest to highest, an… --- ## [Crawlers in the community](https://meta.discourse.org/t/crawlers-in-the-community/171972)
**Author:** [@Ranjan](https://meta.discourse.org/u/Ranjan)\ **Replies:** 4\ **Last updated:** [December 19, 2020, 12:19pm UTC](https://meta.discourse.org/t/crawlers-in-the-community/171972 "2020-12-19T12:19:39Z")
Hi Team, In the community dashboard, I see a lot of crawlers logging in to the site. I’m not able to know who they are and how they reached here. Who are these visitors? How can their activity and what kind of activit… --- ## [Badge for Having Certain Other Badges](https://meta.discourse.org/t/badge-for-having-certain-other-badges/173436)
**Author:** [@Qursch](https://meta.discourse.org/u/Qursch)\ **Replies:** 2\ **Last updated:** [December 17, 2020, 12:27pm UTC](https://meta.discourse.org/t/badge-for-having-certain-other-badges/173436 "2020-12-17T12:27:33Z")
I am working on badge SQL that grant’s users a badge when they have all of the badges in a specified list. (E.g. id’s 3, 4 and 5). I know this badge query works for one badge: SELECT user\_id, count(id) , current\_timest… --- ## [How many active users last month?](https://meta.discourse.org/t/how-many-active-users-last-month/27591)
**Author:** [@alefattorini](https://meta.discourse.org/u/alefattorini)\ **Replies:** 13\ **Last updated:** [December 14, 2020, 2:04am UTC](https://meta.discourse.org/t/how-many-active-users-last-month/27591 "2020-12-14T02:04:52Z")
I want gather this data, for active users i mean registered users who made a post at least in the last month. I guess that i can have this just with a data filter on users export action, in this way I can answer questio… --- ## [Significant Drop in Anonymous Traffic March 2020](https://meta.discourse.org/t/significant-drop-in-anonymous-traffic-march-2020/172915)
**Author:** [@ked](https://meta.discourse.org/u/ked)\ **Replies:** 4\ **Last updated:** [December 10, 2020, 10:03pm UTC](https://meta.discourse.org/t/significant-drop-in-anonymous-traffic-march-2020/172915 "2020-12-10T22:03:30Z")
A 1 yr. lookback report on Anonymous users revealed this: I suspect the spike at July 31st will always be a mystery, but clearly something happened in the March 13-20 week. Anyone else experience something similar?… --- ## [Query for 'Approved By' Data](https://meta.discourse.org/t/query-for-approved-by-data/172765)
**Author:** [@Chris27](https://meta.discourse.org/u/Chris27)\ **Replies:** 0\ **Last updated:** [December 9, 2020, 4:36pm UTC](https://meta.discourse.org/t/query-for-approved-by-data/172765 "2020-12-09T16:36:29Z")
I was wondering if there was an existing query that includes who approved/rejected signups, as well as posts in categories that require moderator approval. Essentially I’m looking for a way to compile month over month: … --- ## [Discourse admin dashboard statistics time generation](https://meta.discourse.org/t/discourse-admin-dashboard-statistics-time-generation/148290)
**Author:** [@VoskCoin](https://meta.discourse.org/u/VoskCoin)\ **Replies:** 3\ **Last updated:** [November 13, 2020, 6:36pm UTC](https://meta.discourse.org/t/discourse-admin-dashboard-statistics-time-generation/148290 "2020-11-13T18:36:06Z")
What time does the dashboard pull its stats? I would like to sync it up with 12:00 AM 0000 EST It is also odd it shows today stats, but they’re never fully accurate? It even says the dashboard has updated within the las… --- ## [Data explorer query to return certain post notices?](https://meta.discourse.org/t/data-explorer-query-to-return-certain-post-notices/271090)
**Author:** [@nathank](https://meta.discourse.org/u/nathank)\ **Replies:** 4\ **Last updated:** [November 19, 2020, 4:33am UTC](https://meta.discourse.org/t/data-explorer-query-to-return-certain-post-notices/271090 "2020-11-19T04:33:37Z")
Is there a way to extend this feature a little and send a notification to a user (or group) if a First time or Returning notice has been posted? We’ve got someone who wishes to be in the role of ‘welcoming committee’ bu… --- ## [Create a report of users including custom fields](https://meta.discourse.org/t/create-a-report-of-users-including-custom-fields/170342)
**Author:** [@nathank](https://meta.discourse.org/u/nathank)\ **Replies:** 0\ **Last updated:** [November 17, 2020, 9:40am UTC](https://meta.discourse.org/t/create-a-report-of-users-including-custom-fields/170342 "2020-11-17T09:40:46Z")
I’ve come up with this as an easy way to quickly get user info per group. It has been hacked together from the suggestions of others and from someone who knows SQL way more deeply than I ever will. It comes in handy if … --- ## [Hour By Hour Statistics](https://meta.discourse.org/t/hour-by-hour-statistics/170223)
**Author:** [@CaptainZac](https://meta.discourse.org/u/CaptainZac)\ **Replies:** 10\ **Last updated:** [November 16, 2020, 5:22pm UTC](https://meta.discourse.org/t/hour-by-hour-statistics/170223 "2020-11-16T17:22:35Z")
When looking at my forum, I generally see that there are more posts in specific hours than others. Is there a way that we can get a statistic that shows specifically; in hours how many posts how many page views etc. like… --- ## [Badges based on User Custom Fields?](https://meta.discourse.org/t/badges-based-on-user-custom-fields/276719)
**Author:** [@downey](https://meta.discourse.org/u/downey)\ **Replies:** 21\ **Last updated:** [November 13, 2020, 7:05pm UTC](https://meta.discourse.org/t/badges-based-on-user-custom-fields/276719 "2020-11-13T19:05:01Z")
Has anyone come up with any badges based on some value for custom user fields? If so, how can we get at those custom user fields with a SQL query? Here’s a sample badge (there is surely better SQL to do this!) that we … --- ## [Report number of users that have used each login method](https://meta.discourse.org/t/report-number-of-users-that-have-used-each-login-method/132943)
**Author:** [@rishabh](https://meta.discourse.org/u/rishabh)\ **Replies:** 1\ **Last updated:** [November 10, 2020, 11:33am UTC](https://meta.discourse.org/t/report-number-of-users-that-have-used-each-login-method/132943 "2020-11-10T11:33:12Z")
Number of active users per login method Counts how many users have used each login method in the last 28 days. The time period can be changed via a parameter --\[params\] -- integer :last\_seen\_days = 28 SELECT provider\_n… --- ## [Unexplainable spike in page views](https://meta.discourse.org/t/unexplainable-spike-in-page-views/169475)
**Author:** [@Heather\_Phillips](https://meta.discourse.org/u/Heather_Phillips)\ **Replies:** 1\ **Last updated:** [November 6, 2020, 8:06pm UTC](https://meta.discourse.org/t/unexplainable-spike-in-page-views/169475 "2020-11-06T20:06:51Z")
We had a huge unexplainable spike in page views on 10/22. We also have Google Analytics wired to our community and it’s not showing the spike. Is this some sort of bug or known issue? If it’s real is there a way to trac… --- ## [Can't get access to a query](https://meta.discourse.org/t/cant-get-access-to-a-query/157365)
**Author:** [@Ed\_Bobkov](https://meta.discourse.org/u/Ed_Bobkov)\ **Replies:** 2\ **Last updated:** [November 6, 2020, 1:29pm UTC](https://meta.discourse.org/t/cant-get-access-to-a-query/157365 "2020-11-06T13:29:54Z")
I created a query and opened an access to all possible groups: Logged in as admin. When I try to access the group that was created manually, I get an error. I used the link https://site/g/new/reports/2 https://site… [Previous page](https://meta.discourse.org/c/community-building/data-reporting/148.md?page=15) [Next page](https://meta.discourse.org/c/community-building/data-reporting/148.md?page=17)