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]
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]
此页内容是否有用?请给出您的反馈和评价:

发送以下问题的反馈:

此网页
需要帮助?请访问我们的支持页面