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.
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.
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.
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.
Proceed to the "Select account(s)" section and specify the Google Play Store account(s) from which you wish to import data.
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:
Ensure that the metrics and dimensions chosen align with your analytical and reporting aims.
Following the selection of metrics and dimensions, select a predefined or custom date range for your data import under the "Date Range" tab.
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:
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.
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:
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.