Getting Google Analytics Retention Data to Power BI

Question

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?&nbsp;Thanks!

kfirm · Answer

Thanks! much appreciated.&nbsp;Just want to understand that PowerBI doesn't import GA4 data but legacy one..?&nbsp;I do see users and new users as mentioned, see the screenshot below -&nbsp;&nbsp;&nbsp;

amitchandak · Answer

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-Google-Analytics/td-p/2949758
https://community.fabric.microsoft.com/t5/Desktop/Google-Analytics-quot-Users-quot-quantity-is-0-or-lower-then/m-p/918283

kfirm · Answer

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 :-(.

kfirm · Answer

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.

kfirm · Answer

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

Forum Discussion

Getting Google Analytics Retention Data to Power BI

5 Replies

Related content

Retention analysis

Employee retention data

Retention Rate

Need help in DAX to get retention

Fabric Retention Period for Cached files