Cloudy's Favorite Apps: Mass Edit + Mass Update + Mass Delete

What do you do when you want to edit the addresses of a couple dozen contacts?

Or what if you need to update the Stage of numerous Opportunities at once?

Or might you wish to quickly delete all Leads who have had no activity in the past year?

This is the type of important data management that keeps your salesforce.com vital, but if it is a hassle, it might not get done.  These jobs are too small to bother with data loader, but as you search, open, and edit each record individually, you will surely wish there was a better way.

One of Cloudy's favorite FREE apps makes this possible:

Mass Edit + Mass Update + Mass Delete -- the name says it all!  After the easy installation of this app, all you need to do is go to the Search Layouts page of the standard object where you would like to use this button.  (Step by step instructions appear in the install guide on the app)

The new buttons will appear on any list view on those object tabs. For specific data management tasks, you may want to create filtered list views that narrow down a list to the records you want to Mass Edit/Update/Delete.  ie. "All Contact with No Mailing Address", "All My Opportunities in Negotiation", or "All Leads with No Recent Activity".  You will have a chance choose specifically which records you are going to edit/update/delete from a list by checking the box next to the record.

Here is an example of a "Mass Edit" view of Contact records.  
From here it's a snap to edit all four records at once and then save!  
Use Mass Edit when you want to Edit multiple records at once, but with different information for each one.  For instance, each contact above likely has different phone and address information.

Here is an example of a "Mass Update" view of Opportunity records.  
From the list view, select several Opportunities to update, and on this page choose the field to update (Stage), and the value to update to.  Use Mass Update when you want to update multiple records with the SAME information.  For instance, I can change all of these Opportunities to "Closed Lost".

BONUS:
Once you are in the groove of using Mass Edit + Mass Update + Mass Delete for your small-batch data management needs, you might wish you could use the buttons on custom objects, or that you could customize the Mass Edit fields available.  Since this free app is an "Unmanaged Package", it is possible, and easier than you might think, to extend its capabilities in these ways. You can find some how-to help among other app users on the "reviews" tab of the appexchange listing.

If you need more customization, training, or help, please Contact Us!

For instructions on test-driving an App in your salesforce.com sandbox:
Test Drive an App in your Salesforce.com Sandbox

More of Cloudy's Favorite Apps:
Dupe Catcher
Conga Composer
Form Assembly
Rollup Helper

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

Last week we started creating a complex dashboard table that could help a nonprofit keep tabs on its most important donors. 

We created the report that will be the basis for the dashboard component.  Today we will finish by actually adding it to the dashboard!

Step 1: Add a chart to your source report

In order to create a complex dashboard table, you must first add a chart to the source report. The chart on the report itself does not have to look meaningful: in fact, it usually doesn't!  

Go to your report, click  "Customize" and then click "Add Chart":

Choose a scatter chart as the type of chart, and on the chart data tab, set all four chart data fields to the meaningful groupings of your report, as shown:

Click "OK" and then Save and Run your report. You will notice that the resulting scatter chart is not very interesting as a chart, but it allows us to create a more complex dashboard table. 

**If you want to make the chart less prominent on the report itself go to the "Formatting" tab on the chart editor and choose to make the chart size "Tiny" and the chart location "Below Report"!**

Step 2: Go to your dashboard

You probably have multiple dashboards in your salesforce org; choose the one where you would like to add this component, or start a new one.  For more about creating and editing dashboards, check out: Cloudy's Chalkboard: Creating Dashboards

When you are on the correct dashboard, click "edit"

Step 3: Drag a table component onto the dashboard

Step 4: Drag the correct report onto the component.

Note that you must switch from the "Components" tab to the "Data Sources" tab in the Dashboard Builder palette on the left side.  

(For instructions about how to build this report, see last week's post: 

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

Step 5: Edit the table

The default settings of the table that appears will only show 2 columns.  Click the wrench in the upper right corner of the table to see more options.

On the Component Editor that appears, choose the Formatting tab and click "Customize table".  You will now be able to edit the table columns to show all four data points: 

Congratulations! You have created a complex dashboard table that will allow you to keep track of important donor relationships that might be at risk.  Consider scheduling this dashboard to refresh regularly, and/or have it emailed to interested parties automatically.

Following similar steps, you can create tables to track other parts of your business as well. If you would like help with your reporting and dashboards, Contact Us!

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