Tracking of Pageviews and Unique Users at Category and Tag Level

数据与报告
1

I am curious if you have advice on tracking community health metrics at the category and/or tag level.
For example, I’d love to have a clearer sense of the daily number of pageviews and user visits (both known and anonymous users, and ideally by specific group-members) on topic-threads under each category and tag.

In /admin/dashboard/reports, new topics and new post have reports that can be filtered to the category level, user profile_views can be filtered by group, and there are sitewide metrics on page views and other useful info.

I suspect some of this can be set-up somehow in Google Analytics, but that’s not obvious to me since it’s not obvious how to associate topic urls with tags and categories in google analytics. I also suspect this may be done via the /admin/plugins/explorer, but I haven’t had any success.

Your advice would be greatly appreciated.

4 个赞
3

Do you have any advice here @hawk? It seems like a reasonable question and maybe new dashboard / reports covers this a bit?

2 个赞
4

It does seem like a reasonable request, yes. At the moment the reports on the dashboard aren’t segment-able but if we can work out a way to do that I think it would be an excellent addition to v2. We’ve also talked about exposing approved Data Explorer queries on the dashboard.

cc @j.jaffeux – do you have plans to revisit the dashboard any time soon?

6 个赞
5

Yes, it will be step by step but might come to something close to this. I don‘t want it to become too complex though and it will never be a “combine any segment you want”, there’s sql (and data-explorer) for this. But will probably try to provide this on a per report basis where we think it makes sense.

4 个赞
6

This query is specifically about pageviews per category, which I don’t think can be handled with Data Explorer can they?

2 个赞
7

Yes, I would also be interested in a report about the unique users on my site.

8

Yes this specific report is using ApplicationRequest table, which doesn’t have any notion of category. So not possible through reports, data-explorer or raw sql.

2 个赞
9

Can we pull a report on the number of anonymous users instead of the number of pages viewed anonymously?

1 个赞
10

Do you mean the number of people that have used the anonymous posting feature? They all get unique anonymous usernames so it will be very easy to pull a report from Data Explorer

2 个赞
11

I’m trying to find out how many people are visiting the site who have not logged in at all and do not have an account.

2 个赞
12

Would love to see this as well! Any advice on how to construct a query? Thx!

13

We also want this number (PVs per category, excluding crawler activity). Is there a way to get this from the Data Explorer?

14

I don’t believe so. We don’t granularly track page views like that. You would need to hook up your GA and use that.

1 个赞
15

@HAWK: Do you reckon this won’t be possible then? Counting Pageviews for users (non-staff, non-crawler)

16

Has anyone found a solution to count page views for all posts within a specific category? Possible with GA?

1 个赞
17

您可以通过汇总类别下所有主题的浏览量，从数据浏览器中获取_总_类别浏览量：

SELECT 
       c.id as category_id, 
       SUM(views) as "total views"
FROM categories c 
JOIN topics t ON t.category_id = c.id
WHERE read_restricted is false
GROUP BY c.id
order by sum(views) desc

按标签获取总浏览量的方法类似：

SELECT tags.name,
       sum(views)
from topics t
     join topic_tags tt on t.id = topic_id
     join tags on tags.id = tt.tag_id
group by tags.name
order by sum(views) desc

还有一个 topic_views 表，理论上可以用来按用户和日期划分浏览量。然而，我发现这个表不太有用，因为当主题浏览量很大时，查询会超时。它还显示每个主题的浏览量少得多，因为如果我理解正确的话，它不计算匿名浏览量。我还认为 topic.views 可能不仅包括匿名浏览量，还包括机器人流量？这比我在 GA 上看到的要多得多。

说到 GA，它拥有您需要的所有数据，但很难按类别或标签进行分组。我能做的最好的事情是尝试解析 pageTitle 来查找类别。我正在使用 googleAnalyticsR 在 R 中执行此操作。请遵循手册中的说明授权您的 Google 帐户并获取您想要的指标。请务必将 pageTitle 包含为维度。我的 API 调用大致如下：

ga_this_year <- ga_data(ga_id, 
                        date_range = c("2023-01-01", "2023-05-30" ),
                        metrics=c("screenPageViews","averageSessionDuration", "sessions"), 
                        dimensions = c("pageTitle", "deviceCategory")
                       )

理解下一部分的关键是看到 pageTitles 符合此通用格式：

Topic title - Category - Site title

如果主题未分类，则“Category”将缺失。还有很多实用页面（“Latest topics”、“New topics”等）没有类别。（我没有将“Latest [category] topics”视为类别的一部分，尽管包含它们可能更好。）最后，主页使用 Site title - short site description 作为页面标题。然而，我们不关心其中任何一个。所以，我使用的正则表达式是：

str_extract(pageTitle,
            str_glue(".*? - (.*) - {sitename}"),
            group=1)

将其组合成一个按类别分组的函数，我得到类似这样的结果：

category_views <- function(data, sitename = "Meta Jon") {
  data %>% 
  mutate(category = str_extract(
                                pageTitle,
                                str_glue(".*? - (.*) - {sitename}"),
                                group=1
                                )) %>% 
  group_by(category) %>% 
  summarise(views = sum(screenPageViews)) %>% 
  arrange(desc(views)) #%>% head(20)
}

category_views(ga_this_year)

（显然，请将“Meta Jon”替换为您自己的网站名称。）

不过，我目前不知道如何根据标签提取 GA 数据。

2 个赞
18

这些总观看次数是否包含机器人，也就是匿名用户？

19

GA 根据其文档排除了机器人流量。我找不到 topic_views 的文档，但代码中的一条注释说：

# 每天每个事物每个（用户 || IP）只存储一次视图

我不确定，但 topic.views 似乎显示了机器人的页面浏览量，因为它显示的浏览量比 GA 同一页面的浏览量多得多。

20

是的，但使用数据浏览器时来自 Discourse 的计数是多少？

早些时候 GA 也这么说过，当有合法的机器人时，这可能是真的。但大多数调用是由恶意机器人、行为不端的 SEO 机器人、敲诈者等引起的，然后一次访问规则就会被打破。如果我诚实地说，我就是这么认为的。

无论如何，我正在使用 Matomo。我不是那种需要 GA 的大人物。

21

仅供参考，这实际上是因为 topic_views 表限制为每天只计算一次新浏览，而 topics.views 字段允许每 8 小时（默认情况下，但可以使用 topic view duration hours 更改）计算一次新浏览。它确实包括用户和匿名用户。:+1:

更新
事实证明，topic_views 表甚至不计算每天一次的新浏览……它实际上计算的是某人第一次浏览某个主题，之后不再计算。因此，每个用户或 IP 每个主题只会有一个记录。

2 个赞