Tips for Salesforce Reports - Filter Logic (By Referential's Ankit SIngh)

Do you use Salesforce.com (SFDC) to run reports at your office? Here at Referential we use SFDC every day –  often multiple times a day across all our different clients. As a result, we’ve picked up a few tips and tricks along the way that have made our lives a bit easier. One such tip is using the filter logic feature to quickly find exactly what you are looking for. In the screen shot below, we are looking for accounts meeting multiple criteria. They need to have made a purchase of products, be reference accounts and within in a certain industry.

In this real example we need government/aerospace customers OR customers specifically related to security, defense, surveillance and analytics. Just to give you an idea of the search results, if we only search for customers within the industries we get about 62,000 results. If we only search for customers with those keywords in their name, we get 4,000 results.

To get the results we desire in one report we need to use the filter logic feature. Filter logic says “1 AND 2 AND (3 OR 4)”. This ensures SFDC applies the first two filters along with the third OR the fourth.

Excel screen shot
Excel screen shot

You can see our first filter is for customers that are fully deployed or at least have gone through with the purchase of products, our second ensures they are reference accounts, and then we get the account name and industry designation – all in one report!  So much faster than running separate reports, combining them, and removing duplicates. When you run as many reports as we do, any time or effort you can save is certainly worth it.

Tell us how you have used the filter logic field or how you will in the future!

Congratulations to our Award Winning Client!

lisa.jpg

Congratulations to our client Lisa Matzdorff, director of customer experience at Symantec.  She was just named the winner of the Sherpa Award for Innovative Feature Use at the Elevate Customer Summit hosted by RO Innovation.

Lisa uses ReferenceView, an application from RO Innovation, to track recruitment and reference activities. She needed a granular method for tracking and reporting each stage of recruitment to support the volume and multi-step process in place at Symantec. Lisa turned to ReferenceView’s workflow functionality to keep recruitment of new advocates moving at an optimal pace. Notes are captured within each step so that a permanent record remains available.

This approach ensures the recruitment process is as efficient as possible, with a clear view of metrics. The process has enabled Lisa to consistently exceed the security industry’s standard advocate recruitment rate!  Congratulations Lisa on both your award and your great results!

Sharing a spreadsheet, carefully

We use spreadsheets, a lot.  There’s one in particular that we share and it’s a bit of a dance when multiple people need it in the same day.   We’ve been careful and haven’t had any version control issues or things like accidental sorts on one column but not all columns.   We have built in some data validation, I like it when key cells turn pink telling me it’s a duplicate.  That means some of the data I need is already there.  So far the amount of data is manageable, there’s very little duplication in the content – just those rare pink cells!  Filters make it a breeze to find the records we need.  There’s nothing pushing us to consider a more robust solution now but who knows, sometime in the future we might need to look at moving to a database.  What’s tipped you from spreadsheet to database?  Any hints to share?