Expand my Community achievements bar.

Announcement: Calling all learners and mentors! Applications are now open for the Adobe Analytics 2024 Mentorship Program! Come learn from the best to prepare for an official certification in Adobe Analytics.

Any ideas on how to get an 'Active days per week/month' for a visitor?

Avatar

Level 1

Hi Community!

 

I'm hoping to create a calculated metric in adobe for 'average active days per user in a week/ month'. eg: If I was active (visited) on Mon and Wed this week, my number would be 2 for the week in question. In summary,  the days in a week or month on average that an app used. 

 

Do you think this is possible? 

 

Thank you!

Sonia

 

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

4 Replies

Avatar

Community Advisor and Adobe Champion

To do this you could use the "count distinct" function in a calculated metric.

To build it you just need to put the dimension "day" in there, and it will count the unique dates that appear. When you put this against a visitor ID of some type, the day will only populate if they visited the site on that day, so it will return the (approximate) number of days that they were on the site. This will work if you're looking at each visitor individually (one per row).

MandyGeorge_0-1717507451322.png

 

Avatar

Level 1

Thank you, @MandyGeorge ! 

I had got as far as the approx count distinct for 'days', but hadn't thought to put it against the visitor id dimension. 

I wonder if there's a way to create the whole thing as a calc metric? I had originally tried using the disc. count of days / unique visitors, but that doesn't create the desired outcome

 

Thanks again 

Avatar

Community Advisor and Adobe Champion

That's one of the difficult things with a lot of the functions in calculated metrics. They require the information to exist in each individual row to be able to do calculations.

 

If you want to get an average across all visitors, take the distinct days metric and put it inside the "mean" function. That'll give you an average, but you still need your visitor id in the rows for it to work.