Pushpendra-Blog

First of all we created the Source DE : Push_Case_When_DE  Target DE created Named : Push_CaseWhen_Target_DE TASK : 1  1. Age Group Segmentation: Query : SELECT FirstName,     CASE         WHEN Age < 18 THEN 'Minor'         WHEN Age between 18 and 40 THEN 'Major'         ELSE 'Senior'     END AS AgeGroup FROM Push_Case_When_DE Result fetched with Column AgeGroup stating : Condition per Age group Task 2 2. Engagement Level : Query : SELECT  FirstName,      CASE         WHEN OpenCount > 10 THEN 'High'         WHEN OpenCount between 5 and 10 THEN 'Medium'         ELSE 'Low'     END AS Engagement FROM Push_Case_When_DE Result fetched with Column  Engagement  stating : OpenCount numbers Level Task 3 :  3. Greeting : Query : SELECT FirstName, CASE           WHE...

           First we have created tow DE Named PushSQL_Userdetails and target DE : Task 1 - For Gmail User :  Result after query execution : 3 out of 12 Records fetched TASK 2 : Users whose name starts with "A" -  Query -> Result after query execution :                                                     2  out of 12 Records fetched Task 3: Users whose name ends with "Kumar" - Query -> Result after query execution :                                             3 out of 12 Records fetched Task 4: Find users with "sale" in email (campaign filtering)- Query -> Result after query execution :     ...