Owned data mavericks! 👋 Got a brain buster for ya.
I am trying to determine the average time spent between orders that contain a certain product type. (Not average amount of days between all orders, as outlined below.)
For context, I would like to use this data point as a trigger for a flow with the CTA of generating repeat purchases of a specific product type.
For example, let’s say a client’s main product is desks.
→ Client also sells desk accessories s/a lamps, drawer organizers, etc.
→ Most customer’s initial purchase contains a desk, but customers place orders of desk accessories that do not contain a desk in between purchasing another desk. (Say that 5 times fast!)
Days Between Orders
|Order No.||Order Contains|
→ On an individual profile level, it’s easy to determine the days between orders that contain a desk, this example would be 365 days.
→ However, if I were to factor in all of the orders, the orders that do not contain a desk dramatically lowers the average amount of days between orders, which would lead to a premature flow trigger.
→ I could go through all profiles that placed multiple orders with desks, but it is extremely time consuming and dynamic.
→ I am trying to determine the average amount of days between orders that contain a desk, but I’m having trouble figuring out a way to filter out the accessory orders that do not contain a desk at scale.
Got any tips, tricks, or suggestions to figure this out? Maybe there’s a Klaviyo feature that can automatically pull this up that I am unaware of? Cheers!
Best answer by stephen.trumbleView original