Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Composite Score in Adobe Analytics - how to?

meagand84656201
Level 3
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
TanmayMathur
Correct answer by
Level 10
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
TanmayMathur
Correct answer by
Level 10
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

meagand84656201
Level 3
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!