大家好，
请问如何访问按主题划分的页面浏览量的历史/时间序列数据？我尝试使用表 top_topics 和 topic_views，但它们都没有包含完整的结果集。我需要主题、日期以及每日计数……
非常感谢！
Alexandra
I like this idea for a stock report here in data explorer, @HAWK can you assign this out to a tech advocate?
We still have the topic_views table which has tons of info, so we could just break this down per day.
4 个赞
Can you clarify what you mean by that? You can sort topics by pageviews in the topic list interface. Just click the views column header.
My understanding is that @Alexandra_Diehl wants to see that on Monday 100 people visited the topic and on Wednesday 32 people. We actually store data at that fidelity.
Though we do need a bit of an internal refactor cause we only count any given user once and any given IP once. A simpler rollup table would take up far less storage and give more interesting results.
4 个赞
Hi, Sam!
Thanks so much for your quick response!
Yes, that’s right. I am interested in understanding how specific temporal events affect pageviews. For example, when an influential user replies a post.
It will be fantastic to count with that info and I am very much looking forward to your news.
Cheers!
Hi Alexandra,
Until a refactor takes places, I believe the following is the best we can do:
-- [params]
-- date :view_date = 2019-03-26
SELECT t.id AS topic_id, COUNT(t.id) AS first_time_views
FROM topics t
JOIN topic_views tv ON t.id = tv.topic_id
GROUP BY t.id, viewed_at
HAVING viewed_at = :view_date
ORDER BY first_time_views DESC
You can specify a date using the field in the Data Explorer UI. The first column of the results will show linked topic titles with their reply count in parenthesis. The second column is the number of first time views of the topic on the day you specified.
7 个赞
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.