# Export Activities data for email opens and clicks

**URL:** <https://community.hubspot.com/t/export-activities-data-for-email-opens-and-clicks/113511>\
**Category:** Reporting & Analytics\
**Tags:** contacts\
**Created:** [August 1, 2024, 5:58pm UTC](https://community.hubspot.com/t/export-activities-data-for-email-opens-and-clicks/113511 "2024-08-01T17:58:25Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![DCombs](https://avatars.discourse-cdn.com/v4/letter/d/51bf81/32.png) [@DCombs](https://community.hubspot.com/u/DCombs)\
**Post date:** [August 1, 2024, 5:58pm UTC](https://community.hubspot.com/t/export-activities-data-for-email-opens-and-clicks/113511/1 "2024-08-01T17:58:25Z")

</div>

Hi HubSpot Community!

Is it possible to export a Contact’s fully Activity list? Using the Report Builder with Activities as the data source, we cannot see key activies like “{{Contact}} opened {{email name}}”, “{{Contact}} clicked {{CTA name}}”.

I can see all that data clearly on the Contact’s record under the Activity feed (see screenshot below). It would be really helpful to be able to report on this, though (e.g., export all the contacts from a recent sequence and see who clicked on what to understand which CTAs are most effective).

Anywhere aware of a way to do this?

 ![DCombs_0-1722534986707.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/0/6/0639905c112c44640cedc5e59a6e6f0793607194.png)

CC: @briannealvarez

---

<div class="post-metadata">

**Author:** ![colinwitt](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/colinwitt/32/67676_2.png) [@colinwitt](https://community.hubspot.com/u/colinwitt)\
**Post date:** [August 2, 2024, 11:25am UTC](https://community.hubspot.com/t/export-activities-data-for-email-opens-and-clicks/113511/2 "2024-08-02T11:25:27Z")

</div>

Hi @DCombs,

I’m not sure what you already tried in the Custom Report Builder, but you should be able to get (at least some) of the data you mentioned. In the Custom Report Builder you can pick CTAs, Marketing E-Mails, Marketing E-Mail Activities etc. as the Data Source.  
If you have exhausted that option, you could look into Lists and filter specific activities, although it might be a lot of work to combine this data into something usable.  
Another option would be to look into the API to export activity data - this would require some technical knowledge though.

Best regards  
Colin

---

<div class="post-metadata">

**Author:** ![DCombs](https://avatars.discourse-cdn.com/v4/letter/d/51bf81/32.png) [@DCombs](https://community.hubspot.com/u/DCombs)\
**Post date:** [August 2, 2024, 4:04pm UTC](https://community.hubspot.com/t/export-activities-data-for-email-opens-and-clicks/113511/3 "2024-08-02T16:04:42Z")

</div>

This is super helpful Colin! Unfortunately the senders for these sequences are within Sales (outside the Marketing function), and it seems like the data for CTAs, Marketing Emails, etc. are only picking up “true” Marketing activity. That said, I’ll continue to play around with these options, and your response is definitely helpful to pointing us in the right direction, so I will accept it as the answer!

Thanks again!

Dan

---

<div class="post-metadata">

**Author:** ![AakashKodale](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/aakashkodale/32/87027_2.png) [@AakashKodale](https://community.hubspot.com/u/AakashKodale)\
**Post date:** [July 31, 2025, 4:06pm UTC](https://community.hubspot.com/t/export-activities-data-for-email-opens-and-clicks/113511/4 "2025-07-31T16:06:22Z")

</div>

I’ve faced the **same issue** as well, but unfortunately, I still haven’t found a proper solution.

I genuinely believe that **HubSpot should improve its email marketing reporting features** , especially to help users track performance and take more data-driven actions.

_ **I’ve submitted an idea regarding this** _  
Here’s the link:[https://community.hubspot.com/t5/Email-Marketing-Tool/Feature-Suggestion-Smart-List-Filtering-Based-on-Email-Sender/td-p/1177025](https://community.hubspot.com/t5/Email-Marketing-Tool/Feature-Suggestion-Smart-List-Filtering-Based-on-Email-Sender/td-p/1177025)  
It would mean a lot if you could **upvote** and **leave a comment** to support it. Thank you!

---

<div class="post-metadata">

**Author:** ![DCombs](https://avatars.discourse-cdn.com/v4/letter/d/51bf81/32.png) [@DCombs](https://community.hubspot.com/u/DCombs)\
**Post date:** [August 2, 2024, 5:59pm UTC](https://community.hubspot.com/t/export-activities-data-for-email-opens-and-clicks/113511/5 "2024-08-02T17:59:57Z")

</div>

Just noting that there now appears to be a way to address this data request using Sales Email (+ Contacts) as the data sources in the report builder!