LO Constituent Export
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.
Comments
-
@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 date0 -
@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 LOThat 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
0 -
@Erik Leaver thank you. I haven't checked out this avenue yet. I will.
0
Categories
- All Categories
- 6 Blackbaud Community Help
- 209 bbcon®
- 1.4K Blackbaud Altru®
- 394 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 15 donorCentrics®
- 359 Blackbaud eTapestry®
- 2.5K Blackbaud Financial Edge NXT®
- 646 Blackbaud Grantmaking™
- 563 Blackbaud Education Management Solutions for Higher Education
- 3.2K Blackbaud Education Management Solutions for K-12 Schools
- 934 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.4K Blackbaud Raiser's Edge NXT®
- 3.7K SKY Developer
- 243 ResearchPoint™
- 118 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 238 The Tap (Just for Fun)
- 33 Blackbaud Community Challenges
- 28 PowerUp Challenges
- 3 (Open) Raiser's Edge NXT PowerUp Challenge: Product Update Briefing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports+
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Email Marketing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Gift Management
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Event Management
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Home Page
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Query
- 779 Community News
- 2.9K Jobs Board
- 53 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)


