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 deze pagina nuttig? Laat ons weten hoe goed we u hebben geholpen:

Feedback verzenden over...

BigQuery Data Transfer Service