Hello, I’m trying to generate a month-over-month top traffic sources report. It would be cool to see how our sources changed each month, all within one graph/table. Is there any way to get this data? Currently I can only get the totals for the full 5 month period that I am interested in: [image] …

WITH traffic_sources AS ( SELECT EXTRACT(MONTH FROM user_visits.visited_at) AS month, incoming_referers.incoming_domain_id, COUNT(*) AS visit_count, LAG(COUNT(*)) OVER (PARTITION BY incoming_referers.incoming_domain_id ORDER BY EXTRACT(MONTH FROM user_visits.visited_at)) AS prev_mo…

Just to check, have you tested this one out this time? :slight_smile: I may have some bad news… :frowning: I don’t think the date_trunc is working as you what it to: [image]

In case it’s useful to anyone attempting this adaptation, here’s a version of the Top Traffic Sources report In SQL: -- [params] -- date :start_date = 04/05/2023 -- date :end_date = 05/06/2023 WITH count_links AS ( SELECT COUNT(*) AS clicks, ind.name AS domain FROM incoming_links il INN…

Month over month top traffic sources report?

Community Building Data & reporting

JammyDodger June 2, 2023, 6:43am 5

Just to check, have you tested this one out this time?

I may have some bad news… I don’t think the date_trunc is working as you what it to:

Topic		Replies	Views
Reports > Top Traffic Sources - Topics Stat Issue Bug dashboard-reports	1	649	February 16, 2021
Dashboard Report - Top Traffic Sources Data & reporting sql-query , dashboard-reports , dashboard-sql	2	571	December 14, 2023
Is the info Top Referred Topics/ Top Traffic Sources stored in a table in the database? Data & reporting sql-query	6	1464	March 16, 2022
Top traffic sources by topic Data & reporting	5	675	March 21, 2025
Dashboard Report - Top Referrers Data & reporting sql-query , dashboard-reports , dashboard-sql	0	383	December 12, 2023

Month over month top traffic sources report?

Related topics