blog post

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

Florian Cabirol
January 31, 2024
Import you Google Play Store data to Google Sheets : How-to, metrics and more...

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

This detailed guide serves the purpose of showcasing how marketing professionals can easily integrate their Google Play Store data with Google Sheets using Catchr. By the end of this tutorial, you'll be equipped with the knowledge to pull relevant data into Google Sheets seamlessly, allowing for a comprehensive analysis and aiding in data-driven decision-making for app optimization and growth.

How to connect your Google Play Store account to Google Sheets

Add a source on Catchr

To initiate, navigate to the Catchr homepage, select Source from the left menu, and click on Add a Source located at the upper right corner. Choose Google Play Store from the platform list and complete the authentication steps to link Catchr with Google Play Store.

Adding a source on Catchr

Create a New Query

Launch Google Sheets, locate and click on the Catchr tab in the menu. Select New Query to prepare a new data import query from Google Play Store data.

Select Your Data Source

Within the query tab, highlight Google Play Store as your desired source for data import. If it doesn't appear in your sources list, you may add a new source by selecting the "+" button.

Selecting your Data Source

Select Your Account(s)

Proceed to the "Select account(s)" section and specify the Google Play Store account(s) from which you wish to import data.

Selecting your Google Play Store Account

Choose Metrics and Dimensions

Now, move to the "Metrics" and "Dimensions" sections to select the essential data points for your analysis. Below are a few examples of metrics and dimensions available for Google Play Store:

Metrics:

  • Package Name: Name of the product as specified by the developer in various locales.
  • Transaction Type: Including charges, refunds, Google fee adjustments, etc.
  • Item Price: Price in the buyer's local currency, taxes included.
Choosing Metrics in Catchr

Dimensions:

  • Country: The origin country of the app visitor.
  • Device: Android device model used by the app visitor.
  • Language: The language setting of the device.
Choosing Dimensions in Catchr

Ensure that the metrics and dimensions chosen align with your analytical and reporting aims.

Set Date Range

Following the selection of metrics and dimensions, select a predefined or custom date range for your data import under the "Date Range" tab.

Setting Date Range in Catchr

Apply Filters

To refine your data, apply filters in the "Filters" tab. Configuring filters requires inputting the field name, operator, and value. For instance, to exclusively view data for US visitors:

  • Field: Country
  • Operator: Equals
  • Value: United States
Applying Filters in Catchr

Schedule & Customize Data Refreshness

In the "Options" tab, set up automatic data refresh schedules and choose preferences such as "Append rows" for ongoing data additions or "Combine rows" for cumulative data updates.

Customizing Data Refresh Options in Catchr

In conclusion, following these steps will seamlessly import Google Play Store data into Google Sheets, enabling effective analysis and strategic actions.

Example of Google Sheets you can create to use with the Google Play Store source

By leveraging the connection between Google Play Store and Google Sheets through Catchr, marketers can craft a variety of analytical reports tailored to their app's performance. Here are a few examples:

  • Revenue and Sales Analysis: Create detailed reports on revenue streams, transaction types, and item prices over chosen periods. Highlight key trends and identify areas for financial growth or restructuring.
  • App Performance Reporting: Compile data on installs, uninstalls, crashes, and average ratings. These insights help in understanding user engagement, app stability, and overall satisfaction.
  • Subscription Metrics: Track new, active, and canceled subscriptions along with discount rates and financial statuses. This analysis aids in evaluating subscription models and loyalty programs.
  • Market Analysis: Use country, device, and language dimensions to gauge your app's market penetration and user demographics. Tailor marketing strategies according to linguistic and geographical insights.

These Google Sheets powered by Catchr and Google Play Store data grant an unparalleled view into app performance, user behavior, and financial metrics, serving as invaluable tools for strategic decision-making and optimization.

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