想了解页面浏览量

数据与报告
,
7

代码 11 的请求类型是 API 发出的请求，代码 12 的请求类型是 user API 发出的请求。

活动指标整合了 登录用户（req_type: 7）、匿名用户（req_type: 8）和 爬虫（req_type: 6）。它们与管理员面板中第一个图表“合并页面浏览量”中考虑的相同。

下面是合并页面浏览量报告查询的示例

SQL 合并页面浏览量 
-- [params]
-- date :start_date
-- date :end_date

SELECT
    ar.date::date AS "date",
    CASE
      WHEN ar.req_type=6 THEN 'Crawlers'
      WHEN ar.req_type=7 THEN 'Logged in users'
      WHEN ar.req_type=8 THEN 'Anonymous users'
    END user_type,
    SUM(ar.count) AS views
FROM application_requests ar
WHERE req_type IN (6,7,8)
    AND ar.date::date BETWEEN :start_date AND :end_date
GROUP BY "date", user_type
ORDER BY "date"
SUM 合并页面浏览量 
-- [params]
-- date :start_date
-- date :end_date


SELECT
    ar.date::date AS "date",
    SUM(ar.count) AS pageviews
FROM application_requests ar
WHERE req_type IN (6,7,8)
    AND ar.date::date BETWEEN :start_date AND :end_date
GROUP BY "date"
ORDER BY "date" DESC
6 个赞