Dashboards & Reporting

Tom_B
Participant

Recreate Sequence Reports

SOLVE

Hello all,

 

I'd like to recreate the default Reports, although I just checked via Chat with a HubSpot Representative that it's not possible at this time to simply duplicate and customise these.

 

Does anybody have any idea (preferably screenshots or recordings) on how I can recreate the following reports:

 

  1. Sequence sender score
  2. Sequence enrollment totals and engagement rates
  3. Sequence enrolls, opens, and clicks by month
  4. Activity feed timeline

 

Much appreciated for any assistance!

 

1 Accepted solution
HubSpot_Corey
Solution
Top Contributor

Recreate Sequence Reports

SOLVE

Hi @Tom_B  and thanks for the tag @PamCotton 

 

There are a few alternative solutions available, though they might vary depending on your HubSpot subscription level. I’ll focus on the options that are generally accessible to everyone.

 

Sequence Sender Score:

To attempt to recreate this report, you'll need to select custom report as the single report option does not support the necessary fields. You don’t need to select multiple datasets here; simply choose “Sequences.” However, there are some caveats. Firstly, the sender score rating field can’t be exactly replicated without access to Report based custom formula functions, which are available with the HubSpot Operations Hub. Secondly, you can only report metrics like “Sequence endings, no response,” “Contact bounces,” and “Replies from sequence” individually. My suggestion is to create a separate report for each metric and then arrange them side by side on a dashboard to recreate the sequence sender score report.

 

Sequence enrolment totals and engagement rates

This report also requires custom reporting. By selecting the fields as shown in the accompanying image, you can closely replicate the report by obtaining the total numbers for each field.

HubSpot_Corey_0-1713146443236.png

 

However, If you have access to formula fields, currently in [BETA] as depicted below, you can calculate engagement percentages using the following formulas:

HubSpot_Corey_1-1713146443236.png

 

Percentage of Opens  = [SEQUENCE.hs_enrollment_count] / [SEQUENCE.hs_enrollment_count]

Percentage of Clicks = [SEQUENCE.hs_enrollment_count] / [SEQUENCE.hs_click_count]

Percentage of Replies = [SEQUENCE.hs_enrollment_count] / [ [SEQUENCE.hs_reply_count]

Percentage of Meetings Booked = [SEQUENCE.hs_enrollment_count] / SEQUENCE.hs_meeting_booked_count]

Percentage of Unsubscribes = [SEQUENCE.hs_enrollment_count] / SEQUENCE.hs_unsubscribed_count

This will be done as shown below:

HubSpot_Corey_2-1713146443237.png

 

These calculations will yield decimal values. To convert these into percentages, simply create the fields, then click on the pen icon and change the format to 'percentage'.

HubSpot_Corey_3-1713146443240.png

 

Sequence enrolls, opens, and clicks by month:

Same as above but add a filter using a date range to limit the data to the timeframe you wish.

 

Activity feed timeline
This table is unable to be recreated to my knowledge without the use of external tools or coding.

If you need any further help or assistance, please just let me know.

View solution in original post

5 Replies 5
ASU
Participant

Recreate Sequence Reports

SOLVE

Voting for this as well, as it would be helpful. 

0 Upvotes
PamCotton
Community Manager
Community Manager

Recreate Sequence Reports

SOLVE

Hey @Tom_B thank you for reaching out to our Community!

 

 

While duplicating and customizing them directly may not be an option currently, there are alternative ways to achieve similar insights, for example, utilizing HubSpot's reporting tools to create custom reports that track sequence enrollments and engagement rates. You can segment data by sequence name, date range, and other relevant criteria to get a comprehensive view of performance.

 

To our top experts, @danmoyle, @HubSpot_Corey any recommendations for @Tom_B matter?

 

Thank you,

Pam

Você sabia que a Comunidade está disponível em outros idiomas?
Participe de conversas regionais, alterando suas configurações de idioma !


Did you know that the Community is available in other languages?
Join regional conversations by changing your language settings !




HubSpot_Corey
Solution
Top Contributor

Recreate Sequence Reports

SOLVE

Hi @Tom_B  and thanks for the tag @PamCotton 

 

There are a few alternative solutions available, though they might vary depending on your HubSpot subscription level. I’ll focus on the options that are generally accessible to everyone.

 

Sequence Sender Score:

To attempt to recreate this report, you'll need to select custom report as the single report option does not support the necessary fields. You don’t need to select multiple datasets here; simply choose “Sequences.” However, there are some caveats. Firstly, the sender score rating field can’t be exactly replicated without access to Report based custom formula functions, which are available with the HubSpot Operations Hub. Secondly, you can only report metrics like “Sequence endings, no response,” “Contact bounces,” and “Replies from sequence” individually. My suggestion is to create a separate report for each metric and then arrange them side by side on a dashboard to recreate the sequence sender score report.

 

Sequence enrolment totals and engagement rates

This report also requires custom reporting. By selecting the fields as shown in the accompanying image, you can closely replicate the report by obtaining the total numbers for each field.

HubSpot_Corey_0-1713146443236.png

 

However, If you have access to formula fields, currently in [BETA] as depicted below, you can calculate engagement percentages using the following formulas:

HubSpot_Corey_1-1713146443236.png

 

Percentage of Opens  = [SEQUENCE.hs_enrollment_count] / [SEQUENCE.hs_enrollment_count]

Percentage of Clicks = [SEQUENCE.hs_enrollment_count] / [SEQUENCE.hs_click_count]

Percentage of Replies = [SEQUENCE.hs_enrollment_count] / [ [SEQUENCE.hs_reply_count]

Percentage of Meetings Booked = [SEQUENCE.hs_enrollment_count] / SEQUENCE.hs_meeting_booked_count]

Percentage of Unsubscribes = [SEQUENCE.hs_enrollment_count] / SEQUENCE.hs_unsubscribed_count

This will be done as shown below:

HubSpot_Corey_2-1713146443237.png

 

These calculations will yield decimal values. To convert these into percentages, simply create the fields, then click on the pen icon and change the format to 'percentage'.

HubSpot_Corey_3-1713146443240.png

 

Sequence enrolls, opens, and clicks by month:

Same as above but add a filter using a date range to limit the data to the timeframe you wish.

 

Activity feed timeline
This table is unable to be recreated to my knowledge without the use of external tools or coding.

If you need any further help or assistance, please just let me know.

danmoyle
Most Valuable Member | Elite Partner
Most Valuable Member | Elite Partner

Recreate Sequence Reports

SOLVE

Thanks for the tag @PamCotton - +1 for the resources and screenshots from @HubSpot_Corey here. Nothing more I can add. Hope it worked out, @Tom_B.

 

Did my answer help? Please "mark as a solution" to help others find answers. Plus I really appreciate it!


Dan Moyle

HubSpot Advisor

LearningOps | Impulse Creative

emailAddress
dan@impulsecreative.com
website
https://impulsecreative.com/
Tom_B
Participant

Recreate Sequence Reports

SOLVE

Hi @PamCotton and @HubSpot_Corey,

 

Thank you for responding to the post. I'm going to give it a shot to see if I can get this to work and I'll get back you after.

 

Kind regards,

Tom