Google Ad Manager 报告转换

当 Google Ad Manager（以前称为 DFP 广告管理系统）数据转移文件转移到 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`
浏览器	p_MatchTableBrowser_`network_code`	MatchTableBrowser_`network_code`
BrowserLanguage	p_MatchTableBrowserLanguage_`network_code`	MatchTableBrowserLanguage_`network_code`
公司	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`
排序	p_MatchTableOrder_`network_code`	MatchTableOrder_`network_code`
展示位置	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`