1

Need help writing an AMPscript to create a campaignmember record AND also upsert a record to a data extension from an email send. This is the AMPscript I used. 

%%[ var @contactId, @campaignId, @id, @contactRows, @limitRow set @id = Id set @campaignId = '70190000000sgS9' set @contactRows = RetrieveSalesforceObjects('Account','PersonContactId','Id','=', @id) set @limitRow = Row(@contactRows, 1) set @contactId= Field(@limitRow, 'PersonContactId') IF _messagecontext == "SEND" Then CreateSalesforceObject( 'CampaignMember', 3, 'CampaignId',@campaignId, 'ContactId',@contactId, 'Status','Sent' ) EndIF ]%%

When I perform a guided email send, the create campaign member record step works.

However, as I also want to create a send log Data extension and add subscribers that were sent the email to my data extension, I amended AMPscript to this and this causes the email send to fail. 

%%[ var @contactId, @campaignId, @id, @contactRows, @limitRow, set @id = Id set @campaignId = '70190000000sgS9' set @contactRows = RetrieveSalesforceObjects('Account', 'PersonContactId','Id', '=', @id) set @limitRow = Row(@contactRows, 1) set @contactId= Field(@limitRow, 'PersonContactId') if_messagecontext != "SEND" then CreateSalesforceObject( 'CampaignMember', 3, 'CampaignId',@campaignId, 'ContactId',@contactId, 'Status','Sent' ) upsertDE ( 'EmailTrackingDE',1, 'SubscriberKey',_SubscriberKey, 'JobID',jobid, 'EmailName',emailname_, 'DateSent',NOW() ) endif ]%%
Improve this question
2
  • what error message are you getting ? Commented Sep 1, 2016 at 5:54
  • It doesn't return any error message. It's only when I look up My Tracking I see the job status is error. after about 15 minutes the status changes to Cancelled. The interesting thing is whilst the email send failed, it still created a campaign member record. Commented Sep 2, 2016 at 6:20

1 Answer 1

Reset to default
2

Upserts aren't allowed in email sends, but if you simply create an AMPScript variable that has a matching column in a SendLog templated data extension, then it'll get recorded automatically.

For example, in your email you have something like this:

%%[ var @firstName set @firstName = "Moonbeam" ]%%

In the Send Log Data Extension:

  • JobID
  • ListID
  • BatchID
  • SubID
  • TriggeredSendID
  • ErrorCode
  • FirstName <- the value at send time will get recorded in this column

More details can be found here:

Send Logging

Improve this answer
1
  • I learn something new every day. How cool is the SendLog templated data extension?! Commented Sep 1, 2016 at 16:35

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.