Hello HubSpot Community,
I’m currently working on a project where I need to analyze the engagement (clicks, opens, and replies) of emails that contain specific keywords in the title. The timeframe I’m interested in is the past 3 years. The goal of this analysis is to identify our most engaged customers.
Is it possible to do that using the UI or do I have to use an API to do it?
I’ve been using the HubSpot API to retrieve email events, but I’m having trouble filtering the data based on the email title and the specific timeframe. I was wondering if anyone could provide some guidance on how to achieve this?
Specifically, I’m looking for a way to:
- Filter emails based on specific keywords in the title.
- Limit the data to a specific timeframe (last 3 years).
- Retrieve engagement data (clicks, opens, and replies) for these emails.
Any help or guidance would be greatly appreciated. Thank you in advance!