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


Terms & ConditionsCookie settings