SELECT mst.SubscriberKey,mst.EmailAddress, mst.Consent_Level_Summary__c, mst.FirstName, mst.LastName, mst.CreatedDate, mst.Mailing_Country__c, mst.Region, mst.SegmentRegion, CASE WHEN mst.Job_Role__c = 'Consulting Engineer' THEN 'Consulting Engineer' WHEN mst.Job_Role__c = 'Consultant Engineer' THEN 'Consulting Engineer' WHEN mst.Job_Role__c = 'Contracting/Consulting' THEN 'Consulting Engineer' ELSE 'Other' END as Job_Role__c FROM ep_mr_en_us_w170049_MASTER mst LEFT JOIN ep_mr_en_EAME_VSP_eBlast hb ON mst.subscriberkey=hb.subscriberkey WHERE mst.SegmentRegion = 'EU'
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter