Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Goals by Customer
Microsoft Dynamics CRM (Archived)

Goals by Customer

(0) ShareShare
ReportReport
Posted on by Pawel P 70

Hello.

I have a problem with Goals. In CRM I have Goals made by Key Account Manager which is good because I can see who is best seller etc.

Now I must add new Golas by Customer (I must see how much we sold by every company we cooperate and made a financial goal for them). I have no idea how to do it while in Goals manager I can only select Users and Groups and I cant get data from any non numerical field from for example oportunity. If I could I would read Customer or End-User field and would be good :).

Do you have any idea how to do it?

Thx a lot for help.

Regards

Paweł

*This post is locked for comments

  • nplima Profile Picture
    nplima 540 on at
    RE: Goals by Customer

    When you create your Goal, towards the bottom of the form there's a tab called "Goal Criteria".

    That's where you choose the Rollup query that goes with the goal record.

    (at least in Dynamics 365 that's where it is!)

  • Pawel P Profile Picture
    Pawel P 70 on at
    RE: Goals by Customer

    Thats interesting because I have second instance with CRM 2015 version and I would test it. I found how to make rollup field but I have no idea how to get data from this field to goals. Have you any idea about that?

  • Suggested answer
    nplima Profile Picture
    nplima 540 on at
    RE: Goals by Customer

    Hi Pawel,

    One thing you could do is to set up an additional goal, still based on the Opportunity revenue, but with a filter on the customer name.

    This would be at the expense of having double the admin effort in setting up your goals, but I think it would work out. I haven't tested it, I was just revising for the sales exam and then saw your post :)

    Essentially, when you set up your sales goal for each person, add a separate goal that has associated a Rollup Query where the Customer = [that specific account you need].

    This is in the module 04 of the course 81056AE: Sales Management in Microsoft Dynamics 365.

    or here, in help: www.microsoft.com/.../create-or-edit-a-goal-rollup-query-sales.aspx

    Hope it helps.

    Nuno

  • ashlega Profile Picture
    ashlega 34,475 on at
    RE: Goals by Customer

    Hi,

     I think the problem is that goals are designed to be for the users, not for the customers.

     If you wanted to have some sort of aggregated value on the account level, a rollup field would probably work.. but, if you are on 2013, you might not have rollups there:

    technet.microsoft.com/.../dn832162.aspx

     If that's the case, then you may need to develop something

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans