Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

Composite Score in Adobe Analytics - how to?

Avatar

Level 3

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

1 Accepted Solution

Avatar

Correct answer by
Level 10

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

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

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

Avatar

Level 3

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!