Yes, this looks good, as long as you have the setting enabled that contacts should unenroll when they do not meet the enrollment criteria anymore and as long as re-enrollment is enabled for marketing emails delivered.
And yes, adding a create date filter makes sense 🙂
Best regards!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
Not out of the box and not easily historically, unfortunately.
Here's how you could approach this going forward: You could set up a workflow that re-enrolls contacts when 'Marketing emails delivered is known AND Lifecycle stage is any of [all your lifecycle stages before customer]'. You then copy the value from Marketing emails delivered into a new custom number property Marketing emails delivered (opportunity or earlier). In the workflow settings, you would select that contacts should be unenrolled when contacts do not meet the enrollment criteria anymore.
This workflow would copy the number of emails delivered until they turn into a customer – then it freezes the number in Marketing emails delivered (opportunity or earlier).
Keep in mind that this number is only correct for new contacts who have not received any marketing emails before. Otherwise it's lower than what it should be.
If you want this information historically, it's unfortunately complicated. You would export the property history for Marketing emails delivered and would have to compare this export to another export of the Became a customer date for each contact. You would then have to prepare an import file in such a way that it includes the last value of Marketing emails delivered before the Became a customer date. At the end, you should have a two columns in your import file: the email address and the Marketing emails delivered (opportunity or earlier). (If you're an Excel wizard, this'll be easy. Otherwise, it's very likely frustrating.)
Regardless of which option you choose, you can then build a report based on this new property under Menu > Reports > Reports > Create report > Single object > Contacts.
Let me know if you have any follow-up questions!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
Yes, this looks good, as long as you have the setting enabled that contacts should unenroll when they do not meet the enrollment criteria anymore and as long as re-enrollment is enabled for marketing emails delivered.
And yes, adding a create date filter makes sense 🙂
Best regards!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer