Google Play Store & Power BI: How to integrate your data and template

Welcome to this comprehensive tutorial where you will learn how to leverage the data from the Google Play Store in PowerBI. By the end of this guide, you will have successfully linked your Google Play Store account with PowerBI, enabling the visualization and advanced analysis of your app’s performance and user interactions.

How to connect your Google Play Store account to PowerBI

Add a source on Catchr

Begin by navigating to the Catchr homepage and selecting 'Source' from the left-side menu. At the top right corner, click on 'Add a Source'. From the list of platforms, choose Google Play Store and proceed with the authorization process to establish a connection between Catchr and the Google Play Store.

Create the request to transfer Google Play Store data to PowerBI

• Once in Catchr, look for 'API' on the left-side menu and click it.

• Start off by changing the export format to 'PowerBI'.

• In the 'Source' tab, select 'Google Play Store' from the platform options.

• Choose the specific account(s) for which you want to pull data. Feel free to select more than one if necessary.

• Pick the metrics and dimensions you want included in your data transfer. You have the flexibility to select multiple.

• Note: Remember to choose all necessary dimensions and metrics if using one of Catchr's templates. The corresponding template should automatically pop up with your data pre-loaded, allowing you to tailor it as per your requirements.
• Define the timeframe for the data extraction from Google Play Store. You can opt for a fixed range or set your own custom dates.

• If necessary, implement filters to refine your data request. It is possible to apply more than one filter.

• Adjust any additional platform-specific options to the request.

• Upon completion, a URL will be generated and displayed in the top bar. Click on 'Preview' to inspect the resulting data before finalization.

• Once everything appears correct, copy the URL. This is what you will use to link Google Play Store to PowerBI.

Import the Google Play Store data and KPIs to PowerBI

To bring your data into PowerBI Desktop, navigate to 'Get Data', then 'Web'. Stay in basic mode and enter the URL you've just copied from Catchr. Click 'OK' and allow PowerBI some time to import your data.

Once your data is in PowerBI, you can edit the query using PowerBI Query and format the fields as needed. Start building out your dashboard and share the insights with your team by publishing it.

In the PowerBI Web App, to use your data set, first publish it from PowerBI Desktop. Under 'New Report', select your published data set from the list and commence creating your report.

By now, you should have a fully functional connection between Google Play Store and PowerBI, opening up a wealth of data exploration opportunities.

Example of metrics you can use with the PowerBI Integration for Google Play Store

With PowerBI and its integration with Catchr, marketing professionals can begin to unlock the true potential of their Google Play Store data. You’ll be entering an analytical playground with the ability to display a variety of metrics such as App Installs, User Behavior, Revenue, and much more.

For instance, observe trends with 'Daily Device Installs' and 'Daily User Uninstalls' to gauge app popularity and retention. 'New Subscriptions' and 'Active Subscriptions' can help you monitor your subscription business model's performance. Discover customer demographic patterns using 'Country', 'City', and 'Language' to better tailor your marketing efforts.

The navigational data like 'Traffic Source' and 'Search Term' is particularly useful in understanding how users find your app and what terms are driving your visibility in the Google Play Store. It can be instrumental in optimizing your app's listing and improving its search rank.

Visit Google Play Store Metrics for a complete list of fields you can use to harness your marketing data effectively within PowerBI.

Use these insights obtained from Google Play Store data in PowerBI to drive decisions, tailor your strategies, and ultimately enhance your app's presence and profitability in the marketplace.

‍