Events results showing up wrong

[FlorentMathieu]

Hi,

We have an app to extract data from marketing e-mails in order to draw stats automatically after each campaign. I'm using the events API in a script to get all of the events I can read from a certain marketing e-mail (using the campaignIds I can find in the "details" section of the marketing e-mail). I use calls like this one : https://api.hubapi.com/email/public/v1/events/?hapikey=XXX&campaignId=79033709  (with successive offsets until I get to the end of the events list).

Everything was working fine before this e-mail, a few discrepancies between these results and the ones on the marketing e-mail page but no big deal. For this particular e-mail (https://app.hubspot.com/email/4247174/details/20076743930/performance for devs who could see that), we sent e-mails to 1000+ persons. From campaignId number 79033709, I'm seeing zero "sent" or "delivered" events, and only 103 opened e-mails and 28 clicks. If I'm counting "filteredEvents" (I understood that I should not), I see 142 "sent" e-mails, 143 "delivered", 103 "open" and 392 "click" (but I can see they're from places that are not coherent with our targets).

This is pretty much the same for all campaignIds of the same e-mail, but I should have an overall opening rate of 10% and 5 clicks total (amongst 1000+ sent e-mails) according to the marketing e-mail webpage. Is there something I missed ?

Thanks in advance,

Florent

[WendyGoh · Accepted solution]

Hi @FlorentMathieu,

When I attempt to grab only eventType=SENT for campaign 79033709 with the following endpoint:

https://api.hubspot.com/email/public/v1/events?hapikey={{hapikey}}&campaignId=79033709&limit=100&eventType=SENT

I'm able to see that it returns a list of email events log with the eventType = SENT - is that how you're calculating the SENT number? If so, I'm not seeing zero SENT.

Likewise for DELIVERED eventType; if I use &eventType=DELIVERED, I'm seeing a list of email events log.

Would you mind elaborating further how you're seeing zero sent or delivered? 

[FlorentMathieu]

Hi,

thank you for your help, I actually discovered through this technique a lot of messages that I was filtering. I was using a test on the "filteredEvent" property, which actually does not always exist. I noticed the same thing about the "status" property. I'm good now, I'll close this 🙂

Thanks again,

Florent