Transformation des rapports Google Ad Manager
Lorsque vos fichiers de transfert de données Google Ad Manager (anciennement DoubleClick for Publishers) sont transférés vers BigQuery, ils sont transformés en tables et vues BigQuery comme suit.
Lorsque vous affichez les tables et les vues dans BigQuery, la valeur de network_code correspond à votre code réseau Google Ad Manager.
Fichier Google Ad Manager | Table(s) BigQuery | Vue(s) BigQuery |
---|---|---|
Fichiers de transfert de données | ||
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 |
Tables de correspondance | ||
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 |
Entreprise | 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 (obsolète) | - | - |
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 |
Utilisateur | p_MatchTableUser_network_code | MatchTableUser_network_code |