Hey there community! By any chance has anyone wrote a query using Data explorer to fetch monthly pageviews number? Is there any other programatic way to get those numbers than manually accessing my dashboard?

Yes, it is possible, in this case, you need to adjust the format of the date field first and then adjust the group by. Below is the adjusted query. -- [params] -- date :start_date -- date :end_date WITH data AS (SELECT date_part('month', ar.date) AS month, date_part('year', ar…

This is the query behind the Consolidated Pageviews report, I hope it helps. -- [params] -- date :start_date -- date :end_date SELECT ar.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' …

Perfect! That helps a bit! Is it possible to fetch this number: [Screenshot 2021-02-02 at 14.45.04]

This query lists the total number of pageviews over the period. -- [params] -- date :start_date -- date :end_date WITH data AS ( SELECT ar.date, CASE WHEN ar.req_type=6 THEN 'Crawlers' WHEN ar.req_type=7 THEN 'Logged in users' WHEN ar.req_type=8 T…

Perfect! That was what I was looking for.

Got one more question actually. Maybe that won’t be much of a hustle. Is there a way to get the results in following format so using sum: [Screenshot 2021-02-02 at 15.29.21]

كيفية الحصول على مرات المشاهدة الشهرية برمجياً؟ يفضل باستخدام Data Explorer

مجتمع البيانات والتقارير

Konrad_Sopala (KonradSopala) 2 فبراير 2021، 1:46م 3

ممتاز! هذا يساعد قليلاً!

هل من الممكن جلب هذا الرقم:

الموضوع		الردود	مرات العرض
Dashboard Report - Consolidated Pageviews Data & reporting sql-query , dashboard-reports , dashboard-sql	3	739	24 مارس 2025
Calculate total participation moments by month using Data Explorer Data & reporting sql-query	12	1483	25 فبراير 2021
Dashboard Report - Site Traffic Data & reporting sql-query , dashboard-reports , dashboard-sql	0	255	24 مارس 2025
Dashboard Report - Web Crawler Pageviews Data & reporting sql-query , dashboard-reports , dashboard-sql	0	394	8 فبراير 2024
Dashboard Report - Anonymous Data & reporting sql-query , dashboard-reports , dashboard-sql	9	638	21 ديسمبر 2023

كيفية الحصول على مرات المشاهدة الشهرية برمجياً؟ يفضل باستخدام Data Explorer

الموضوعات ذات الصلة