Skip to main content
Question

How to compare computed traits?

  • December 10, 2024
  • 2 replies
  • 160 views

Forum|alt.badge.img+1

Hello,

I am currently tracking almost all the important events on our e-commerce website. Now, I want to use this data to send an abandoned cart email to the customer.
How can I filter out the abandoned carts?
I was thinking if the customer didn’t purchase anything in the next two hours then I can trigger it but if customer has removed an item from cart before that it can be empty.
So what will be a good strategy?

I am saving cart id but i am unable to compare last cart id of item added to cart and item purchased with each other.
 

2 replies

Tyler Nelson
Forum|alt.badge.img+3

Hey Aiman,

As you mentioned, most computed traits can only be compared against constants.

I had a bit of a chat with our team and one possible solution would be to tackle this with SQL, Reverse ETL and profiles sync. If you’d like to explore that option, I can see if I can get some more information on it.

For now, you can try building out an audience where computed trait “added to cart count” > 0, computed trait “removed from cart count” = 0, and “did not perform item ordered” - all during a certain period of time. This will drop users that have done a bit of cart shuffling, but should capture anyone that added items and then abandoned their session.

I’ll do a bit more digging on this.

Cheers,

Tyler


Forum|alt.badge.img+1

Thanks Tyler,

I will try both the solutions you have suggested. Thanks again