Google Play Store & Google Sheets: how to integrate your data

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.

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.

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.

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.

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.

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.

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

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.

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.

‍