I feel like with the information and tools we have available, this should be an easy ask. We've come a long way since the early 2000's of having to pull data warehouses for answers, yet, I can't find a solid methodology to answer this outside of a data warehouse pull which is massive in size. We have visit number dimension, loyalty dimensions, retention dimensions, and then the obvious orders metric, but when I pull all this information into excel and try to find a weighted average, it just does...