percentage of row / create a ratio | Community
Skip to main content
Amigo1989
Amigo1989
New Participant
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

    Show previous replies
    Urs_Boller
    Urs_Boller
    New Participant
    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
      New Participant
      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!

      PratheepArunRaj
      PratheepArunRaj
      New Participant
      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

        Terms & ConditionsAccessibility statement

        Loading footer...