SQL use cases Subodh

 SQL use cases

Query 1 ) SELECT *
FROM [Subodh_Source]
WHERE EmailAddress LIKE 'john____%@example.com%'


Target DE:


Query 2 ) SELECT *
FROM [Subodh_Source]
WHERE Country_Code LIKE 'I__'


Target DE:















Comments

Post a Comment

Popular posts from this blog

Job link subodh

Image
 Job link A Job Link is a system-generated link used to track email activity at the send/job level . Email Studio > Email > Tracking > sends https://mc.s10.exacttarget.com/cloud/#app/Email/C12/Default.aspx?entityType=none&entityID=0&ks=ks%23Tracking Created one template-based email  https://mc.s10.exacttarget.com/cloud/#app/Email/C12/Default.aspx?entityType=none&entityID=0&ks=ks%23Content and checked 1) Job link before email send 2) Job link before opening email 3) Job link after opening the email
Read more

SQL continuation in SFMC Subodh

Image
 SQL continuation in SFMC What is TOP ? Think of TOP as a VIP pass. In SQL terms: TOP N = fetch first N records from your data set. Works with or without sorting , but sorting makes it predictable. Source DE: Query Activity SELECT TOP 5 * FROM [subodh_DE] We get the option to  i) Append - Add new data to your target Data Extension (DE). ii) Update - Update matching data, if found. If a record is not found, a new one is added. iii) Overwrite - Replace or overwrite the current data in your target DE. Target DE: SFMC SQL: Understanding the WHERE Clause – Filtering Data The WHERE clause in Salesforce Marketing Cloud ( SFMC ) SQL is used to filter records based on conditions, making queries more targeted and efficient. It helps select only the necessary data rather than retrieving all records. Query Activity Query  1 ) SELECT TOP 5 * FROM [subodh_DE] WHERE PurchaseAmount >= '750' Target DE: Query  2 ) SELECT TOP 5 * FROM [subodh_DE] WHERE PurchaseAmount >=...
Read more

Publication list Subodh

Image
  Create Publication List Send Mail (Create DE with your record) Start Sending Mail Check Publication List Unsubscribe Again Check Publication List Status CReate New Publication List Follow Same Process Created publication list and send email SFMC>Email Studio>Email>Subscribers>All Subscribers>Publication Lists Publication list status after unsubscribe Recreated the publication list to send to the subscriber SFMC>Email Studio>Email>Content Publication list status 
Read more