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
匹配表
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 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
排序 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