# HubSpot Open rates not matching API data

**URL:** <https://community.hubspot.com/t/hubspot-open-rates-not-matching-api-data/68058>\
**Category:** APIs & Integrations\
**Created:** [October 27, 2022, 6:13pm UTC](https://community.hubspot.com/t/hubspot-open-rates-not-matching-api-data/68058 "2022-10-27T18:13:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![SimonP1](https://avatars.discourse-cdn.com/v4/letter/s/58956e/32.png) [@SimonP1](https://community.hubspot.com/u/SimonP1)\
**Post date:** [October 27, 2022, 6:13pm UTC](https://community.hubspot.com/t/hubspot-open-rates-not-matching-api-data/68058/1 "2022-10-27T18:13:57Z")

</div>

We have been analyzing our HubSpot Open Rates and individual open confirmation for marketing emails and seeing discrepancies between what is reported through the HubSpot UI and what is visible when analyzing the raw API data which we are importing into an external reporting tool through Fivetran. For example, a recent email showed 801 contacts opening an email one or more times when viewed at the API level, but these same contacts were labeled as Sent/Delivered, but not opened in HubSpot. Has anyone seen similar and identified root cause?

---

<div class="post-metadata">

**Author:** ![kvlschaefer](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/kvlschaefer/32/71076_2.png) [@kvlschaefer](https://community.hubspot.com/u/kvlschaefer)\
**Post date:** [October 28, 2022, 11:57am UTC](https://community.hubspot.com/t/hubspot-open-rates-not-matching-api-data/68058/2 "2022-10-28T11:57:40Z")

</div>

Hi @SimonP1,

Thank you for reaching out!

I wanted to share a [related thread](https://community.hubspot.com/t5/APIs-Integrations/Hubspot-Contact-Activity-screen-Email-Clicks-not-matching-API/td-p/500375) where @CTo shares some ways to test this discrepancy out by adding either “excludefilteredEvent is true” filter to your request or &excludeFilteredEvents=true&obsoletedBy=NULL.

It sounds like the discrepancy they were running into was due to bot filtering.

I would recommend seeing if you could filter out potential bot activity. If you are still seeing a discrepancy after that, I would recommend connecting with [HubSpot Technical Support](http://help.hubspot.com/), as Support is included in your subscription and they will be able to provide real-time assistance for this matter, where you are able to share examples of this discrepancy.

Best,

Kristen

---

<div class="post-metadata">

**Author:** ![SimonP1](https://avatars.discourse-cdn.com/v4/letter/s/58956e/32.png) [@SimonP1](https://community.hubspot.com/u/SimonP1)\
**Post date:** [October 31, 2022, 11:13pm UTC](https://community.hubspot.com/t/hubspot-open-rates-not-matching-api-data/68058/3 "2022-10-31T23:13:34Z")

</div>

Thanks Kristen, I will try this and post back. I did contact HubSpot Tech Support and they did confirm that the opens I was seeing were not labeled as bot activity so I am still not sure why I am seeing the discrepancy.