Building a segment off of a metric output. Is it possible or impossible? | Adobe Higher Education
Skip to main content
F
FPW_AA
Level 2
May 30, 2024
Pregunta

Building a segment off of a metric output. Is it possible or impossible?

  • May 30, 2024
  • 2 respuestas
  • 683 visualizaciones

Related to this question: https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/workaround-for-calculated-metric-inside-a-segment/m-p/238112

 

If I build a calculated metric, let's say average clicks per session for sessions that hit xyz page. I get my output in the freeform and it says 15 clicks, I then want to see the time on site for users who met the criteria of 15 clicks on average. I thought I could create a segment for that group with that value but I'm not having any luck. Am I trying to do something that simply isn't possible to do in Adobe Workspace? Seems like that was the case years ago (based on the post), but is that still the case? Any suggested workarounds? 

Thanks!

Este tema ha sido cerrado para respuestas.

2 respuestas

pradnya_balvir
Community Advisor
pradnya_balvirCommunity Advisor
Community Advisor
May 31, 2024

Hi @fpw_aa ,  Building a new segment from calculated metric is not possible in the tool currently.

I would like to suggest, create your report using your calculated metric and avg. time on site metric for pages in the workspace and download it to csv and apply your formula (criteria of 15 clicks on average) in excel and check the results.

 

 

MandyGeorge
Community Advisor and Adobe Champion
MandyGeorgeCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
May 31, 2024

While you can't do this in a segment, there are logical tests that you can do in calculated metrics. 

 

I'm assuming that you're starting with a table where you have a column for your calculated metric, and that your dimension on the side is some kind of visitor or session ID. So you can see average clicks per person/session. 

 

What you want to output is for those users that have an average of 15 clicks, return the time on site.

 

Steps:

In your calculated metric builder, start with an IF function. In the logical test box, put the EQUALS function (if you want avg clicks to be exactly 15, other options are greater than/less than functions).

In metric X put your avg click metric. For metric Y you're going to use a static number and put 15 (or whatever value you want to compare it to).

In value if true, put your time on site metric. And for value if false, put 0.

 

 

The result of this will be that it is going to compare your avg clicks to the static number of 15. If it matches, it'll return their time on site, and if not it'll put a 0 there. So it won't completely exclude those people, but you can sort by the column and the 0's will always be at the bottom.

 

    Términos y condicionesAccessibility statement

    Loading footer...