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 |