# Custom report using 2 activity data sources

**URL:** <https://community.hubspot.com/t/custom-report-using-2-activity-data-sources/125889>\
**Category:** Dashboards & Reporting\
**Tags:** analytics-tools, dashboards\
**Created:** [February 11, 2025, 8:00pm UTC](https://community.hubspot.com/t/custom-report-using-2-activity-data-sources/125889 "2025-02-11T20:00:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![DarrenScottUK](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/darrenscottuk/32/30770_2.png) [@DarrenScottUK](https://community.hubspot.com/u/DarrenScottUK)\
**Post date:** [February 11, 2025, 8:00pm UTC](https://community.hubspot.com/t/custom-report-using-2-activity-data-sources/125889/1 "2025-02-11T20:00:41Z")

</div>

hi, we would like to build a custom report which shows activity from our sales team they have logged only for contacts who have opened a particular marketing email from us. We want to quantify the level of engagements this email has triggered but the custom report wont let us combine activies & m,arketing emails together. We have to take this into excel to do it manually. THis feels like this should be a basic report within a CRM. ANy ideas or is this just not currently possible?

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [February 11, 2025, 8:04pm UTC](https://community.hubspot.com/t/custom-report-using-2-activity-data-sources/125889/2 "2025-02-11T20:04:35Z")

</div>

Hi @DarrenScottUK,

There is a simple workaround here: create an active list du f contacts who opened your marketing email, then create a report with data sources contacts and activities. The contact object allows you to filter on list membership of those contacts.

The marketing email data sources are meant for other reporting use cases, I agree that this should be made more clear in descriptions and examples.

Best regards

---

<div class="post-metadata">

**Author:** ![DarrenScottUK](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/darrenscottuk/32/30770_2.png) [@DarrenScottUK](https://community.hubspot.com/u/DarrenScottUK)\
**Post date:** [February 11, 2025, 8:40pm UTC](https://community.hubspot.com/t/custom-report-using-2-activity-data-sources/125889/3 "2025-02-11T20:40:03Z")

</div>

ah of course, don’t know why i didnt think of that initially 😄 thanks @karstenkoehler