Composite Score in Adobe Analytics - how to? | Community
Skip to main content
meagand84656201
Level 2
March 17, 2017
Solved

Composite Score in Adobe Analytics - how to?

  • March 17, 2017
  • 2 replies
  • 2836 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by TanmayMathur

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__meq0-hi_everyonewea.html

Thanks,

Tanmay

2 replies

TanmayMathur
Adobe Employee
TanmayMathurAdobe EmployeeAccepted solution
Adobe Employee
March 20, 2017

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__meq0-hi_everyonewea.html

Thanks,

Tanmay

meagand84656201
Level 2
March 20, 2017

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__meq0-hi_everyonewea.html

Thanks,

Tanmay

 

Thank you so much Tanmay!