# Create List based on Sequence Activity

**URL:** <https://community.hubspot.com/t/create-list-based-on-sequence-activity/54921>\
**Category:** Sales Email\
**Tags:** sequences, lists\
**Created:** [April 13, 2022, 1:34pm UTC](https://community.hubspot.com/t/create-list-based-on-sequence-activity/54921 "2022-04-13T13:34:21Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ZHerman](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/zherman/32/93635_2.png) [@ZHerman](https://community.hubspot.com/u/ZHerman)\
**Post date:** [April 13, 2022, 1:34pm UTC](https://community.hubspot.com/t/create-list-based-on-sequence-activity/54921/1 "2022-04-13T13:34:21Z")

</div>

Good Morning!

I am loving the sequence functionality and am looking to take it a step further. I am trying to create a list of contacts based on their activity taken in the sequence. My sequence consists of 3 emails, and if the contacts have clicked on anything in any of the three emails, I want them to be added to a list. Same goes for the contacts that have not clicked on anything in the three emails.

Any ideas?

---

<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:** [April 13, 2022, 1:41pm UTC](https://community.hubspot.com/t/create-list-based-on-sequence-activity/54921/2 "2022-04-13T13:41:35Z")

</div>

Hi @ZHerman,

The two properties you want to use for your list are:

- _Recent sales email clicked date_ (Sales Hub Professional and Enterprise only): the date of the last time that the contact clicked on a sales email.
- _Last sequence enrolled_: the unique ID of the last sequence that the contact was enrolled in.

As you can see, a Sales Hub Professional subscription is needed to create this list. Without this subscription, this cannot be done.

It’s also not possible to specify that the sales click originated from the sequence. It might have been any sales email.

Your first list would filter for contacts where “Last sequence enrolled is equal to any of [SEQUENCE\_ID]” and “Recent sales email clicked date is known”. Your second list would look the same except “Recent sales email clicked date is unknown.”

To find your sequence ID, navigate to _Menu_ \> _Automation_ \> _Sequences_ \> _Manage_. Click on the sequence and copy the numbers from the end of the URL: [https://app.hubspot.com/sequences/PORTAL\_ID/sequence/SEQUENCE\_ID](https://app.hubspot.com/sequences/PORTAL_ID/sequence/SEQUENCE_ID)

Let me know if you have any follow-up questions!

---

<div class="post-metadata">

**Author:** ![CKnight2004](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/cknight2004/32/35608_2.png) [@CKnight2004](https://community.hubspot.com/u/CKnight2004)\
**Post date:** [March 22, 2023, 12:40pm UTC](https://community.hubspot.com/t/create-list-based-on-sequence-activity/54921/3 "2023-03-22T12:40:00Z")

</div>

Just came on to the community to ask this exact question. Thank you for the clear reply and explanation. Hopefully more functionality to action outputs from sequences is coming as built in functionality, as this is a bit clunky. Works for now though!

---

<div class="post-metadata">

**Author:** ![ZHerman](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/zherman/32/93635_2.png) [@ZHerman](https://community.hubspot.com/u/ZHerman)\
**Post date:** [April 13, 2022, 6:52pm UTC](https://community.hubspot.com/t/create-list-based-on-sequence-activity/54921/4 "2022-04-13T18:52:26Z")

</div>

Thank you so much Karsten! I believe this is EXACTLY what I was looking for.

Appreciate the help!