Is there a way to export all the community post data? I want to run an in-deep analysis of the community activities metric. Time to first response Repost to resolution Time to resolution Re-Assign to resolution

I’d recommend the data explorer plugin. It can do at least some of the analysis that you want and can export whatever data you need.

Does anyone have this query to share? Also is there a way to do an export of the raw text of each post published? Thanks!

Have you looked at the sample queries? [이미지] 401Ott: Also is there a way to do an export of the raw text of each post published? select id post_id,raw from posts

That will also give the PMs and deleted posts, which he probably doesn’t want. @401Ott , if you want all posts published that do not include private messages, then you will need to filter out posts whose topic’s archetype is ‘private_message’. Additionally, if you don’t want posts that have been de…

Yeah, I think this is spot on that filtering to only the public, published posts is ideal. In a perfect export I would be looking for username, create date (of post), create time, and text body of the post. Having associated tags would also be great. Overall my goal is to be able to identify when, …

The easiest and quickest way to do this is select post_id, user_id, created_at, raw, cooked from badge_posts where deleted_at is null with from badge_posts instead of from posts. It’s already filtered to public posts only.

This is where the lack of documentation is quite frustrating, as I wasn’t aware of badge_posts, and so the queries I wrote a few weeks ago all filter out PMs explicitly from posts.

분석을 위해 모든 게시글을 데이터 내보내기로 내보내고 싶습니다

제품 지원

401Ott (Chuck Rapoza) 1월 20, 2021, 11:22오후 6

이 쿼리를 공유하실 분이 계신가요? 또한 게시된 각 게시물의 원본 텍스트를 내보내는 방법이 있을까요?

감사합니다!

글		댓글	조회수
User posts export as csv or text Data & reporting sql-query	5	1250	7월 31, 2023
Is it possible to export topic post data to csv? Product Support data-explorer	3	441	2월 14, 2024
Capture just the posts in a topic Product Support	5	670	11월 22, 2022
How do I extract raw data from my discourse community site? Product Support	5	2163	3월 9, 2022
Is there a way to export topics/posts that are displayed when filtering? Product Support	6	900	9월 28, 2023

분석을 위해 모든 게시글을 데이터 내보내기로 내보내고 싶습니다

Related topics