Composite Score in Adobe Analytics - how to?

[meagand84656201]

Hello!

To give our merchandising team a quick view of product performance at an individual product level we are trying to create a composite score that provides a single 1-5 (or similar) score for each product, based on the performance of RPV, Conversion and Exit Rate of each PDP. I see that at the Summit POPSUGAR showed how they used composite scoring in Adobe Analytics but NO WHERE online can I find a place that shows me how to create a composite score. I know what formula I would use in Excel (nested IF) but that doesn't translate to AA. Can anyone help me with tips/tricks/suggestions?

Thank you!

Meagan

[TanmayMathur · Accepted solution]

Hi Meagan,

Welcome to the Analytics Community! 

I think what you are referring to is called Derived Metrics. It has been there in Ad-hoc and now in Analytics too. This is a great post on derived metrics and it should be the thing you are looking for http://www.digitalbalance.com.au/our-blog/how-to-use-derived-metrics/

This post by Adam Greco should also give some additional insights - https://www.linkedin.com/pulse/engagement-scoring-adobe-analytics-derived-metrics-adam-greco

Also, I would encourage you to Introduce yourself to the community as well - http://help-forums.adobe.com/content/adobeforums/en/analytics-forum/adobe-analytics.topic.html/forum...

Thanks,

Tanmay

[meagand84656201]

TanmayM wrote...

Hi Meagan,

Welcome to the Analytics Community! 

I think what you are referring to is called Derived Metrics. It has been there in Ad-hoc and now in Analytics too. This is a great post on derived metrics and it should be the thing you are looking for http://www.digitalbalance.com.au/our-blog/how-to-use-derived-metrics/

This post by Adam Greco should also give some additional insights - https://www.linkedin.com/pulse/engagement-scoring-adobe-analytics-derived-metrics-adam-greco

Also, I would encourage you to Introduce yourself to the community as well - http://help-forums.adobe.com/content/adobeforums/en/analytics-forum/adobe-analytics.topic.html/forum...

Thanks,

Tanmay

Thank you so much Tanmay!