Email Total Opens via API

Marketing & Content Email Marketing Tool
1

Can you please advise which fileds should be selected to get all total Opens for an email campaign to match the total as shown on the Hubspot website. Currently we match on the majority of campaigns but there are a few campaigns where we are pulling in more Total Opens that shown on the Hubspot web page.

2

@boywonder can you clarify what you mean about “match the total shown on the HubSpot website” please? A screenshot may help.

I’ll share that open rates simply aren’t the most reliable metric. It’s a place to start, but I’d look at other rates like overall clicks or other conversions. You can see details in this resource from HubSpot on email tracking, but the definition of “open” varies from email client to email client. It’s unlikely that it will ever be the exact same number acorss tools even in the same software.

3

Hi Dan,

Thanks for coming back ..

As an example .. in the below screen shot there are 2090 opens (from the hubspot email dashboard) whereas when we pull the opens through via the API there are 2116. We have tried to apply various filters based on all the fields we get back but cant match the 2090. In nealry all campaigns we match opens so we are curious to see if any additioanl filters could be applied or if there is a specific formula got generate opens in Hub spot

hubspotExample.png
hubspotExample.png387×290 21.6 KB

4

@boywonder thanks for the conext. I don’t mean to come off as dense or dismissive here. I’m wondering “why” though. It’s a difference of about 1% between the two reports, and open rates have become far less reliable than they once were. If it were me, I’d benchmark where we are with numbers and see if they correspond as we move forward. For instance, as long as the open rates (along with more meaningful metrics) are going “up and to the right” at about the same rate, then that 1% difference becomes less of an obstacle and more of an anomaly.

Not to argue, as maybe someone else has an idea to get the two reports to match. I’m just not convinced you will, so I’d be looking for a different metric upon which I measure my success.

Just my two cents. Good luck with the solution in the meantime! I hope someone has a different perspective.