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 |