Average Days Between Orders That Contain Certain Product Types

Owned data mavericks! 👋 Got a brain buster for ya.

Data Point

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.)
 

Context

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.
 

Example

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!)

Example Customer:

→ 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.
 

The Challenge

→ 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!