Drill-downs for Sequences Open/Click Reporting

glencornell

There's no way to see the contacts that are actually opening, clicking, replying, and booking meetings on sequences. This report is currently only helpful for evaluating the effectiveness of a sequence but it does not allow users to take action from the report, or  understand the full picture of who is interacting with templates within the sequence. 

 

Users need the ability to click the % and see a list of the contacts that have opened or clicked the specific sequence.

 

Sequences___HubSpot.png

HubSpot updates
Status updated to: In Beta
Friday

Happy Friday Community! 

 

Here's an update on our work to improve the reporting capabilities in Sequences and 

 

Sequences data in the custom report builder is now out to all customers with access to Sequences!

We were getting some questions about where the open and click data was in the custom report builder. One important thing to know is that the open and click information is under the Email dataset on the custom report builder. You will need to select 'Sales Email' and filter by the Sequence properties there. Here's a short demo/explanation: https://share.vidyard.com/watch/24fg6yaWcVM3Dsyr23jTrL?

 

I'd also like to share an update on some of the new Analytics features we are adding in Sequences. These updates are still in development, the images show in this clip are just prototpes and not our software (yet!). If you've been following since the last update, you'll notice some changes - as we have now progressed in development and have a more clear picture for what the first iteration will look like: https://share.vidyard.com/watch/7vbK9wZ7b98QmBPSRpBbpe?

Status updated to: In Beta
Apr 9, 2021

We now have the sequences and email data in custom reporting ready and available for beta testing, and will soon roll out to call customers. In the next week we can provide access to folks who request through their point of contact here at HubSpot! This will include the ability to build custom reports using sequences data as well as build reports showing contacts that have clicked or open sequences.

 

There are some more updates we are still planning, which will include a dashboard with visibility into engagements like opens and clicks directly from Sequences. This will be a work in progress for the coming weeks, but I can give a peek as to what we are planning here (please note, that this could change as we go!):

https://www.loom.com/share/5046bd3952d449b495cfc3319e11cdee

Status updated to: In Planning
Mar 29, 2021

Hi Community!

 

Sorry for missing the update 2 weeks back, here's some more news on our progress.

 

Sequences custom reports: In closed beta (internal testing)

Sequences data is now in the custom report builder and we are currently running tests with the data. It should be a matter of days or weeks before this will be available! This data includes the ability to build custom reports using sequences events such as enrolled, replied, step executed, and much more. Along with this data, we will also be providing Email data for opens and clicks, which can be sorted by Sequence enrollment. All of this will be available through the custom report builder, meaning that reports can be built, drilled into, and exported. Here's a video with more information and details on this:

https://www.loom.com/share/d9fe14b768a64c1d97167bf8fe9ff907

 

Sequences contact properties:  In closed beta (backfilling data)

We also have a number of new contact properties that will soon be available to all. We are still backfilling the data here, so once that is done we will be able to begin rolling these properties out to your accounts. These properties are designed to give you more context about sequence enrollments on contact records. These are the first of a number of new properties that we plan to include. The current properties in progress include:

  1. Last sequence enrolled
  2. Last sequence enrolled date
  3. Last sequence ended date
  4. Number of sequences enrolled

Here's a clip sharing what this looks like in my personal portal:

https://www.loom.com/share/38cc4d3318544953b1623a057dd92cca

 

Excited to get this out to you all in the coming days and weeks! 

 

Best,

Glen

Status updated to: In Planning
Feb 28, 2021

Hi Community, 

 

An update from our progress in the last 2 weeks. 

 

We have made great progress in adding sequences data to the new Custom Report Builder in HubSpot. This will allow folks the ability to build custom reports cross-object reports using sequences data. We plan for this update to be ready within the next month.

 

We are making good progress on bringing over open/click/reply/bounce "event" data into Sequences reporting, to make our data in sequences cross-referenceable with the associated Contact objects. Once we have done this, we will be able to make this data interactable, allowing folks to drill down and view the specific contacts

 

With this same data we are developing a 'history log' concept that will serve as a timeline of all relevant "events" that fire for a sequence enrollment. The goal of this history log will be to serve as a timeline of every interaction that has occured during the span of a sequence enrollment. We will be treating this as an experiment to to iterate and improve on how we display sequences data, and I will provide details on how to participate here when that is ready. This will come after the Custom Report Builder is ready.

 

Thanks again for your patience and excitement for these updates, I will post here again as we progress.

 

Best,

Glen

Status updated to: In Planning
Feb 8, 2021

Hi Community! 

 

Thanks for continuing to follow this issue, and I apologize for the time it has taken the last several months. I want to assure you that this continues to be a top priority, and although there have been some setbacks, are continuing to make progress and still plan to provide this functionality in Sequences reports, Lists, Workflows, and custom reports in the reporting dashboard. Due to some internal dependencis across multiple teams, I need to refrain from providing any direct time estimates on this project, but I can assure you all that this is a top priority for Sequences. 

 

