Hello,I’m working with a children’s play space and we’d like to send emails and create segments based on children’s ages and birthdays. We have the following information-Contact Info for the parent (each family has a single parent registered) Names and birthdays for children in that family. Families can have 1 or more children. Currently I store these as a List[Text] for names and List[Date] for birthdays but I can store this however is bestWe want to do the following-Create segments for families with children of specific ages (<1 year old, 3-5 years old etc.) Send emails 90 days out from a child’s birthday with our birthday party package. We’d like to include the child’s name in the email to personalize it. Send emails on a child’s birthdayThese things are pretty easy with a regular Date field on the profile but the wheels seem to fall off when the dates move into a list. I’m curious if anyone has any advice or has done something like this before? We’re completely flexible on data formats if anyone has creative ideas.

How to handle date fields in a list

Hello,

I’m working with a children’s play space and we’d like to send emails and create segments based on children’s ages and birthdays. We have the following information-

Contact Info for the parent (each family has a single parent registered)
Names and birthdays for children in that family. Families can have 1 or more children. Currently I store these as a ListsText] for names and ListaDate] for birthdays but I can store this however is best

We want to do the following-

Create segments for families with children of specific ages (<1 year old, 3-5 years old etc.)
Send emails 90 days out from a child’s birthday with our birthday party package. We’d like to include the child’s name in the email to personalize it.
Send emails on a child’s birthday

These things are pretty easy with a regular Date field on the profile but the wheels seem to fall off when the dates move into a list. I’m curious if anyone has any advice or has done something like this before? We’re completely flexible on data formats if anyone has creative ideas.

Page 1 / 1

Hey @jcheney44! Apologies for the late response here. How are you currently collecting the name and birthday data? Date fields are particularly finicky because they need to be exact in order to function properly. My gut instinct is to suggest to collect names and birthdays as individual custom properties. For example: Child 1 Name (text), Child 1 Birthday (date).

Hi Kaila,

I’m pulling the names and birthdays out of our guest management system and using the Klaviyo API to add them to a profile (using email as the unique key). We started down the individual custom properties route, but it felt like an incomplete solution because you never know how many kids someone could have. Creating our Segments and email flows turned into a mess of “if Child 1 Birthday is in 90 days or Child 2 Birthday is in 90 days or Child 3 birthday is in 90 days or Child 4 Birthday is in 90 days...” and you could never be sure you’d capture everyone. Even if we confirm there are no 6 child families in our data today one might come along tomorrow. I was hoping there would be something more elegant we could achieve with lists?

I also experimented with creating custom events for children, and the child’s birthday is a custom property on the event, since 1 profile can have unlimited numbers of events. I thought our filters could then be ‘Something someone has done = “My custom child event”’ filtered by the child event DoB property’ but date filtering within events was quite limited.

I’m happy to try anything you’d suggest and can use the API to be pretty creative with how data is inserted and stored.

Totally! I’m going to send this thread over to the Developer Group to see if any much more technically savvy and creative friends can help you sort out a better solution.

Hi Kaila, just wondering if you got an update from the Developer Group?

Hi Kaila, I noticed this was marked solved but I don’t think that it is. Can we leave it open in hopes of a better response from the developer group?

Reply

Sign up

Use your Klaviyo credentials

Log in to the Community

Use your Klaviyo credentials

Scanning file for viruses.

This file cannot be downloaded