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 |
| 瀏覽器 | 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 |
| 訂單 | 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 |
| User | p_MatchTableUser_network_code | MatchTableUser_network_code |