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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

edwardr28531298
Community profile edwardr28531298 Level 2
Job title here
Location here
12 BADGES
Level 2

Level 2

Learn more
Joined the community 25-01-2019 1:36:14 PM
Offline
Top badges earned by edwardr28531298
Customize the badges you want to showcase on your profile
can you have more than one input form per schema?
Avatar
Give Back 10
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Give Back 5
Ignite 5
Ignite 3
Give Back 3
View profile
edwardr28531298
- Adobe Campaign Classic
Hello, I tried to create an input form based on the nms:recipient schema. however when I created it, it overwrote the input form that I am currently using under profiles and targets>recipients folder. the objective I was trying to accomplish is to create a second input form with less information and include that in a separate folder. is something like this possible? thanks.

Views

227

Likes

0

Replies

1
Re: Help with simple SQL activity script
Avatar
Give Back 10
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Give Back 5
Ignite 5
Ignite 3
Give Back 3
View profile
edwardr28531298
- Adobe Campaign Classic
Hello, thank you. Is there a reason why the SQL activity is not a good option for something like this? what would typically be a good use for the sql activity then? thanks!

Views

275

Likes

0

Replies

0
Re: Help with simple SQL activity script
Avatar
Give Back 10
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Give Back 5
Ignite 5
Ignite 3
Give Back 3
View profile
edwardr28531298
- Adobe Campaign Classic
Hello, thank you. Is there a reason why the SQL activity is not a good option for something like this? what would typically be a good use for the sql activity then?

Views

275

Likes

0

Replies

0
Help with simple SQL activity script
Avatar
Give Back 10
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Give Back 5
Ignite 5
Ignite 3
Give Back 3
View profile
edwardr28531298
- Adobe Campaign Classic
Hello, I would like some more information on how to use the SQL activities in adobe campaign classic.let's say for example Instead of using the generic query editor to query the recipient's table for email = "helloworld@123domain.com" I wanted to use the SQL activity and write: SELECT T0.[iRecipientID], T0.[sEmail] FROM [neolane_application].[NmsRecipient] T0 WITH (NOLOCK) WHERE T0.[sEmail] IN ('helloworld@123domain.com') the activity runs without any errors, but it does not return an actual res...

Views

306

Likes

0

Replies

4
Re: apply filtering rules/typology rules during sending
Avatar
Give Back 10
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Give Back 5
Ignite 5
Ignite 3
Give Back 3
View profile
edwardr28531298
- Adobe Campaign Classic
Thank you so much for taking the time to reply. in regards to comment #2: How can we apply the recalculation of typology rules during the send out? That's what I would like to implement, however when going through the available configurations in typology rules I don't see that option. Thank you.

Views

2.0K

Likes

0

Replies

0
apply filtering rules/typology rules during sending
Avatar
Give Back 10
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Give Back 5
Ignite 5
Ignite 3
Give Back 3
View profile
edwardr28531298
- Adobe Campaign Classic
Hello, I would like to know if there is a way to apply filtering rules during sending? i am noticing when i am doing a pre-run we have a 'clean' list with no blacklist recipients but when i come to check the day after the newsletter has gone out I'm seeing that some recipients have blacklisted us since our last pre-run 9 hours before..is this a common problem?

Views

2.0K

Likes

0

Replies

2
Re: determining if an email was opened after a 5 minute w...
Avatar
Give Back 10
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Give Back 5
Ignite 5
Ignite 3
Give Back 3
View profile
edwardr28531298
- Adobe Campaign Classic
Thank you this was helpful!

Views

2.4K

Likes

0

Replies

0
Re: determining if an email was opened after a 5 minute w...
Avatar
Give Back 10
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Give Back 5
Ignite 5
Ignite 3
Give Back 3
View profile
edwardr28531298
- Adobe Campaign Classic
is there a better way of doing this since its coming from a recurring delivery?

Views

2.5K

Likes

0

Replies

0
determining if an email was opened after a 5 minute wait activity
Avatar
Give Back 10
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Give Back 5
Ignite 5
Ignite 3
Give Back 3
View profile
edwardr28531298
- Adobe Campaign Classic
Hello, I have a question that would seem rather simple but I cannot figure it out. I have a WF that sends an email followed by a 5-minute wait activity, after that, I have a split that identifies if an email was opened or not. if opened send another email if not opened do nothing. In all my test it doesn't matter whether I open an email or not, the WF sends both my test emails through "opened email branch" after the five minute wait here are the rules I have in the split activity. a snapshot of ...

Views

3.2K

Likes

0

Replies

