Looking for help posting automating data explorer reports to my forum

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?

2 Likes

Data explorer has an API, and this would allow you to combine it with other tools to achieve your end goal:

3 Likes

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.

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?

All reports in the dashboard are generated using sql queries, which are listed in the guide and you can add as data explorer queries, assuming you have that plugin enabled. Then you can use Discourse Automation 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.

1 Like