Cloudy's Favorite Apps: SyncApps by Cazoomi

So your Salesforce org is up and running, and you are starting to think about how to connect it to other systems.

If you are like many others, Email Integration is at the top of your list. Email integration can be a big slippery subject, as there are many possible requirements, and just as many possible solutions! 

Recently, Cloudy discovered a solution that is both robust AND user friendly: SyncApps by Cazoomi offers an "integration framework", capable of connecting Salesforce with many common Email platforms (among other things). 

Let's see how SyncApps by Cazoomi is able to connect Salesforce with one popular Email Marketing tool, MailChimp.*

To get started, sign up for a free trial SyncApps account and create a "Sync Profile" for your Salesforce-MailChimp connection. 

• The setup wizard walks you through the process, where you will enter your login credentials for both platforms, and select the sync options you prefer from a list of check boxes. 
• The wizard also allows you to specify which Salesforce object to sync your lists with: Campaigns, or a new custom object called "Marketing Lists". Cloudy likes the custom object; it's nice and simple, and keeps your Salesforce campaigns less confused.
• If you choose to sync MailChimp email responses as well as lists, these will sync to Salesforce Campaigns. Each MailChimp email you send to a synced list creates a new Salesforce Campaign, with the current list members as Campaign Members, logging opens, clicks, and bounces on the Campaign Member record. The Campaign will display summary totals of opens, clicks, and bounces for that email.
• When you look at a Contact record in Salesforce, you will see which MailChimp groups they belong to (in the "Marketing Lists" related list, if you use it) and the details of their interactions with each individual email in the Campaign History related list. 

Here are screen shots of an example setup, and a chart that explains how the sync will work:

Action:	Sync result
Salesforce side
NEW Contact is added to Salesforce with NO email address, and is not added to a Marketing List.	Nothing
NEW Contact is added to Salesforce WITH email address, but is not added to any Marketing List	Nothing
NEW Contact is added to Salesforce with NO email address and IS added to a Marketing List	Nothing
NEW Contact is added to Salesforce WITH email address, and IS added to a Marketing List	Contact will be added to MailChimp Master List and added to the matching SyncApps Groups
Existing Contact Name is updated in Salesforce	FN and LN will be updated in MailChimp Contact with matching email address
Existing Contact Email is updated in Salesforce (and this contact is on at least one Marketing List)	The email will be updated on the contact in MailChimp
Existing Contact has “Email Opt-Out” Checked in Salesforce	Contact will be opted out in MailChimp too.
Contact is DELETED	Email address is deleted in MailChimp (**If this option is selected in sync settings**)
MailChimp Side
Existing Contact Email is updated in MailChimp	The matching contact in Salesforce will be updated as well.
Existing Contact Name is updated in Mailchimp	If the “MailChimp Update Form” was used, the update will push to Salesforce. Otherwise, the change in MailChimp will be overwritten by data in Salesforce.
NEW Contact is added to MailChimp but is not added to a SyncApps Group	New Contact is created in Salesforce
NEW Contact is added to MailChimp and IS added to a SyncApps Group	New Contact is created in Salesforce and is added to a Marketing List
Existing Contact Unsubscribes from all lists thru MailChimp	Salesforce Contact will be removed from all Marketing Lists and "Email Opt-out" is checked "true" (**if this option is checked in sync settings**)
Existing Contact updates subscriptions thru MailChimp - ie. Unsubscribes from one group, and/or Subscribes to a different group	Salesforce Contact will be removed and/or added to Marketing Lists, accordingly
Subscriber is DELETED	Contact will be removed from synced Marketing Lists

If you would like Cloudy's help implementing SyncApps by Cazoomi for your org, or evaluating other tools for your integration Contact Us!

*If you use MailChimp, you may have noticed they offer a free Salesforce integration. Cloudy does not really recommend using this sync, as it has some serious downsides and limitations: it does not sync opt-outs, it can only sync new subscribers as leads (not contacts), it creates copious amounts of records which can get you into a bind with data storage, and customer support is limited.

Read about more of Cloudy's Favorite Apps:
Cloudy's Favorite Apps: Apsona 
Cloudy's Favorite Apps: More from Apsona!
Cloudy's Favorite Apps: DupeCatcher
Cloudy's Favorite Apps: Rollup Helper
Cloudy's Favorite Apps: FormAssembly
Cloudy's Favorite Apps: Conga Composer
Cloudy's Favorite Apps: FlipTop Social Profiles
Cloudy's Favorite Apps: Mass Edit + Mass Update + Mass Delete

Cloudy's Favorite Apps: MORE from Apsona!

One of Cloudy's Favorite Apps just keeps getting better!

