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`
데이터 이동 색인
AdCategory	p_MatchTableAdCategory_`network_code`	MatchTableAdCategory_`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(지원 중단됨)	-	-
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`