Sunday, October 26, 2014

Using Goals, Goal Metrics and Rollup Queries in Microsoft Dynamics CRM 2011

Posted in [Dynamics CRM], [Business Intelligence], [Business User] By anonymous @ 7/25/2013


The Dynamics CRM 2011 Goals feature makes it easy to set business goals,
assign goals to individual teams or employees, and track and measure results against your targets.

To begin using Goals in Dynamics CRM, all you need to do is follow the simple instructions, below.
First you will need to create a Goal for the data you are trying to measure. Next follow my second step on using a Goal Metric to tell the Goal if the figures being measured are number or dollar amounts. The third step is to create a Rollup field. In Dynamics CRM, every metric has Rollup fields that detail the actual and estimated value of the Goal that you are trying to measure. The last step will cover tracking and measuring results.

Part 1: Creating a New Goal in Dynamics CRM 

  1. Goals are located in the Sales area of your Dynamics CRM. To get started, click Sales then Goals in the left-hand navigation menu.  

  2. Select New from the ribbon. (If you want to attach an existing Goal to a colleague, select the Goal in the Parent Goal Lookup, and then skip to Step 2 below.)  

  3. Give your Goal a unique name.  

  4. To associate a Goal to a specific person, do a lookup in the Goal Owner field and choose the person that you want this Goal to track.  

  5. Then select a Manager for the Goal.

 

 



Part  2: Setting up the Goal Metric 
 

  1. Select the Lookup in the Goal Metric field.  

  2. Choose to Create a New Metric.  

  3. In the new window, give your Metric a name.  

  4. Select the Metric Type you are tracking. Amount will count the totals that you are tracking, count only counts the rows.  

  5. Using the pick list, choose the Amount Data Type. Money will return your results in dollar format (use if tracking revenue), Decimal will allow for decimals, and Integer will return a whole number (for tracking quantities).  

  6. By selecting Track Stretch Target, you can insert a higher Goal to reach.  

  7. Save but do not close the Goal Metric. You still need to add rollup fields to this Metric. 

 

 



Part 3: Creating a Rollup Field
 

  1. Click within the Rollup sub grid. Then select Add New Rollup Field from the ribbon.  

  2. Use the Rollup Field pick list to choose what you want to track.

  3. The Source Record Type allows you to select the entity you want the data to come from. The Source Field pick list lets you choose the field on the entity that you selected.

  4. The Record Type should match the Source Record type that you selected earlier.  

  5. Pick the Date Field that will give you the most correct data. For example, if you are tracking the total revenue from closed Contracts, then pick Est. Close date. If you are only tracking the number of Leads that a person has brought in, Created On might be your best choice.

  6. Save and Close the new Rollup.  

  7. Click on Goal Metrics in the ribbon tab.  

  8. Save and close the Goal Metric.  


Part 4: Selecting and Calculating a Goal
 

  1. Choose whether you want to track a goal during a Fiscal Period or set your own custom period.  

  2. Enter in the Target amount you want to track.   

  3. Save the Goal.  

  4. Click Recalculate on the ribbon to run the Goal.  

  5.  The Actuals tab is where you can view how close an employee is to reaching the Goal you just set for them. You might have to scroll down to view your results.  



For more information on Goals, check out my Step-by-Step Guide for Using the Goals Feature in Dynamics CRM 2011.

To find out more about our services and solutions, please fill out our Contact Us form.

 

, , ,

Comments

Got something to say? Join the discussion »
    Posted by Jerry Borgen on 11/3/2013
    I am a franchisee of Manpower in Lansing MI with about 80 employees and have Microsoft CRM and are using about 2% of the potential.

    Right now I am particularly interested in developing the employee goal area,

leave a reply

 [Quick Submit with Ctrl+Enter]

Remember my details
Notify me of followup comments via e-mail

C5_Insight

About C5 Insight

We are a Microsoft Gold Certified partner focusing on SharePoint, Microsoft Dynamics CRM and Salesforce.com.  Learn more about us by visiting our website.

Search

We Wrote the Bible on Microsoft SharePoint and Dynamics CRMBook-Microsoft Dynamics CRM 2011 and SharePoint 2010 Bible

Tags

Maximize

Recent Comments

Maximize

Blog Roll

Maximize

Disclaimer

The information herein may be used solely at your own risk.  No warranty is made by the author or by C5 Insight, Inc.

The opinons expressed herein are those of the individual authors and do not necessarily represent C5 Insight, Inc in any way.

Copyright 2011-2013 by C5 Insight