Google Play Store

Creating the data source

Adding the data source

By adding the Google Play Store data source in Kondado, you can access your Play Store apps data directly in your Data Warehouse or Data Lake – process also known as ETL or ELT.

To add the data source, you must have a user that has access to the Google Play console and its reports.

1) Sign in to Google Play Console: https://play.google.com/console

2) Once logged in, go to the “Download reports” section in the left menu and select any category of reports;

3) On the report download page, click the “Copy Cloud Storage URI” button and paste the value into a notepad;

4) On the Kondado platform, go to the add new sources page, select the Google Play Store data source and click "AUTHORIZE";

5) Select the account you wish to use;

ATTENTION: Make sure you selected the google account with the google play console access.

6) On the next screen, check ALL permissions that are required and click Continue;

7) With authorized access, name your connector, fill in the bucket obtained in step (3) and click SAVE.

Pipelines

Relationship chart

Click to expand

Crashes

Replication type: Incremental

Parameters:

Read start date (Savepoint): Initial month for data replication
Detalhamento: Select the breakdown for the report

Google Play stability statistics report, aggregated by day and by the chosen dimension, with daily counts of crashes and ANRs.

Campo	Tipo
_kdd_report_file	text	[en] Kondado internal identifier: name of the source report file (CSV) in the Google Play bucket from which this row was extracted. Used as a key to avoid duplication.
dimension	text	[en] Value of the dimension by which the report is broken down (app version, device or Android OS version, according to the dimension chosen in the pipeline).
date	date	[en] Date (UTC) the aggregated metrics in this row refer to, at daily granularity.
package_name	text	[en] Package name (application ID) of the app on the Google Play Store, e.g. com.company.app.
daily_crashes	float	[en] Number of app crashes recorded on the day.
daily_anrs	float	[en] Number of ANR (Application Not Responding) errors of the app recorded on the day.

Earnings

Replication type: Incremental

Parameters:

Read start date (Savepoint): Initial month for data replication

Google Play Earnings report: one row per type of financial movement (charge, Google fee, tax, refund, adjustment), with amounts in the buyer currency and in the developer currency.

Campo	Tipo
_kdd_report_file	text	[en] Kondado internal identifier: name of the source report file (CSV) in the Google Play bucket from which this row was extracted. Used as a key to avoid duplication.
merchant_currency	text	[en] Currency code (ISO) in which the developer (merchant) is paid.
hardware	text	[en] Android device model used in the purchase (for subscriptions, the one of the original purchase).
product_type	float	[en] Product type of the transaction (e.g. managed in-app product or subscription).
transaction_date	date	[en] Date (UTC) when the transaction occurred.
description	text	[en] Description of the transaction/product associated with the earnings line.
product_title	text	[en] Name/title of the product (paid app, in-app product or subscription).
refund_type	text	[en] Refund type when the line represents a refund (e.g. full, partial).
product_id	text	[en] Identifier of the app or product: app package name or in-app product/subscription ID.
amount_merchant_currency	float	[en] Transaction line amount in the developer (merchant) currency, already converted.
transaction_type	text	[en] Transaction type (e.g. Charge, Google fee, Tax, Charge refund, Adjustment).
sku_id	text	[en] SKU (identifier) of the in-app product or subscription plan.
buyer_country	text	[en] Country code (ISO) of the buyer.
buyer_postal_code	text	[en] Postal/ZIP code of the buyer.
buyer_state	text	[en] State/region of the buyer.
transaction_time	text	[en] Time/timestamp (UTC) when the transaction occurred.
buyer_currency	text	[en] Currency code (ISO) in which the buyer made the payment.
tax_type	text	[en] Type of tax applied to the line (e.g. third-party tax); blank for non-tax lines.
currency_conversion_rate	float	[en] Conversion rate used to convert the amount from the buyer currency to the developer currency.
amount_buyer_currency	float	[en] Transaction line amount in the buyer currency, before conversion.

Estimated sales

Replication type: Incremental

Parameters:

Read start date (Savepoint): Initial month for data replication

Google Play Estimated Sales report: one row per purchase transaction of a paid app, in-app product or subscription, with amounts before taxes and Google fees.

