Google uses AI technology to translate content into your preferred language. AI translations can contain errors.

Transformasi laporan Google Ad Manager

Saat file transfer data Google Ad Manager (sebelumnya dikenal sebagai DoubleClick for Publishers) ditransfer ke BigQuery, file tersebut akan diubah menjadi tabel dan tampilan BigQuery yang dijelaskan dalam dokumen ini.

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

File transfer data

Laporan di bagian berikut memberikan informasi mendetail tentang aktivitas jaringan Ad Manager Anda.

Permintaan jaringan

File Ad Manager: NetworkRequests dan NetworkBackfillRequests

Tabel BigQuery:: p_NetworkRequests_network_code
p_NetworkBackfillRequests_network_code
Tampilan BigQuery:: NetworkRequests_network_code
NetworkBackfillRequests_network_code

Penayangan kode jaringan

File Ad Manager: NetworkCodeServes dan NetworkBackfillCodeServes

Tabel BigQuery:: p_NetworkCodeServes
p_NetworkBackfillCodeServes_network_code
Tampilan BigQuery:: NetworkCodeServes
NetworkBackfillCodeServes_network_code

Tayangan iklan jaringan

File Ad Manager: NetworkImpressions dan NetworkBackfillImpressions

Tabel BigQuery:: p_NetworkImpressions_network_code
p_NetworkBackfillImpressions_network_code
Tampilan BigQuery:: NetworkImpressions_network_code
NetworkBackfillImpressions_network_code

Klik jaringan

File Ad Manager: NetworkClicks dan NetworkBackfillClicks

Tabel BigQuery:: p_NetworkClicks_network_code
p_NetworkBackfillClicks_network_code
Tampilan BigQuery:: NetworkClicks_network_code
NetworkBackfillClicks_network_code

Tampilan aktif jaringan

File Ad Manager: NetworkActiveViews dan NetworkBackfillActiveViews

Tabel BigQuery:: p_NetworkActiveViews_network_code
p_NetworkBackfillActiveViews_network_code
Tampilan BigQuery:: NetworkActiveViews_network_code
NetworkBackfillActiveViews_network_code

Bid pengisian ulang jaringan

File Ad Manager: NetworkBackfillBids

Tabel BigQuery:: p_NetworkBackfillBids_network_code
Tampilan BigQuery:: NetworkBackfillBids_network_code

Konversi video jaringan

File Ad Manager: NetworkVideoConversions dan NetworkBackfillVideoConversions

Tabel BigQuery:: p_NetworkVideoConversions_network_code
p_NetworkBackfillVideoConversions_network_code
Tampilan BigQuery:: NetworkVideoConversions_network_code
NetworkBackfillVideoConversions_network_code

Konversi multimedia jaringan

File Ad Manager: NetworkRichMediaConversions dan NetworkBackfillRichMediaConversions

Tabel BigQuery:: p_NetworkRichMediaConversions_network_code
p_NetworkBackfillRichMediaConversions_network_code
Tampilan BigQuery:: NetworkRichMediaConversions_network_code
NetworkBackfillRichMediaConversions_network_code

Aktivitas jaringan

File Ad Manager: NetworkActivities

Tabel BigQuery:: p_NetworkActivities_network_code
Tampilan BigQuery:: NetworkActivities_network_code

Tabel pencocokan

Tabel di bagian berikut berisi kolom atribut dan metadata untuk akun Anda.

Kategori iklan

File Ad Manager: AdCategory

Tabel BigQuery:: p_MatchTableAdCategory_network_code
Tampilan BigQuery:: MatchTableAdCategory_network_code

Unit iklan

File Ad Manager: AdUnit

Tabel BigQuery:: p_MatchTableAdUnit_network_code
Tampilan BigQuery:: MatchTableAdUnit_network_code

Segmen audiens

File Ad Manager: AudienceSegment

Tabel BigQuery:: p_MatchTableAudienceSegment_network_code
Tampilan BigQuery:: MatchTableAudienceSegment_network_code

Kategori segmen audiens

File Ad Manager: AudienceSegmentCategory

Tabel BigQuery:: p_MatchTableAudienceSegmentCategory_network_code
Tampilan BigQuery:: MatchTableAudienceSegmentCategory_network_code

Grup bandwidth

File Ad Manager: BandwidthGroup

Tabel BigQuery:: p_MatchTableBandwidthGroup_network_code
Tampilan BigQuery:: MatchTableBandwidthGroup_network_code

