LO Constituent Export

Ram Basu

How can I get an export of all my LO constituents that shows the email sign-up date, their current email status (accept or not), and their unsubscribe date? When I go to Import/Export, there are no export options, and I've been unable to find a report that includes this information.

Erik Leaver

@Ram Basu You should be able to use a Report Writer → constituent report to get this data.
That report has the following fields you'd need:

FN, LN, Creation Date, email, email opt-in status, accept email, opt-out date

Philip Nawrocki

@Ram Basu look into Mail Merge. You can go to Data Management → Mail Merge. Create a new one and then on the left column you will see all the fields. You will find the ones you are looking for. It's a little bit of a search the first few times you do this, but then you will be all set.

Current Email Status = Email/Email Status in LO
Unsubscribe Date = Email/Opt-Out Date in LO
First Name = Biographical Information/Name/First Name in LO

That should get you started. You can get Contact ID as well so if you need to re-import to a group, its really easy.

Thanks,

Phil

Ram Basu

@Erik Leaver thank you. I haven't checked out this avenue yet. I will.