Campo	Tipo
_kdd_report_file	text	[en] Kondado internal identifier: name of the source report file (CSV) in the Google Play bucket from which this row was extracted. Used as a key to avoid duplication.
state_of_buyer	text	[en] State/region of the buyer billing address.
city_of_buyer	text	[en] City of the buyer billing address.
country_of_buyer	text	[en] Country code (ISO) of the buyer billing address.
device_model	text	[en] Device model used to make the purchase.
product_title	text	[en] Name/title of the product (paid app, in-app product or subscription).
item_price	float	[en] Listed unit price of the item in the sale currency, before taxes and fees.
product_id	text	[en] Identifier of the app or product: app package name or in-app product/subscription ID.
order_charged_date_utc	date	[en] Date (UTC) when the transaction was charged to the buyer.
taxes_collected	float	[en] Amount of taxes collected on the transaction, in the sale currency.
sku_id	text	[en] SKU (identifier) of the in-app product or subscription plan.
financial_status	text	[en] Financial status of the transaction (e.g. Charged, Refund, Chargeback).
postal_code_of_buyer	text	[en] Postal/ZIP code of the buyer billing address.
order_charged_timestamp	float	[en] Timestamp (epoch) of the moment the transaction was charged.
product_type	text	[en] Product type of the transaction (e.g. 1 = managed in-app product, 2 = subscription).
currency_of_sale	text	[en] Currency code (ISO) in which the sale was made.
charged amount	float	[en] Total amount charged to the buyer in the transaction, in the sale currency.
order_number	text	[en] Unique order number/identifier on Google Play.
base_plan_id	text	[en] Identifier of the subscription base plan, when applicable.
offer_id	text	[en] Identifier of the offer applied to the subscription, when applicable.

Installs

Replication type: Incremental

Parameters:

Read start date (Savepoint): Initial month for data replication
Detalhamento: Select the breakdown for the report

Google Play install statistics report, aggregated by day and by the chosen dimension, with install, uninstall and update metrics at the user and device levels.

Campo	Tipo
_kdd_report_file	text	[en] Kondado internal identifier: name of the source report file (CSV) in the Google Play bucket from which this row was extracted. Used as a key to avoid duplication.
dimension	text	[en] Value of the dimension by which the report is broken down (e.g. country, device, app version, language, carrier or Android OS version, according to the dimension chosen in the pipeline).
date	date	[en] Date (UTC) the aggregated metrics in this row refer to, at daily granularity.
package_name	text	[en] Package name (application ID) of the app on the Google Play Store, e.g. com.company.app.
daily_user_installs	float	[en] Number of new unique users who installed the app on the day (user level).
daily_device_upgrades	float	[en] Number of devices that upgraded the app to a new version on the day.
daily_device_installs	float	[en] Number of app installs on devices on the day, including new installs and reinstalls (device level).
total_user_installs	float	[en] Cumulative total of unique users who have the app installed as of the date.
uninstall_events	float	[en] Number of uninstall events recorded on the day.
daily_device_uninstalls	float	[en] Number of devices that uninstalled the app on the day (device level).
install_events	float	[en] Number of install events recorded on the day.
update_events	float	[en] Number of app update events recorded on the day.
daily_user_uninstalls	float	[en] Number of unique users who uninstalled the app on the day (user level).
active_device_installs	float	[en] Number of active devices (used at least once in the last 30 days) with the app installed.

Ratings

Replication type: Incremental

Parameters:

Read start date (Savepoint): Initial month for data replication
Detalhamento: Select the breakdown for the report

Google Play ratings statistics report, aggregated by day and by the chosen dimension, with the daily average and the cumulative average of star ratings.

Campo	Tipo
_kdd_report_file	text	[en] Kondado internal identifier: name of the source report file (CSV) in the Google Play bucket from which this row was extracted. Used as a key to avoid duplication.
dimension	text	[en] Value of the dimension by which the report is broken down (e.g. country, device, app version, language, carrier or Android OS version, according to the dimension chosen in the pipeline).
date	date	[en] Date (UTC) the aggregated metrics in this row refer to, at daily granularity.
package_name	text	[en] Package name (application ID) of the app on the Google Play Store, e.g. com.company.app.
daily_average_rating	float	[en] Average star rating received on the day (1 to 5).
total_average_rating	float	[en] Cumulative average of all star ratings as of the date (1 to 5).

Reviews

Replication type: Incremental

Parameters:

Read start date (Savepoint): Initial month for data replication

Public app reviews on the Google Play Store, with star rating, user text and developer reply. One row per review.

