Hi, I want to see the exact link of the topic post that has been shared which appears in "‘top referred topics’ "Can anyone guide me on how to see this data in the data explorer?

Would something like this fit the bill? --[params] -- date :start_date -- date :end_date SELECT 'https://meta.discourse.org/' || 't/' || t.slug || '/' || t.id || '/' || p.post_number AS post_url, COUNT(*) AS external_click_count FROM incoming_links il INNER JOIN posts p ON p.id = il.post_id INNER JOIN topics t ON t.id = p.topic_id WHERE t.archetype = 'regular' AND il.created_at::date BETWEEN :start_date AND :end_date GROUP BY p.id, t.id ORDER BY external_click_count DESC (Though swop out your own site link rather than https://meta.discourse.org :slight_smile: )

Is this what you are looking for? [image] Is the info Top Referred Topics/ Top Traffic Sources stored in a table in the database? Data & reporting For traffic sources, give this query a try. It returns the traffic source domain name, the number of clicks from the traffic source within the time period, and the number of distinct topics that were linked to from the traffic source. Results are ordered by click count in descending order. The query requires you to set start_date and end_date parameters. Dates should be in the form ‘yyyy-mm-dd’, for example 2020-01-09. The query limits the number of results to 100. If you need to change that, …

Just to clarify, you want the actual URL and not the pretty title? eg. https://meta.discourse.org/t/how-to-see-exact-link-of-top-referred-topics/275250 and not How to see exact link of ‘top referred topics’

No, I want to see the link to the top-referred topics. It only shows the topic URL. What I want is to see the URL of the shared comment or post within the thread, like this link: Example: https://meta.discourse.org/t/how-to-see-exact-link-of-top-referred-topics/275250/2 I want to know which post of a thread is shared, but it only shows the topic URL, not the specific post that was shared and clicked in the top-referred topics.

Thank you it works you are awesome. :grinning:

How to see exact link of ‘top referred topics’

Community Building Data & reporting

kynic September 29, 2023, 2:59pm 7

Thank you it works you are awesome.

Topic		Replies	Views
Is the info Top Referred Topics/ Top Traffic Sources stored in a table in the database? Data & reporting sql-query	6	1480	March 16, 2022
Dashboard Report - Top Referred Topics Data & reporting sql-query , dashboard-reports , dashboard-sql	0	384	December 12, 2023
What does 'top referred topics' measure? Data & reporting	10	1583	April 9, 2024
Top traffic sources by topic Data & reporting	5	699	March 21, 2025
Dashboard Report - Top Traffic Sources Data & reporting sql-query , dashboard-reports , dashboard-sql	2	574	December 14, 2023

How to see exact link of ‘top referred topics’

Related topics