blog post

Explore your Google Play Store Application KPI with PowerBI: How-to, templates and metrics

Florian Cabirol
January 29, 2024
Explore your Google Play Store Application KPI with PowerBI: How-to, templates and metrics

Quick steps to create a Google Play Store report with Google Sheets:

You can easiliy create a Google Play Store report following this step :

  1. Get informations from the data integration from our Google Play Store connector.
  2. Create a source on catchr.io.
  3. Download our Google Sheets extensions.
  4. Configure and run your request
If you need more informations, you can follow the tutorial.

How to install Google Sheets Catchr Add-on.

To start exporting your Google Play Store data to Google Sheets, you need to install the Catchr add-on. You currently have two options :

Option A: Via the marketplace:

  1. Visit the Catchr Add-on page on the Google Workspace Marketplace and click "Install."
  2. Grant the necessary permissions for the add-on.
  3. Upon successful installation, open a Google Sheets to proceed.
Connect Google Sheet to Facebook Ads
Install Catchr Google Sheets Add-on

Option B: Directly within a Google Sheets:

  1. Open a new Google Sheets.
  2. In the top menu, click "Extensions", then hover over "Add-ons" and select "Get add-ons."
  3. Search for "Catchr" and choose "Catchr - data connector."
  4. Click "Install" and grant the required permissions.
  5. Close the installation pop-up when completed.
  6. Start using the Catchr add-on.
Install Catchr Add-on for Google Sheets
Install Catchr Add-on for Google Sheets

Once you have installed the add-on, you can start making requests.

The tutorial

Quick steps to create a Google Play Store report with Looker Studio:

You can easiliy create a Google Play Store report following this step :

  1. Get informations from the data integration from our Google Play Store connector.
  2. Create a datasource and new report on Looker Studio.
  3. Choose your metrics and dimensions.
  4. Use charts with your metrics and dimensions.
If you need more informations, you can follow the tutorial. You can also find a template for Google Play Store at the end of the page.

The tutorial

Quick steps to create a Google Play Store report with PowerBI:

You can easiliy create a Google Play Store report following this step :

  1. Get informations from the data integration from our Google Play Store connector.
  2. Create a source on catchr.io.
  3. Configure your request on the PowerBI request manager.
  4. Copy the given URL in PowerBI
If you need more informations, you can follow the tutorial. You can also find a template for Google Play Store at the end of the page.

The tutorial

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.

Adding a source on Catchr

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.
Navigating to API section
  • Start off by changing the export format to 'PowerBI'.
Switching export format to PowerBI
  • In the 'Source' tab, select 'Google Play Store' from the platform options.
Selecting Google Play Store
  • Choose the specific account(s) for which you want to pull data. Feel free to select more than one if necessary.
Selecting account from Google Play Store
  • Pick the metrics and dimensions you want included in your data transfer. You have the flexibility to select multiple.
Selecting metrics and dimensions
Further metric and dimension selection
  • 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.
Choosing the period for data extraction
  • If necessary, implement filters to refine your data request. It is possible to apply more than one filter.
Applying filters to data request
  • Adjust any additional platform-specific options to the request.
Customizing request with platform-specific options
  • Upon completion, a URL will be generated and displayed in the top bar. Click on 'Preview' to inspect the resulting data before finalization.
Previewing data
Data preview
  • Once everything appears correct, copy the URL. This is what you will use to link Google Play Store to PowerBI.
Copy URL for use in 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.

Navigating to Get Data in PowerBI Desktop
Pasting URL to import 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.

No items found.

In this Google Play Store template, you will find all the metrics and dimensions you would need to get a better view of your data.

If you need more templates, you could look at our looker studio template gallery.

No items found.

In this Google Play Store template, you will find all the metrics and dimensions you would need to get a better view of your data thank to our integrations.

If you need more templates, you could look at our PowerBI template gallery.

Unlock Insights with Style!

Transform your marketing data into stunning dashboards.

Integrate, visualize, and impress with Catchr's seamless dashboards. Elevate your data game now!
Build your first report
14 days free-trial - No credit card required 🎉

More blog post about Google Play Store

Import you Google Play Store data to Google Sheets : How-to, metrics and more...

Unlock the full potential of your Google Play Store data with this comprehensive guide on integrating it into Google Sheets using Catchr. From connecting your account to visualizing key marketing metrics, learn to navigate the seamless workflow for data-driven decision-making. Perfect for marketing professionals seeking to enhance app performance analysis and strategic planning.

Florian Cabirol

Explore your Google Play Store Application KPI with PowerBI: How-to, templates and metrics

Learn how to connect your Google Play Store account with PowerBI for advanced app performance analysis. This guide covers every step, from data transfer with Catchr to creating insightful dashboards in PowerBI, helping you unlock key metrics like app installs, user behavior, and revenue to drive strategic app marketing decisions.

Florian Cabirol