Hi @TSeibert,
We can track the link’s open count from reports by using objects like Email Raw Events and Email Log V2.
Let me give you a quick explanation on this
The "Email Raw Events" object pulls raw, unsanitized data directly from Sendgrid, capturing all activity such as opens, clicks, unsubscribes, and bounces. This data is stored as-is, without any deduplication. For instance, if a participant clicks or opens the same link multiple times, each action is recorded as a separate entry. Similarly, if a participant clicks the unsubscribe link, that event is also logged. Due to the lack of deduplication, this object will inherently contain duplicate entries, reflecting each interaction exactly as it occurs. Logistically, it is not ideal to retain old, unsanitized records in this object, as they consume significant table space over time. Therefore, older data may be removed if size constraints become an issue. Due to this limitation, this object is not suitable for historical analysis, and reliance on it for long-term data insights is discouraged. So here you can use the field “Clicked URL” field for the latest clicks and break down.
The "Email Log V2" object is a sanitized version of "Email Raw Events." It maps events from "Email Raw Events" and links them to the appropriate program by applying relevant program details. For instance, if a participant in Program ABC clicks or opens a link 10 times, this object updates the click/open counter to reflect the count of 10 for that participant, rather than creating 10 separate entries. This approach minimizes duplicates and keeps the data organized. Here you can use the “Link Clicked JSON” field to have the break down for each link.