Dashboards & Reporting

TThomas0
Participant

Create a sequence enrollment status report

SOLVE

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.

0 Upvotes
1 Accepted solution
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Create a sequence enrollment status report

SOLVE

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

 

What exactly are you referring with 'sequence status'?

 

Best regards

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

View solution in original post

0 Upvotes
3 Replies 3
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Create a sequence enrollment status report

SOLVE

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

 

What exactly are you referring with 'sequence status'?

 

Best regards

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

0 Upvotes
TThomas0
Participant

Create a sequence enrollment status report

SOLVE

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

 

 

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

Stacked Display.png

 

 

0 Upvotes
karstenkoehler
Hall of Famer | Partner
Hall of Famer | Partner

Create a sequence enrollment status report

SOLVE

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

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

0 Upvotes