Google Play 보고서 변환

Google Play 보고서가 BigQuery로 전송되면 보고서는 다음과 같은 BigQuery 테이블 및 뷰로 변환됩니다.

BigQuery에서 테이블과 뷰를 볼 때 suffix 값은 전송을 생성할 때 구성한 테이블 서픽스입니다.

Google Play 보고서 BigQuery 테이블 BigQuery 뷰
세부 보고서
리뷰
리뷰 p_Reviews_suffix Reviews_suffix
재무 보고서
예상 매출 p_Sales_suffix Sales_suffix
순익 p_Earnings_suffix Earnings_suffix
대한민국 Play 잔액 차감 p_Korean_Play_balance_funded_suffix Korean_Play_balance_funded_suffix
집계 보고서
통계
설치 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
비정상 종료 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
평점 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
구독자 p_Stats_Subscribers_country_suffix
p_Stats_Subscribers_device_suffix
Stats_Subscribers_country_suffix
Stats_Subscribers_device_suffix
사용자 획득
설치 후 제거하지 않은 사용자 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
구매자(설치 후 7일) 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
구독자 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