Posts

Landing page via Cloud

Image
  Cloud Page-Landing Page - (Naveen Dairy A2 Milk)  First, we have to create the Data Cloud landing page Then create an Image Block, Smart capture, and Text block for creating a registration form > Upload the image   > Edit the Text block as a registration form and design properly Drag n Drop the Smart Capture   > Registration form > Data target as Data extension  > Select the data extension as created with the name "Organic_A2_Milk_Landig_Page." > select the column name from the list, tick the check boxes . Smart Capture & Text > Made the settings as per the image and attached it to the Data extension. Click on the publish button  This is the preview page 'Naveen Dairy A2 milk'  Landing page > Then Publish This is URL for 'Naveen Dairy A2 milk' Landing page. https://mcbn59q90grl4-c77svccmld863y.pub.sfmc-content.com/og1xoj2cjku
Post a Comment
Read more

SQL Case When Advanced Real time Use Case

Image
  SFMC SQL CASE Statement Use Cases 5 normal CASE use cases and 5 advanced real-time enterprise use cases in Salesforce Marketing Cloud SQL. 1. Customer Segmentation Query:- SELECT  SubscriberKey, CASE         WHEN TotalSpent >= 10000 THEN 'VIP'         WHEN TotalSpent >= 5000 THEN 'Gold'         ELSE 'Regular' END AS CustomerSegment FROM Sub_Customer_Naveen Result:-   2. Gender Formatting Query:- SELECT SubscriberKey, CASE Gender         WHEN 'M' THEN 'Male'         WHEN 'F' THEN 'Female'         ELSE 'Unknown' END AS GenderName FROM Sub_Customer_Contacts Result:- 3. Email Engagement Status Query:- SELECT   SubscriberKey, CASE         WHEN OpenCount >= 10 THEN 'Highly Engaged'    ...
Post a Comment
Read more

SFMC SQL - JOINS

Image
  Naveen_SFMC_SQL_Joins   -: JOINS:- -: JOIN in  Salesforce Marketing Cloud:- In SFMC, A  JOIN  is used to combine data from multiple  Data Extensions (tables)  using a common field. In  Salesforce Marketing Cloud , data is usually stored in multiple  Data Extensions (DEs)  instead of one single table. JOINs are important because they help combine related data from different DEs using a common field. Why JOINs Are Important Without JOINs:👉 data remains separated reports become difficult personalization is limited segmentation becomes hard JOINs help marketers connect subscriber data, order data, journey data, and engagement data together. First of all we created Three Source tables and one Target Table  1.  Naveen_Customer_table_Joins 2.  Naveen_Order_table_Joins 3.  Naveen_self_Join 4. Naveen_Customer_Table_Joins_TargetDE ------------------------------------------------------------------------------------------...
Post a Comment
Read more