Apsona has long been one of Cloudy's top picks for enabling all kinds of easy data management tasks in salesforce.com. 
Now there is an add-on that allows easy merges to documents, spreadsheets, or email. Read on to see how easy it is to set up a merge for Thank You letters - in batches or one at a time!

(**note: this demo uses Salesforce + Non Profit Starter Pack with 1:1 model. Other data models and merge processes will vary in the details**)

First create a Word document with merge fields for the data you wish to pull in to your Thank You - this probably includes data from both the Donation record and the Contact record of the Donor. Upload this doc to the "Documents" tab in salesforce.com.

The merge fields needn't conform to any rules or format conventions - just call them whatever makes sense to you.

Next, create a report on the Donation Contact Roles tab in Apsona. Pull all of your merge field data into the report. Add any filter terms as needed, for example:

-Filter so that Donation "Stage=Posted/Closed Won"

-Consider creating a custom checkbox on donations that marks "Thank You Sent"; filter so that the report only shows un-thanked donations. 

If you don't see this tab, you must first create a custom tab "Configuration" under "Settings", then "Clear Cache" under settings to make it visible.

Run the report to preview the data. The list you see should be a complete list of un-thanked Donations. If everything looks good, you are ready to create your merge; click "Merge/Mail" at the top of your report.

Pro-Tip! If you want your Merge to *AUTOMATICALLY* update a field on a record, such as a "Thank You Sent" checkbox, you must include the ID field for that record in the report (ie. Donation ID).

The Merge Wizard that appears will walk you through the merge setup: Your uploaded Word template will be available to select, and you will be able to match your Word merge fields to the data columns in your report. Finally, note the options available in Step 4 of the merge: 

You can log a Task on each donation record, showing that a Thank You was generated. Even better, you can update a field on the record with a given value. 
For this process, check the custom "Thank You Sent" checkbox on the Donation record. You filtered the Merge report so that it only pulls donations where "Thank You Sent=False"; now you can run the Merge and it always creates a perfect set of the latest Thank Yous!

When it's time to create the next batch of Thank Yous, there is no need to go back to the report on Donation Contact Roles. Your new Merge can now be found and run under Settings>Merge Actions. 

One more amazing feature of Apsona Merge is the ability to very easily create a Merge Button on a record. For this example, a button right on the donation record can generate quick, one-off Thank Yous as needed. To create it, simply go to Settings>VF pages & buttons, look up your Merge, and click the "Generate code" button.

Copy this code into a new "Button" on Donations and add it to the Donation page layout. Now you can create a one-off Thank You on a Donation with a single click.

These Thank You letters look great, Cloudy!

If you would like some help evaluating this tool for your salesforce.com, please Contact Us!

Read about more of Cloudy's Favorite Apps:
Cloudy's Favorite Apps: Apsona (Part 1!)
Cloudy's Favorite Apps: DupeCatcher
Cloudy's Favorite Apps: Rollup Helper
Cloudy's Favorite Apps: FormAssembly
Cloudy's Favorite Apps: Conga Composer
Cloudy's Favorite Apps: FlipTop Social Profiles
Cloudy's Favorite Apps: Mass Edit + Mass Update + Mass Delete

Big Data - Small Business : Part III

Big Data means bringing all the parts of your business into one place.

If you have followed along with Part I and Part II of this series, you are beginning to understand what Big Data means to your small business or nonprofit, and may be wondering if you are up to the challenges.  Here are some important pointers to guide you on your journey:

• Leverage the salesforce.com platform.  Not only should you bring all your data IN, but make sure you are using the tools available in salesforce.com: workflow automation, live reporting, systems integration, AppExchange add-ons, etc.
• Act: You are about to gain unprecedented insight into your business. Get ready to make changes, measure, and react.
• Bring it ALL in! Systems and departments that you thought were less important may turn out to be very important. Don't turn your back on your own data.
• Get a good implementation partner. Successful organizations agree that this is key. Talk to your salesforce.com Account Exec, visit a local user group to get recommendations, or contact Redpath.
• Invest: The cost of a major transition can be significant, but is worth it!
• Leadership Alignment: Are your team leaders trying to build the same company? Get aligned now!
• Imagine: Where is your business now? Where should it be? Accessing your big data will be a critical leap towards your business goals.
• Information: Knowledge is power. Give your team the tools to excel by putting more information in their hands.
• Keep an open mind: What is your data really telling you?
• Time: It takes time to collect big data and see results.  Be patient and don't give up now - you're almost there!

Cloudy and the consultants at Redpath have helped many salesforce.com customers on this exciting journey. To learn more, please Contact Us!