Joined the community
03-08-2020
9:20:50 AM
Offline
Customize the badges you want to showcase on your profile
Recurring Email to Net New Audience
- Adobe Campaign Standard
239
0
1
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
Likes
Replies
Re: Error in SFTP File Processing Workflow (FPW) with Ins...
- Adobe Campaign Standard
274
0
0
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
Likes
Replies
Error in SFTP File Processing Workflow (FPW) with Insert/Update Step
- Adobe Campaign Standard
340
0
3
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
Likes
Replies
Re: Duplicate Profiles after Subscribing to a Service
- Adobe Campaign Standard
282
0
0
hey @SatheeskannaK, yes, I can confirm those parameters are set in the
LP.
Views
Likes
Replies
Re: Duplicate Profiles
- Adobe Campaign Standard
265
0
0
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
Likes
Replies
Duplicate Profiles
- Adobe Campaign Standard
397
0
2
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
Likes
Replies
Re: Adding a Merge Profiles function
- Adobe Campaign Standard
398
0
0
@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
Likes
Replies
Duplicate Profiles after Subscribing to a Service
- Adobe Campaign Standard
354
0
3
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
Likes
Replies