Going forward I will be provide updates every 2-3 weeks to keep everyone in the loop and provide information once there are new related features in beta or in production.

 

Thanks,

Glen

Status updated to: In Planning
Oct 27, 2020

Hi Community! 

 

I appreciate all of your patience on this issue as we reviewed and planned in these past couple of months. There are several reporting updates we have planned that will be rolling out in the coming weeks and months, which will impact the following Ideas in the community:

 

We are in the progress of adding sequences to the custom report builder, which will allow users to create custom, sophiticated, "drill-downable" reports for sequences to be added to the dashboard and report library. In order to do this, we have been going through a long process of migrating sequences data to our reporting platform, which will begin to unlock more platform capabilities.

 

We then plan to also follow-up with new Contact properties related to sequences, which should give you the ability to filter contacts based on sequence enrollment, and based on engagements like "opens" and "clicks" within a sequence. We'll next be able to follow with new sequences-specific properties that will be accessible in Lists, Workflows, and Reports!

 

Finally, we plan to make some larger changes to the report that currently exists in the Sequences section of HubSpot. This will likely include updates to the report layout, and when completed will also include the ability to drill down into the contacts that have opened a clicked.

 

We are very excited and eager to work on these updates, and I will follow-up on this and the other ideas forums posts when we have more to share!

 

Best,

Glen

Status updated to: Being Reviewed
Apr 9, 2020

Hey Community! 

 

Thanks for all the feedback, suggestions, and passion around this sequences reporting idea. I wanted to give an update for you all so you have a better idea for where this falls in our planning.

 

We initially proactively created this idea because we believe that all sales metrics, wherever possible, should be accessible for drill-downs. We still believe this, and are still planning un providing better insights here. For that reason, we are planning a broader update to sequences reporting across the board in 2020. Some of these changes will results in new properties available for creating lists and filters, others will allow for new functions in the custom report builder. Within our Sequences user interface, where this specific report lives, we are planning to do some overall restructuring of the reporting section as a whole. With this, we plan to provide more categories/metric, better management of enrollments, including some bulk actions, the ability to drill down into metrics and other types of functions that we still need to evaluate.

 

Unfortunately, in order to improve reporting as a whole in the longer term, we've delayed making this change in the first half of 2020. I will update again here once we are making meaningful progress in reporting updates for sequences.

 

Thank you all for your patience!


Best,

Glen

Mar 24, 2020

Hey Community! 

 

Thanks for all the feedback, suggestions, and passion around this sequences reporting idea. I wanted to give an update for you all so you have a better idea for where this falls in our planning.

 

We initially proactively created this idea because we believe that all sales metrics, wherever possible, should be accessible for drill-downs. We still believe this, and are still planning un providing better insights here. For that reason, we are planning a broader update to sequences reporting across the board in 2020. Some of these changes will results in new properties available for creating lists and filters, others will allow for new functions in the custom report builder. Within our Sequences user interface, where this specific report lives, we are planning to do some overall restructuring of the reporting section as a whole. With this, we plan to provide more categories/metric, better management of enrollments, including some bulk actions, the ability to drill down into metrics and other types of functions that we still need to evaluate.

 

Unfortunately, in order to improve reporting as a whole in the longer term, we've delayed making this change in the first half of 2020. I will update again here once we are making meaningful progress in reporting updates for sequences.

 

Thank you all for your patience!


Best,

Glen

 

 

Status updated to: In Planning
Apr 11, 2019

139 Replies
ksalmon
Participant

THANK YOU! This is great! @glencornell 

glaurain
Contributor

Appreciate the update @glencornell.  Regarding sequences and last enroll date - believe that would be the date when the customer was first enrolled.  It would also be helpful to know when the sequence is ending i.e. 6/15/21, so we can build additional tasks to take when the sequence ends i.e. enroll in another sequence based on level of interaction, phone calls etc.  

 

Also, on a separate but related note... any update on the limit of emails that can be sent as part of a sequence? It's presently set at 5 and I know there's another thread on this - but just thought I would ask since the team is making so much progress. 😀

Gerard

HubSpotMaster
Key Advisor | Platinum Partner

@glencornell  - Great updates! Super excited for the changes coming. One quick questions

 

Will sequences be integrated into the Marketing Attribution? It would be great to be able and see that contact came into our database from the XYZ Marketing event. We then enrolled them in a sequence, a deal gets created and closed and we can see those touch points. 

 

Thanks!

 

JColby9
Member

It blows my mind that this is not straight up baked in.  Other products have this.  Get this ASAP please.  

FlywheelKinetic
Contributor | Partner

@glencornell Looking forward to playing with that!!

Status updated to: In Beta
glencornell
HubSpot Product Team

