How to do cohort or retention analysis for e-commerce startup | Google sheets BigQuery SQL

[@allanneri6096]

This is the best explanation in Sheets about Cohort I ever seen. Thanks to you I did that analysis over my customers.

[@kal_so]

Glad it was helpful!

[@jacobukokobili6457]

I struggled to understand this concept until I stumbled on your video and you made it very simple to comprehend especially with the BigQuery. Thank you so much for this and I hope you have more videos for marketing analytics

[@kal_so]

Thanks, glad it was helpful

[@yosigam]

this is the best cohort analysis build ever, thanks a lot

[@kal_so]

Thanks, glad you found it useful

[@simonasvalionis6599]

Super helpful, clear, and easy-to-follow video on cohort analysis in SQL, thank you very much! Keep up the good work and you have my subscribe! :)

[@mohamed.montaser]

you didn't do count distinct in the google sheet example, the values were count of orders not count of unique customers also since you took the cumulative sales then revenue per customer calc should be cumulative sales / M0 or total customers in each month

[@lenafranco7152]

How can I make the cohort by weeks besides months

[@adnanafdalahmed]

super easy explaination

[@kal_so]

Glad you think so!

[@SACHINKUMAR-vt6pp]

Super helpful

[@kal_so]

Glad to hear!

[@thanhle0606]

How can I perform query to create pivot table without using PIVOT function? I am using postgresql. Thank you

[@MO3az-hw9qy]

use the crosstab() function from the tablefunc extension

[@emadeldienadel5005]

Thanks

[@K-wx6ki]

would this work for pgadmin?