Dynamics CRM Goals

Leave a comment

Dynamics CRM has the ability to manage goals. This allows managers to review team and individual goals across different timelines.

Goals are accessed from the main CRM menu:

Here, we opened Goals from the Sales area. If we were in the Service area, or another area, it would still open the same goals. Selecting Goals opens the My Active Goals view:

Clicking on Goal for Q1 (Sample) we can see goal details:

If we click on Goal Metrics from the main menu, we see all the goal metrics listed:

Clicking on the Revenue goal metric we can see it is of type Money and the metric count is Amount:

There are a couple of roll-up fields defined. Let’s look at Actual:

In this case, the following is happening:

  1. 2 Rollup Fields are created to measure the totals of the:
    1. Actual revenue on opportunities won
    2. Estimated revenue on opportunities won
  2. Once we have these fields rolling up, we create a Goal Metric. Here we specify what type our goal is, i.e. an amount or a count. If it is an amount, is it money, decimal or integer type. And then the rollup fields associated with this goal metric.
  3. We create a Goal. We tell it what is the goal metric, and the period for the goal (fiscal period and fiscal year, or custom period of dates). We then set the actual amount that is our goal, i.e. $10,000.

So to go through the example above:

  1. 2 rollup fields look at the actual and estimated revenue for opportunities.
  2. We have a goal metric Revenue of type money that has these rollup fields.
  3. We have a goal for Q1, 2013 for the Revenue goal metric that has a target of $30,000.

If we scroll down we can see the actual numbers associated with our goal:

You can see in this case both the actual numbers are 0. Let’s recalculate this:

This has no effect as there were no opportunities in this time period for this goal. Let’s create a more recent time period goal and enter an opportunity:

Based on my opportunities:

We can see the goal estimated is $10,000:

If we close an opportunity for $20,000 we see the Actual amount has increased:

As an employee you can monitor your goals by viewing the out of the box charts:

Rollup queries can also be defined and assigned:

Under goals in the main menu, you can access Rollup Queries:

You can see there is logic behind these queries like in Advanced Find:

This can allow you to filter your rollups further.

At present there is no way to create recurring goals in CRM, but you could work around this by creating a workflow to create goals, or use data import to create a mass number of goals.

If you wanted to create parent goals, create a new goal:

On your child goals, assign the parent:

The parent goal will now show the child goals:

And recalculating the parent goal will take into consideration the child goals:



Carl de Souza is a developer and architect focusing on Microsoft Dynamics 365, Power BI, Azure, and AI.

carldesouza.comLinkedIn Twitter | YouTube


Leave a Reply

Your email address will not be published. Required fields are marked *