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...
I got it! Maybe because I logged into analytics and went right to
components to create the new segment...?But I went to a report and then
created the segment and it seems to work! Thank you for your help.