cohort
2 Topics
Cohort analysis - retention rate
Hi, I'm new to Power BI and I want to calculate and show retention rate on dashboard. I have tables regarding user cohort data and we calculate retention rate as below. ex. Retention Rate for Android JP user who installed App A through Facebook network, campaign_1, Image_1 during 2020-01-01~2020-01-02 - Retention Rate (D+1) = (50+140)/(100+200) Retention Rate for iOS JP user who installed App A through Google network, campaign_2, Video_1 during 2020-01-01~2020-01-02 - Retention Rate (D+1) = (30+40)/(50+100) * Retention Rate (D+n) = retained_users with period n / retained_users with period 0 App OS Country Network Campaign Ad Group Creative Date Period Retained_users A Android JP Facebook campaign_1 Image Image_1 2020-01-01 0 100 A Android JP Facebook campaign_1 Image Image_1 2020-01-01 1 50 A Android JP Facebook campaign_1 Image Image_1 2020-01-02 0 200 A Android JP Facebook campaign_1 Image Image_1 2020-01-02 1 140 A iOS JP Google campaign_2 Video Video_1 2020-01-01 0 50 A iOS JP Google campaign_2 Video Video_1 2020-01-01 1 30 A iOS JP Google campaign_2 Video Video_1 2020-01-02 0 100 A iOS JP Google campaign_2 Video Video_1 2020-01-02 1 40 I want to show retention rate by variables (App, OS, Country, Network, Campaign, Ad Group, Creative, Date). How can I solve this problem ?Solved6KViews0likes5Comments
