# Create a sequence enrollment status report

**URL:** <https://community.hubspot.com/t/create-a-sequence-enrollment-status-report/114018>\
**Category:** Dashboards & Reporting\
**Tags:** reports, sequences, marketing, enterprise\
**Created:** [August 7, 2024, 10:00pm UTC](https://community.hubspot.com/t/create-a-sequence-enrollment-status-report/114018 "2024-08-07T22:00:44Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![TThomas0](https://avatars.discourse-cdn.com/v4/letter/t/a88e57/32.png) [@TThomas0](https://community.hubspot.com/u/TThomas0)\
**Post date:** [August 7, 2024, 10:00pm UTC](https://community.hubspot.com/t/create-a-sequence-enrollment-status-report/114018/1 "2024-08-07T22:00:44Z")

</div>

Hello,

I wanted to know if it’s possible to create a sequence enrollment status report to view the total number of MQL contacts who have been in a sequence this year (monthly view). I would also like to know if I can stack the sequence statuses by month.

---

<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:** [August 8, 2024, 4:14am UTC](https://community.hubspot.com/t/create-a-sequence-enrollment-status-report/114018/2 "2024-08-08T04:14:40Z")

</div>

Hi @TThomas0,

Yes, this can be done with the custom report builder: Menu \> Reporting \> Reports \> Create report \> Custom Report Builder \> Choose my own data sources \> Contacts (primary data source) + Sequences

You can then filter the report by ‘Date entered “Marketing Qualified Lead” is between A and B’ and specify the date range.

You would then visualize:

- Enrollments in sequence \> Enrolled at
- Count of contacts

 ![karstenkoehler_0-1723090407458.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/d/5/d5355f4a9c823b36b756293d70e4a45b5fff7474.png)

What exactly are you referring with ‘sequence status’?

Best regards

---

<div class="post-metadata">

**Author:** ![TThomas0](https://avatars.discourse-cdn.com/v4/letter/t/a88e57/32.png) [@TThomas0](https://community.hubspot.com/u/TThomas0)\
**Post date:** [August 8, 2024, 1:27pm UTC](https://community.hubspot.com/t/create-a-sequence-enrollment-status-report/114018/3 "2024-08-08T13:27:09Z")

</div>

Thanks so much for the quick response.

There is a sequence filter that allows you to see the sequence status of a contact. (see screenshot)

 ![Sequence Status.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/c/7/c7a7a4178554df0b8ad1b696c8b2b9ac20ee1445.png)

Ideally, I would like to show (stack) their sequence status within their enrollment month.

 ![Stacked Display.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/e/b/eb036b6c0cf9385afd052ba3ddb42149ea2c8a22.png)

---

<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:** [August 8, 2024, 1:33pm UTC](https://community.hubspot.com/t/create-a-sequence-enrollment-status-report/114018/4 "2024-08-08T13:33:35Z")

</div>

@TThomas0 this is not possible within the report builder, unfortunately. What I proposed in my previous reply is the best approximation.