Calculated Metric - Return Total Visits of pages where a specific event happened | Adobe Higher Education
Skip to main content
I
Iamahmad
September 20, 2023
해결됨

Calculated Metric - Return Total Visits of pages where a specific event happened

  • September 20, 2023
  • 1 답변
  • 1553 조회

Hi all, 

 

I would like to build a calculated metric that checks if a specific event was triggered or not, then return the total number of visits of the pages where the event was triggered. 

 

To clarify, I do not want the number of visits where the event was triggered, I want total page visits. 

Example: A page could receive 3k visits where a button was clicked in only 1k visits, so I do not want the 1k, I am interested in the 3k. 

 

Is there such a way we could do that using calculated metrics? 

 

Thanks in advance. 

이 주제는 답변이 닫혔습니다.
최고의 답변: Jennifer_Dungan

I'm sorry, I am not quite understanding... You just want the visits where Page A was visited (i.e 3K visits)... I don't understand what logic you then need in regards to the button (i.e. 1K visits with button clicks) this seems completely unrelated to your segmentation. If you are tracking button clicks, and have a segment pulling back the 3K visits to the page, the overall clicks will be limited to those visits by the nature of the segment.

 

Now, if your end goal is to create some sort of calculated rate... ie. 1K clicks / 3K Visits = 33.33% click rate, you can just create segments that stack on each of those columns (Visits - stacked with the Visit "Page A" segment; and Clicks - if needed stacked with another segment that looks at Visits on "Page A" with a Click) and create your division calculated metric from those.... 

1 답변

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe Champion답변
Community Advisor and Adobe Champion
September 20, 2023

I'm sorry, I am not quite understanding... You just want the visits where Page A was visited (i.e 3K visits)... I don't understand what logic you then need in regards to the button (i.e. 1K visits with button clicks) this seems completely unrelated to your segmentation. If you are tracking button clicks, and have a segment pulling back the 3K visits to the page, the overall clicks will be limited to those visits by the nature of the segment.

 

Now, if your end goal is to create some sort of calculated rate... ie. 1K clicks / 3K Visits = 33.33% click rate, you can just create segments that stack on each of those columns (Visits - stacked with the Visit "Page A" segment; and Clicks - if needed stacked with another segment that looks at Visits on "Page A" with a Click) and create your division calculated metric from those.... 

I
Iamahmad작성자
September 20, 2023

Hi Jennifer, 

 

I have some pages within the help portal where users are able to call us & I would like to calculate the calls ratio to the total visits happening to those pages. 

 

i.e. This month, we received 200 calls from 10 pages. and those 10 pages have happened to receive 3k visits. 

And I do not have any dimension or segment that can be used to filter by those 10 pages. So when calculating the ratio, I would like the calculated metric to check this condition, you received 200 calls from this list of pages, and overall visits is xyz so that means the 200 / 3000? 

 

Is it possible to create a calculated metric to give me this ratio? 

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
September 20, 2023

Hi,

 

I do not have any dimension or segment that can be used to filter by those 10 pages

I don't understand why you cannot create a segment for those 10 pages... 

 

But let's look at the 200/3000 part of this.... if you already can see 300 Visits (using the Visits metric and some criteria to identify "help" pages), and you have 200 Calls (I am assuming identified by a custom eventX when a call is made)

 

In order to get your call rate, build out a freeform table with Visits as 1 column (you may need to apply a stacked segment on this column), and a "Calls" column:

 

 

OR

 

 

Select both columns, right click, choose "Create Metric from Selection", then select "Divide":

 

You will want to modify this new calculated metric to change the display from Decimal to Percent, and you may want to change the name (also, if you columns are in a different order in your table, you may need to adjust the division to be in the correct order in the calculated metric):

 

약관 및 조건Accessibility statement

Loading footer...