topic Re: How To Create a Report of Website Pages visited by Contacts who opened an email in Reporting & Analytics

How To Create a Report of Website Pages visited by Contacts who opened an email

khookguy — Tue, 17 Jan 2023 00:11:14 GMT

How can I create a report showing the contacts and the web pages they visited for all contacts opening an email?

The UI for the custom report builder will not let me select Marketing email and Web activites. I see the message "Only one event table can be selected at a time".

Re: How To Create a Report of Website Pages visited by Contacts who opened an email

Syeda_Fatima — Tue, 17 Jan 2023 04:52:55 GMT

Hey @khookguy, Unfortunately, you cannot create a report in HubSpot that shows contacts and the web pages they visited for all contacts opening an email. This is because the UI for the custom report builder only lets you select one event table at a time.

You may be able to accomplish this by creating two separate reports: one report showing all contacts that opened an email, and a second report showing which web pages they visited. You can then join the two reports together manually by matching the contact names.

If you need to automate this process, you can use the HubSpot API to fetch the contact data for each report, and then join the two datasets using a script or language of your choice.

Hope this helps! 🙂

Re: How To Create a Report of Website Pages visited by Contacts who opened an email

karstenkoehler — Tue, 17 Jan 2023 05:29:38 GMT

Hi @khookguy,

If it's one specific email you'd like to filter for, the workaround would be a report based on Web activities and Contacts. You can then create an active list of contacts that have interacted with the marketing email in the desired way and filter your report by this list membership.

Best regards!