Getting Google Analytics Retention Data to Power BI

[kfirm]

Hi,

Just found this great possibility to connect our GA to the PBI desktop, and it's working great. I try to get into PBI the retention figures, for example, how many users connected 7 days ago and again today (7 days retention).

Any idea how to do it?

Thanks!

[kfirm]

Any advise here? still struggling on getting the right figures from Google Analytics to PowerBI in order to measure users Retention rates

[kfirm]

Thanks! much appreciated. 

Just want to understand that PowerBI doesn't import GA4 data but legacy one..? 

I do see users and new users as mentioned, see the screenshot below - 

[kfirm]

Using the beta 2.0 native connector, and it worked great so far with the rest of the data.. just probably my misunderstanding on how to do the retention figures right.

[amitchandak]

@kfirm , refer if one of these can help

https://www.optimizesmart.com/visualizing-google-analytics-data-via-microsoft-power-bi/

https://community.fabric.microsoft.com/t5/Desktop/How-To-Extract-More-Than-26-Months-Of-Data-From-Go...

https://community.fabric.microsoft.com/t5/Desktop/Google-Analytics-quot-Users-quot-quantity-is-0-or-...

[kfirm]

Thanks! its more about getting new users and user count, I want to track retention, meaning that a user that is connected today came back after 7 days, so if 100 of the 1000 users who came today came back in a week, the retention would be 10% (it should be same users).

I'm still looking to solve it; used chatGPT, Bard, and Google search.., but nothing to be found :-(.