![]() It’s also not possible to get a "scorecard" of average DAU or average MAU. It’s not possible to make a calculated metric for the DAU/MAU ratio. Details on how to add data sources can be found in Google's guide here ( ) for Google Analytics and here ( ) for Google Sheets. With our Google Analytics data source set up, we can create time charts for our report. In this guide we’re going to connect Google Analytics and Google Sheets as data sources for the report in Google Data Studio. Again, where I use "Monthly Active Users" or "MAU" I'm referring to "28 Day Active Users" specifically. The permissions for giving a Google Apps Script access to your data are fairly broad so you should make sure to review the script provided here so you can be confident your data isn’t going to be mishandled.Īlso, for brevity, I'm using "DAU" for "Daily Active Users" and "MAU" for "Monthly Active Users" throughout. This guide does use the Google Analytics API so you will need to be able to set up API access for the Google Analytics view your data is in. It would also be good to run through “Automated Access to Google Analytics Data in Google Sheets” ( ) as the principles used there will be used in this guide. PREAMBLEįor this guide to make sense, ideally you should be familiar with Google Analytics and Google Data Studio. Google has made some of this easy to do, and some of it is less easy.but the entire thing is automatable.
0 Comments
Leave a Reply. |