Average Number of Days in a Month a Segment of Visitors Visits

Avatar

Avatar
Validate 1
Level 1
alexjbaker11
Level 1

Likes

0 likes

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
alexjbaker11
Level 1

Likes

0 likes

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
alexjbaker11
Level 1

26-05-2021

Hi,

 

I have a segment of visitors, let's call them "subscribers".

 

I want to know how many distinct days in a month on average this segment of visitors visits my site.

 

Sounds fairly simple in my head but can't quite figure it out!

 

Thanks,

Alex

 

 

View Entire Topic

Avatar

Avatar
Establish
Level 5
ashokkumarm
Level 5

Likes

87 likes

Total Posts

56 posts

Correct reply

12 solutions
Top badges earned
Establish
Contributor
Shape 1
Give Back 10
Give Back 5
View profile

Avatar
Establish
Level 5
ashokkumarm
Level 5

Likes

87 likes

Total Posts

56 posts

Correct reply

12 solutions
Top badges earned
Establish
Contributor
Shape 1
Give Back 10
Give Back 5
View profile
ashokkumarm
Level 5

26-05-2021

Hello Alex,

 

Using Calculated Metrics we can calculate the Average Subscribers based on number of days in the below sample (we have used Unique Visitors instead of Subscribers)

 

Example: In Calculated metric we have used the function Approximate Count Distinct to calculate the number of Days, then we have divied the Unique Visitors (you can use your subscribers metric here) data with that function result.

 

ashokkumarm_0-1622036361270.png

 

Hope the above answer will helps you..!

 

Thanks

Ashok