Hello everyone,

I’m working on building a JO report that answers three key questions:

1. Which emails were sent?

2. Who received each email?

3. Which links (including mailto:xxx@xxx.com) were clicked—and when?

Here’s what I’ve done so far:

• I’ve added trackable tokens to every link in my email templates, including mailto: addresses

• I’m successfully reporting on email sends and recipients 

Where I’m currently stuck:

• I believe Email Raw Events stores some of the click data, but I can only find actual hyperlinks—not mailto: links or token-level identifiers

• I’d like to build a report that shows:

  • The contact who clicked

  • The specific link/token they clicked

  • The timestamp of the click

Has anyone managed to report on this level of detail?
If you’ve built something similar—or have any tips, best practices, or object relationships I should be using—I'd really appreciate your input!

Thanks so much in advance!