Post by account_disabled on Jan 11, 2024 3:46:55 GMT
Can you tell us about specific examples of what you were able to do in practice after attending the camp? As I mentioned earlier, I wanted to calculate retention myself. Google Analytics and AppsFlyer, which the company uses, have retention dashboards, but these dashboards only allow you to check data for the past few months. Also, it is difficult to view the data by setting the conditions in detail that I want. So I thought I should calculate retention directly using SQL . Based on what I learned at the SQL Data Analysis Camp, I implemented a retention chart myself.
Thanks to this, I am now able to monitor retention indicators under my desired conditions. After I became familiar with using retention queries repeatedly, I was able to use them with the conditions I wanted, such as ana Whatsapp Number List lyzing cohorts of customers who purchased a specific brand or looking at retention based on purchase criteria. Additionally, we have recently segmented and analyzed customers through the RFM framework, contributing to coupon efficiency and increased sales. This was possible because through the camp, I was able to acquire SQL skills to understand and modify queries written by others. Practical class Week 2. Some of the course materials for cohort analysis and retention analysis. Practical class Week 2. Some of the course materials for cohort analysis and retention analysis. Q. It's really good news that you've started making good use of SQL in your work.
notice after upgrading your SQL skills? By analyzing various customer data with SQL, we were able to find clues for CRM campaign planning. Through this, we were able to plan a new campaign that had not been carried out before and achieve results. In addition, we were able to receive positive reviews because we were able to quickly accomplish various tasks as a marketer without going through the development team, improving the speed of work within the team and enhancing promotion planning capabilities within the team. notion image You can analyze data much more freely than using tools alone. Q. Do you think CRM marketers or marketers need SQL skills? Why do you think so? I think that SQL skills may not be essential in a work environment equipped with an advanced CRM tool/platform.
Thanks to this, I am now able to monitor retention indicators under my desired conditions. After I became familiar with using retention queries repeatedly, I was able to use them with the conditions I wanted, such as ana Whatsapp Number List lyzing cohorts of customers who purchased a specific brand or looking at retention based on purchase criteria. Additionally, we have recently segmented and analyzed customers through the RFM framework, contributing to coupon efficiency and increased sales. This was possible because through the camp, I was able to acquire SQL skills to understand and modify queries written by others. Practical class Week 2. Some of the course materials for cohort analysis and retention analysis. Practical class Week 2. Some of the course materials for cohort analysis and retention analysis. Q. It's really good news that you've started making good use of SQL in your work.
notice after upgrading your SQL skills? By analyzing various customer data with SQL, we were able to find clues for CRM campaign planning. Through this, we were able to plan a new campaign that had not been carried out before and achieve results. In addition, we were able to receive positive reviews because we were able to quickly accomplish various tasks as a marketer without going through the development team, improving the speed of work within the team and enhancing promotion planning capabilities within the team. notion image You can analyze data much more freely than using tools alone. Q. Do you think CRM marketers or marketers need SQL skills? Why do you think so? I think that SQL skills may not be essential in a work environment equipped with an advanced CRM tool/platform.