Skip to main content

I want to check how many users streamed a new song in the last 30 days

1 user can stream a song multiple times a day, We consider a user as converted if he streamed the song once a day - I want to check how many user where active on this song per day in the last 30 days 

I want to see how many users streamed the song 1 or 2 or 3 or etc days out of the last 30 days

Right now if I use HLIST or Frequency for the event started song  with song_name=<The song I want> 
This will count a user multiple times if a user streams the song multiple times a day, the frequency of the output can be >30 even if I am looking at only 30 days data. I want to aggregate that into a daily level. 
 

Essentially daily activation aggregate for this song, and frequency distribution of this daily activation 

Let me know if you want more clarification here. 

Example chart: https://app.amplitude.com/analytics/demo/chart/new/7m3ja4li

Hi Anuvind,

Thank you for reaching out. Happy to help!

You can use the 'count in interval' clause to define a cohort of users who performed an event on X days in any week in the past 30 days.

Here is an example: https://app.amplitude.com/audiences/org/3149/cohort/on1pg73w

I hope this helps. Please don't hesitate to let me know if you have any questions.

Best regards,
Thao


P.S. Checkout upcoming events and user meetups on our events page.

Reply