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 |