# Drill-downs for Sequences Open/Click Reporting

**URL:** <https://community.hubspot.com/t/drill-downs-for-sequences-open-click-reporting/13958>\
**Category:** HubSpot Ideas\
**Tags:** reports, sequences\
**Created:** [April 11, 2019, 1:24pm UTC](https://community.hubspot.com/t/drill-downs-for-sequences-open-click-reporting/13958 "2019-04-11T13:24:51Z")\
**Posts on this page:** 1\
**Showing post:** 58

<div class="post-metadata">

**Author:** ![2chars](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/2chars/32/18130_2.png) [@2chars](https://community.hubspot.com/u/2chars)\
**Post date:** [September 2, 2020, 5:57pm UTC](https://community.hubspot.com/t/drill-downs-for-sequences-open-click-reporting/13958/58 "2020-09-02T17:57:14Z")

</div>

**Workaround - Track / Drill Down Into Sequence Opens and Clicks**

1 - [Create a property](https://knowledge.hubspot.com/crm-setup/manage-your-properties#create-custom%20properties) called Import List

2 - [Bulk edit](https://knowledge.hubspot.com/crm-setup/how-can-i-bulk-edit-contacts-companies-deals-or-tasks) all the contacts in a single sequence (e.g. from Contacts → Lists → the list containing all contacts in a given sequence)

3 - Create an [Active List](https://knowledge.hubspot.com/lists/create-active-or-static-lists)

4a - For Opens: apply filters “Recent sales email open date is after” (after \<day before date your sequence started\>) and “Import List is equal to any of” \<Name Of Your Import List\>

4b - For Clicks: apply filters “Recent sales emails clicked date” (after \<day before date your sequence started\>) and “Import List is equal to any of” \<Name Of Your Import List\>

Want to exclude those who have unsubscribed? Add a filter for “Now in Sequence” (which is a default Contact property).

Limitation: If someone enrolled in a sequence opens (or clicks a link in) a different 1:1 tracked email (“sales email”) from you, they would be captured as well; if you aren’t sending emails to the relevant contacts outside of the sequence in question, this shouldn’t be an issue.

 ![31073i5A03DE31B5CEEC15.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/d/d0151802aa9c84b2d3dbd020889feeb1627713a3.png)  
HubSpot - Track Sequence Opens and Clicks Workaround

---

_[View the full topic](https://community.hubspot.com/t/drill-downs-for-sequences-open-click-reporting/13958)._