5
Re: external signal activity
Avatar
Give Back 10
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Give Back 5
Ignite 5
Ignite 3
Give Back 3
View profile
edwardr28531298
- Adobe Campaign Standard
The workflow is running but I do get at least one or more deadlocks a day. so im constantly having to go back and start them up again. we do have message center set up on our dev environment. but I'm not very sure how to use it. it seems like we may be able to get some good use out of it, but the examples I found online weren't very useful.

Views

1.7K

Likes

0

Replies

0
external signal activity
Avatar
Give Back 10
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Give Back 5
Ignite 5
Ignite 3
Give Back 3
View profile
edwardr28531298
- Adobe Campaign Standard
Hello, I would like to know if any of you could provide some helpful examples of how to use an external signal. I really want to make sure I'm maximizing the potential of adobe campaign and judging by the name this looks like it can be useful. Would the following be possible on adobe campaign?- right now we have a workflow on a scheduler that will send a verification email to a new subscriber, and that triggers every 2 minutes. is it possible to have that triggered based using the external signa...

Views

4.2K

Like

1

Replies

4
Calling a stored procedure.
Avatar
Give Back 10
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Give Back 5
Ignite 5
Ignite 3
Give Back 3
View profile
edwardr28531298
- Adobe Campaign Classic
Hello all. I have two questions, SQL related.what are some ways to use the SQL activity? is it possible to write my own SQL in that activity to query a list of recipients instead of using the query activity?second, is there a way to call a stored procedure in adobe campaign classic?any info on this will be much appreciated!Thank you!

Views

1.8K

Likes

2

Replies

1
Re: Implementing a 'Test' flow control to technical Workflow
Avatar
Give Back 10
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Give Back 5
Ignite 5
Ignite 3
Give Back 3
View profile
edwardr28531298
- Adobe Campaign Classic
How would I check to see if there is a record or not using the test activity? I like this idea as I was thinking to myself, not every cycle will have a result. so if there are no results this time 'end' query. but when I select conditions under the test activity not sure what field to use?Thanks!

Views

1.6K

Likes

0

Replies

0
Implementing a 'Test' flow control to technical Workflow
Avatar
Give Back 10
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Give Back 5
Ignite 5
Ignite 3
Give Back 3
View profile
edwardr28531298
- Adobe Campaign Classic
Hello all! I would like to know the best method to go about implementing a Test activity to 4 of my technical workflows. I currently have 4 different workflows (one for each Newsletter subscription type, health, pets, etc) When they run I sometimes get deadlocks and my workflow fails. I figured if I put a 'Test' activity right after my scheduler to check if any of the other 3 workflows are currently running to try again later would help solve this issue?is there a way about implementing this? Ho...

Views

3.9K

Likes

3

Replies

5
Re: querying recipients of a particular delivery in the past 24 hours
Avatar
Give Back 10
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Give Back 5
Ignite 5
Ignite 3
Give Back 3
View profile
edwardr28531298
- Adobe Campaign Classic
Thank a lot all! it worked in 18 seconds now!

Views

1.7K

Likes

0

Replies

0
Re: querying recipients of a particular delivery in the past 24 hours
Avatar
Give Back 10
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Give Back 5
Ignite 5
Ignite 3
Give Back 3
View profile
edwardr28531298
- Adobe Campaign Classic
UPDATE: IT RAN! however, it took 9 minutes to do so. I figure there is probably a more efficient way of doing this.

Views

1.3K

Likes

0

Replies

0
Re: querying recipients of a particular delivery in the past 24 hours
Avatar
Give Back 10
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Give Back 5
Ignite 5
Ignite 3
Give Back 3
View profile
edwardr28531298
- Adobe Campaign Classic
Thank you for your prompt reply. I removed the additional 'recipient delivery log exist' line and ran it again, but no dice. the query is staying in limbo with the gear at the top running. Like you mentioned the query regarding the event date seems correct. in fact, when I hard code the dates I get the recipient population I'm looking for. this only happens when I try using a function.

Views

1.3K

Likes

0

Replies

0
querying recipients of a particular delivery in the past 24 hours
Avatar
Give Back 10
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Give Back 5
Ignite 5
Ignite 3
Give Back 3
View profile
edwardr28531298
- Adobe Campaign Classic
Hello, I'm trying to create a query that will look at the event date of a recipient who received a Welcome Email but did not open it in the last 24 hours. For example on 8/14 I want to send another email to recipients who were sent the first email on 8/13 but did not open it. I'm having a problem with calculating the event date. If I hardcode the date I can get it to work. but when I use 'current date minus n days' the query just spins and doesn't produce a result.any ideas? Thank you!

Views

3.6K

Likes

2

Replies

6