We now have the sequences and email data in custom reporting ready and available for beta testing, and will soon roll out to call customers. In the next week we can provide access to folks who request through their point of contact here at HubSpot! This will include the ability to build custom reports using sequences data as well as build reports showing contacts that have clicked or open sequences.

 

There are some more updates we are still planning, which will include a dashboard with visibility into engagements like opens and clicks directly from Sequences. This will be a work in progress for the coming weeks, but I can give a peek as to what we are planning here (please note, that this could change as we go!):

https://www.loom.com/share/5046bd3952d449b495cfc3319e11cdee

KHesselmann
Member

Looking really forward to testing it! Sounds amazing 

TinaSimpson
Member

Looking forward to this report being made available!

Justin_Anderson
Member

@glencornell video looks great. Please give us all an update when it's the right time to reach out to our HubSpot rep for the beta!

 

-J

KJaju
Member

This would be awesome! Another request for sequences + tracking.

 

We are trying to figure out how to:

A. Score prospects automatically based on email opens and email clicks.

B. Automatically assign a task to an SDR if a certain score is breached. For example, Call this contact.

 

While signing up, we were told that is is possible under Sales Hub Professional. But we are having a tough time figuring it out. Tried support as well a couple days ago, no help yet.

 

Can you shed some light?

 

Sorry if this is not the right thread for it.

FlywheelKinetic
Contributor | Partner
Sounds like you want to set up a custom scoring property: https://knowledge.hubspot.com/crm-setup/set-up-score-properties-to-qualify-leads

And then set up a workflow to trigger enrollment when that scoring contact property hits X, your rep gets the task.

You will need the more advanced properties from sequences that they are working on in order to set the custom scoring property up to add “points” based on sequence engagement. But it sounds like it’s coming.
marksteinleaf
Member
I noticed that say when a sequence finishes and no one has replied for example you see a status like 'Sequence Ended, No Response'.
 
It would be great to build a workflow off this and push ths contact into a list and maybe into a marketing flow. Is this possible to add to the wish list please?
 
Thanks. 
 
 
HubSpotMaster
Key Advisor | Platinum Partner

@glencornell How do you get access to the Beta? I

TPiotrowski3
Member

Following this as this is great information to track sequences wise!

JColby9
Member

This functionality is incredibly important to help management as well as sales reps review and interact with signals in the reporting area.  

We are rapidly scaling up our Sequence use as an organization and will be expanding the # of users.  Hope to get into the beta as soon as we can.  Thanks!

KJaju
Member

Thank you. I used the workaround suggested here - https://knowledge.hubspot.com/crm-setup/set-up-score-properties-to-qualify-leads

 

This works to a certain extent on increasing the Hubspot Score for sequences. 

* Email open = 5 points.

* Email click = 10 points.

 

And then a workflow that triggers an automatic task if score crosses say 5 points.

 

However, this is not ideal by any stretch of the imagination.

 

Is there any way to take into account the number of emails that were opened? Or the number of links that were clicked? Currently cannot seem to figure that out. That would be a lot more potent for our process.

CLY
Member

For such a robust platform, I'm shocked HubSpot does not have this capability. This makes the sales process even more limited, and another reason why potential clients will want to move away from such an expensive platform to something cheaper with the functions they already need. For example, Klenty is only $30 and provides the same automation features AND the ability to drill down into who clicked what, who opened, who replied, etc. in an easy-to-view format. 

I hope HubSpot can release a similar feature ASAP.

 

YiRui_Chua
HubSpot Employee

Hi team,

Commenting for a customer here.

Not sure if I missed anything, but when I look at the BETA feature within reports, I am not seeing "Email Opens".

One of the request over here is that we want to see a drop down list of contacts who have opened the email. Under sequence filters, we do have a bunch of filters but most are related to only enrollment/ replies.

Wondering if we can include this in the official product launch? Thanks!

Status updated to: In Beta
glencornell
HubSpot Product Team

Happy Friday Community! 

 

Here's an update on our work to improve the reporting capabilities in Sequences and 

 

Sequences data in the custom report builder is now out to all customers with access to Sequences!

We were getting some questions about where the open and click data was in the custom report builder. One important thing to know is that the open and click information is under the Email dataset on the custom report builder. You will need to select 'Sales Email' and filter by the Sequence properties there. Here's a short demo/explanation: https://share.vidyard.com/watch/24fg6yaWcVM3Dsyr23jTrL?

 

I'd also like to share an update on some of the new Analytics features we are adding in Sequences. These updates are still in development, the images show in this clip are just prototpes and not our software (yet!). If you've been following since the last update, you'll notice some changes - as we have now progressed in development and have a more clear picture for what the first iteration will look like: https://share.vidyard.com/watch/7vbK9wZ7b98QmBPSRpBbpe?