Send a birthday email about the "correct birthday" | Community
Skip to main content
sqwgglz
sqwgglz
Level 3
Apr 26, 2018 2:31 PM UTC
Solved

Send a birthday email about the "correct birthday"

Let me explain:

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

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:

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

Thanks


Kevin

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    vraghav
    vraghavAccepted solution
    Employee
    Jul 12, 2018 12:05 AM UTC

    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

    View reply

    5 replies

    vraghav
    vraghavAccepted solution
    Employee
    Jul 12, 2018 12:05 AM UTC

    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

    Translate
      sqwgglz
      sqwgglzAuthor
      Level 3
      Jul 11, 2018 10:30 AM UTC

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

      Translate
      sqwgglz
      sqwgglzAuthor
      Level 3
      Jul 11, 2018 10:30 AM UTC

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

      Translate
      johnf48867289
      Level 2
      Apr 26, 2018 4:21 PM UTC

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

      Thanks,

      John

      Translate
        AbdulZa
        Level 3
        Apr 26, 2018 3:55 PM UTC

        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.

        Translate
          Terms & ConditionsAccessibility statement

          Loading footer...