# Looking for help posting automating data explorer reports to my forum
**URL:** https://meta.discourse.org/t/looking-for-help-posting-automating-data-explorer-reports-to-my-forum/355265
**Category:** Data & reporting
**Tags:** dashboard-reports
**Created:** [March 2, 2025, 3:20am UTC](https://meta.discourse.org/t/looking-for-help-posting-automating-data-explorer-reports-to-my-forum/355265 "2025-03-02T03:20:34Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@hmmmnotsure](https://meta.discourse.org/u/hmmmnotsure)
#### Post date: [March 2, 2025, 3:20am UTC](https://meta.discourse.org/t/looking-for-help-posting-automating-data-explorer-reports-to-my-forum/355265/1 "2025-03-02T03:20:34Z")
I am looking for a way to schedule some of the existing reports i.e. pageviews, posts, signups, visits etc, so the data gets PM’d to a group as a csv every week. But I’m not sure how to do that.
Besides, when i tried to write something on data processor, I’m not sure what to choose for pageviews (logged-in and anonymous).
Is there a way to leverage the existing reports?
---
### Author:  [@merefield](https://meta.discourse.org/u/merefield)
#### Post date: [March 2, 2025, 10:21am UTC](https://meta.discourse.org/t/looking-for-help-posting-automating-data-explorer-reports-to-my-forum/355265/2 "2025-03-02T10:21:35Z")
[Data explorer](https://meta.discourse.org/t/32566?silent=true) has an API, and this would allow you to combine it with other tools to achieve your end goal:
> [@Run Data Explorer queries with the Discourse API](https://meta.discourse.org/t/run-data-explorer-queries-with-the-discourse-api/120063):
>
> bookmark This guide explains how to use the Discourse API to create, run, and manage queries with the [Data Explorer](https://meta.discourse.org/t/32566?silent=true) plugin. person_raising_hand Required user level: Administrator Virtually any action that can be performed through the Discourse user interface can also be triggered with the Discourse API. This document provides a comprehensive overview for utilizing the API specifically in conjunction with the [Data Explorer](https://meta.discourse.org/t/32566?silent=true) plugin. For a general overview of how to find the correct API …
---
### Author:  [@hmmmnotsure](https://meta.discourse.org/u/hmmmnotsure)
#### Post date: [March 18, 2025, 3:04pm UTC](https://meta.discourse.org/t/looking-for-help-posting-automating-data-explorer-reports-to-my-forum/355265/3 "2025-03-18T15:04:45Z")
how do i include the numbers of site\_traffic? i need anonymous and sign-in pageviews. i have the script for creating a report with 30 days’ data of user signups, topics, posts etc. i need help with pageviews. @merefield
I would like to collect all the pageviews - home page, category pages, topic pages, profile views, inbox… everything.
---
### Author:  [@tobiaseigen](https://meta.discourse.org/u/tobiaseigen)
#### Post date: [March 20, 2025, 6:09pm UTC](https://meta.discourse.org/t/looking-for-help-posting-automating-data-explorer-reports-to-my-forum/355265/7 "2025-03-20T18:09:42Z")
I moved your topic to #data-reporting where it might be noticed by people interested in reporting. If you have a budget, you may want to post an opportunity to #Marketplace.
Have you had a look at the reference guide?
> [@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…
All reports in the dashboard are generated using sql queries, which are listed in the guide and you can add as [data explorer](https://meta.discourse.org/t/32566?silent=true) queries, assuming you have that plugin enabled. Then you can use [Discourse Automation](https://meta.discourse.org/t/discourse-automation/195773) to have those queries run on a schedule and posted in your forum or as PMs to yourself, as you see fit.
If site tracking is a priority for you, you may want to use an external tool like google analytics instead of trying to get all of this out of Discourse’s reports.