Transformation des rapports Google Play

Lorsque vos rapports Google Play sont transférés vers BigQuery, ils sont transformés en tables et vues BigQuery, comme indiqué ci-dessous.

Lorsque vous affichez les tables et les vues dans BigQuery, la valeur de suffix est le suffixe de table que vous avez configuré au moment de la création du transfert.

Rapport Google Play Table BigQuery Vue BigQuery
Rapports détaillés
Avis
Avis p_Reviews_suffix Reviews_suffix
Rapports financiers
Ventes estimées p_Sales_suffix Sales_suffix
Revenus p_Earnings_suffix Earnings_suffix
Achats coréens payés via le solde Play p_Korean_Play_balance_funded_suffix Korean_Play_balance_funded_suffix
Rapports agrégés
Statistiques
Installations 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
Plantages 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
Notes 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
Abonnés p_Stats_Subscribers_country_suffix
p_Stats_Subscribers_device_suffix
Stats_Subscribers_country_suffix
Stats_Subscribers_device_suffix
Acquisition d'utilisateurs
Personnes ayant installé et conservé l'application 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
Acheteurs (sept jours après l'installation) 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
Abonnés 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