I've got a Junction Object between Artists and Songs that uses a related list to track when an Artist guest-appears on a Song (Jay-Z featuring Nas, for example). Additionally, I have a Lookup field on every Song record associated to an Artist.
When a Song is played, we log a completed Activity to track. What isn't being tracked on the Artist Object is the number of times an Artist is on a Song that was played (completed Activity logged) in which he/she was the guest Artist, not the Artist designated by the Lookup field.
How would I track this?
Detailed explanation: Artist Lupe Fiasco makes a guest-appearance on Artist Kanye West's Song "Touch The Sky". This is tracked with the Junction Object between Artist and Song Objects and their corresponding related lists. Additionally, when "Touch The Sky" played a completed Activity was logged. This was tracked on the Song record Actvity History related list as well as Artist Kanye West's Activity History related list. But it was not tracked on Artist Lupe Fiasco's Activity History related list.
Thanks for any and all help.
Best,
Brooks
1 answer
To use roll-up summaries, which allows you to do counts, you need a master detail relationship. so, you'd use a custom object in place of activities. This can end up being better for many reasons as you'll have more flexibility long term.
Then create a roll-up summary to do a count. You can also filter the count, to get metrics on specifics, like song plays from a different source, or whatevah.
If the additional custom object is not an option, there's a couple tools which allow you to do roll-ups. https://developer.salesforce.com/page/Declarative_Rollup_Summary_Tool_for_Force.com_Lookup_Relationships
https://appexchange.salesforce.com/listingDetail?listingId=a0N30000009i3UpEAI
Also, the new Process builder may help here, although I wouldn't have specific instructions :( I should go play with it and find out though...
Just out of curiosity, do you have a salesforce app, or do you provide a streaming service? Love music, so you peaked my curiosity.
