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 |
Subscribers | p_Stats_Subscribers_country_suffix p_Stats_Subscribers_device_suffix |
Stats_Subscribers_country_suffix Stats_Subscribers_device_suffix |
User Acquisition | ||
Store Performance | p_Store_Performance_country_suffix p_Store_Performance_traffic_source_suffix |
Store_Performance_country_suffix Store_Performance_traffic_source_suffix |