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
