Google Play Report Transformation

When your Google Play reports are transferred to BigQuery, the reports are transformed into the following BigQuery tables and views.

When you view the tables and views in BigQuery, the value for [SUFFIX] is the table suffix you configured when you created the transfer.

Google Play report BigQuery table BigQuery view
Detailed Reports
Reviews
Reviews p_Reviews_[SUFFIX] Reviews_[SUFFIX]
Financial Reports
Estimated Sales p_Sales_[SUFFIX] Sales_[SUFFIX]
Earnings p_Earnings_[SUFFIX] Earnings_[SUFFIX]
Korean Play balance funded p_Korean_Play_balance_funded_[SUFFIX] Korean_Play_balance_funded_[SUFFIX]
Aggregated Reports
Statistics
Installs p_Installs_app_version_[SUFFIX]
p_Installs_carrier_[SUFFIX]
p_Installs_country_[SUFFIX]
p_Installs_device_[SUFFIX]
p_Installs_language_[SUFFIX]
p_Installs_os_version_[SUFFIX]
Installs_app_version_[SUFFIX]
Installs_carrier_[SUFFIX]
Installs_country_[SUFFIX]
Installs_device_[SUFFIX]
Installs_language_[SUFFIX]
Installs_os_version_[SUFFIX]
Crashes p_Crashes_app_version_[SUFFIX]
p_Crashes_device_[SUFFIX]
p_Crashes_os_version_[SUFFIX]
Crashes_app_version_[SUFFIX]
Crashes_device_[SUFFIX]
Crashes_os_version_[SUFFIX]
Ratings p_Ratings_app_version_[SUFFIX]
p_Ratings_carrier_[SUFFIX]
p_Ratings_country_[SUFFIX]
p_Ratings_device_[SUFFIX]
p_Ratings_language_[SUFFIX]
p_Ratings_os_version_[SUFFIX]
Ratings_app_version_[SUFFIX]
Ratings_carrier_[SUFFIX]
Ratings_country_[SUFFIX]
Ratings_device_[SUFFIX]
Ratings_language_[SUFFIX]
Ratings_os_version_[SUFFIX]
FCM p_Firebase_Cloud_Messaging_app_version_[SUFFIX]
p_Firebase_Cloud_Messaging_carrier_[SUFFIX]
p_Firebase_Cloud_Messaging_country_[SUFFIX]
p_Firebase_Cloud_Messaging_device_[SUFFIX]
p_Firebase_Cloud_Messaging_language_[SUFFIX]
p_Firebase_Cloud_Messaging_os_version_[SUFFIX]
p_Firebase_Cloud_Messaging_message_status_[SUFFIX]
p_Firebase_Cloud_Messaging_response_code_[SUFFIX]
Firebase_Cloud_Messaging_app_version_[SUFFIX]
Firebase_Cloud_Messaging_carrier_[SUFFIX]
Firebase_Cloud_Messaging_country_[SUFFIX]
Firebase_Cloud_Messaging_device_[SUFFIX]
Firebase_Cloud_Messaging_language_[SUFFIX]
Firebase_Cloud_Messaging_os_version_[SUFFIX]
Firebase_Cloud_Messaging_message_status_[SUFFIX]
Firebase_Cloud_Messaging_response_code_[SUFFIX]
Subscribers p_Stats_Subscribers_country_[SUFFIX]
p_Stats_Subscribers_device_[SUFFIX]
Stats_Subscribers_country_[SUFFIX]
Stats_Subscribers_device_[SUFFIX]
User Acquisition
Retained Installers p_Retained_installers_channel_[SUFFIX]
p_Retained_installers_country_[SUFFIX]
p_Retained_installers_play_country_[SUFFIX]
p_Retained_installers_utm_tagged_[SUFFIX]
p_Retained_installers_google_[SUFFIX]
Retained_installers_channel_[SUFFIX]
Retained_installers_country_[SUFFIX]
Retained_installers_play_country_[SUFFIX]
Retained_installers_utm_tagged_[SUFFIX]
Retained_installers_google_[SUFFIX]
Buyers (7 days after install) p_Buyers_7_days_after_install_channel_[SUFFIX]
p_Buyers_7_days_after_install_country_[SUFFIX]
p_Buyers_7_days_after_install_play_country_[SUFFIX]
p_Buyers_7_days_after_install_utm_tagged_[SUFFIX]
p_Buyers_7_days_after_install_google_[SUFFIX]
Buyers_7_days_after_install_channel_[SUFFIX]
Buyers_7_days_after_install_country_[SUFFIX]
Buyers_7_days_after_install_play_country_[SUFFIX]
Buyers_7_days_after_install_utm_tagged_[SUFFIX]
Buyers_7_days_after_install_google_[SUFFIX]
Subscribers p_Subscribers_channel_[SUFFIX]
p_Subscribers_country_[SUFFIX]
p_Subscribers_play_country_[SUFFIX]
p_Subscribers_utm_tagged_[SUFFIX]
p_Subscribers_google_[SUFFIX]
Subscribers_channel_[SUFFIX]
Subscribers_country_[SUFFIX]
Subscribers_play_country_[SUFFIX]
Subscribers_utm_tagged_[SUFFIX]
Subscribers_google_[SUFFIX]
Was this page helpful? Let us know how we did:

Send feedback about...

Need help? Visit our support page.