the personal blog of adam spriggs
This comes up a lot — trouble joining the _Journey and _JourneyActivity data views. The issue is that the VersionID is a UniqueIdentifier data type behind the scenes. The workaround is to cast/convert it to a varchar(36):
I like to maintain a list of Journey _Job records beyond the 6 month lookback threshold for the data views. You can apply the same VersionID join trick on this one also:
The Final Countdown by Europe covered expertly by The Floppotron 3.0.
Original song is here.
Counting THIS IS THE WAY in The Mandalorian seasons 1-3.
Sometimes it’s handy having a list of Content Builder Assets by folder in a Data Extension, especially for migrating Package Manager.
Before you add this Script Activity in Automation Studio, add your API creds and update the Category ID for your target Data Extension. You can also update the query criteria starting on line 91, if needed.
As always, let me know if you have any feedback in the comments below (or on Github).
Instrumental version here.