Marketing Cloud

Robert Wynter

Update one Data Extensions with another using SQL Query: morning folks, a newbie at MC SQL. need help wrapping my brain around the syntax of a SQL statement. I have a Journey Builder (JB) Data Extension (DE) where I need the attendance field to be updated from another DE based on the Contact ID AND EVENT/ACTIVITY ID. So the source DE would be ([Recruitment Contacts Booking Attended]) and the Target DE would be ([SC Contact Journey - November 26 2020 456 PM - 2020-11-27T105138104]). The following syntax I've tried with no success: SELECT T.[Event:Attendance__c], T.[Event:WhoId] FROM [Recruitment Contacts Booking Attended] AS G INNER JOIN [SC Contact Journey - November 26 2020 456 PM - 2020-11-27T105138104] as T ON G.[Event:WhoId] = T.[Contact ID] AND G.[Event:Id]= T.[Activity ID] WHERE G.Attendance = T.[Event:Attendance__c] More

46 minutes ago · 0 comments · 0 likes

Manish Tripathi

Hi All, I am not able to update the sales cloud filed dynamically from the marketing cloud using amp script on the landing page. but it is working for hardcoded values can anyone help to identify the reason? %%[ /* SET @emailAddress = requestparameter("Email") */ set @SubKey= 'a0Q2w000----' /*set @SubKey= requestparameter("test_RecordID")*/ set @jid= requestparameter("jobid") set @listid= requestparameter("listid") SET @lue = CreateObject("ExecuteRequest") SetObjectProperty(@lue,"Name","LogUnsubEvent") SET @lue_prop = CreateObject("APIProperty") SetObjectProperty(@lue_prop, "Name", "SubscriberKey") SetObjectProperty(@lue_prop, "Value", @SubKey) AddObjectArrayItem(@lue, "Parameters", @lue_prop) SET @lue_prop = CreateObject("APIProperty") SetObjectProperty(@lue_prop, "Name", "JobID") SetObjectProperty(@lue_prop, "Value", @jid) AddObjectArrayItem(@lue, "Parameters", @lue_prop) SET @lue_prop = CreateObject("APIProperty") SetObjectProperty(@lue_prop, "Name", "ListID") SetObjectProperty(@lue_prop, "Value", @listid) AddObjectArrayItem(@lue, "Parameters", @lue_prop) /* SET @lue_prop = CreateObject("APIProperty") SetObjectProperty(@lue_prop, "Name", "BatchID") SetObjectProperty(@lue_prop, "Value", @batchid) AddObjectArrayItem(@lue, "Parameters", @lue_prop) */ SET @lue_statusCode = InvokeExecute(@lue, @overallStatus, @requestId) SET @Response = Row(@lue_statusCode, 1) SET @Status = Field(@Response,"StatusMessage") SET @Error = Field(@Response,"ErrorCode") IF LENGTH(@SubKey) == 18 AND IndexOf(@SubKey, "@") == 0 THEN /* SET @updateRecord = UpdateSingleSalesforceObject("Contact", @SubKey, "HasOptedOutOfEmail", 0)*/ SET @updateRecord = UpdateSingleSalesforceObject("abc__c", "a0Q2w0000------", "Name","Test") SET @updateRecord = UpdateSingleSalesforceObject("abc__c", "a0Q2w000-------", "Opt_Out__c", "true") ENDIF ]%% More

3 hours ago · 0 comments · 0 likes

Janaina Ferreira

Howdy. Has anyone taken the SFMC consultant exam in the last month? I've been studying and noticed the exam outline/syllabus recently changed and wanted to see if the Udemy course I am doing is still relevant. Thank you! More

3 hours ago · 2 comments · 1 likes

Rachid Mamai

Ever wanted a way to check all your automations runtimes and frequencies on one page? Use two undocumented REST API endpoints to create a dashboard with the look and feel of Lightning Experience in a Marketing Cloud CloudPage. https://sfmcify.com/create-automations-runtimes-and-frequencies-dashboard-using-rest-api/ More

6 hours ago · 0 comments · 0 likes

Guduli Das Mohapatra

Hello Everyone . I have created one intercative email which consists of 15 questions.I have triggered that email and Gmail clips the message. What should i do to avoid this ? More

12 hours ago · 1 comments · 0 likes