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
2 weeks ago

Hi Community! 

 

I wanted to share another update on some of our progress and developments in improving the ability to find view contacts that are engaging with sequence emails through things like opens and clicks. This update is not in Beta, but will be soon! I know it's a little confusing due to the status of this Idea being "In beta" - this is because there are multiple features involved with the idea!

 

We will be adding some new reports in sequences, on a new Overview tab, with metrics that can all be drilled down into for more information. See this screenshare with details: https://www.loom.com/share/60d9298c868740c3b3903cf33dc4b20e

 

I will update here once this is in beta and available! We expect another couple of weeks before we'll have this ready. 

 

IMAGE BELOW IS NOT IN BETA YET, BUT WILL BE SOON:

Sequences_overview.jpg

Status updated to: In Beta
May 7, 2021

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

144 Replies
Leadstreet-M
Participant | Diamond Partner

Hi,

 

can you provide an update on this?

 

Thank you.

 

 

natedame
Participant

Yes, absolutely needed... Also need this click activity to be able to trigger workflows etc.

DataCollector
Member

Hubspot please provide this reporting.  You already have the reporting solution within the Workflows emailing system. 

 

Show me who opened a sequence and how many times they opened.  Or make it available within contact filtering.  or add Open as a status in sequence reporting. 

 

 

 

Austgen123
Member

Hello,

 

This is more in response to your April 2020 post explaining the revamp that is coming to sequence reporting.

 

In addition for the sequence reporting to become more granular (which is amazing and much, much needed), it would be great if an API was created for sequence data. We use an external company to pull Hubspot data for reporting purposes and the lack of availability in sequence data entirely is extremely frustrating and has caused us to explore other CRM options. 

 

The data is there - I can click into any contact that is enrolled in a sequence and see the sequence email activity, so why would users now be able to extract this data? Hubspot has multiple APIs for contact data, but none for contact activity data - not sure why not.

 

Hoping this is done sooner rather than later before my team becomes unwilling to compromise with mediocre reporting and urges us to make a switch to a new CRM.

sleitz
Participant

It's pretty crazy that the reports for sequences allow you to see your click and open rates, but not actually dive into WHO clicked and opened it. Since these are a sales tool, the sales team needs to know who is actually engaging with their emails, not those that reply to them. 

Envizi
Member

Hi development team,

 

It would be so much more helpful if you can add more functions to the sequence report page where we can either filter by status or click on every email in the sequence to see how many contacts and who opened emails and clicked the links. 

finn
Top Contributor

@glencornell Ay news?

DavidBurnett
Member

This has to be put in place.  If not I don't see much point to sending out emails to prospects this way.

danaeciousv
Member

We're officially well into the 2nd half of 2020. Where does this project stand to date?

vn
Participant

Any update on this? We were looking to move a bunch of BDRs using a different tool to Hubspot sales pro and in a pilot stage.. I really am at a loss to sell this if there is no way to find who clicked or opened!! Can we at least know when this will be done?

superjeep7
Member

Seriously this is a year and a half old suggestion!  Surely this is a priority for HubSpot.  The absence of being able to see number of opens and clicks in a reportable way, or sorting by greater than/less than opens/clicks is a basic function of any sales process!  Please help us!

Mudia
Member

This functionality would be an absolute lifesaver as a sales organization. Are we still set to have it completed sometime in 2020?

brotelli
Participant

It has been radio silence from HubSpot since April 9th. This topic is continually growing as people attempt to use your tools and realize that the functionality that would appear as if it was standard does not even exist. As sales organizations, we rely on data to help us target the best leads and this just renders much of sequences useless. We need to know who is clicking on what and not monitoring every alert to find out, drill-down reporting is what is needed. Is anyone from Hubspot actually monitoring these forums?

sfinnerty
Member

Couldn't agree more, as a sales person or marketer the main thing we need to see is who opened our emails, and we want to be able to do this in each particular sequence as each sequence is unique and targeted, it's too general running a search on 'Currently in sequence' or 'Recent sales emails clicked'.

I want to be able to click the "open rate" and see who engaged and is worth following up with.

It's crucial information and something I would have expected Hubspot to already have, I'm quite surprised it doesn't.

2chars
Contributor

Workaround - Track / Drill Down Into Sequence Opens and Clicks

 

1 - Create a property called Import List

2 - Bulk edit all the contacts in a single sequence (e.g. from Contacts -> Lists -> the list containing all contacts in a given sequence)

3 - Create an Active List

4a - For Opens: apply filters "Recent sales email open date is after" (after <day before date your sequence started>) and "Import List is equal to any of" <Name Of Your Import List>

4b - For Clicks: apply filters "Recent sales emails clicked date" (after <day before date your sequence started>) and "Import List is equal to any of" <Name Of Your Import List>

 

Want to exclude those who have unsubscribed? Add a filter for "Now in Sequence" (which is a default Contact property).

 

Limitation: If someone enrolled in a sequence opens (or clicks a link in) a different 1:1 tracked email ("sales email") from you, they would be captured as well; if you aren't sending emails to the relevant contacts outside of the sequence in question, this shouldn't be an issue.

 

HubSpot - Track Sequence Opens and Clicks WorkaroundHubSpot - Track Sequence Opens and Clicks Workaround

2chars
Contributor
sarahw
Contributor

Is there an update on this? Drill downs to see contacts who opened the emails would be beneficial.

erica11
Top Contributor

Would like to be involved in beta please when available.

bertazizoglu
Member

This is a great and necessary suggestion. The last update has been in April. Any news on the progress? Not sure why this is so hard to implement as an interim solution until you get the major update ready. 

Status updated to: Being Reviewed
glencornell
HubSpot Product Team

From what I've gathered in these comments, this idea appears to be quite similar to the one titled: Drill-downs for Sequences Open/Click Reporting.

 

In both ideas, the goal is to be able to view the indivudal contacts that make up the summary reporting in sequences. For purposes of organization, and to increase the collective weight of both these concepts, I'm going to go ahead and merge these together, as from a product perspective,  I believe both of these problems should be addressed together.