Skip to main content

Hi guys,

 

Considering the AmpliTunes example where there is a “Play Song or Video” event with a “Content_ID” property. I’m interested to find the average amount of times a song is played per duration (hourly, daily, weekly, etc. dropdown). Is there an advanced formula to count the unique content_id’s and then divide them by the number of users to somehow get a number like on average, each song is played 1.2 times per user?

 

I started on something like this, but got completely lost. Would appreciate any help! Thanks!

https://analytics.amplitude.com/demo/chart/new/uwvn0gb

 

 

Not 100% clear which average you want (songs per user per song, users per song, plays per song, plays per user per song … etc) - but if you switch that chart link to the “average” tab then I you get one meaningful average :)

  Hi Timothy,

 

Thanks for your reply! Pulled up the average and not exactly seeing what I was looking for - https://analytics.amplitude.com/demo/chart/new/a19irm2. Could you confirm the insight from this report is: That on average, users played 15 songs per day? How can each individual song get played 1.xx times?

 

The results I am looking for are:

Goo Goo Dolls Iris gets played 10 times per day.

On average, a user plays Goo Goo Dolls 5x per day and ignore the people who play it 0?

This let’s me derive or know that 2 people played it 5x per day to get the 10 number.

 

Hope this isn’t too confusing. Thanks for answering!

Reply


Terms & ConditionsCookie settings