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.

[glencornell]

@sboug 

All data has been backfilled, so you'll see all the interactions prior to the update as well!

[glencornell]

Hi Community!

The most recent 'Overview' page is now live to all, so I'm updating this idea to delivered to avoid any confusion related to continuing to cycle this idea through betas.

This is not the end of our development related to this issue, so below I'll outline some of the next updates coming and 'Ideas" to follow.

Now, when you go to Sequences in the navigation, you'll land on an Overview page, with , clickable summary of all sequences data in a datawell report, and a list of 'top enrollments' based on clicks and opens across the entire portal in a second report. Both of these reports can be filtered by 'Sender', 'Status', 'Sequence', and 'Enrollment dates' and searchable by 'Company name'. We are considering this page a "minimum viable product" (MVP) , which means we still have plans to update the information shown in this Overview, and potentially the functionality of these reports. Some areas in particular that we think still need work include increasing the types of reports shown here, adding more options for customization, and the ability to take bulk actions from the contacts once you drill into a metric. I'm continuing to monitor comments here for feedback on this update as we consider improvements!

There is still a lot more work that needs to be done and is currently being prioritized in regards to Sequences analytics. Below I've outlined some of our next projects and top priorties in Sequences.

1. Improvements to sequences analytics on the individual sequence summary page

- I've created this page to track some updates we plan to make on reporting for the individual sequence page

2. Create a contact list from a sequence or sequences

- Next on our priorities will be the provide the ability to use sequence data when building lists and workflows

3. The ability to use sequence behavior in workflows

[glencornell]

Hi Community! Another exciting update, we now have a new "Overview" page in sequences that will give you a full explorable view of your sequences, the contacts enrolled in sequences, and the interactions like opens, clicks, replies and more. This is now in an open beta! If you'd like access contact your customer success representative or contact support to request access!

Explained more in this loom video:

https://www.loom.com/share/86ba91e460f642c3a72041a89154b74f

[glencornell]

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:

[glencornell]

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?

[glencornell]

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

[glencornell]

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

[glencornell]

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

[glencornell]

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

[glencornell]

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:

• Filter contacts by sequence enrollment
• The ability to use sequence behavior in workflows
  
• Create a contact list from a sequence or sequences
• Completed a Sequence List

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

[glencornell]

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

[glencornell]

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

[Leadstreet-M]

Hi,

can you provide an update on this?

Thank you.

[natedame]

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

[DataCollector]

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]

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]

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]

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]

@glencornell Ay news?

[DavidBurnett]

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

[danaeciousv]

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

[vn]

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]

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]

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

[brotelli]

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]

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]

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 Workaround

[2chars]

Here's a workaround. More details (and an official reply from HubSpot in the thread) here.

HubSpot - Track Sequence Opens and Clicks Workaround

[sarahw]

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

[erica11]

Would like to be involved in beta please when available.

[bertazizoglu]

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. 

[glencornell]

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.