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

Cloudy's Chalkboard: Tracking the stars in your salesforce universe - Part 1

Who are your 

STAR clients?

Are any of those 

relationships at risk?

If you are using salesforce.com CRM, you understand the idea of Customer Relationship Management: you want to track the relationships and transactions of your customers or constituents and gain a 360 degree view of your business. You know that you can look at a single contact record and see all of their information, including lifetime transactions, campaign involvement, and activity history. 

But how do you leverage that information at a higher level?

Let's learn how to create a complex dashboard table that displays critical relationship updates at a fictitious nonprofit organization called Cartoon.org:

This example relies on some fields that are standard
in the salesforce.com Non Profit Starter Pack.
A for-profit company can create a metric to fit their business
using the same basic process described here.

Cartoon.org puts a high value on two types of donors:

1) Those who have donated more than $2,000 in their lifetime.

2) Those who have donated more than 5 times in their lifetime, regardless of amount.

These donors have shown, either by the amount OR frequency of their donations, that they are invested in the mission of Cartoon.org: it would be unwise to let those relationships founder!

The head of development at Cartoon.org wants to see a table of these high-value donors who HAVE NOT DONATED in the last six months. She will use this information to target these donors with some special attention to make sure they don't forget about their favorite charitable organization!


This two-part demo will show you how to create this report and dashboard for your organization.

Step 1: Create a new report

Go to Reports>New Report>Accounts & Contacts>Contacts & Accounts>Create
("Accounts" may be renamed "Organizations" in your org!)

Step 2: Set Filters and Filter Logic

Standard Filters: Show = All Accounts (/All Organizations) Date Field = Created Date Range = All Time

Custom Filters: Total Number of Gifts >= 5 Total Gifts >= $2,000 Last Gift Date < "6 MONTHS AGO"

(**NOTE: You will probably need to adjust the custom filter values to reflect donation totals, donation frequency, and time frames that are meaningful to your organization!)

Filter Logic:
Adjust the filter logic by clicking the little down arrow next to "Filters" and select "Filter Logic".
The default logic that is displayed will be "1 AND 2 AND 3".
Edit it to be "(1 OR 2) AND 3" as shown above.

Step 3: Set Columns and Summarize

You can quickly clear the default columns by clicking "Remove All Columns" Link

Add the four columns we need for this report: 
Name, Last Gift Date, Total Number of Gifts, and Total Gifts

Summarize the two "Total" columns:
Hover over the column header, click the down arrow, select "Summarize this Field" and click "Sum" on the dialogue box.

Step 4: Add report groupings

Group by "Last Gift Date" and "Name":
Hover over the column header, click the down arrow and select "Group by this Field" for both columns.

Run the report; it should look like this: 

Step 5: Save your report

Click "Save" and save your report with a meaningful name and description.  

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
This report is ready to be shared 
with your development team: 

These are your most important at-risk donors.

Make a plan to follow up with them!

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Tune in next week to create a handy dashboard component with this information.

If you would like help creating more meaningful reports and dashboards for your organization, Contact Us!

More dashboard tutorials from Cloudy:

Cloudy's Chalkboard: Creating Dashboards

Cloudy's Chalkboard: Grouped Bar Charts

Cloudy's Chalkboard: Use a Workflow to send an Email

Using workflows in salesforce.com to automate your business processes saves you time, money and frustrating busywork. Today, we will set up a workflow to send an email. Emails can be automatically sent not only to salesforce.com users, but to other employees, business partners, and customers. Merge fields in the email template can bring in the recipient's name as well as other information from their record.

If you are not yet using workflows, you might not know when you should use one! Here are some examples of when you might use a workflow to send an email:

-When an Opportunity worth more than $50k is Closed-Lost, the sales manager should be notified for follow-up.
-When a Sales Rep completes a demo with a client, a Thank You email should be sent to the client.
-When a new Account is created in a given geographic location, the regional manager should be notified.

These specific examples might not apply to your business, but can help you start thinking about the kinds of events and processes in your org that should trigger an automatic email or alert.

****************

Let's use the example of the Thank You note after a demo. After completing a product demo with a contact, the Sales Rep marks a custom checkbox called "Demo Participant"  on the contact records of the participants.  When this box is checked, we want to automatically send out a personalized thank you email to that contact.

Step 1: Create the Email Template

The Merge Fields on your template should be related to "Contact." For step-by-step instructions to create an email template, check out Cloudy's Chalkboard: How to Create an Email Template. Be sure to mark the "Available for Use" checkbox before you are done!

Step 2: Create the Workflow Rule

• Go to Setup>Create>Workflow & Approvals>Workflow Rules and click "New."
• Select the object where the trigger action will occur. (In this case, "Contact".) Click "Next".
• Name and describe the rule. As a best practice, begin the rule name with the name of the object, or an abbreviation thereof. (When you have a lot of workflows, this helps keep related rules grouped together in the list.)
• Under Evaluation Criteria, choose "created, and any time it's edited to subsequently meet criteria".
• Under Rule Criteria, define the field values or formula test that will trigger the action. For this example "Contact: Demo Participant" + "equals" + "TRUE"
• Click "Save & Next"

Step 3: Add the Workflow Action

• Select "New Email Alert" from the Add Workflow Action menu. A new screen will appear.
• Add a short description (the unique name will auto-pupulate based on the description).
• Select your email template from the lookup.
• Under Recipient Type, select "Email Field" and from the dual panes below, select the correct contact email address.
• Click "Save." On the final screen that appears, click "Activate".

You are ready to test your workflow!

If you would like help adding process automation to your salesforce.com, Contact Us!