Hi,
Thanks for any help in advance.
I have the following data:
1) a sign-up table (see dummy attached)
2) a orders table (see dummy attached)
Sign-up table ID = UserId in orders table. The tables are linked via SQL connection
I am trying to achieve the following:
1) See conversation from sign-up to order
e.g. Q2 cohort for sign ups is 100 sign-ups. Of those 30 places 1 or more orders any time after sign-up ... so Q2 sign-up cohort has a 30% conversation to orders. I am interested in showing totals and percentages
2) See days from sign-up to first order
e.g. looking at all sign-ups from all times lets say 100 -> 30 never place an order 30%, 10 on the day of sign-up 10%, 10 five days after sign up 10% and 40 ten days after sign-up 40%.
This would be best to see in brackes -> did not order, same day as sign-up, 1+ after sign-up, 2-7days after sign-up, 8-15days afer sign-up, 15-30days, 31+ days after sign-up
Also here interested in % and totals.
I have a very hard time getting even close to doing any of this.
Thanks a lot for some help.
Carl
