Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

vbennett
Community profile vbennett Level 1
Job title here
Location here
0 BADGES
Level 1

Level 1

Learn more
Joined the community 03-08-2020 9:20:50 AM
Offline
Top badges earned by vbennett
Customize the badges you want to showcase on your profile
Recurring Email to Net New Audience
Avatar
Level 1
vbennett
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
View profile
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

239

Likes

0

Replies

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

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
View profile
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

274

Likes

0

Replies

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

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
View profile
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

340

Likes

0

Replies

3
Re: Duplicate Profiles after Subscribing to a Service
Avatar
Level 1
vbennett
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

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

Views

282

Likes

0

Replies

0
Re: Duplicate Profiles
Avatar
Level 1
vbennett
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
View profile
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

265

Likes

0

Replies

0
Duplicate Profiles
Avatar
Level 1
vbennett
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
View profile
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

397

Likes

0

Replies

2
Re: Adding a Merge Profiles function
Avatar
Level 1
vbennett
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
View profile
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

398

Likes

0

Replies

0
Duplicate Profiles after Subscribing to a Service
Avatar
Level 1
vbennett
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
View profile
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

354

Likes

0

Replies

3