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
사용자 p_MatchTableUser_network_code MatchTableUser_network_code