Calculated Metric for Average Page Views

Avatar

Avatar
Validate 1
Level 2
tomk61257382
Level 2

Likes

4 likes

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Ignite 1
Give Back
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
tomk61257382
Level 2

Likes

4 likes

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Ignite 1
Give Back
Boost 3
Boost 1
View profile
tomk61257382
Level 2

09-11-2015

Hello,

I am attempting to build a calculated metric to provide the average (mean) number of page views over a time period.  Tried using the Mean function which seems to work in preview but is incorrect in a Metrics reportlet.  Here is my calculation:

 List Builder Segment   (Mean ( metric Page View Summary include zeros true) ) ) 

Additional attempts to construct a metric and use it as a denominator have also failed.

Function Count  (Calendar Day (v16) Instances)

AND

Segment List Builder (Page View Summary (Count(Page View Summary) ) )   

Again, in the preview panel it seems to count the number of days or calculate an appropriate result but whne the metric is inserted in the Site Metrics Reportlet the results is not calculated as expected.

Thanks!

Tom  

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 1
Level 1
abhiramt
Level 1

Like

1 like

Total Posts

1 post

Correct reply

1 solution
Top badges earned
Boost 1
Affirm 1
View profile

Avatar
Boost 1
Level 1
abhiramt
Level 1

Like

1 like

Total Posts

1 post

Correct reply

1 solution
Top badges earned
Boost 1
Affirm 1
View profile
abhiramt
Level 1

14-05-2019

Hi Tom,

If you're looking for calculating the Average daily visits/visitors then creating a calculated metric would come handy. Hope this helps.

Thank you!

Screen Shot 2019-05-14 at 4.30.24 PM.png

Answers (5)

Answers (5)

Avatar

Avatar
Establish
Employee
hyderziaee
Employee

Likes

228 likes

Total Posts

465 posts

Correct reply

222 solutions
Top badges earned
Establish
Coach
Contributor
Shape 1
Give Back 25
View profile

Avatar
Establish
Employee
hyderziaee
Employee

Likes

228 likes

Total Posts

465 posts

Correct reply

222 solutions
Top badges earned
Establish
Coach
Contributor
Shape 1
Give Back 25
View profile
hyderziaee
Employee

23-06-2017

Hi Felipe,

So the first step would be to get the calculated metric

1236765_pastedImage_1.png

Once done you can get the values in two ways in Analysis Workspace:

1. Months broken down by Days

1236766_pastedImage_3.png

Here the months will show the average visits across all months (example: 90388). However, the day breakdown will show the average daily visits across each month (example: 3026, 3052, 2975 and 3004). I have collapsed all days to have just the average daily number shown

2. Cross-tab between months and days

1236767_pastedImage_6.png

I have got the days as a dimension column in the table. The months are under the average visits metric as column each. Again, I have the day metric collapsed, so that only the concerned number is seen.

I understand, both these methods are not very refined, but they are easy to create. If want to have refined and a solution that you do not have to tweak continuously, I would recommend Report Builder.

Avatar

Avatar
Level 1
feliped34277437
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
feliped34277437
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile
feliped34277437
Level 1

22-06-2017

Hi,

I'm also looking at a custom metric for "Average Daily Number of Visit per Month":

example:

  • i have 100 visits in Jan = 100/31 = 3,23 visits per day
  • i have 100 visits in Feb = 100/28 = 3.57 visits per day
  • etc.

Any ideas? ts very simalar to the previous asked question on Avg. num of visits for the time period selected"

Thanks!

Felipe

Avatar

Avatar
Validate 1
Level 2
lesliea25900412
Level 2

Likes

11 likes

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
lesliea25900412
Level 2

Likes

11 likes

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
lesliea25900412
Level 2

18-05-2017

I have the same question but see that there is no response posted here. Do you happen to know if there is a way to do this? I'm trying to create similar time-based averages for Pageviews in Workspace. Thanks!

Avatar

Avatar
Validate 1
Level 2
tomk61257382
Level 2

Likes

4 likes

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Ignite 1
Give Back
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
tomk61257382
Level 2

Likes

4 likes

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Ignite 1
Give Back
Boost 3
Boost 1
View profile
tomk61257382
Level 2

25-11-2015

Hi TanmayM,

Thanks for taking the time to look into my query. 

I am interested in building custom metric calculations for the following in this order of priority:

1) Average Number of Page Views for a the Time Period Selected - Page Views/Days (Average Daily Page Views)

2) Average Number of Visits for the Time Period Selected - Visits/Days (Average Daily Visits)

3) Average Number of Visitors for the Time Period Selected - Visitors/Days (Average Daily Visitors)

These metrics would allow us to benchmark against the High Volume or High/Low Dates and Values Reportlet in a Dashboard.

Thanks!

Tom

Avatar

Avatar
Validate 250
Level 10
TanmayMathur
Level 10

Likes

245 likes

Total Posts

1,193 posts

Correct reply

422 solutions
Top badges earned
Validate 250
Validate 100
Validate 25
Validate 50
Validate 10
View profile

Avatar
Validate 250
Level 10
TanmayMathur
Level 10

Likes

245 likes

Total Posts

1,193 posts

Correct reply

422 solutions
Top badges earned
Validate 250
Validate 100
Validate 25
Validate 50
Validate 10
View profile
TanmayMathur
Level 10

24-11-2015

Hi Tom, 

Apologies for a delayed response.

I would like to have some more information on the type of metric you want to create. Will it be a daily average page views or a average total page views or average page views per visit? All of them would require a different approach.

Thanks!

TM