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
|
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-08-25 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-25 UTC."],[[["\u003cp\u003eGoogle Play reports, when transferred to BigQuery, are transformed into specific tables and views for analysis.\u003c/p\u003e\n"],["\u003cp\u003eDetailed reports, including reviews and financial data such as estimated sales, earnings, and Korean Play balance funded, are transformed into corresponding p_ and non-p_ prefixed tables and views, respectively.\u003c/p\u003e\n"],["\u003cp\u003eAggregated reports like installs, crashes, ratings, and subscribers are transformed into tables and views with variations based on app version, carrier, country, device, language, and OS version.\u003c/p\u003e\n"],["\u003cp\u003eUser acquisition data, such as store performance, is also transformed into tables and views, with breakdowns by country and traffic source.\u003c/p\u003e\n"],["\u003cp\u003eWhen viewing the tables and views, the "\u003cvar translate=no\u003esuffix\u003c/var\u003e" in the table and view names indicates the table suffix you configured when you created the transfer.\u003c/p\u003e\n"]]],[],null,["# Google Play report transformation\n=================================\n\nWhen your Google Play reports are transferred to BigQuery,\nthe reports are transformed into the following BigQuery tables\nand views.\n\nWhen you view the tables and views in BigQuery, the value for\n\u003cvar translate=\"no\"\u003esuffix\u003c/var\u003e is the table suffix you configured when you created the\ntransfer."]]
