Google Ad Manager 보고서 변환

Google Ad Manager(이전 DoubleClick for Publishers) 데이터 전송 파일이 BigQuery로 전송될 때는 다음 BigQuery 테이블 및 뷰로 변환됩니다.

BigQuery에서 테이블과 뷰를 볼 때는 [NETWORK_CODE] 값이 Google Ad Manager 네트워크 코드에 해당합니다.

Google Ad Manager 파일 BigQuery 테이블 BigQuery 뷰
데이터 전송 파일
NetworkRequests NetworkBackfillRequests p_NetworkRequests_[NETWORK_CODE] p_NetworkBackfillRequests_[NETWORK_CODE] NetworkRequests_[NETWORK_CODE] NetworkBackfillRequests_[NETWORK_CODE]
NetworkCodeServes NetworkBackfillCodeServes p_NetworkCodeServes p_NetworkBackfillCodeServes_[NETWORK_CODE] NetworkCodeServes NetworkBackfillCodeServes_[NETWORK_CODE]
NetworkImpressions NetworkBackfillImpressions p_NetworkImpressions_[NETWORK_CODE] p_NetworkBackfillImpressions_[NETWORK_CODE] NetworkImpressions_[NETWORK_CODE] NetworkBackfillImpressions_[NETWORK_CODE]
NetworkClicks NetworkBackfillClicks p_NetworkClicks_[NETWORK_CODE] p_NetworkBackfillClicks_[NETWORK_CODE] NetworkClicks_[NETWORK_CODE] NetworkBackfillClicks_[NETWORK_CODE]
NetworkActiveViews NetworkBackfillActiveViews p_NetworkActiveViews_[NETWORK_CODE] p_NetworkBackfillActiveViews_[NETWORK_CODE] NetworkActiveViews_[NETWORK_CODE] NetworkBackfillActiveViews_[NETWORK_CODE]
NetworkBackfillBids p_NetworkBackfillBids_[NETWORK_CODE] NetworkBackfillBids_[NETWORK_CODE]
NetworkVideoConversions NetworkBackfillVideoConversions p_NetworkVideoConversions_[NETWORK_CODE] p_NetworkBackfillVideoConversions_[NETWORK_CODE] NetworkVideoConversions_[NETWORK_CODE] NetworkBackfillVideoConversions_[NETWORK_CODE]
NetworkRichMediaConversions NetworkBackfillRichMediaConversions p_NetworkRichMediaConversions_[NETWORK_CODE] p_NetworkBackfillRichMediaConversions_[NETWORK_CODE] NetworkRichMediaConversions_[NETWORK_CODE] NetworkBackfillRichMediaConversions_[NETWORK_CODE]
NetworkActivities p_NetworkActivities_[NETWORK_CODE] NetworkActivities_[NETWORK_CODE]
데이터 이동 색인
AdUnit p_MatchTableAdUnit_[NETWORK_CODE] MatchTableAdUnit_[NETWORK_CODE]
AudienceSegment p_MatchTableAudienceSegment_[NETWORK_CODE] MatchTableAudienceSegment_[NETWORK_CODE]
AudienceSegmentCategory p_MatchTableAudienceSegmentCategory_[NETWORK_CODE] MatchTableAudienceSegmentCategory_[NETWORK_CODE]
BandwidthGroup p_MatchTableBandwidthGroup_[NETWORK_CODE] MatchTableBandwidthGroup_[NETWORK_CODE]
Browser p_MatchTableBrowser_[NETWORK_CODE] MatchTableBrowser_[NETWORK_CODE]
BrowserLanguage p_MatchTableBrowserLanguage_[NETWORK_CODE] MatchTableBrowserLanguage_[NETWORK_CODE]
Company p_MatchTableCompany_[NETWORK_CODE] MatchTableCompany_[NETWORK_CODE]
DeviceCapability p_MatchTableDeviceCapability_[NETWORK_CODE] MatchTableDeviceCapability_[NETWORK_CODE]
DeviceCategory p_MatchTableDeviceCategory_[NETWORK_CODE] MatchTableDeviceCategory_[NETWORK_CODE]
DeviceManufacturer p_MatchTableDeviceManufacturer_[NETWORK_CODE] MatchTableDeviceManufacturer_[NETWORK_CODE]
ExchangeRate p_MatchTableExchangeRate_[NETWORK_CODE] MatchTableExchangeRate_[NETWORK_CODE]
GeoTarget p_MatchTableGeoTarget_[NETWORK_CODE] MatchTableGeoTarget_[NETWORK_CODE]
LineItem p_MatchTableLineItem_[NETWORK_CODE] MatchTableLineItem_[NETWORK_CODE]
MobileCarrier p_MatchTableMobileCarrier_[NETWORK_CODE] MatchTableMobileCarrier_[NETWORK_CODE]
MobileDevice p_MatchTableMobileDevice_[NETWORK_CODE] MatchTableMobileDevice_[NETWORK_CODE]
MobileDeviceSubmodel p_MatchTableMobileDeviceSubmodel_[NETWORK_CODE] MatchTableMobileDeviceSubmodel_[NETWORK_CODE]
OperatingSystem p_MatchTableOperatingSystem_[NETWORK_CODE] MatchTableOperatingSystem_[NETWORK_CODE]
OperatingSystemVersion p_MatchTableOperatingSystemVersion_[NETWORK_CODE] MatchTableOperatingSystemVersion_[NETWORK_CODE]
Order p_MatchTableOrder_[NETWORK_CODE] MatchTableOrder_[NETWORK_CODE]
Placement p_MatchTablePlacement_[NETWORK_CODE] MatchTablePlacement_[NETWORK_CODE]
ProgrammaticBuyer p_MatchTableProgrammaticBuyer_[NETWORK_CODE] MatchTableProgrammaticBuyer_[NETWORK_CODE]
ProposalRetractionReason p_MatchTableProposalRetractionReason_[NETWORK_CODE] MatchTableProposalRetractionReason_[NETWORK_CODE]
ThirdPartyCompany p_MatchTableThirdPartyCompany_[NETWORK_CODE] MatchTableThirdPartyCompany_[NETWORK_CODE]
TimeZone p_MatchTableTimeZone_[NETWORK_CODE] MatchTableTimeZone_[NETWORK_CODE]
User p_MatchTableUser_[NETWORK_CODE] MatchTableUser_[NETWORK_CODE]
이 페이지가 도움이 되었나요? 평가를 부탁드립니다.

다음에 대한 의견 보내기...

도움이 필요하시나요? 지원 페이지를 방문하세요.