Salesforce.com Reports Dynamically Filtered

Written by ShamrockCRM on August 9, 2009 – 3:16 pm

When using Campaigns for mass mailing, the easiest way to add a large amount of Contacts to the Campaign is to have a predefined Contact report. With this predefined Salesforce report, you can easily click the “Add to Campaign” button and automatically add all of the Contacts on the report to this Campaign.
Salesforce.com Reports

If you needed to step through this process to create or modify a report every time you needed to add a new set of users to a campaign, you would spend a lot of time setting this up.

Well, Salesforce.com provides the capability to create a generic report that will have generic criteria established that can be dynamically filtered through the URL. For example, lets say you created a generic “Sales Pipeline” report. This generic report would be grouped by Salesperson (Owner). Without any filters, this would show the pipeline for the entire company. With a filter, you could detect the User that is currently logged into the system, send them to this generic report, with a filter criteria in the URL to specify that you only should display the Sales Pipeline for this specific user. So, instead of creating 1 Pipeline report for every user or making your users customize this report over and over, you can create 1 report that will work for the entire company and also all users. Very useful way to keep the system clean.

For this example, you can place a link on the Account page layout that will take you to a report of all Contacts at the Company.

1) Create your custom report. For this example, just build a simple Contacts and Accounts report.
2) Go into the customize section of this report. Go to the Criteria section.
3) Create a simple criteria item where “Account Name equals blank.” This will be the criteria that will be filled in through the URL.
3a) Feel free to add other criteria like this or any business specific criteria that you might need (ie. State = Florida).
4) Save the report.

5) Now, you will want to take the URL of your report:
ie. https://na1.salesforce.com/report_id
6) Add this to your report URL: ?pv0=
So, now you will have https://na1.salesforce.com/report_id?pv0=

The “pv0” is the variable for that first criteria that you created. If you created multiple “blank” criteria like the Account Name one above, you would also have pv1, pv2, etc for each criteria created.

7) So, if you wanted to test this out, place an Account Name after pv0=. Like https://na1.salesforce.com/report_id?pv0=Shamrock CRM . This will bring in the Contact report with only Contacts working for Shamrock CRM.
8) Now, if this worked, you might want to put this as a link (or button) directly on the Account layout, just create a generic button/link and place this URL in it. Instead of hard coding an Account name, use the Account Name merge field. This will dynamically grab the Account Name and place it in the URL.

This will work in any Parent Child relationship.

Awesome, right?


Tags: , , , , ,
Posted in Business Analysis, Campaigns, Reports | 1 Comment »

Salesforce.com User Adoption Tracking

Written by ShamrockCRM on July 21, 2009 – 8:07 pm

So, you have made a large investment in Salesforce.com for your Sales, Marketing and Service needs and you want to ensure that your users are utilizing the system to its full potential and allowing this excellent CRM system to do exactly as it is supposed to:  decrease costs, increase sales and provide better visibility into the operations of your organization.

How would you track this?  How would you be able to tell if your users are being active in the system or not?  Thanks to Salesforce.com, we can provide reports and dashboards to provide analytics on exactly this type of data.

There are a few categories of data that you really want to track:  1) Login Activity 2) Usage 3) Data Quality

1) Login Activity is going to tell you if users are logging in AT ALL.  This will allow you to compare the login activity between different groups, or roles, or regions, or profiles of Salesforce users.  If the Eastern mega region of the United States is logging in much more than the West, it is possible that the Sales Managers in the Western region might need further education or promotion of the system or they might need to be asked to manage their users better.

Some metrics used for this category:
– Users Logged in within the last 7 days
– Users Not Logged in within the last 7 days
-Login leaderboards (for competition)
-Users Never Logged In

2) Usage is really going to let you know if the Users have both logged in AND have created records and if so how many.  For example, are Salesforce.com Users actively marketing to find new Leads or are there Activities (Emails and Calls Logged) being consistently created to prove that users are contacting their Accounts, Contacts and Leads.

Metrics used for this category:
-Accounts created by Owner role/profile/region
-Opportunities created by Owner role/profile/region
-Contacts created by Owner role/profile/region
-Activities closed by Owner role/profile/region

3) Data quality reports and dashboard components let you know if the data required for your business process is being properly filled in, if data is being maintained properly and in a timely manner and if all or most data is actually in the system.

Metrics for data quality:
– Neglected Opportunities – Past Close Date, but not Closed
– Open Tasks by Assigned Users
-Any other metrics based on records/fields that should be filled in in a certain manner based on your business process.

Any other adoption metrics that everyone else uses?


Tags: , , , , , , , , ,
Posted in Business Analysis, dashboards, marketing, Reports, sales | Comments Off on Salesforce.com User Adoption Tracking

Free Salesforce.com S-Control to Dynamically Auto Refresh Dashboards

Written by ShamrockCRM on March 14, 2009 – 3:06 am

Ok, I have received many positive comments about this functionality that I posted about before regarding the auto refreshing of either a home page dashboard or an individual dashboard when a user simply visits the page.

I know that Salesforce offers the ability to schedule dashboards, but this is really to be used in the case of an organization having MANY dashboards and a Salesforce.com Administrator not wanting to schedule hundreds of dashboard refreshes.

Take a look at my original post explaining this Salesforce.com Dashboard Refreshing functionality

I am going to provide this useful code for you to use for free.  This is once again a very simple piece of code, but somewhat useful and unique.

1) Create an S-Control called whatever you’d like.  I called mine “Auto Refresh Dashboard.”

2) Paste in this code:

<code lang="html">&lt;html&gt;
&lt;head&gt;
&lt;script type="text/javascript"&gt;
function clickButton(){
var thebutton = parent.document.getElementsByName('refresh');
thebutton.item(0).click();
}
&lt;/script&gt;
&lt;/head&gt;
&lt;body onload="clickButton()"&gt;
&lt;/body&gt;
&lt;/html&gt;</code>

3) Create a Home Page Component of type “HTML Area.”
4) Click “Show HTML”
5) Paste in the following code:

<code lang="html">&lt;iframe name="rss_iframe" src="/servlet/servlet.Integration?lid=XXXXXXXXXX&amp;ic=1" width="0%" height="0"&gt;&lt;/iframe&gt;</code>

6) Replace XXXXXXXXXX with the Salesforce.com record ID of the S-Control that you created above.
7) Add this home page component to your home page layout.

Now, the home page dashboard will always automatically refresh when Users visit their home page, preventing confusion by keeping data up to date!

Have fun!


Tags: , , , , , , ,
Posted in dashboards, S-Controls, Salesforce.com | 13 Comments »

Automatically Refreshing Dashboards

Written by ShamrockCRM on December 19, 2008 – 9:18 pm

If your Salesforce.com Users are like most Users, they are always calling you asking why their Dashboards are incorrect.  Well, it’s because they forgot to refresh the Dashboard or they do not even know how to refresh the Dashboard.

Well, I found a unique little way around this.  I created a small piece of Javascript that can either be placed on everyone’s home page OR on the individual dashboards themselves.  Every time the User visits the page, the code will basically CLICK THE REFRESH BUTTON FOR THEM!  Great, right?

It is the simple things that make me the most happy.  This little script keeps all visited Dashboards up to date all the time automatically.  Let me know if you are interested in this script at all.

salesforce.com dashboards

salesforce.com reports

UPDATE: 8/15/2011 – Tons of requests for this script.  http://www.shamrockcrm.com/salesforce/free-salesforcecom-s-control-to-dynamically-auto-refresh-dashboards/

 


Tags: , , ,
Posted in Programming, S-Controls, Salesforce.com, Web Development | 23 Comments »