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 doesn't seem accurate.
What ways do your teams answer these questions?
I'd love to hear your suggestions and/or feedback.