Browser

File Ad Manager: Browser

Tabel BigQuery:: p_MatchTableBrowser_network_code
Tampilan BigQuery:: MatchTableBrowser_network_code

Bahasa browser

File Ad Manager: BrowserLanguage

Tabel BigQuery:: p_MatchTableBrowserLanguage_network_code
Tampilan BigQuery:: MatchTableBrowserLanguage_network_code

Perusahaan

File Ad Manager: Perusahaan

Tabel BigQuery:: p_MatchTableCompany_network_code
Tampilan BigQuery:: MatchTableCompany_network_code

Kemampuan perangkat

File Ad Manager: DeviceCapability

Tabel BigQuery:: p_MatchTableDeviceCapability_network_code
Tampilan BigQuery:: MatchTableDeviceCapability_network_code

Device category

File Ad Manager: DeviceCategory

Tabel BigQuery:: p_MatchTableDeviceCategory_network_code
Tampilan BigQuery:: MatchTableDeviceCategory_network_code

Produsen perangkat

File Ad Manager: DeviceManufacturer

Tabel BigQuery:: p_MatchTableDeviceManufacturer_network_code
Tampilan BigQuery:: MatchTableDeviceManufacturer_network_code

Nilai tukar (tidak digunakan lagi)

File Ad Manager: ExchangeRate

Tabel BigQuery:: Tidak ada
Tampilan BigQuery:: Tidak ada

Target geografis

File Ad Manager: GeoTarget

Tabel BigQuery:: p_MatchTableGeoTarget_network_code
Tampilan BigQuery:: MatchTableGeoTarget_network_code

Item baris

File Ad Manager: LineItem

Tabel BigQuery:: p_MatchTableLineItem_network_code
Tampilan BigQuery:: MatchTableLineItem_network_code

Operator seluler

File Ad Manager: MobileCarrier

Tabel BigQuery:: p_MatchTableMobileCarrier_network_code
Tampilan BigQuery:: MatchTableMobileCarrier_network_code

Perangkat seluler

File Ad Manager: MobileDevice

Tabel BigQuery:: p_MatchTableMobileDevice_network_code
Tampilan BigQuery:: MatchTableMobileDevice_network_code

Submodel perangkat seluler

File Ad Manager: MobileDeviceSubmodel

Tabel BigQuery:: p_MatchTableMobileDeviceSubmodel_network_code
Tampilan BigQuery:: MatchTableMobileDeviceSubmodel_network_code

Sistem operasi

File Ad Manager: OperatingSystem

Tabel BigQuery:: p_MatchTableOperatingSystem_network_code
Tampilan BigQuery:: MatchTableOperatingSystem_network_code

Versi sistem operasi

File Ad Manager: OperatingSystemVersion

Tabel BigQuery:: p_MatchTableOperatingSystemVersion_network_code
Tampilan BigQuery:: MatchTableOperatingSystemVersion_network_code

Pesanan

File Ad Manager: Order

Tabel BigQuery:: p_MatchTableOrder_network_code
Tampilan BigQuery:: MatchTableOrder_network_code

Penempatan

File Ad Manager: Penempatan

Tabel BigQuery:: p_MatchTablePlacement_network_code
Tampilan BigQuery:: MatchTablePlacement_network_code

Pembeli terprogram

File Ad Manager: ProgrammaticBuyer

Tabel BigQuery:: p_MatchTableProgrammaticBuyer_network_code
Tampilan BigQuery:: MatchTableProgrammaticBuyer_network_code

Alasan pencabutan proposal

File Ad Manager: ProposalRetractionReason

Tabel BigQuery:: p_MatchTableProposalRetractionReason_network_code
Tampilan BigQuery:: MatchTableProposalRetractionReason_network_code

Perusahaan pihak ketiga

File Ad Manager: ThirdPartyCompany

Tabel BigQuery:: p_MatchTableThirdPartyCompany_network_code
Tampilan BigQuery:: MatchTableThirdPartyCompany_network_code

Zona waktu

File Ad Manager: TimeZone

Tabel BigQuery:: p_MatchTableTimeZone_network_code
Tampilan BigQuery:: MatchTableTimeZone_network_code

Pengguna

File Ad Manager: Pengguna

Tabel BigQuery:: p_MatchTableUser_network_code
Tampilan BigQuery:: MatchTableUser_network_code