# Data Explorer 쿼리 결과를 CSV로 변환해 Discourse 자동 이메일에 첨부하기

**URL:** https://meta.discourse.org/t/turn-data-explorer-query-results-into-csv-to-attach-to-discourse-automated-emails/267529
**Category:** Feature
**Tags:** email, data-explorer, completed
**Created:** [6월 7, 2023, 1:15오후 UTC](https://meta.discourse.org/t/turn-data-explorer-query-results-into-csv-to-attach-to-discourse-automated-emails/267529 "2023-06-07T13:15:15Z")
**Posts on this page:** 1
**Showing post:** 9

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [9월 5, 2023, 3:08오후 UTC](https://meta.discourse.org/t/turn-data-explorer-query-results-into-csv-to-attach-to-discourse-automated-emails/267529/9 "2023-09-05T15:08:46Z")

</div>

확인 차问一下, 상위 100개에 해당하는 특정 보고서를 사용 중이신가요? 제한이 없는 버전이 더 유용할 수 있을 것 같아서요?

> [@검색 로그 - 특정 날짜 범위의 전체 목록을 가져오는 방법?](https://meta.discourse.org/t/search-logs-how-to-get-a-complete-list-for-a-given-date-range/272825/7?u=jammydodger):
>
> I think something like this should be more like it: -- [params] -- date :start\_date -- date :end\_date WITH results AS ( SELECT LOWER(term) AS term, COUNT(\*) AS searches, SUM(CASE WHEN search\_result\_id IS NOT NULL THEN 1 ELSE 0 END) AS click\_through FROM search\_logs WHERE created\_at BETWEEN :start\_date AND :end\_date GROUP BY term ) SELECT term AS "Search Term", searches AS "Searches", click\_through AS "Clicks-Through", CEIL ((click\_through/searches::floa…

---

_[View the full topic](https://meta.discourse.org/t/turn-data-explorer-query-results-into-csv-to-attach-to-discourse-automated-emails/267529)._