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.
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;
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
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.
Reviews
| Field | Type | |
|---|---|---|
| __kdd_report_file | text | |
| package_name | text | |
| app_version_code | float | |
| app_version_name | text | |
| reviewer_language | text | |
| device | text | |
| review_submit_date_utc | timestamp | |
| review_last_update_date_utc | timestamp | |
| star_rating | float | |
| review_title | text | |
| review_text | text | |
| developer_reply_date_utc | timestamp | |
| developer_reply_text | text | |
| review_link | text |
Estimated sales report
| Field | Type | |
|---|---|---|
| __kdd_report_file | text | |
| state_of_buyer | text | |
| city_of_buyer | text | |
| country_of_buyer | text | |
| device_model | text | |
| product_title | text | |
| item_price | float | |
| product_id | text | |
| order_charged_date_utc | date | |
| taxes_collected | float | |
| sku_id | text | |
| financial_status | text | |
| postal_code_of_buyer | text | |
| order_charged_timestamp | float | |
| product_type | text | |
| currency_of_sale | text | |
| charged amount | float | |
| order_number | text | |
| base_plan_id | text | |
| offer_id | text |
Earnings report
| Field | Type | |
|---|---|---|
| __kdd_report_file | text | |
| merchant_currency | text | |
| hardware | text | |
| product_type | float | |
| transaction_date | date | |
| description | text | |
| product_title | text | |
| refund_type | text | |
| product_id | text | |
| amount_merchant_currency | float | |
| transaction_type | text | |
| sku_id | text | |
| buyer_country | text | |
| buyer_postal_code | text | |
| buyer_state | text | |
| transaction_time | text | |
| buyer_currency | text | |
| tax_type | text | |
| currency_conversion_rate | float | |
| amount_buyer_currency | float |
Installs
| Field | Type | |
|---|---|---|
| __kdd_report_file | text | |
| dimension | text | |
| date | date | |
| package_name | text | |
| daily_user_installs | float | |
| daily_device_upgrades | float | |
| daily_device_installs | float | |
| total_user_installs | float | |
| uninstall_events | float | |
| daily_device_uninstalls | float | |
| install_events | float | |
| update_events | float | |
| daily_user_uninstalls | float | |
| active_device_installs | float |
Crashes
| Field | Type | |
|---|---|---|
| __kdd_report_file | text | |
| dimension | text | |
| date | date | |
| package_name | text | |
| daily_crashes | float | |
| daily_anrs | float |
Ratings
| Field | Type | |
|---|---|---|
| __kdd_report_file | text | |
| dimension | text | |
| date | date | |
| package_name | text | |
| daily_average_rating | float | |
| total_average_rating | float |
Subscriptions
| Field | Type | |
|---|---|---|
| __kdd_report_file | text | |
| dimension | text | |
| date | date | |
| package_name | text | |
| product_id | text | |
| new_subscriptions | float | |
| cancelled_subscriptions | float | |
| active_subscriptions | float |
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 <a href="https://kondado.io/en/sources/google-play-store.html">Kondado Google Play Store source page</a>, 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 <a href="https://kondado.io/en/data-integration.html">data integration</a>.
