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