How do you create Average Deal Size (Won) key figure using Lead Funnel data source basic key figure?

[former_member702923]

Hi Sir/Madam,

I want to use the key figure in Sales Effectiveness Scorecard key structure in my custom data source. However due to key figure group/structure does not support to use in custom data source, I need to create those key figure. But my issue now is I couldn't find any basic key figure to create them, how should I proceed?

One example key figure I need to create: To create Average Deal Size (Won) key figure using Lead Funnel data source basic key figure.

Appreciate your assistance on this.

Thanks.

[former_member226]

Hi,

You can very well create a custom key figure just by checking the documentation of the standard base key figure. It will give you an idea about how SAP is calculating those key figures. YOu hrightly said that you cannt use key group but you can still see their documentation and try to design your own key figure.

For example, you want to design "Average Deal Size (Won)" for your data source then you can first check "Sales Effectiveness Scorecard" documentation. This clearly tells that It is calculated as "EQUAL([Total Revenue (Won)])". (URL: https://my30XXXX.crm.ondemand.com/sap/bc/mdrs/cdo?compname=average_deal_size_won&objname=codmklefu_s... ) Now you can how "Total Revenue (Won)" is calculated.(https://my30XXXX.crm.ondemand.com/sap/bc/mdrs/cdo?compname=won_revenue&objname=codmklefu_str_01&type=ui_mkfc_component) here you will find that it just takes "Expected Value" of all WON opportunities.

[former_member702923]

Hi Saurabh Kabra,

Thanks for the answer. I can't access to both link you sent. my30xxxx.crm.ondemand.com’s server IP address could not be found. Is there any way I can access them? Thanks in advance.

[former_member226]

Hi,

You need to replace my30xxxx with your C4C hostname like my312345.

[former_member702923]

Hi Saurabh Kabra,

Thanks for clarifying. After seeing through them, I sort of understand how to create.

Just to be more clear, after I drilled down on both of these key figure's documentations, they have the same calculation am I right?

If yes, then what is the difference of both in Sales Effectiveness Scorecard?

Average Deal Size (Won) and Total Revenue (Won) in Sales Effectiveness Scorecard (https://my30XXXX.crm.ondemand.com/sap/bc/mdrs/cdo?compname=won_revenue&objname=codmklefu_str_01&type=ui_mkfc_component)

Thanks in advance

Regards,

Win Nee

[former_member226]

Hello Win Nee Yau,

Though both key figures look the same from the calculation point of view BUT they are not the same. In Key figure "Average Deal Size (Won)", there is an exception aggregation define which calculates the average of "Total Revenue (Won)" splitted over all opportunities as shown below:(i.e. Average Deal Size (Won) = Total Revenue (Won) / Number of opportunities)

Hope it clearifies your doubt!

[former_member702923]

Hi saurabh.kabra

Thanks for the clear explanation. Another issue I am facing - I want to create Sourced from Leads key figure (from Sales Effectiveness Scorecard key figure structure) in Opportunity Header and Item data source.. However, couldn't find the characteristics to create..

How should I create that key figure in Opportunity Header and Item data source in this case?

Looking forward to your reply.

Thanks,

Win Nee

[former_member226]

Hello,

I am glad that it helped you.

Since the main issue has been resolved hence can you kindly mark this thread as closed so that others can utilize the solution/discussion?

Thanks

Saurabh

PS: I see you already opened as a new thread for the question about, let it handle there.