Getting more data from Google Analytics

[eberstk]

I've connected my Power BI to my Google Analytics account, but certain key metrics don't seem to show up. For example, I can get the number of bounces, but not the bounce rate, and I can see the number of new users but not the ratio of new vs returning traffic.

Is there a way to get this data?

I'm currently deciding between Power BI and Google Data Studio for my team's main dashboard tool, and while Power BI seems to have a better design, it seems much more difficult to show Google Analytics data. 

[Anonymous · Accepted solution]

@eberstk,

You can use Power BI Desktop to connect to Google Analytics, then calculate bounce rate and ratio of new vs returning traffic, create report there. After that, you can publish the Power BI Desktop file to Power BI Service, and create dashboard in Service.

There is a similar thread for your reference.
https://community.powerbi.com/t5/Desktop/Calculate-One-Time-Visitors-from-Google-Analytics-Session-D...  

Regards,
Lydia

[eberstk]

Thank you for the help! Will the resulting report have a live feed from Google Analytics or will I have to re-upload the report to Power BI every time I want to see updated numbers?

Thanks again!

[Anonymous]

@eberstk,

You can set schedule refresh for your dataset in Power BI Service, this way, data will be updated automatically in Power BI Service based on the schedule each time you make change to the data in Google Analytics.

Regards,
Lydia