APIs & Integrations

SSmith852
Member

Campaign Email object vs Campaign Email Event

I am reviewing the stats from these 2 tables.  In the Campaign Email table, all email events are summarized by Campaign, i.e 50 bounced emails, 100 sent, 35 clicks, etc.  However, when I look at the details of these events in the Campaign Email Event table and look at the Type field, which has the values of Sent, Bounced, Clicked, etc I get different numbers,  Any one know why that would be?  For example, in the summarized table I will see 6 clicks for a campaign, but in the detail table, I have 13 emails that have clicks associated with them and they all have the same events, Sent, Open, Clicked, Delivered and Processed.  Thanks you!

0 Upvotes
2 Replies 2
Tariqqq
Member

Campaign Email object vs Campaign Email Event


@SSmith852 wrote:

I am reviewing the stats from these 2 tables.  In the Campaign Email table, all email events are summarized by Campaign, i.e 50 bounced emails, 100 sent, 35 clicks, etc.  However, when I look at the details of these actor events in the Campaign Email Event table and look at the Type field, which has the values of Sent, Bounced, Clicked, etc I get different numbers,  Any one know why that would be?  For example, in the summarized table I will see 6 clicks for a campaign, but in the detail table, I have 13 emails that have clicks associated with them and they all have the same events, Sent, Open, Clicked, Delivered and Processed.  Thanks you!


The difference between the Campaign Email summary and the Campaign Email Event details in HubSpot happens because they count things differently. The summary shows unique actions for example, if someone clicks 3 times, it only counts once. But the event table logs every single action, so you might see more clicks there. Also, some email tools or bots can trigger fake clicks that show up in the event table but not in the summary. The summary gives a clean overview, while the event table shows all the details. That's why the numbers don’t always match.

0 Upvotes
SSmith852
Member

Campaign Email object vs Campaign Email Event

Yes, thank you for the reply. What I am looking for is the logic used to get to those unique records from the detail. Any thoughts?
0 Upvotes