Reiss Company is planning a promotion for customers who have spent less than £200 in a month. Before finalizing the offer, the marketing team wants to determine the number of customers who match this criteria. Create the target data extension Data Extension Details: Master Customer Name Data Type Length Primary Key Nullable id Text 50 Yes email EmailAddress 254 TRUE first_name Text 50 TRUE last_name Text 50 TRUE Total_spend_month Decimal 18,2 FALSE SQL query activity SELECT COUNT(id) AS eligible_customers FROM [Master Customer] WHERE Total_spend_month < 200 Explanation SELECT: This clause point out which columns you’d like to see in your target data…

Reiss Company has launched two 2 weeks ago a new dress called “Dalia”. The marketing team would like to notify all subscribers who haven’t yet buy Dalia dress yet. In order to get this list of contacts, we have to query the the master customer data extension . Create the target data extension Data Extension name: Master Customer Field names Data Type Length Primary Key Nullable id Text 50 Yes email EmailAddress 254 TRUE first_name Text 50 TRUE last_name Text 50 TRUE dress Text 50 FALSE SQL query activity SELECT email, first_name, last_name, dress FROM [Master Customer] WHERE dress != ‘Dalia’…

A Editor company would like to send out its weekly newsletter, and the marketing team requires create the customer list from their master customer, they wish to personalize their communication by using the first names and last names of their subscribers. As a member of the marketing team, you are responsible for creating the target data extension which will hold the data that will serve for personalization. Create the target data extension Data Extension Details: Master Customer Name Data Type Length Primary Key Nullable id Text 50 Yes email EmailAddress 254 TRUE first_name Text 50 TRUE last_name Text 50 TRUE SQL…

SELECT Customer_Id, TotalSpend_90Days, AverageSpend_90days FROM Customer_Spend_90DaysVsAVG WHERE TotalSpend_90Days <=  AverageSpend_90days

SELECT Customer_Id, TotalSpend_90Days, AverageSpend_90days FROM Customer_Spend_90DaysVsAVG WHERE TotalSpend_90Days > AverageSpend_90days

Select a.Customer_Id, a.Email_Address, a.First_Name, a.Delivery_Address_Postal_Code, a.Delivery_Address_Town, b.Product_Code from Master_Customer_Active a join Master_Order o on  a.Customer_Id = o.Customer_Id join Master_Order_Line_Item b on b.Order_Id = o.Order_Id