Send a birthday email about the "correct birthday"

Avatar

Avatar
Validate 1
Level 2
sqwgglz
Level 2

Likes

15 likes

Total Posts

41 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
sqwgglz
Level 2

Likes

15 likes

Total Posts

41 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
sqwgglz
Level 2

26-04-2018

Let me explain:

We have a Loyalty table that holds up to 10 friends/family members' names and birthdays.

1474096_pastedImage_0.png

I want to be able to send an email that looks at all those records and pulls out the family member and birthday that meets my criteria (i.e. birthday is in 14 days) as well as enrich the email with that guests' personalised information (i.e. name or age).

i.e. I have the Query I want, which will find anyone's birthday 14 days from now: 1474119_pastedImage_1.png

but how do I find out which of the 10 meets that criteria so it can be enriched by a delivery?

Thanks


Kevin

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Vapsy
Employee

11-07-2018

It will be good to create 10 such query activities in your workflow, one each for

  • Family member 1
  • Family member 2

and so on.

Check the corresponding birthday against the 14 days criteria.

Connect the outgoing transition of all such query activities using a Union.

The only concern I see with this logic is, if two members of the same family have birthday on the same day, this will send an email to only one of them.

Regards,
Vipul

Answers (4)

Answers (4)

Avatar

Avatar
Validate 1
Level 2
johnf48867289
Level 2

Likes

4 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Ignite 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
johnf48867289
Level 2

Likes

4 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Ignite 1
Boost 3
Boost 1
View profile
johnf48867289
Level 2

26-04-2018

This is specific to Adobe Campaign Classic based on the screenshots provided. Campaign Standard does not have this interface.

Thanks,

John

Avatar

Avatar
Boost 5
Level 4
AbdulZa
Level 4

Likes

43 likes

Total Posts

50 posts

Correct reply

8 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 4
AbdulZa
Level 4

Likes

43 likes

Total Posts

50 posts

Correct reply

8 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
AbdulZa
Level 4

26-04-2018

Very good question and increasingly becoming more popular (parent-children, owner-pets, etc.) This is similar in many ways to householding with message personalized using the people of the household.

Is this question related to Campaign Standard or Classic?

Thanks.

Avatar

Avatar
Validate 1
Level 2
sqwgglz
Level 2

Likes

15 likes

Total Posts

41 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
sqwgglz
Level 2

Likes

15 likes

Total Posts

41 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
sqwgglz
Level 2

11-07-2018

If anyone has any suggestions as to how if can be done (if at all possible) do let me know

Avatar

Avatar
Validate 1
Level 2
sqwgglz
Level 2

Likes

15 likes

Total Posts

41 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
sqwgglz
Level 2

Likes

15 likes

Total Posts

41 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
sqwgglz
Level 2

11-07-2018

Sorry for late reply. Yes it's for Campaign Classic.