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:
| Days Between Orders | Order No. | Order Contains |
|---|---|---|
| 0 | 1 | Desk |
| 32 | 2 | Accessories |
| 67 | 3 | Accessories |
| 120 | 4 | Accessories |
| 365 | 5 | Desk |
→ 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!