How to see exact link of ‘top referred topics’

Data & reporting
,
1

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?

3

Is this what you are looking for?

1 Like
4

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’

5

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.

6

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: )

2 Likes
7

Thank you it works you are awesome. :grinning:

2 Likes
8

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.