Pushpendra-Blog

           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 :     ...

 For SQL Query Automation :  Select - Journey Builder > Automation Studio > New Automation  Select : Starting Source Schedule  and drag it to Starting source and drag SQL Query . click on choose and select : Create new Query Activity - Name the Query Write the Query on editor and validate the Query syntax  and also create the New target data extension before moving ahead with all fields. Now select the target data extension with action data as overwrite : Then finish and save and name the Automation: Now Save and Run Once the automation : Click "Select All activity" and Click on Run Click on RUN ONCE Query Automation Run successfully. checked the Targeted DE found all the records are successfully updated.

📌Test Send Thresholds  - Test Send Thresholds define the limit of emails that can be sent as test emails from a single user or account within a specific time period.  Warning Threshold This feature displays a notification when a test send exceeds the specified threshold. You can bypass this notification to perform the test send.   Minimum value is 1. Maximum Threshold This notification displays when a test send exceeds the maximum test send threshold. You cannot bypass this notification to perform the test send. Max value is set to 1000. What it means: A Warning Threshold is a soft limit alert level . 👉 It does NOT stop you from sending 👉 It only warns you that you're approaching the limit For Example: Warning threshold = 80 emails You send 75 test emails → SFMC shows warning You can still continue sending Purpose: Alert users early Prevent accidental overuse Improve governance awareness  🔹Subject & Pre-header Validation : It validates ...