percentage of row / create a ratio | Community
Skip to main content
Amigo1989
Level 3
May 21, 2019
Solved

percentage of row / create a ratio

  • May 21, 2019
  • 13 replies
  • 8098 views

hey guys,

just one question: is there any possibility to get the percentage of the row in this case? So i mean something like "percentage of row" which is not available? in this case i need something like a click / view Ratio. so i have created two segments, where on the one hand just clicker on an advertising are counted and on the other hand just the viewer but not the clicker on an Advertising are counted. what I need now is the ratio of the clicker to the viewers, because i want to know, how many users, who have viewed an add, also clicked on that add. or do i need a calculated metric? because on this screensot i just see the percentage of the column.

Thank you very much!

Click-Segment:

View-Segment:

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 Urs_Boller

ok, try to explain how I would setup the segments

1) "view segment"

hit-container where "c99" = "x" AND "AdClick view" exists

2) "click segment"

visit container where "c99" = "x" THEN within 1 hit "AdClick click" exists

3) metric "visit clickthrough %"

calculated metric with "clicked" (visits) / "view" (visits)

Problem: since you save it as a prop, you can't get the real numbers (real click through rate), your lowest level is visit! means if a user had a clickthrough twice in the same visit it would just count as 1

if you save your c99 as an evar (maybe with a short expiration on the click event), you could change the "click" segment to a "hit"-segment where "evar=x and click exists"

13 replies

PratheepArunRaj
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
May 21, 2019

Dear Amigo,

As i understand, i guess it is upfront Calculated Metrics : Adclick Click / Adclick View in %. If you subtract the % from 100, then it will give the number of customers who viewed but didn't click.

Thank You!

Arun

Thank You, Pratheep Arun Raj B (Arun) | Xerago | Terryn Winter Analytics
Amigo1989
Amigo1989Author
Level 3
May 21, 2019

hey,

thank you! so i can create two calculated metrics, is that correct? on the one hand the proportion of the clicker to the viewer (Adclick Click / Adclick View in %) and on the other hand i can substract the % of this result from 100  and i get the number of customers who viewed but didn't click?

thank you!

Urs_Boller
Community Advisor
Community Advisor
May 21, 2019

Hi Amigo1989

support the idea from PratheepArunRaj​ to use calculated metrics. but I'm not sure if youre segments are right...

just a view questions:

1) do you have 2 server calls, like one for "view" and "click"? if yes, the "hit" segment with both "view" and "click" together does not work

2) for the "view" segment I would not exclude the "click". since everybody who has clicked must have seen (view) the desired item, right? and changing the segment would allow to calculate "click"/"view" to get the "click-through-rate"

Amigo1989
Amigo1989Author
Level 3
May 22, 2019

Hi @ursboller

thanks for answering

1) Do you mean related to my "view segment" with "AdClick View" and "Adclick Click"? so if there are two server calls, my hit-segment for the view-segment would not work, because just one hit single hit is counted? So just my view would be counted in this segment and not the click? how do i get only the views, if this are 2 server calls?

2) what i want to capture are the users who have just viewed an advertising but not have clicked. so if i do it like you explain i can not see the users, who just have viewed the Advertising, Right?

Maybe you can help me

PratheepArunRaj
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
May 22, 2019

Yes Amigo,

You wont get the number of Customers, but the % of Customers.

Thank You!

Arun

Thank You, Pratheep Arun Raj B (Arun) | Xerago | Terryn Winter Analytics
Urs_Boller
Community Advisor
Urs_BollerCommunity AdvisorAccepted solution
Community Advisor
May 22, 2019

ok, try to explain how I would setup the segments

1) "view segment"

hit-container where "c99" = "x" AND "AdClick view" exists

2) "click segment"

visit container where "c99" = "x" THEN within 1 hit "AdClick click" exists

3) metric "visit clickthrough %"

calculated metric with "clicked" (visits) / "view" (visits)

Problem: since you save it as a prop, you can't get the real numbers (real click through rate), your lowest level is visit! means if a user had a clickthrough twice in the same visit it would just count as 1

if you save your c99 as an evar (maybe with a short expiration on the click event), you could change the "click" segment to a "hit"-segment where "evar=x and click exists"

Amigo1989
Amigo1989Author
Level 3
May 23, 2019

hey,

ok, so the dimension "IQ Nummer" is an evar:

if i unterstand you correctly, this is how my segments should look like:

Click Segment:

View Segment:

Calculated Metric:

Just one question: why can i change to hit if this dimension is evar?

Thanks!

Urs_Boller
Community Advisor
Community Advisor
May 23, 2019

hey, great you use an eVar, would create the segments the same way.

why hit-segment with eVar? because (depending on timeout) the eVar will keep the value while the prop is only available on the hit level. imagine two simple call: first for "view" (having the value c99), the second for the click. if you write the value c99 to a prop, the "click" has no clue what was set before (prop expired). but using an eVar, the c99 will be available. that means with an eVar you can change to a hit-segment checking the click and the c99.

Amigo1989
Amigo1989Author
Level 3
May 27, 2019

hey, thank you

1. so it does not matter, if the dimension is evar or prop, "view" and "click" can never be on the same hit (due to 2 server calls)?

But Dimension (IQ Nummer) and - for example - Metric (AdClick Click) would work on the same hit?

​2. yes, this is exactly what i want to show: i want to create a segment for "viewed but not clicked". This is why i want to exclude the clicks.

Urs_Boller
Community Advisor
Community Advisor
May 27, 2019

Hi Amigo1989

just a few points:

a) you need to add your segments to the calculated metric. otherwise you would not have a filter on the desired "c99"

b) "view" and "click" are most likely not on the same call (regardless the prop/eVar discussion)

c) if you have a hit-segment, you can add filters an every dimension you have on the call. and even add conditions for persistent values, eg. if you set an eVar earlier in the visit...

d) to get the "view but not click" you have several options: first, if you only need the number, you can create a calc. metric "1 - click/view" (by using the calc. metric from above). if you need a segment to use in other adobe solutions, you might create another segment where you check for visits (or visitors) who had viewed the c99 but then not clicked.