I know this is not the optimal way to track traffic, but I’m curious if there is a way to decipher who has clicked a link within our community. I assume the data is there since it is displayed via link click counting. Is there a data explorer query to show which users clicked the link? I know anonymous clicks won’t show.

I think you can get this info from the topic_links and topic_link_clicks tables. :+1:

Just to check back in, but was that enough of a breadcrumb for you? Did you manage to come up with the query you needed? :crossed_fingers:

Hey Jammy! Yes and no. The following Data Explorer query worked, but unfortunately, the link I want to track is within an event object. The query worked for another link that was in the topic, but not the one I want to see. -- [params] -- topic_id :topic_id SELECT u.username AS "Username", t.title AS "Topic Title", tl.url AS "Clicked URL", tlc.created_at AS reltime$clicked_at FROM topic_link_clicks tlc JOIN topic_links tl ON tlc.topic_link_id = tl.id JOIN users u ON tlc.user_id = u.id JOIN topics t ON tl.topic_id = t.id WHERE tl.topic_id = :topic_id ORDER BY tlc.created_at DESC Or, maybe I’m being optimistic and of the 60 views, no one clicked on the link :sob:

Aah, that’s unfortunate. :frowning: I’m not sure that’s something I’ve tested before. :thinking: Does that particular link get a link counter next to it in the post?

מונה קליקים של קישורי מעקב

קהילה נתונים ודיווח

putty (putty) 9 במאי,‏ 2025,‏ 6:00pm 7

I have since learned that it does not (just tested myself). TIL!

נושא		תגובות	צפיות
Data Explorer query users who clicked specific link Data & reporting sql-query	1	778	25 בספטמבר,‏ 2020
Aggregated click number on forum click counter Feature	6	2823	27 במרץ,‏ 2015
Download tracker plugin Product Support	12	1015	14 באוגוסט,‏ 2023
Most clicked external links? Development	2	683	6 בספטמבר,‏ 2019
How to see exact link of ‘top referred topics’ Data & reporting sql-query , dashboard-reports	5	824	29 בספטמבר,‏ 2023

מונה קליקים של קישורי מעקב

נושאים קשורים