SQL Query (Basic SQL, Top 5, Where Equals, Append, Overwrite, Update, Sort Order ASC)

Basic SQL Queries in SFMC: https://elearningit24.atlassian.net/wiki/spaces/~7120200750f3d117454eeea44f735f580cbc36/pages/34734091/2.1+Basic+SQL+Queries+in+SFMC

Source DE:

Select ID,Name,Age From [Source DE]

Scheduled

Run Test

Top 5 (Name & Age)

Test Complete:

Target DE:

Top 5* & Where City = Bangalore:

Overwrite action:

Target DE after running test - 1 record

Append:
Add new data to your target data extension.

DE where new row data was added: (Subscriber Key should not be duplicate)

Update: Update Matching Data if found, if not found, new one is added.

Before Update there were 2 Records

After Update the number of records has been changed:

Sort Orders in Ascending Order (ASC)

Overwrite for ASC :

Comments

A/B Testing

Confluence link 1: https://elearningit24.atlassian.net/wiki/external/MzA3YWUxNjI3YzBkNGZiZmFlZTc1ZGIzYmU1ZmM1MmQ What is A/B Testing? A/B testing, also known as split testing , is a controlled experiment where two versions of a webpage, email, ad, or any digital asset are tested against each other to determine which one performs better. Why? Higher open rates Better Engagement Increased Sales and Lead conversion Reduced unsubscribed rates Date Driven- No assumption & Proven Results Test Type Subject Line Email Content Area From Name Send Date & Time Pre Header Email Test Template: Friendly and Personalised Straight to the point & Action Oriented Confluence Link 2: https://elearningit24.atlassian.net/wiki/external/NDk0Zjg0ODk3YjAwNDI5ZjkxOTVmMTAxNTQ3ZjlhNmQ Subject Line A/B Test: A/B Testing Use Case: Optimizing Email Subject Lines for Higher Open Rates Scenario- Subject Line: A company wants to increase the open rates of its promotional emails in Sa...

Email Marketing Campaings

Use Cases of Standard Data Extensions 1. Customer Data Storage Scenario : A retail business wants to store customer information, such as names, email addresses, and purchase history, for email marketing campaigns. Solution : Use a standard data extension to store and manage customer data securely and efficiently. Data Extension Structure Field Name Data Type Length Required Primary Key SubscriberKey Text 50 Yes Yes FirstName Text 50 Yes No LastName Text 50 Yes No EmailAddress EmailAddress N/A Yes No PurchaseHistory Decimal N/A No No Sample Records SubscriberKey FirstName LastName EmailAddress PurchaseHistory 001 John Doe john.doe@example.com 1500.50 002 Jane Smith jane.smith@example.com 200.00 https://mc.s8.exacttarget.com/cloud/#app/Email/C12/Default.aspx?entityType=none&entityID=0&ks=ks%23Subscribers

External Content Block/ Enhance Dynamic/ Send Management/ Code Snippet

External Content Block (Repair Pricing) https://mc.s10.exacttarget.com/cloud/#app/Email/C12/Default.aspx?entityType=none&entityID=0&ks=ks%23Content External content is any content stored outside your platform (e.g., websites, APIs, content management systems, external databases). It can include: ✅ Product descriptions & pricing (from an e-commerce website) ✅ Blog posts & news feeds (from external websites) ✅ Social media posts (Twitter, Instagram, LinkedIn feeds) ✅ Meta descriptions & templates ✅ Weather updates & live data feeds ✅ Customer-specific data (from CRM or CDP systems) In Salesforce Marketing Cloud ( SFMC ) , the External Content Block allows marketers to fetch real-time content from external URLs (APIs, websites, or content servers) and insert it into email templates dynamically. Updated URL> Link Validated> Retrieival Method: Immediately Retrieval Options: Subscriber Level( Content is retrieved separately for each recipient ) ...

GurbachanBlog

Search This Blog