Cloudy's Favorite Apps: Apsona

Have you ever wished you could import and export all of your salesforce.com data without firing up an external application or digging out your security token?

Have you ever encountered the limits of Salesforce.com reporting, wished that you could create more sophisticated reporting filters, or gotten frustrated while managing a list of custom report types?

How much time would you save if you could perform inline-editing on a whole list of records, without clicking into each one individually?

What if you could realize all of these functions and more with a single inexpensive app?

Apsona is one of Cloudy's favorite AppExchange apps, with such varied and powerful functionality that it can benefit any organization. What's more, nonprofits have access to 10 free licenses! 

Cloudy recently created an awesome report for a nonprofit client, allowing them to see which of their donors contributed to last year's matching grant Campaign, but did not contribute to the same Campaign this year. This insight will enable them to do a targeted and informed "ask" of those invested donors for this year's matching grant challenge!  The information on how to create this report using nested filters was right on the Apsona website:

The Apsona Website has lots of eye-opening use-cases and tutorials like this one!

Surely you are already considering the possibilities, but here are even more exciting ideas to ponder:

-Create Exception Reports: ie. Show all Accounts WITHOUT Opportunities
-Quickly change record ownership en mass.
-Import into multiple objects.
-Cleanse and import data in a single, integrated process.

Visit this page for some short, informative demos to see how powerful yet simple Apsona can be: Apsona Demos on the AppExchange 

If you would like help evaluating this App for your salesforce.com, installing it, or creating your first custom reports, CONTACT US!


Read Cloudy's reviews of other popular Apps:
Form Assembly
Conga Composer
Flip Top Social Profiles
Dupe Catcher
Rollup Helper

Cloudy's Favorite Apps: DupeCatcher

The number one Salesforce.com data quality complaint at most organizations is duplicate accounts and contacts.  Without safeguards in place, it can be all too easy to add duplicate records.  When this problem reaches a critical threshold, is it impossible to trust your data and make the daily decisions that depend on it. 

Salesforce.com experts and developers have many strategies, tools, and apps to address this common issue, including proper search technique for users and good matching criteria for data uploads.  The third strategy used by many companies who are winning the battle against "dupes" is DupeCatcher from Symphonic Source.  This simple, free app stops dupes on their way in, based on rules that you define.  

If you have never installed an AppExchange app in your Salesforce.com org, DupeCatcher is a great first choice.  Start the process by going to the AppExchange listing and clicking the green "Get it now" button.  After you follow the step-by-step directions to install it in your org, you will find you have a new listing for Dupecatcher in the App menu drop-down in the upper right corner of your Salesforce.com.  If you click on it, you will have a new view of the collection of tabs that comprise the DupeCatcher App.  To start blocking dupes in your org only requires two steps:

Step 1: Create a Filter
On the "DupeCatcher Filters" tab, click "New" to create a new filter.  From the drop-downs, select whether the filter will apply to Contacts, Accounts, or Leads and define the action you want to occur when a duplicate is detected.  For instance, do you want the duplicate to be completely blocked, or just display a warning to the user?

Step 2: Define the Filter Rules
Once you have saved your filter, it is time to define the duplicate-matching criteria.  On the filter record, scroll down the the DupeCatcher Filter Rules related list and click the "New DupeCatcher Filter Rule" button.  You will probably want to add several rules to have a well defined filter.  

Here is an example of a good set of rules for one contact filter:

Resources:
DupeCatcher on the AppExchange <--Go here to download to your Salesforce.com org
www.DupeCatcher.com <--For more information and resources about this app
Cloudy's favorite: Quick-Start Guide from DupeCatcher
Cloudy's Step-by-Step Direction to install an app

For more of Cloudy's advise about Dirty Data:
Clean ALL the Data!!! Part I
Clean ALL the Data!!! Part II

If you would like help setting up DupeCatcher in your org, if you are struggling with duplicates and need help cleaning up the mess, or if you would like more resources and training on how to effectively manage your data, please Contact Us!

More of Cloudy's Favorite Apps:
FormAssembly
Rollup Helper
Conga Composer
FlipTop