# Automatically email admin report CSVs on a recurring cadence
**URL:** https://meta.discourse.org/t/automatically-email-admin-report-csvs-on-a-recurring-cadence/267283
**Category:** Feature
**Tags:** email
**Created:** [June 5, 2023, 5:40pm UTC](https://meta.discourse.org/t/automatically-email-admin-report-csvs-on-a-recurring-cadence/267283 "2023-06-05T17:40:32Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@paigen11](https://meta.discourse.org/u/paigen11)
#### Post date: [June 5, 2023, 5:40pm UTC](https://meta.discourse.org/t/automatically-email-admin-report-csvs-on-a-recurring-cadence/267283/1 "2023-06-05T17:40:32Z")
Hello,
I was hoping there might be a way to automate emailing the downloadable reports available on the Discourse admin panel to a defined email list on a recurring basis (like weekly or monthly CSV reports of Trending Topics, for instance).
In the meantime, I built my own Python script to get the data from the Discourse API and create a CSV, but if there’s already a pre-built solution I could use instead, I’d prefer it.
Thanks very much,
Paige
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [June 5, 2023, 6:13pm UTC](https://meta.discourse.org/t/automatically-email-admin-report-csvs-on-a-recurring-cadence/267283/2 "2023-06-05T18:13:20Z")
> [@paigen11](#):
>
> I built my own Python script to get the data from the Discourse API and create a CSV,
Unless you want to write a plugin, that’s what to do.
---
### Author:  [@sam](https://meta.discourse.org/u/sam)
#### Post date: [June 6, 2023, 12:38am UTC](https://meta.discourse.org/t/automatically-email-admin-report-csvs-on-a-recurring-cadence/267283/3 "2023-06-06T00:38:31Z")
Discourse automation has this option you may find handy, can you try it out and let us know what you think?
---
### Author:  [@paigen11](https://meta.discourse.org/u/paigen11)
#### Post date: [June 6, 2023, 2:08pm UTC](https://meta.discourse.org/t/automatically-email-admin-report-csvs-on-a-recurring-cadence/267283/4 "2023-06-06T14:08:10Z")
Thanks for pointing this out, Sam - I had no idea it existed even after the amount of time I spent perusing various Discourse threads in my search for it.
Follow up question though: after looking through the existing SQL [Data Explorer](https://meta.discourse.org/t/32566?silent=true) queries in the GitHub repo and making a few attempts at writing my own, is there somewhere where I can pull the query that generates the “Trending Search Terms” report available in the Discourse admin dashboard for the past month (term, search count, CTR)?
I’ve used the `admin/reports/trending_search.json` API to get the info manually, but I’d like to use a Discord cron job here if possible.
---
### Author:  [@paigen11](https://meta.discourse.org/u/paigen11)
#### Post date: [June 6, 2023, 3:19pm UTC](https://meta.discourse.org/t/automatically-email-admin-report-csvs-on-a-recurring-cadence/267283/5 "2023-06-06T15:19:08Z")
I figured out the query to run in [Data Explorer](https://meta.discourse.org/t/32566?silent=true), it is:
```plaintext
SELECT term, count(*) searches,
sum(case when search_result_id is not null then 1 else 0 end) clicks,
round(sum(case when search_result_id is not null then 1 else 0 end) * 100.0 / count(*), 1) as ctr
from search_logs
where created_at > current_timestamp - interval '30' day
group by term
order by count(*) desc
```
So my final, final question is: is there a way in the Automation, to have this query run and turn the results into a CSV attached to the email for the recipients instead of the results posted in the body of the email?
---
### Author:  [@sam](https://meta.discourse.org/u/sam)
#### Post date: [June 6, 2023, 8:15pm UTC](https://meta.discourse.org/t/automatically-email-admin-report-csvs-on-a-recurring-cadence/267283/6 "2023-06-06T20:15:54Z")
> [@paigen11](#):
>
> So my final, final question is: is there a way in the Automation, to have this query run and turn the results into a CSV attached to the email for the recipients instead of the results posted in the body of the email?
Not at the moment but it is a very good feature request, and should not be too hard to change
Can you post a dedicated topic for this ?
---
### Author:  [@paigen11](https://meta.discourse.org/u/paigen11)
#### Post date: [June 7, 2023, 1:15pm UTC](https://meta.discourse.org/t/automatically-email-admin-report-csvs-on-a-recurring-cadence/267283/7 "2023-06-07T13:15:54Z")
Happy to. New [feature request here](https://meta.discourse.org/t/turn-data-explorer-query-results-into-csv-to-attach-to-discourse-automated-emails/267529) - thanks very much!
---
### Author:  [@Thas](https://meta.discourse.org/u/Thas)
#### Post date: [June 7, 2023, 2:59pm UTC](https://meta.discourse.org/t/automatically-email-admin-report-csvs-on-a-recurring-cadence/267283/8 "2023-06-07T14:59:14Z")
> [@sam](#):
>
> 
What does PM stand for?
---
### Author:  [@Moin](https://meta.discourse.org/u/Moin)
#### Post date: [June 7, 2023, 3:15pm UTC](https://meta.discourse.org/t/automatically-email-admin-report-csvs-on-a-recurring-cadence/267283/9 "2023-06-07T15:15:30Z")
PM is user for personal message
The second line also says “to your messages”
---
### Author:  [@Thas](https://meta.discourse.org/u/Thas)
#### Post date: [June 7, 2023, 4:02pm UTC](https://meta.discourse.org/t/automatically-email-admin-report-csvs-on-a-recurring-cadence/267283/10 "2023-06-07T16:02:07Z")
Yes but it hasn’t come to my messages therefore, I thought I may be missing something here.
Could I get this sent to my outlook instead?
---
### Author:  [@sam](https://meta.discourse.org/u/sam)
#### Post date: [June 8, 2023, 12:18am UTC](https://meta.discourse.org/t/automatically-email-admin-report-csvs-on-a-recurring-cadence/267283/11 "2023-06-08T00:18:45Z")
> [@Thas](#):
>
> Could I get this sent to my outlook instead?
As long as your outlook uses the same email address as your Discourse account, it should land there.