Level 3

Solved

percentage of row / create a ratio

Forum|Forum|7 years ago
May 21, 2019
13 replies
8145 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:

Analytics

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"

Show previous replies

Amigo1989Author

Level 3

hi ursboller

thanks for answering:

so this is what the metric should look like for this example (for the dimension "IQ Nummer") if i want to get view but not click?

to c) i think i do not exactly get the problem. so let's talk about our case with the dimension "IQ Nummer" which is an evar. if we now assume that this dimension "IQ Nummer" is part of a Hit-Segment, everything what happens within this hit is measured, because it's evar? Where in this case is the difference between hit and call? So is everything what happens during the hit (Hit Segment "IQ-Nummer = xxx") is one single call? Because you said, that AdClick and AdView are two different calls. what would be about what happens within the hit-Segment "IQ Nummer". so how Can i identify if something is not part of one single call respectively what are different calls.

Thank you very much!

Urs_Boller

Community Advisor

first, the calculated metrics looks ok for me, but I would prefer to have separated segments for "views" and "clicks". but I assume that there wouldn't be a difference in the result.

regarding c)

it gets difficult as soon as we get deeper into details without me knowing the implementation. basically, when talking about a call, it's a single "server call" (the b/ss beacon sent to adobe). if you investigate on a certain call you take a "hit-segment" (1 call = 1 hit)

I assume that the user on your page has a view in the first call/hit and the can decide either to click or not (the click would result in a second call/hit).

if this is true, extracting the user that haven't clicked is a little bit difficult and might depend on the use case. the easiest way is to search for "visits where user had a view but no click", so basically create a "visit segment" where view and exclude all visits who had a click... I'm sure there are more options to create a segment...

jantzen_b

Adobe Employee

Do any of these replies provide an answer to your original question? If so, please mark the most correct answer. If not, can you provide some additional details to help the community better answer your question.

Sign up

Login with SSO

Login to the community

Login with SSO