How to clean up a constant contact list | Data Bridge
← Back to Blog

How to clean up a constant contact list

July 9, 2021

Introduction

Having clean data is necessary as you can use these lists for marketing or any promotional activity from your organization. Make sure to clean your records from tools like Constant Contact and Mailchimp before you sync it over to have consistent data within Altru. Learn how to free your Constant Contact list from bad records without exerting a lot of effort in sorting and cleaning your data using the Data Bridge.

Cleaning up a Constant Contact list

1: Log in to your Social Good Software account.

2: Proceed to Data Bridge.

3: Click on create widget button.

4: A dialog box will pop out wherein you need to put on the name of the Widget before you click Next.

5: Select the widget type then click Next.

6: You now have a new Widget. Click on it and authorize it to go into Constant Contact.

7: Once it was authenticated, on the Widget Settings under Mailing List select the list that you want its data to be clean up. In this illustration, we will go with New Members.

8: Proceed to the Data Cleanup where you can see your first 500 rows of record based on the selected mailing list and start cleaning it up.

9: On the left side of the window located the options that you can enable and disable. Each of these options has different rules that you can take advantage of to have a consistent record. You can also test your configuration to see what works for you and Save Settings.

10: If everything looks good, export as a CSV or XLS format to perform a spot check. The option to export the data is located at the bottom part of the window.

11: Open the document to see if all the data is nice and clean; spot check if necessary. If you found inconsistent data, you can fix it manually.

12: You can now reimport this clean list of contacts into Constant Contact. 

Summary

These options are specially made with the intention of helping you clean your data from tools like Constant Contact. Repeat this process to all your lists before you sync it over to Altru to free your records from any bad data.

If you have more questions, please reach out to us through our support channel.

Continue reading

How to Track Instructor Activity for Scheduled Programs in Altru

How to Track Instructor Activity for Scheduled Programs in Altru

“How many classes did Maria teach last spring, and which ones?” It sounds like a question Altru should answer in ten seconds. In practice, many education departments end up digging through calendars, email threads, and a payroll spreadsheet to piece it together, because the instructor was never recorded anywhere a query could find. Altru is

How to Turn a Group Sales Overpayment Into a Donation in Altru

How to Turn a Group Sales Overpayment Into a Donation in Altru

A school books a field trip for 60 students, sends a check for the full quote, and then 48 kids show up. The teacher says, “Keep the difference, it’s a gift.” Now you have a group sales order that is overpaid, money that is really a donation, and a deposit that has to balance. The

Can a Spouse Be a Fundraiser in Altru? Solicitor Credit for Couples

Can a Spouse Be a Fundraiser in Altru? Solicitor Credit for Couples

It happens more often than you’d expect. A board member and her husband both care about your capital campaign. She asks a friend for a gift, but it was really his introduction and his follow-up phone call that closed it. Development wants him credited as the fundraiser on that gift. Then someone at the desk

Social Good platform

See it in action

Get started with Social Good

Book a demo to see Social Good Software in action for Altru.

Book a Demo
Social Good platform

See Social Good in action

Tell us a bit about your organization and we’ll take you straight to short demo walkthroughs of the software.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.