# 정기적으로 관리자 보고 CSV를 자동으로 이메일로 보내기

**URL:** https://meta.discourse.org/t/automatically-email-admin-report-csvs-on-a-recurring-cadence/267283
**Category:** Feature
**Tags:** email
**Created:** [6월 5, 2023, 5:40오후 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:** 1
**Showing post:** 5

<div class="post-metadata">

### Author: ![paigen11](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/paigen11/32/229055_2.png) [@paigen11](https://meta.discourse.org/u/paigen11)
#### Post date: [6월 6, 2023, 3:19오후 UTC](https://meta.discourse.org/t/automatically-email-admin-report-csvs-on-a-recurring-cadence/267283/5 "2023-06-06T15:19:08Z")

</div>

[Data Explorer](https://meta.discourse.org/t/32566?silent=true)에서 실행할 쿼리를 찾았습니다. 내용은 다음과 같습니다:

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

```

따라서 제가 드리는 마지막, 정말 마지막 질문은 이렇습니다: Automation에서 이 쿼리를 실행하여 결과를 이메일 본문에 게시하는 대신 수신자의 이메일에 첨부된 CSV 파일로 변환할 방법이 있을까요?

---

_[View the full topic](https://meta.discourse.org/t/automatically-email-admin-report-csvs-on-a-recurring-cadence/267283)._