vbennett

Recurring Email to Net New Audience - Adobe Campaign Standard

Hello all,I am trying to work out some kinks with my recurring emails. Here is what I am trying to achieve. I have a scheduler on a workflow for the population to pull in ticket purchasers and send them a pre-event email. After the first send, I want to exclude the previous batch of recipients and only send to net new people from the ticket purchasers population. I don't believe I have set up the delivery exclusion correctly because it has sent a duplicate delivery to the initial population in a...

335

Re: Error in SFTP File Processing Workflow (FPW) with Ins... - Adobe Campaign Standard

hi, no I still haven't. I am wondering if it's the sftp file because I have confirmed all the sftp data columns are the same as the ACS fields. Here is the latest error code: WDB-200001 SQL statement 'INSERT INTO wkf50169430_244_1 (iRecTrnState, iPKey1, sPKey_1, fFld1952776435, sFld1952841972, sFld1952841973, sFld1952841974, sFld1952841975, sFld1952841976, sFld1952841977, sFld1952841978, sFld1952841979, sFld1952841980, sFld1952841981, sFld1952841982, sFld1952841983, sFld1952841984, sFld195284198...

365

Error in SFTP File Processing Workflow (FPW) with Insert/Update Step - Adobe Campaign Standard

Hey All,I am trying to work through an issue with an SFTP File Processing Workflow. We are trying to grab the data from the SFTP from our Shopify Customer Orders. In doing so I keep encountering errors in the Insert/Update step & I am not sure where the disconnect is. The Error is:PGS-220000 PostgreSQL error: ERROR: column w0.morderlineitemkey does not exist LINE 1: ...N CusShopify C1 ON (C1.sOrderlineitemkey = substr(W0.mOrderL... ^ HINT: Perhaps you meant to reference the column "w0.sorderline...

431

Re: Duplicate Profiles after Subscribing to a Service - Adobe Campaign Standard

hey @SatheeskannaK, yes, I can confirm those parameters are set in the LP.

387

Re: Duplicate Profiles - Adobe Campaign Standard

hey @SatheeskannaK, So the issue with this solution is that some of the data is scattered among the duplicate profiles. So I want to be able to transfer all data from all dups to just one profile & delete the others. But will this work?

370

Duplicate Profiles - Adobe Campaign Standard

Hey! After spending almost 2 days researching ACS Duplicate info I have come to find that ACS does not currently have a direct function to merge duplicate profiles. Is there any other workaround to merge duplicate profiles?

502

Re: Adding a Merge Profiles function - Adobe Campaign Standard

@johnwwilcoxmba thanks for the info! Did you do this workflow based off upload profiles?? I am looking to merge profiles like you mentioned but when we switched to ACS we kept everything in profiles & don't use updates so I have tons of thousands of dups. I was hoping to do something like this but pulling from profiles from our ACS.

489

Duplicate Profiles after Subscribing to a Service - Adobe Campaign Standard

Hey there! I have just run across an issue with our profiles. I have recently created a Landing Page that subscribes a user to a specific service however when an existing profile subscribes through this landing page to the new service, it duplicates the profile rather than updating the existing profile with the new subscription. Has this happened to anyone or does anyone have some experience that would prevent duplicates? Thanks, friends!

459

Learn

Documentation

Community

Support

Resources

Adobe account

Adobe