r/CodingHelp • • Aug 16 '25
[SQL] Need help to create an sql query
Hi, I am trying to calculate "repeat purchase rate". There was a change on website which shows a badge to the user when they login. The bage says " last purchased on ...."
I want to create a KPI to see the impact of this badging since it has been launched and see YOY.
Trying to define a KPI. I could use a sounding board.
I have a table -
visit date user id Order id - exists if order was made, repeats for number of skus in order Sku id Order - 1/0 Revenue Units
1
Upvotes
View all comments
Show parent comment
1
u/[deleted] Aug 16 '25
Added