I’m constantly faced with situations with data in Salesforce Marketing Cloud where I need to select or identify rows based on some ordered criteria. The row_number() over (partition by x order by y) as ranking is my go-to method.
This particular query finds a random row for each bounce category in the _bounce data view:
Recently, found this shorter method:See the gist on github.
https://www.youtube.com/watch?v=z5U5Kxrv6SY Good stuff from Hagerty's #RedlineRebuild series.
JUST DON'T schedule a meeting for me without checking to see if I'm available JUST DON'T repeatedly propose something to…
If you need to trigger one Marketing Cloud email to multiple recipients in a single REST API call, here's how…
https://www.youtube.com/watch?v=RE_dSJh5bvQ via Little Giants Construction Company