Google アド マネージャー レポートの変換

Google アド マネージャー(旧称 DoubleClick for Publishers)のデータ転送ファイルを BigQuery に転送すると、ファイルは次の BigQuery のテーブルとビューに変換されます。

BigQuery でテーブルとビューを表示する場合、network_code の値は、Google アド マネージャーのネットワーク コードです。

Google アド マネージャーのファイル 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
User p_MatchTableUser_network_code MatchTableUser_network_code