Campo	Tipo
_kdd_report_file	text	[en] Kondado internal identifier: name of the source report file (CSV) in the Google Play bucket from which this row was extracted. Used as a key to avoid duplication.
package_name	text	[en] Package name (application ID) of the app on the Google Play Store, e.g. com.company.app.
app_version_code	float	[en] Numeric version code (versionCode) of the app installed on the device where the review was written.
app_version_name	text	[en] Version name/label (versionName) of the app installed on the device at the time of the review.
reviewer_language	text	[en] Language code (e.g. pt_BR) set on the reviewer device.
device	text	[en] Codename of the device model from which the review was submitted.
review_submit_date_utc	timestamp	[en] Date and time (UTC) when the review was originally submitted by the user.
review_last_update_date_utc	timestamp	[en] Date and time (UTC) of the last update of the review by the user.
star_rating	float	[en] Star rating given by the user, from 1 to 5.
review_title	text	[en] Title of the review written by the user (may be empty).
review_text	text	[en] Body text/comment of the review written by the user (may be empty).
developer_reply_date_utc	timestamp	[en] Date and time (UTC) of the developer reply to the review, when present.
developer_reply_text	text	[en] Text of the developer reply to the review, when present.
review_link	text	[en] URL to the review in the Google Play Console.

Subscriptions

Replication type: Incremental

Parameters:

Read start date (Savepoint): Initial month for data replication
Detalhamento: Select the breakdown for the report

Google Play subscription statistics report, aggregated by day and by the chosen dimension, with counts of new, cancelled and active subscriptions.

Campo	Tipo
_kdd_report_file	text	[en] Kondado internal identifier: name of the source report file (CSV) in the Google Play bucket from which this row was extracted. Used as a key to avoid duplication.
dimension	text	[en] Value of the dimension by which the subscriptions report is broken down (country or device).
date	date	[en] Date (UTC) the aggregated metrics in this row refer to, at daily granularity.
package_name	text	[en] Package name (application ID) of the app on the Google Play Store, e.g. com.company.app.
product_id	text	[en] Identifier of the subscription product.
new_subscriptions	float	[en] Number of new subscriptions acquired on the day.
cancelled_subscriptions	float	[en] Number of subscriptions cancelled on the day.
active_subscriptions	float	[en] Number of active subscriptions as of the date.

Notes

Google Play Store pipelines use monthly reporting data aggregated by Google on a daily basis, which can take up to 3 days to provide the most recent dates.

Part of this documentation was automatically generated by AI and may contain errors. We recommend verifying critical information

Add Google Play Store as a data source on Kondado

Connect your Google Play Console reports to Kondado so you can ETL app data into your Data Warehouse or Data Lake.

Access Google Play Console and locate your Cloud Storage URI

Sign in to Google Play Console, navigate to "Download reports" in the left menu, select any report category, then click "Copy Cloud Storage URI" and save the value.

Start the Google Play Store connector setup on Kondado

On the Kondado Google Play Store source page, click to add the data source and select "AUTHORIZE".

Authenticate with the correct Google account

Choose the Google account that has access to your Google Play Console. Verify you selected the right account before proceeding.

Grant all required permissions

On the permissions screen, check ALL required permissions and click Continue to complete the OAuth authorization.

Configure and save your connector

Name your connector, paste the Cloud Storage URI bucket obtained in step 1, and click SAVE to finalize the data integration.

Frequently asked questions

What permissions do I need to add the Google Play Store data source?▼

You need a Google account with access to the Google Play Console and its reports. During setup, you must grant ALL permissions requested on the authorization screen.

Where do I find the Cloud Storage URI for my Play Store reports?▼

In Google Play Console, go to the left menu section "Download reports", select any report category, then click the "Copy Cloud Storage URI" button on the report download page.

How long does it take for the most recent Google Play Store data to appear in my pipeline?▼

Google Play Store pipelines use monthly reporting data aggregated on a daily basis, which can take up to 3 days to provide the most recent dates.

What reports are available from the Google Play Store data source?▼

Available reports include Reviews, Estimated sales, Earnings, Installs, Crashes, Ratings, and Subscriptions. See the pre-built reports page for detailed field schemas for each report.

Can I send Google Play Store data to a BI tool or spreadsheet?▼

Yes, after adding the source you can route the data to any Kondado destination, including Data Warehouses, Data Lakes, or BI tools for visualization and analysis.

Written by

Thassyo Pereira·Published 2023-06-16·Updated 2026-06-01