如何以编程方式获取月度 pageviews？最好使用 Data Explorer

社区 数据与报告
2

这是 Consolidated Pageviews 报告背后的查询，希望对您有帮助。

-- [参数]
-- date :start_date
-- date :end_date

SELECT
    ar.date,
    CASE 
      WHEN ar.req_type=6 THEN '爬虫'
      WHEN ar.req_type=7 THEN '已登录用户'
      WHEN ar.req_type=8 THEN '匿名用户'
    END,
    ar.count AS views
FROM application_requests ar
WHERE req_type IN (6,7,8)
    AND ar.date::date BETWEEN :start_date::date
    AND :end_date::date
ORDER BY ar.date ASC, ar.req_type