SQL Row_Number - Salesforce Marketing Cloud Functions in 5 minutes
3.6 هزار بار بازدید -
3 سال پیش
-
Cameron Robert shows how to
Cameron Robert shows how to use the Row Number (Over Partition By) SQL function in Salesforce Marketing Cloud.
The SQL Row Number function can be used in Marketing Cloud to segment your data so that it is more easy to reference in your emails using AMPscript. For example, creating lists of products or content recommendations to make your emails more dynamic.
The SQL Row Number function is also very useful for segmenting your subscriber engagement data (from the Sends, Opens and Clicks Data Views) to create Re-Engagement Journeys!
Key Moments:
Introduction (0:00)
SQL Row_Number Documentation (0:14)
Example SQL Row_Number Code (0:37)
SQL Row_Number Code Demonstration (1:05)
Summary (2:43)
SQL Row_Number Documentation:
https://www.sqlshack.com/overview-of-...
https://www.sqlservertutorial.net/sql...
https://learnsql.com/cookbook/how-to-...
Contact:
LinkedIn: camrobert
https://www.cameronrobert.com.au/
Twitter: AusCamRobert
Music: https://www.bensound.com
The SQL Row Number function can be used in Marketing Cloud to segment your data so that it is more easy to reference in your emails using AMPscript. For example, creating lists of products or content recommendations to make your emails more dynamic.
The SQL Row Number function is also very useful for segmenting your subscriber engagement data (from the Sends, Opens and Clicks Data Views) to create Re-Engagement Journeys!
Key Moments:
Introduction (0:00)
SQL Row_Number Documentation (0:14)
Example SQL Row_Number Code (0:37)
SQL Row_Number Code Demonstration (1:05)
Summary (2:43)
SQL Row_Number Documentation:
https://www.sqlshack.com/overview-of-...
https://www.sqlservertutorial.net/sql...
https://learnsql.com/cookbook/how-to-...
Contact:
LinkedIn: camrobert
https://www.cameronrobert.com.au/
Twitter: AusCamRobert
Music: https://www.bensound.com
3 سال پیش
در تاریخ 1400/06/11 منتشر شده
است.
3,675
بـار بازدید شده