# Tracking Link Click Counters

**URL:** <https://meta.discourse.org/t/tracking-link-click-counters/360474>\
**Category:** Data & reporting\
**Tags:** click-counter\
**Created:** [April 4, 2025, 6:39pm UTC](https://meta.discourse.org/t/tracking-link-click-counters/360474 "2025-04-04T18:39:24Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![putty](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/putty/32/370902_2.png) [@putty](https://meta.discourse.org/u/putty)\
**Post date:** [May 8, 2025, 6:58pm UTC](https://meta.discourse.org/t/tracking-link-click-counters/360474/5 "2025-05-08T18:58:47Z")

</div>

Hey Jammy!  
Yes and no. The following [Data Explorer](https://meta.discourse.org/t/32566?silent=true) 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.

```plaintext
-- [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 😭

---

_[View the full topic](https://meta.discourse.org/t/tracking-link-click-counters/360474)._