Segmentation based on metadata

Hi Mads,

Is the “metadata” currently stored on the user’s profile, or in klaviyo events? Can you explain the “metadata” more? I am not sure what this means in Klaviyo.

I think the “higher” comment from Klaviyo means the profile/event properties need to be “top-level” properties. Does this make more sense?

Klaviyo doesn’t totally support nested object fields on profiles (or events, I think) for the purposes of segments.

Let me know.

Kevin.

Hey Mads,

Can you move the `booking_start_date` (and end_date) to be at the same hierarchical level as `Metadata`?

If you do that, you can create segments based on “What someone has done” (in your instance, the “Ordered Sne...” event) with filters for the profile properties.

If you try to do this now, you should see “Metadata” as an option in your segment, but you won’t be able to “drill down” into any subproperties.

If it helps your understanding, try making a segment based on the Metadata property of the “Ordered” action. You can hack Klaviyo’s segment builder by doing something like “where Metadata contains booking_start_date: value: 2024-01-01” (or something like that, treating the nested object as a serialized string). This won’t work for your use case, but it might help you understand how Klaviyo handles sub-objects.

Best,

Kevin.

Ah, my apologies Mads, I understand now.

I don’t believe you can update a prior event’s properties. Would you have a path forward if you could store the booking dates directly on a profile? Or would you be able to call your “order” event a second time?

Since you can’t update a past event, I am trying to figure out how to make this work for your current workflow and future workflow. We’d have to update the “Order” event to save the booking dates to the profile (for any future orders), and then also backfill current profiles who have already placed orders.

With a custom script using Klaviyo’s API, you could certainly fetch all instances of this event and backfill current profiles that have already placed orders.

Let me know if I’m making sense and what approach you want to go with.

Best,

Kevin.

Hi Mads,

Show this to your developer:

// New Klaviyo API call format.
{
    "data": {
        "type": "event",
        "id": "",
        "attributes": {
            "properties": {
                "booking_start_date": "" // Put the data here!!!
                "Metadata": {} // this is where you're putting the data right now
            }
        }
    }
}

// Old Klaviyo API call format.
{
  "token":"",
  "event":"Placed Order",
  "customer_properties":{}, // Put booking data here IF YOU WANT IT TO BE ON A PROFILE
  "properties": {
    "booking_start_date": "" // Put the data here!!!
    "Metadata": {} // this is where you're putting the data right now
  }
}

Hope that helps

Hi Kevin

Unfortunately, it didn’t seem to do the trick.
Booking data is still being nested in the same place as before.
One of the chat supporters mentioned that the dates, can’t be in actual date formats, otherwise it won’t work. 

“It is not possible to segment on date type data from a property”

Best regards
Mads

Hi Kevin

The last one I received from him was this.
Not sure if this is what you mean by script - my apologies if not :-)

add_filter('kl_added_to_cart','kl_modify_added_to_cart', 99, 4);

function kl_modify_added_to_cart($added_to_cart, $added_product, $quantity, $wck_cart) {

   if( isset($_REQUEST['start_date_submit']) ){

      $start_date = $_REQUEST['start_date_submit'];

      $added_to_cart['booking_start_date'] = $start_date;

   }

   if( isset($_REQUEST['end_date_submit']) ){

      $end_date = $_REQUEST['end_date_submit'];

      $added_to_cart['booking_end_date'] = $end_date;

   }

   return $added_to_cart;

}

Hi Kevin

Did anyone from Klaviyo reach out to you yet?
Really appreciate the help! :-)

Best regards
Mads

Hi Kevin

Seems like it’s a bit difficult to receive support from Klaviyo, if you have a question that is deviating a bit from standard inquiries :(

Thanks a lot for your help, I will see and try if I can get a hold of someone in support (again)

Best regards
Mads

I initially reached out to them, and they were actually the ones who referred me to Klaviyo Developer Group, because they said they couldn’t help with something of that nature.

In a last desperate effort of help, are you able to provide me with an optimal framing of the question, that you believe would make support able to help?
No strings attached if it doesn’t work out, you have done more than enough for me already :-)

Best regards
Mads