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`