Google Code-in

We use Salesforce for managing our database of customers, partners, and volunteers and all communications and contact history with them.

This task involves cleaning up the Contacts within Salesforce to ensure they're ready to be imported in Mailchimp. Sometimes when we automatically convert leads to contacts from our web forms on our website, all the necessary values for segmentation don't get added.

For each contact, we must ensure it has a value for (and if it doesn't, add it):

• Country Dropdown (look in the mailing country field or the country value for the parent account)
• Contact Type (look at the parent account type to see what their account type is)
• Area of Interest (if it's not obvious from details, simply pick an area of interest that maps closest to their contact type) - this field will be captured more diligently on lead forms going forward.

How to work on this task:

• Claim the task
• Email edcable@mifos.org to request credentials to access our Salesforce instance.
• Run the report titled: Contacts Cleanup for GCI with the date range of 01/01/2015 to 09/30/2015 for Created Date
• For all the values that don't have the above fields completed, click the name of the contact, edit the values and save each record.

Task isn't complete until all the contacts in the date range are complete with the above fields.

If you plow through this task too rapidly, please while you're editing the contacts make sure they have proper capitalization, etc (i.e. general clean-up)