Exporting User's Last Email Open Date

Reena Vadehra

Hi,

Is there a way to export when constituents last opened an email? I know you can create a query based on engagement factor of opens. But I can't seem to export the date when someone last opened an email.


 

Jeremy Reynolds

Reena Vadehra:

Hi,

Is there a way to export when constituents last opened an email? I know you can create a query based on engagement factor of opens. But I can't seem to export the date when someone last opened an email.


 

File this under "not the droids you're looking for, but droids nevertheless."


Tasks has an option for "Email Response Rate Segmentation" that would let you save an engagement factor based on email opened within X days. You could set a couple of those up and bucket people into groups that have opened within 30, 60, 90 days, etc. Those will show up in the Transaction Information fields that can be reported on.


Really, that's more useful as an exclusion list to make sure you don't have several emails going to a person in a given week, but it beats nothing, I guess.