since ‎03-08-2020
‎04-02-2021
vbennett
Level 1
Recurring Email to Net New Audience
Avatar

vbennett

vbennett
- 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...

Views

124

Likes

0

Replies

1
Re: Error in SFTP File Processing Workflow (FPW) with Ins...
Avatar

vbennett

vbennett
- 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...

Views

202

Likes

0

Replies

0
Error in SFTP File Processing Workflow (FPW) with Insert/Update Step
Avatar

vbennett

vbennett
- 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...

Views

262

Likes

0

Replies

3
Re: Duplicate Profiles after Subscribing to a Service
Avatar

vbennett

vbennett
- Adobe Campaign Standard
hey @SatheeskannaK, yes, I can confirm those parameters are set in the LP.

Views

200

Likes

0

Replies

0
Re: Duplicate Profiles
Avatar

vbennett

vbennett
- 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?

Views

181

Likes

0

Replies

0
Duplicate Profiles
Avatar

vbennett

vbennett
- 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?

Views

313

Likes

0

Replies

2
Re: Adding a Merge Profiles function
Avatar

vbennett

vbennett
- 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.

Views

303

Likes

0

Replies

0
Duplicate Profiles after Subscribing to a Service
Avatar

vbennett

vbennett
- 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!

Views

272

Likes

0

Replies

3