47 Commits

Author SHA1 Message Date
4056bac3ab content performance 2025-03-14 23:23:47 +08:00
d0f2ab0620 interaction api 2025-03-14 22:31:45 +08:00
bd1a5ce384 hotkeyword 2025-03-14 22:02:10 +08:00
942fb592b5 morte change 2025-03-14 21:10:50 +08:00
5a03323c69 add comment table 2025-03-14 20:39:38 +08:00
853ce79e16 rename ch create table sql name 2025-03-14 20:12:34 +08:00
e0bacfac1a rm initDB code 2025-03-14 20:02:09 +08:00
55ac825d08 change component 2025-03-14 19:16:22 +08:00
364a9dfc41 rm mock data 2025-03-14 19:15:12 +08:00
ebd35b7576 fix coments trend 2025-03-14 18:08:55 +08:00
9d0d3ddf4f posts hot 2025-03-14 16:11:25 +08:00
a345bf9cac sentiment analysisi 2025-03-14 16:00:10 +08:00
a2f5261523 trend 2025-03-14 15:24:34 +08:00
2033adfc67 dasboard 2025-03-14 15:16:00 +08:00
b3d3c7cb3b post perfermance fornt 2025-03-14 15:11:14 +08:00
2a3ca09862 funnel front 2025-03-14 14:00:44 +08:00
6964eb75cc kol overview frontend 2025-03-14 12:40:57 +08:00
18276652f3 更改需求说明 2025-03-13 22:02:54 +08:00
23bcb4cb8b 获取概览卡片数据 (/api/analytics/dashboard-cards)
返回包含留言总数、平均互动率和情感分析三个核心指标的卡片数据及环比变化
支持时间范围和项目ID过滤
获取留言趋势数据 (/api/analytics/comment-trend)
返回一段时间内留言数量的变化趋势,用于绘制柱状图
支持时间范围、项目ID和平台过滤
获取平台分布数据 (/api/analytics/platform-distribution)
返回不同社交平台上的评论或互动分布情况
支持时间范围、项目ID和事件类型过滤
获取情感分析详情 (/api/analytics/sentiment-analysis)
返回正面、中性、负面评论的比例和平均情感得分
支持时间范围、项目ID和平台过滤
获取热门文章数据 (/api/analytics/popular-posts)
返回按互动数量或互动率排序的热门帖文列表
支持时间范围、项目ID、平台过滤,以及排序字段和限制返回数量
2025-03-13 21:54:21 +08:00
f9ba8a73ba KOL贴文表现 2025-03-13 21:36:26 +08:00
72c040cf19 kunnel 2025-03-13 20:06:58 +08:00
b8ea4e7097 add fake event data 2025-03-13 18:43:15 +08:00
bb98531073 use winstonlog 2025-03-13 18:35:35 +08:00
6d29a208f1 kol overview 2025-03-13 18:17:27 +08:00
f5c660217a click house api tables 2025-03-13 17:22:35 +08:00
e179b9b6db sync events done 2025-03-12 23:53:36 +08:00
a25478e738 insert data to clickhouse test succss 2025-03-12 23:31:42 +08:00
210603b685 rw create table when start app 2025-03-12 20:52:23 +08:00
d9a71976f5 delete old analytics 2025-03-12 17:53:40 +08:00
1a100ae4ce added fake data 2025-03-12 16:58:53 +08:00
9d7d1abb49 cleaning up api 2025-03-12 15:49:47 +08:00
285a0c780a cleaning up db 2025-03-12 14:08:38 +08:00
ae7ea3b567 readme 2025-03-11 18:06:01 +08:00
56b1844889 get db schema 2025-03-11 17:54:57 +08:00
b53fe1b6b0 post comments fix 2025-03-11 15:20:51 +08:00
9d89eb4290 post scroll 2025-03-11 13:05:51 +08:00
609dfec44e post use api 2025-03-11 12:27:27 +08:00
db2aedf0a6 funel data 2025-03-11 00:49:11 +08:00
bc42ff4dbf funel data 2025-03-11 00:36:22 +08:00
7857a9007a front fix 2025-03-10 23:43:21 +08:00
fe9428f36c add test data 2025-03-10 20:27:12 +08:00
acf8a06375 an 2025-03-10 19:10:51 +08:00
5ef6c75360 an 2025-03-10 18:55:33 +08:00
e49b3a2172 an 2025-03-10 18:03:47 +08:00
755fb6ac04 web only use supabase auth 2025-03-10 14:21:58 +08:00
4b5910be83 only use supabase token 2025-03-10 13:38:39 +08:00
936af0c4ec init 2025-03-07 18:04:27 +08:00