Transformasi laporan Google Ad Manager

Saat file transfer data Google Ad Manager (sebelumnya dikenal sebagai DoubleClick for Publishers) ditransfer ke BigQuery, file tersebut diubah ke dalam tabel dan tampilan BigQuery berikut.

Saat Anda melihat tabel dan tampilan di BigQuery, nilai untuk network_code adalah kode jaringan Google Ad Manager Anda.

File Google Ad Manager	Tabel BigQuery	Tampilan BigQuery
File Transfer Data
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`
Tabel Pencocokan
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`
Perusahaan	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 (tidak digunakan lagi)	-	-
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`
Memesan	p_MatchTableOrder_`network_code`	MatchTableOrder_`network_code`
Penempatan	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`
Pengguna	p_MatchTableUser_`network_code`	MatchTableUser_`network_code`