Composite Score in Adobe Analytics - how to?

Avatar

Avatar

meagand84656201

Avatar

meagand84656201

meagand84656201

17-03-2017

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

TanmayMathur

Employee

Total Posts

1.2K

Likes

241

Correct Answer

421

Avatar

TanmayMathur

Employee

Total Posts

1.2K

Likes

241

Correct Answer

421
TanmayMathur
Employee

20-03-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...

Thanks,

Tanmay

Answers (1)

Answers (1)

Avatar

Avatar

meagand84656201

Avatar

meagand84656201

meagand84656201

20-03-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...

Thanks,

Tanmay

 

Thank you so much Tanmay!