Hi! I’ve been searching for a while but couldn’t find anything similar, not even in the cool Data Explorer queries . I want to see the history of views/visits that a specific topic has received for a period of time. Ideally, I’d like to have something like this, but for each individual topic: [i…

Hi @Ayelen_Rives :wave: Maybe try this: -- [params] -- int :topic_id = -- date :start_date = -- date :end_date = SELECT COUNT(*) AS views FROM topic_views WHERE topic_id = :topic_id AND viewed_at BETWEEN :start_date AND :end_date you will need to specify the topic id (from the topic URL) and …

Hi Lilly! It’s useful! I’ll make some research in order to separate data day by day, because it sums up all views during period. Now I know where to begin :raised_hands: :mag_right: Thanks!!

Glad that helps you. Let us know if you need more specific queries or more help with it :slight_smile:

I’m afraid I have recently found out that the topic_views table only records the very first view of a topic by a user and not one topic view per user/ip per day. Unfortunately this makes doing a time-based breakdown on views a little skewed, and can only be done on ‘viewed for the first time’.

Well then the table should be called topic_first_views :sweat_smile: :upside_down_face: Sorry @Ayelen_Rives , I tried :woman_shrugging:t2: :crying_cat_face: edit: Found a relevant discussion: [圖片] Topic_views vs Topic.views Development When helping a cl…

What a pity! Agree with Lilly that the table should be called topic_first_views for disambiguation. Thanks for the info and thanks Lilly for the try! :raised_hands: I’ll keep looking on that discussion.

主题浏览历史

社区数据与报告

Lilly (Lillian ) 2023年十月2日 16:42 6

那么表名就应该是 topic_first_views

抱歉 @Ayelen_Rives，我尽力了

编辑：找到了一个相关的讨论：

話題		回覆	觀看
Counting pageviews per topic using the Data-Explorer plugin Data & reporting sql-query	5	1096	2019年三月27日
How many viewers viewed a topic during a certain period? Data & reporting	3	1219	2021年九月15日
View count difference in category vs data-explorer Data & reporting	3	257	2024年十一月9日
Topic Reads by Date Data & reporting sql-query	0	915	2020年六月2日
Dashboard Report - Topic View Stats Data & reporting sql-query , dashboard-reports , dashboard-sql	0	189	2025年一月28日

主题浏览历史

相關主題