La nouvelle API Search Ads 360 Reporting est désormais disponible. Rejoignez le groupe Google searchads-api-announcements pour vous tenir informé des améliorations et versions à venir.

Cette page a été traduite par l'API Cloud Translation.

Mappages de champs pour l'API Search Ads 360 Reporting

Les tableaux suivants mappent les champs de l'ancienne API Search Ads 360 avec les ressources de la nouvelle API Search Ads 360 Reporting.

Rapport de compte

Noms de colonnes dans le rapport `account`	nouveau mappage de l'API Search Ads 360 Reporting
`absoluteTopImpressionPercentage`	`metrics.absolute_top_impression_percentage`
`account`	`customer.descriptive_name`
`accountCurrencyCode`	`customer.currency_code`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountTimeZone`	`customer.time_zone`
`accountType`	`customer.account_type`
`advertiser`	Voir la section Gestion des comptes
`advertiserId`	Voir la section Gestion des comptes
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`
`agency`	Voir la section Gestion des comptes
`agencyId`	Voir la section Gestion des comptes
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Nouveau comportement
`clicks`	`metrics.clicks`
`cost`	`metrics.cost_micros`
`creationTimestamp`	`customer.creation_time`
`ctr`	`metrics.ctr`
`date`	`segments.date`
`deviceSegment`	`segments.device`
`dfaActions`	`metrics.all_conversions` – `metrics.cross_device_conversions`
`dfaActionsCrossEnv`	`metrics.all_conversions`
`dfaRevenue`	`metrics.all_conversions_value` – `metrics.cross_device_conversions_value`
`dfaRevenueCrossEnv`	`metrics.all_conversions_value`
`dfaTransactions`	`metrics.all_conversions` – `metrics.cross_device_conversions`
`dfaTransactionsCrossEnv`	`metrics.all_conversions`
`dfaWeightedActions`	Nouveau comportement
`dfaWeightedActionsCrossEnv`	Nouveau comportement
`displayBudgetLostImpressionShare`	`metrics.content_budget_lost_impression_share`
`displayImpressionShare`	`metrics.content_impression_share`
`displayRankLostImpressionShare`	`metrics.content_rank_lost_impression_share`
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Utiliser `conversion_action`
`floodlightActivityTag`	Utiliser `conversion_action`
`floodlightGroup`	Nouveau comportement
`floodlightGroupId`	Nouveau comportement
`floodlightGroupTag`	Utiliser `conversion_action`
`impr`	`metrics.impressions`
`lastModifiedTimestamp`	`customer.last_modified_time`
`monthEnd`	Nouveau comportement
`monthStart`	`segments.month`
`qualityScoreAvg`	`metrics.historical_quality_score`
`quarterEnd`	Nouveau comportement
`quarterStart`	`segments.quarter`
`searchAbsoluteTopImpressionShare`	`metrics.search_absolute_top_impression_share`
`searchBudgetLostAbsoluteTopImpressionShare`	`metrics.search_budget_lost_absolute_top_impression_share`
`searchBudgetLostImpressionShare`	`metrics.search_budget_lost_impression_share`
`searchBudgetLostTopImpressionShare`	`metrics.search_budget_lost_top_impression_share`
`searchImpressionShare`	`metrics.search_impression_share`
`searchRankLostAbsoluteTopImpressionShare`	`metrics.search_rank_lost_absolute_top_impression_share`
`searchRankLostImpressionShare`	`metrics.search_rank_lost_impression_share`
`searchRankLostTopImpressionShare`	`metrics.search_rank_lost_top_impression_share`
`searchTopImpressionShare`	`metrics.search_top_impression_share`
`status`	`customer.status`
`topImpressionPercentage`	`metrics.top_impression_percentage`
`topOfPageBidAvg`	Nouveau comportement
`visits`	`metrics.visits`
`weekEnd`	Nouveau comportement
`weekStart`	`segments.week`
`yearEnd`	Nouveau comportement
`yearStart`	`segments.year`

Rapport sur les performances des annonces

Noms de colonnes dans le rapport `ad`	nouveau mappage de l'API Search Ads 360 Reporting
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`ad`	`ad_group_ad.ad.name`
`adDescription1`	`ad_group_ad.ad.{ad type}.description1`¹
`adDescription2`	`ad_group_ad.ad.{ad type}.description2`¹
`adDisplayUrl`	`ad_group_ad.ad.display_url`
`adEngineId`	`ad_group_ad.engine_id` ou `ad_group_ad.ad.id`²
`adGroup`	`ad_group.name`
`adGroupId`	`ad_group.id`
`adGroupStatus`	`ad_group.status`
`adHeadline`	`ad_group_ad.ad.{ad type}.headline`³.
`adHeadline2`	`ad_group_ad.ad.expanded_text_ad.headline2`
`adHeadline3`	`ad_group_ad.ad.expanded_text_ad.headline3`
`adId`	`ad_group_ad.ad.id`
`adLabels`	`ad_group_ad.labels`
`adLandingPage`	`ad_group_ad.ad.final_urls`
`adPathField1`	`ad_group_ad.ad.{ad type}.path1`⁴
`adPathField2`	`ad_group_ad.ad.{ad type}.path2`⁴
`adPromotionLine`	Nouveau comportement
`adType`	`ad_group_ad.ad.type`
`advertiser`	Voir la section Gestion des comptes
`advertiserId`	Voir la section Gestion des comptes
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`
`agency`	Voir la section Gestion des comptes
`agencyId`	Voir la section Gestion des comptes
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Nouveau comportement
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`clicks`	`metrics.clicks`
`cost`	`metrics.cost_micros`
`creationTimestamp`	`ad_group_ad.creation_time`
`ctr`	`metrics.ctr`
`date`	`segments.date`
`deviceSegment`	`segments.device`
`dfaActions`	`metrics.all_conversions` – `metrics.cross_device_conversions`
`dfaActionsCrossEnv`	`metrics.all_conversions`
`dfaRevenue`	`metrics.all_conversions_value` – `metrics.cross_device_conversions_value`
`dfaRevenueCrossEnv`	`metrics.all_conversions_value`
`dfaTransactions`	`metrics.all_conversions` – `metrics.cross_device_conversions`
`dfaTransactionsCrossEnv`	`metrics.all_conversions`
`dfaWeightedActions`	Nouveau comportement
`dfaWeightedActionsCrossEnv`	Nouveau comportement
`effectiveLabels`	`Not available in V0`
`engineStatus`	`ad_group_ad.engine_status`
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Utiliser `conversion_action`
`floodlightActivityTag`	Utiliser `conversion_action`
`floodlightGroup`	Nouveau comportement
`floodlightGroupId`	Nouveau comportement
`floodlightGroupTag`	Utiliser `conversion_action`
`impr`	`metrics.impressions`
`isUnattributedAd`	`Not available`
`lastModifiedTimestamp`	`ad_group_ad.last_modified_time`
`monthEnd`	Nouveau comportement
`monthStart`	`segments.month`
`quarterEnd`	Nouveau comportement
`quarterStart`	`segments.quarter`
`status`	`ad_group_ad.status`
`visits`	`metrics.visits`
`weekEnd`	Nouveau comportement
`weekStart`	`segments.week`
`yearEnd`	Nouveau comportement
`yearStart`	`segments.year`

Rapport sur les groupes d'annonces

Noms de colonnes dans le rapport `adGroup`	nouveau mappage de l'API Search Ads 360 Reporting
`absoluteTopImpressionPercentage`	`metrics.absolute_top_impression_percentage`
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`adGroup`	`ad_group.name`
`adGroupBroadMaxCpc`	Nouveau comportement
`adGroupContentMaxCpc`	Nouveau comportement
`adGroupDesktopBidAdjustment`	`ad_group_bid_modifier`
`adGroupEndDate`	`ad_group.end_date`
`adGroupEngineId`	`ad_group.engine_id`
`adGroupExactMaxCpc`	Nouveau comportement
`adGroupId`	`ad_group.id`
`adGroupLabels`	`ad_group.labels label.name`
`adGroupMobileBidAdjustment`	`ad_group_bid_modifier`
`adGroupPhraseMaxCpc`	Nouveau comportement
`adGroupSearchMaxCpc`	`ad_group.cpc_bid_micros`
`adGroupStartDate`	`ad_group.start_date`
`adGroupStatus`	`ad_group.status`
`adGroupTabletBidAdjustment`	`ad_group_bid_modifier`
`adGroupType`	`ad_group.type`
`adRotation`	`ad_group.ad_rotation_mode`
`advertiser`	Voir la section Gestion des comptes
`advertiserId`	Voir la section Gestion des comptes
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`
`agency`	Voir la section Gestion des comptes
`agencyId`	Voir la section Gestion des comptes
`appId`	`asset.mobile_app_asset.app_id`
`appStore`	`asset.mobile_app_asset.app_store`
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Nouveau comportement
`bidStrategyInherited`	Nouveau comportement
`bingAdsAdDistributions`	Nouveau comportement
`bingAdsLanguage`	`ad_group.language_code`
`callCallOnly`	Nouveau comportement
`callConversionTracker`	`asset.call_asset.call_conversion_action`
`callConversionTrackerId`	Nouveau comportement
`callCountryCode`	`asset.call_asset.country_code`
`callIsTracked`	`asset.call_asset.call_tracking_enabled`
`callPhoneNumber`	`asset.call_asset.phone_number`
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`cityTargets`	`ad_group_criterion.location.geo_target_constant`
`clicks`	`metrics.clicks`
`clicksWithFeedItemShowing`	Nouveau comportement
`cost`	`metrics.cost_micros`
`costWithFeedItemShowing`	Nouveau comportement
`countryTargets`	`ad_group_criterion.location.geo_target_constant`
`creationTimestamp`	`ad_group.creation_time`
`ctr`	`metrics.ctr`
`date`	`segments.date`
`deviceSegment`	`segments.device`
`deviceTargets`	`ad_group_bid_modifier.device.type`
`dfaActions`	`metrics.all_conversions` – `metrics.cross_device_conversions`
`dfaActionsCrossEnv`	`metrics.all_conversions`
`dfaRevenue`	`metrics.all_conversions_value` – `metrics.cross_device_conversions_value`
`dfaRevenueCrossEnv`	`metrics.all_conversions_value`
`dfaTransactions`	`metrics.all_conversions` – `metrics.cross_device_conversions`
`dfaTransactionsCrossEnv`	`metrics.all_conversions`
`dfaWeightedActions`	Nouveau comportement
`dfaWeightedActionsCrossEnv`	Nouveau comportement
`displayImpressionShare`	`metrics.content_impression_share`
`displayRankLostImpressionShare`	`metrics.content_rank_lost_impression_share`
`effectiveBidStrategy`	`bidding_strategy.name`
`effectiveBidStrategyId`	`bidding_strategy.id`
`effectiveCityTargets`	`Same as cityTargets`
`effectiveCountryTargets`	`Same as countryTargets`
`effectiveDeviceTargets`	`ad_group_bid_modifier.device.type`
`effectiveLabels`	`Not available in V0`
`effectiveMetroTargets`	`Same as metroTargets`
`effectiveProvinceTargets`	`Same as provinceTargets`
`engineRemarketingListTargetAll`	`ad_group.targeting_setting.target_restrictions`
`engineStatus`	`ad_group.engine_status`
`feedId`	`asset_set.id`
`feedItemId`	`asset.id`
`feedType`	`asset.type`
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Utiliser `conversion_action`
`floodlightActivityTag`	Utiliser `conversion_action`
`floodlightGroup`	Nouveau comportement
`floodlightGroupId`	Nouveau comportement
`floodlightGroupTag`	Utiliser `conversion_action`
`impr`	`metrics.impressions`
`lastModifiedTimestamp`	`ad_group.last_modified_time`
`locationBusinessName`	`Not available in V0`
`locationCategory`	Nouveau comportement
`locationDetails`	`Not available in V0`
`locationFilter`	Nouveau comportement
`metroTargets`	`ad_group_criterion.location.geo_target_constant`
`monthEnd`	Nouveau comportement
`monthStart`	`segments.month`
`provinceTargets`	`ad_group_criterion.location.geo_target_constant`
`qualityScoreAvg`	`metrics.historical_quality_score`
`quarterEnd`	Nouveau comportement
`quarterStart`	`segments.quarter`
`searchAbsoluteTopImpressionShare`	`metrics.search_absolute_top_impression_share`
`searchImpressionShare`	`metrics.search_impression_share`
`searchRankLostAbsoluteTopImpressionShare`	`metrics.search_rank_lost_absolute_top_impression_share`
`searchRankLostImpressionShare`	`metrics.search_rank_lost_impression_share`
`searchRankLostTopImpressionShare`	`metrics.search_rank_lost_top_impression_share`
`searchTopImpressionShare`	`metrics.search_top_impression_share`
`sitelinkClickserverUrl`	`asset.tracking_url_template`
`sitelinkDescription1`	`asset.sitelink_asset.description_1`
`sitelinkDescription2`	`asset.sitelink_asset.description_2`
`sitelinkDisplayText`	`asset.sitelink_asset.link_text`
`sitelinkLandingPageUrl`	`asset.final_urls`
`status`	`ad_group.status`
`topImpressionPercentage`	`metrics.top_impression_percentage`
`topOfPageBidAvg`	Nouveau comportement
`visits`	`metrics.visits`
`weekEnd`	Nouveau comportement
`weekStart`	`segments.week`
`yearEnd`	Nouveau comportement
`yearStart`	`segments.year`

Rapport "GroupTarget"

Noms de colonnes dans le rapport `adGroupTarget`	nouveau mappage de l'API Search Ads 360 Reporting
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`adGroup`	`ad_group.name`
`adGroupId`	`ad_group.id`
`adGroupStatus`	`ad_group.status`
`adGroupTargetId`	`ad_group_criterion.criterion_id`
`advertiser`	Voir la section Gestion des comptes
`advertiserId`	Voir la section Gestion des comptes
`adWordsConversions`	`metrics.client_account_conversions`⁵
`adWordsConversionValue`	`metrics.client_account_conversions_value`⁵
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`⁵
`agency`	Voir la section Gestion des comptes
`agencyId`	Voir la section Gestion des comptes
`ageTargetAgeRange`	`ad_group_criterion.age_range.type`
`ageTargetBidModifier`	`ad_group_criterion.bid_modifier`
`avgCpc`	`metrics.average_cpc`⁵
`avgCpm`	`metrics.average_cpm`⁵
`avgPos`	Nouveau comportement
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`clicks`	`metrics.clicks`⁵
`cost`	`metrics.cost_micros`⁵
`creationTimestamp`	`ad_group_criterion.creation_time`
`ctr`	`metrics.ctr`⁵
`date`	`segments.date`
`deviceSegment`	`segments.device`
`dfaActions`	`metrics.all_conversions` – `metrics.cross_device_conversions`⁵
`dfaActionsCrossEnv`	`metrics.all_conversions`⁵
`dfaRevenue`	`metrics.all_conversions_value` – `metrics.cross_device_conversions_value`⁵
`dfaRevenueCrossEnv`	`metrics.all_conversions_value`⁵
`dfaTransactions`	`metrics.all_conversions` – `metrics.cross_device_conversions`⁵
`dfaTransactionsCrossEnv`	`metrics.all_conversions`⁵
`dfaWeightedActions`	Nouveau comportement
`dfaWeightedActionsCrossEnv`	Nouveau comportement
`dynamicSearchAdsTargetConditions`	`ad_group_criterion.webpage.conditions`
`dynamicSearchAdsTargetCoverage`	`ad_group_criterion.webpage.coverage_percentage`
`dynamicSearchAdsTargetCpcBid`	`ad_group_criterion.cpc_bid_micros`
`dynamicSearchAdsTargetLandingPageUrl`	`dynamic_search_ads_search_term_view.landing_page`
`engineRemarketingList`	`ad_group_criterion.user_list.user_list user_list.name`
`engineRemarketingListBidModifier`	`ad_group_criterion.bid_modifier`
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Utiliser `conversion_action`
`floodlightActivityTag`	Utiliser `conversion_action`
`floodlightGroup`	Nouveau comportement
`floodlightGroupId`	Nouveau comportement
`floodlightGroupTag`	Utiliser `conversion_action`
`genderTargetBidModifier`	`ad_group_criterion.bid_modifier`
`genderTargetGenderType`	`ad_group_criterion.gender.type`
`impr`	`metrics.impressions`⁵
`lastModifiedTimestamp`	`ad_group_criterion.last_modified_time`
`locationTargetBidModifier`	`ad_group_criterion.bid_modifier`
`locationTargetName`	`ad_group_criterion.location.geo_target_constant`
`monthEnd`	Nouveau comportement
`monthStart`	`segments.month`
`quarterEnd`	Nouveau comportement
`quarterStart`	`segments.quarter`
`status`	`ad_group_criterion.status`
`unclassifiedTargetName`	Nouveau comportement
`unclassifiedTargetType`	Nouveau comportement
`visits`	`Not available in V0`
`weekEnd`	Nouveau comportement
`weekStart`	`segments.week`
`yearEnd`	Nouveau comportement
`yearStart`	`segments.year`

Rapport sur les annonceurs

Noms de colonnes dans le rapport `advertiser`	nouveau mappage de l'API Search Ads 360 Reporting
`absoluteTopImpressionPercentage`	`metrics.absolute_top_impression_percentage`
`advertiser`	`customer.descriptive_name`
`advertiserCurrencyCode`	`customer.currency_code`
`advertiserId`	`customer.id`
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`
`agency`	Voir la section Gestion des comptes
`agencyId`	Voir la section Gestion des comptes
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Nouveau comportement
`clicks`	`metrics.clicks`
`cost`	`metrics.cost_micros`
`creationTimestamp`	`customer.creation_time`
`ctr`	`metrics.ctr`
`date`	`segments.date`
`deviceSegment`	`segments.device`
`dfaActions`	`metrics.all_conversions` – `metrics.cross_device_conversions`
`dfaActionsCrossEnv`	`metrics.all_conversions`
`dfaAdvertiserId`	`customer.double_click_campaign_manager_setting.advertiser_id`
`dfaNetworkId`	`customer.double_click_campaign_manager_setting.network_id`
`dfaNetworkTimeZone`	`customer.double_click_campaign_manager_setting.time_zone`
`dfaRevenue`	`metrics.all_conversions_value` – `metrics.cross_device_conversions_value`
`dfaRevenueCrossEnv`	`metrics.all_conversions_value`
`dfaTransactions`	`metrics.all_conversions` – `metrics.cross_device_conversions`
`dfaTransactionsCrossEnv`	`metrics.all_conversions`
`dfaWeightedActions`	Nouveau comportement
`dfaWeightedActionsCrossEnv`	Nouveau comportement
`displayBudgetLostImpressionShare`	`metrics.content_budget_lost_impression_share`
`displayImpressionShare`	`metrics.content_impression_share`
`displayRankLostImpressionShare`	`metrics.content_rank_lost_impression_share`
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Utiliser `conversion_action`
`floodlightActivityTag`	Utiliser `conversion_action`
`floodlightGroup`	Nouveau comportement
`floodlightGroupId`	Nouveau comportement
`floodlightGroupTag`	Utiliser `conversion_action`
`googleAnalyticsTimeZone`	`Not available in V0`
`impr`	`metrics.impressions`
`lastModifiedTimestamp`	`customer.last_modified_time`
`monthEnd`	Nouveau comportement
`monthStart`	`segments.month`
`qualityScoreAvg`	`metrics.historical_quality_score`
`quarterEnd`	Nouveau comportement
`quarterStart`	`segments.quarter`
`searchAbsoluteTopImpressionShare`	`metrics.search_absolute_top_impression_share`
`searchBudgetLostAbsoluteTopImpressionShare`	`metrics.search_budget_lost_absolute_top_impression_share`
`searchBudgetLostImpressionShare`	`metrics.search_budget_lost_impression_share`
`searchBudgetLostTopImpressionShare`	`metrics.search_budget_lost_top_impression_share`
`searchImpressionShare`	`metrics.search_impression_share`
`searchRankLostAbsoluteTopImpressionShare`	`metrics.search_rank_lost_absolute_top_impression_share`
`searchRankLostImpressionShare`	`metrics.search_rank_lost_impression_share`
`searchRankLostTopImpressionShare`	`metrics.search_rank_lost_top_impression_share`
`searchTopImpressionShare`	`metrics.search_top_impression_share`
`status`	`customer.status`
`topImpressionPercentage`	`metrics.top_impression_percentage`
`topOfPageBidAvg`	Nouveau comportement
`visits`	`Not available in V0`
`weekEnd`	Nouveau comportement
`weekStart`	`segments.week`
`yearEnd`	Nouveau comportement
`yearStart`	`segments.year`

Rapport BidStrategy

Noms de colonnes dans le rapport `bidStrategy`	nouveau mappage de l'API Search Ads 360 Reporting
`advertiser`	Voir la section Gestion des comptes
`advertiserId`	Voir la section Gestion des comptes
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`
`agency`	Voir la section Gestion des comptes
`agencyId`	Voir la section Gestion des comptes
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Nouveau comportement
`bidStrategy`	`bidding_strategy.name`
`bidStrategyGoal`	`bidding_strategy.target_*`
`bidStrategyId`	`bidding_strategy.id`
`bidStrategyMaxBid`	`bidding_strategy.target_{}.cpc_bid_ceiling_micros`
`bidStrategyMinBid`	`bidding_strategy.target_{}.cpc_bid_floor_micros`
`clicks`	`metrics.clicks`
`cost`	`metrics.cost_micros`
`cpaTarget`	`bidding_strategy.target_cpa.target_cpa_micros`
`creationTimestamp`	Nouveau comportement
`ctr`	`metrics.ctr`
`date`	`segments.date`
`dfaActions`	`metrics.all_conversions` – `metrics.cross_device_conversions`
`dfaActionsCrossEnv`	`metrics.all_conversions`
`dfaRevenue`	`metrics.all_conversions_value` – `metrics.cross_device_conversions_value`
`dfaRevenueCrossEnv`	`metrics.all_conversions_value`
`dfaTransactions`	`metrics.all_conversions` – `metrics.cross_device_conversions`
`dfaTransactionsCrossEnv`	`metrics.all_conversions`
`dfaWeightedActions`	Nouveau comportement
`dfaWeightedActionsCrossEnv`	Nouveau comportement
`ersTarget`	`bidding_strategy.target_roas.target_roas`
`floodlightActivityTargetIds`	Utilisez `segments.conversion_action` pour obtenir la liste des informations Floodlight
`floodlightOptimizationEnabled`	utilisez `segments.conversion_action` pour vérifier s'il est optimisé pour les conversions Floodlight.
`highPosition`	Nouveau comportement
`impr`	`metrics.impressions`
`lastModifiedTimestamp`	Nouveau comportement
`lowPosition`	Nouveau comportement
`monthEnd`	Nouveau comportement
`monthlySpendTarget`	`bidding_strategy.target_spend.target_spend_micros`
`monthStart`	`segments.month`
`quarterEnd`	Nouveau comportement
`quarterStart`	`segments.quarter`
`roasTarget`	`bidding_strategy.target_roas.target_roas`
`status`	`bidding_strategy.status`
`type`	`bidding_strategy.type`
`visits`	`Not available in V0`
`weekEnd`	Nouveau comportement
`weekStart`	`segments.week`
`yearEnd`	Nouveau comportement
`yearStart`	`segments.year`

Rapport sur les performances des campagnes

Noms de colonnes dans le rapport `campaign`	nouveau mappage de l'API Search Ads 360 Reporting
`absoluteTopImpressionPercentage`	`metrics.absolute_top_impression_percentage`
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`advertiser`	Voir la section Gestion des comptes
`advertiserId`	Voir la section Gestion des comptes
`adWordsBidStrategy`	`campaign.bidding_strategy_type`
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`
`agency`	Voir la section Gestion des comptes
`agencyId`	Voir la section Gestion des comptes
`appId`	`asset.mobile_app_asset.app_id`
`appStore`	`asset.mobile_app_asset.app_store`
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Nouveau comportement
`bidStrategyInherited`	Nouveau comportement
`bingAdsBudgetType`	`campaign_budget.period campaign_budget.delivery_method`
`callCallOnly`	Nouveau comportement
`callConversionTracker`	`asset.call_asset.call_conversion_action`
`callConversionTrackerId`	Nouveau comportement
`callCountryCode`	`asset.call_asset.country_code`
`callIsTracked`	`asset.call_asset.call_tracking_enabled`
`callPhoneNumber`	`asset.call_asset.phone_number`
`campaign`	`campaign.name`
`campaignDesktopBidAdjustment`	`campaign_criterion.bid_modifier campaign_criterion.device.type`
`campaignEndDate`	`campaign.end_date`
`campaignEngineId`	`campaign.engine_id`
`campaignId`	`campaign.id`
`campaignLabels`	`label.name using campaign_label resource`
`campaignMobileBidAdjustment`	`campaign_criterion.bid_modifier campaign_criterion.device.type`
`campaignStartDate`	`campaign.start_date`
`campaignStatus`	`campaign.status`
`campaignTabletBidAdjustment`	`campaign_criterion.bid_modifier campaign_criterion.device.type`
`campaignType`	`campaign.advertising_channel_type campaign.advertising_channel_sub_type`
`cityTargets`	`campaign_criterion.location.geo_target_constant`
`clicks`	`metrics.clicks`
`clicksWithFeedItemShowing`	Nouveau comportement
`cost`	`metrics.cost_micros`
`costWithFeedItemShowing`	Nouveau comportement
`countryTargets`	`campaign_criterion.location.geo_target_constant`
`creationTimestamp`	`campaign.creation_time`
`ctr`	`metrics.ctr`
`dailyBudget`	`campaign_budget.period campaign_budget.amount_micros`
`date`	`segments.date`
`deliveryMethod`	`campaign_budget.delivery_method`
`deviceSegment`	`segments.device`
`deviceTargets`	`campaign_criterion.device.type`
`dfaActions`	`metrics.all_conversions` – `metrics.cross_device_conversions`
`dfaActionsCrossEnv`	`metrics.all_conversions`
`dfaRevenue`	`metrics.all_conversions_value` – `metrics.cross_device_conversions_value`
`dfaRevenueCrossEnv`	`metrics.all_conversions_value`
`dfaTransactions`	`metrics.all_conversions` – `metrics.cross_device_conversions`
`dfaTransactionsCrossEnv`	`metrics.all_conversions`
`dfaWeightedActions`	Nouveau comportement
`dfaWeightedActionsCrossEnv`	Nouveau comportement
`displayBudgetLostImpressionShare`	`metrics.content_budget_lost_impression_share`
`displayImpressionShare`	`metrics.content_impression_share`
`displayRankLostImpressionShare`	`metrics.content_rank_lost_impression_share`
`effectiveBidStrategy`	`bidding_strategy.name`
`effectiveBidStrategyId`	`bidding_strategy.id`
`effectiveCityTargets`	`campaign_criterion.location.geo_target_constant`
`effectiveCountryTargets`	`campaign_criterion.location.geo_target_constant`
`effectiveDeviceTargets`	`campaign_criterion.device.type`
`effectiveLabels`	`Not available in V0`
`effectiveMetroTargets`	`campaign_criterion.location.geo_target_constant`
`effectiveProvinceTargets`	`campaign_criterion.location.geo_target_constant`
`engineStatus`	`Not available now. It will map to campaign.engine_status`
`excludedCityTargets`	`campaign_criterion.location.geo_target_constant (filtering with campaign_criterion.negative)`⁷.
`excludedCountryTargets`	`campaign_criterion.location.geo_target_constant (filtering with campaign_criterion.negative)`⁷.
`excludedMetroTargets`	`campaign_criterion.location.geo_target_constant (filtering with campaign_criterion.negative)`⁷.
`excludedProvinceTargets`	`campaign_criterion.location.geo_target_constant (filtering with campaign_criterion.negative)`⁷.
`feedId`	`asset_set.id`
`feedItemId`	`asset.id`
`feedType`	`asset.type`
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Utiliser `conversion_action`
`floodlightActivityTag`	Utiliser `conversion_action`
`floodlightGroup`	Nouveau comportement
`floodlightGroupId`	Nouveau comportement
`floodlightGroupTag`	Utiliser `conversion_action`
`impr`	`metrics.impressions`
`keywordNearMatchEnabled`	Nouveau comportement
`lastModifiedTimestamp`	`campaign.last_modified_time`
`languageTargets`	`campaign_criterion.language.language_constant`
`locationBusinessName`	`Not available in V0`
`locationCategory`	Nouveau comportement
`locationDetails`	`Not available in V0`
`locationFilter`	Nouveau comportement
`metroTargets`	`campaign_criterion.location.geo_target_constant`
`monthEnd`	Nouveau comportement
`monthlyBudget`	`campaign_budget.period campaign_budget.amount_micros`
`monthStart`	`segments.month`
`networkTarget`	`campaign.network_settings.target_{network_type}`
`provinceTargets`	`campaign_criterion.location.geo_target_constant`
`qualityScoreAvg`	`metrics.historical_quality_score`
`quarterEnd`	Nouveau comportement
`quarterStart`	`segments.quarter`
`searchAbsoluteTopImpressionShare`	`metrics.search_absolute_top_impression_share`
`searchBudgetLostAbsoluteTopImpressionShare`	`metrics.search_budget_lost_absolute_top_impression_share`
`searchBudgetLostImpressionShare`	`metrics.search_budget_lost_impression_share`
`searchBudgetLostTopImpressionShare`	`metrics.search_budget_lost_top_impression_share`
`searchImpressionShare`	`metrics.search_impression_share`
`searchRankLostAbsoluteTopImpressionShare`	`metrics.search_rank_lost_absolute_top_impression_share`
`searchRankLostImpressionShare`	`metrics.search_rank_lost_impression_share`
`searchRankLostTopImpressionShare`	`metrics.search_rank_lost_top_impression_share`
`searchTopImpressionShare`	`metrics.search_top_impression_share`
`sitelinkClickserverUrl`	`asset.tracking_url_template`
`sitelinkDescription1`	`asset.sitelink_asset.description_1`
`sitelinkDescription2`	`asset.sitelink_asset.description_2`
`sitelinkDisplayText`	`asset.sitelink_asset.link_text`
`sitelinkLandingPageUrl`	`asset.final_urls`
`status`	`campaign.status`
`topImpressionPercentage`	`metrics.top_impression_percentage`
`topOfPageBidAvg`	Nouveau comportement
`visits`	`metrics.visits`
`weekEnd`	Nouveau comportement
`weekStart`	`segments.week`
`yahooGeoTargets`	`campaign_criterion.location.geo_target_constant`
`yahooJapanBidStrategy`	`bidding_strategy.name`
`yearEnd`	Nouveau comportement
`yearStart`	`segments.year`

Rapport CampaignTarget

Noms de colonnes dans le rapport `campaignTarget`	nouveau mappage de l'API Search Ads 360 Reporting
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`advertiser`	Voir la section Gestion des comptes
`advertiserId`	Voir la section Gestion des comptes
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`
`agency`	Voir la section Gestion des comptes
`agencyId`	Voir la section Gestion des comptes
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Nouveau comportement
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`campaignTargetId`	`campaign_criterion.criterion_id`
`clicks`	`metrics.clicks`
`cost`	`metrics.cost_micros`
`creationTimestamp`	Nouveau comportement
`ctr`	`metrics.ctr`
`date`	`segments.date`
`deviceSegment`	`segments.device`
`dfaActions`	`metrics.all_conversions` – `metrics.cross_device_conversions`
`dfaActionsCrossEnv`	`metrics.all_conversions`
`dfaRevenue`	`metrics.all_conversions_value` – `metrics.cross_device_conversions_value`
`dfaRevenueCrossEnv`	`metrics.all_conversions_value`
`dfaTransactions`	`metrics.all_conversions` – `metrics.cross_device_conversions`
`dfaTransactionsCrossEnv`	`metrics.all_conversions`
`dfaWeightedActions`	Nouveau comportement
`dfaWeightedActionsCrossEnv`	Nouveau comportement
`engineRemarketingList`	`campaign_criterion.user_list.user_list user_list.name`
`engineRemarketingListBidModifier`	`campaign_criterion.bid_modifier`
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Utiliser `conversion_action`
`floodlightActivityTag`	Utiliser `conversion_action`
`floodlightGroup`	Nouveau comportement
`floodlightGroupId`	Nouveau comportement
`floodlightGroupTag`	Utiliser `conversion_action`
`impr`	`metrics.impressions`
`lastModifiedTimestamp`	`campaign_criterion.last_modified_time`
`locationTargetBidModifier`	`campaign_criterion.bid_modifier`
`locationTargetName`	`campaign_criterion.location.geo_target_constant`
`monthEnd`	Nouveau comportement
`monthStart`	`segments.month`
`quarterEnd`	Nouveau comportement
`quarterStart`	`segments.quarter`
`status`	`campaign_criterion.status`
`visits`	`Not available in V0`
`weekEnd`	Nouveau comportement
`weekStart`	`segments.week`
`yearEnd`	Nouveau comportement
`yearStart`	`segments.year`

Rapport sur les conversions

Noms de colonnes dans le rapport `conversion`	nouveau mappage de l'API Search Ads 360 Reporting
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.descriptive_name`
`ad`	`ad_group_ad.ad.name`⁸.
`adGroup`	`ad_group.name`
`adGroupId`	`ad_group.id`
`adGroupStatus`	`ad_group.status`
`adId`	`conversion.ad_id`
`advertiser`	Voir la section Gestion des comptes
`advertiserConversionId`	`conversion.advertiser_conversion_id`
`advertiserId`	Voir la section Gestion des comptes
`agency`	Voir la section Gestion des comptes
`agencyId`	Voir la section Gestion des comptes
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`conversionAttributionType`	`conversion.attribution_type`
`conversionDate`	`conversion.conversion_date_time`
`conversionId`	`conversion.id`
`conversionLastModifiedTimestamp`	`conversion.conversion_last_modified_date_time`
`conversionQuantity`	`conversion.conversion_quantity`
`conversionRevenue`	`conversion.conversion_revenue_micros`
`conversionSearchTerm`	Nouveau comportement
`conversionTimestamp`	`conversion.conversion_date_time`
`conversionType`	Nouveau comportement
`conversionVisitExternalClickId`	`conversion.click_id`
`conversionVisitId`	`conversion.visit_id`
`conversionVisitTimestamp`	`conversion.conversion_visit_date_time`
`deviceSegment`	`segments.device`
`feedId`	Nouveau comportement
`feedItemId`	Nouveau comportement
`feedType`	Nouveau comportement
`floodlightActivity`	Utiliser `conversion_action`
`floodlightActivityId`	Utiliser `conversion_action`
`floodlightActivityTag`	Utiliser `conversion_action`
`floodlightEventRequestString`	Nouveau comportement
`floodlightGroup`	Utiliser `conversion_action`
`floodlightGroupConversionType`	Utiliser `conversion_action`
`floodlightGroupId`	Nouveau comportement
`floodlightGroupTag`	Utiliser `conversion_action`
`floodlightOrderId`	`conversion.floodlight_order_id`
`floodlightOriginalRevenue`	`conversion.floodlight_original_revenue`
`floodlightReferrer`	Nouveau comportement
`inventoryAccountId`	`conversion.merchant_id`
`isUnattributedAd`	Nouveau comportement
`keywordId`	`conversion.criterion_id`
`keywordMatchType`	`ad_group_criterion.keyword.match_type`
`keywordText`	`ad_group_criterion.keyword.text`
`productChannel`	`conversion.product_channel`
`productCountry`	`conversion.product_country_code`
`productGroupId`	`ad_group_criterion.criterion_id`
`productId`	`conversion.product_id`
`productLanguage`	`conversion.product_language_code`
`productStoreId`	`conversion.product_store_id`
`productTargetId`	Nouveau comportement
`status`	`conversion.status`

Rapport sur l'élément de flux

Noms de colonnes dans le rapport `feedItem`	nouveau mappage de l'API Search Ads 360 Reporting
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`advertiser`	Voir la section Gestion des comptes
`advertiserId`	Voir la section Gestion des comptes
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`
`agency`	Voir la section Gestion des comptes
`agencyId`	Voir la section Gestion des comptes
`appId`	`asset.mobile_app_asset.app_id`
`appStore`	`asset.mobile_app_asset.app_store`
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Nouveau comportement
`callCallOnly`	Nouveau comportement
`callConversionTracker`	`asset.call_asset.call_conversion_action`
`callConversionTrackerId`	Nouveau comportement
`callCountryCode`	`asset.call_asset.country_code`
`callIsTracked`	`asset.call_asset.call_tracking_enabled`
`callPhoneNumber`	`asset.call_asset.phone_number`
`clicks`	`metrics.clicks`
`clicksWithFeedItemShowing`	Nouveau comportement
`cost`	`metrics.cost_micros`
`costWithFeedItemShowing`	Nouveau comportement
`creationTimestamp`	`asset.creation_time`
`ctr`	`metrics.ctr`
`date`	`segments.date`
`dfaActions`	`metrics.all_conversions` – `metrics.cross_device_conversions`
`dfaActionsCrossEnv`	`metrics.all_conversions`
`dfaRevenue`	`metrics.all_conversions_value` – `metrics.cross_device_conversions_value`
`dfaRevenueCrossEnv`	`metrics.all_conversions_value`
`dfaTransactions`	`metrics.all_conversions` – `metrics.cross_device_conversions`
`dfaTransactionsCrossEnv`	`metrics.all_conversions`
`dfaWeightedActions`	Nouveau comportement
`dfaWeightedActionsCrossEnv`	Nouveau comportement
`engineStatus`	`asset.engine_status`
`feedId`	`asset_set.id`
`feedItemId`	`asset.id`
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Utiliser `conversion_action`
`floodlightActivityTag`	Utiliser `conversion_action`
`floodlightGroup`	Nouveau comportement
`floodlightGroupId`	Nouveau comportement
`floodlightGroupTag`	Utiliser `conversion_action`
`impr`	`metrics.impressions`
`lastModifiedTimestamp`	`asset.last_modified_time`
`locationBusinessName`	`Not available in V0`
`locationCategory`	Nouveau comportement
`locationDetails`	`Not available in V0`
`monthEnd`	Nouveau comportement
`monthStart`	`segments.month`
`quarterEnd`	Nouveau comportement
`quarterStart`	`segments.quarter`
`sitelinkClickserverUrl`	`asset.tracking_url_template`
`sitelinkDescription1`	`asset.sitelink_asset.description_1`
`sitelinkDescription2`	`asset.sitelink_asset.description_2`
`sitelinkDisplayText`	`asset.sitelink_asset.link_text`
`sitelinkLandingPageUrl`	`asset.final_urls`
`status`	`asset.status`
`visits`
`weekEnd`	Nouveau comportement
`weekStart`	`segments.week`
`yearEnd`	Nouveau comportement
`yearStart`	`segments.year`

Rapport "Activité Floodlight"

Noms de colonnes dans le rapport `floodlightActivity`	nouveau mappage de l'API Search Ads 360 Reporting
`advertiser`	Voir la section Gestion des comptes
`advertiserId`	Voir la section Gestion des comptes
`agency`	Voir la section Gestion des comptes
`agencyId`	Voir la section Gestion des comptes
`creationTimestamp`	`conversion_action.creation_time`
`floodlightActivity`	`conversion_action.name`
`floodlightActivityId`	`conversion_action.floodlight_settings.activity_id`
`floodlightActivityTag`	`conversion_action.floodlight_settings.activity_tag`
`floodlightConfigurationId`	Nouveau comportement
`floodlightGroup`	Nouveau comportement
`floodlightGroupConversionType`	`conversion_action.type`
`floodlightGroupId`	Nouveau comportement
`floodlightGroupTag`	`conversion_action.floodlight_settings.activity_group_tag`
`lastModifiedTimestamp`	Nouveau comportement
`status`	`conversion_action.status`

Rapport sur les mots clés

Noms de colonnes dans le rapport `keyword`	nouveau mappage de l'API Search Ads 360 Reporting
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`ad`	`ad_group_ad.ad.name`⁸.
`adDescription1`	`ad_group_ad.ad.{ad type}.description1`¹^,⁸
`adDescription2`	`ad_group_ad.ad.{ad type}.description2`¹^,⁸
`adDisplayUrl`	`ad_group_ad.ad.display_url`⁸.
`adGroup`	`ad_group.name`
`adGroupId`	`ad_group.id`
`adGroupStatus`	`ad_group.status`
`adHeadline`	`ad_group_ad.ad.{ad type}.headline`³^,⁸
`adHeadline2`	`ad_group_ad.ad.expanded_text_ad.headline2`⁸.
`adHeadline3`	`ad_group_ad.ad.expanded_text_ad.headline3`⁸.
`adId`	`ad_group_ad.ad.id`⁸.
`adLandingPage`	`ad_group_ad.ad.final_urls`⁸.
`adPromotionLine`	Nouveau comportement
`adType`	`ad_group_ad.ad.type`⁸.
`advertiser`	Voir la section Gestion des comptes
`advertiserId`	Voir la section Gestion des comptes
`adWordsConversions`	`metrics.client_account_conversions`⁶
`adWordsConversionValue`	`metrics.client_account_conversions_value`⁶
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`⁶
`agency`	Voir la section Gestion des comptes
`agencyId`	Voir la section Gestion des comptes
`avgCpc`	`metrics.average_cpc`⁶
`avgCpm`	`metrics.average_cpm`⁶
`avgPos`	Nouveau comportement
`bidStrategyInherited`	Nouveau comportement
`bingKeywordParam2`	Nouveau comportement
`bingKeywordParam3`	Nouveau comportement
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`clicks`	`metrics.clicks`⁶
`cost`	`metrics.cost_micros`⁶
`creationTimestamp`	`ad_group_criterion.creation_time`
`ctr`	`metrics.ctr`⁶
`date`	`segments.date`
`deviceSegment`	`segments.device`
`dfaActions`	`metrics.all_conversions` – `metrics.cross_device_conversions`⁶
`dfaActionsCrossEnv`	`metrics.all_conversions`⁶
`dfaRevenue`	`metrics.all_conversions_value` – `metrics.cross_device_conversions_value`⁶
`dfaRevenueCrossEnv`	`metrics.all_conversions_value`⁶
`dfaTransactions`	`metrics.all_conversions` – `metrics.cross_device_conversions`⁶
`dfaTransactionsCrossEnv`	`metrics.all_conversions`⁶
`dfaWeightedActions`	Nouveau comportement
`dfaWeightedActionsCrossEnv`	Nouveau comportement
`effectiveBidStrategy`	`bidding_strategy.name`
`effectiveBidStrategyId`	`bidding_strategy.id`
`effectiveKeywordMaxCpc`	`ad_group_criterion.effective_cpc_bid_micros`
`effectiveLabels`	`Not available in V0`
`engineStatus`	`ad_group_criterion.engine_status`
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Utiliser `conversion_action`
`floodlightActivityTag`	Utiliser `conversion_action`
`floodlightGroup`	Nouveau comportement
`floodlightGroupId`	Nouveau comportement
`floodlightGroupTag`	Utiliser `conversion_action`
`impr`	`metrics.impressions`⁶
`isDisplayKeyword`	Nouveau comportement
`isUnattributedAd`	`Not available in V0`
`keywordClickserverUrl`	`ad_group_criterion.tracking_url_template`
`keywordEngineId`	`ad_group_criterion.engine_id`
`keywordId`	`ad_group_criterion.criterion_id`
`keywordLabels`	`ad_group_criterion_label.label label.name`
`keywordLandingPage`	`ad_group_criterion.final_urls`
`keywordMatchType`	`ad_group_criterion.keyword.match_type`
`keywordMaxBid`	`bidding_strategy.target_{}.cpc_bid_ceiling_micros`
`keywordMaxCpc`	`ad_group_criterion.cpc_bid_micros`
`keywordMinBid`	`bidding_strategy.target_{}.cpc_bid_floor_micros`
`keywordText`	`ad_group_criterion.keyword.text`
`keywordUrlParams`	`ad_group_criterion.final_url_suffix`
`lastModifiedTimestamp`	`ad_group_criterion.last_modified_time`
`monthEnd`	Nouveau comportement
`monthStart`	`segments.month`
`qualityScoreAvg`	`metrics.historical_quality_score`⁶
`qualityScoreCurrent`	`ad_group_criterion.quality_info.quality_score`
`quarterEnd`	Nouveau comportement
`quarterStart`	`segments.quarter`
`status`	`ad_group_criterion.status`
`topOfPageBidAvg`	Nouveau comportement
`topOfPageBidCurrent`	`ad_group_criterion.position_estimates.top_of_page_cpc_micros`
`visits`	`metrics.visits`⁶
`weekEnd`	Nouveau comportement
`weekStart`	`segments.week`
`yearEnd`	Nouveau comportement
`yearStart`	`segments.year`

Rapport KeywordGroupKeyword

Noms de colonnes dans le rapport `negativeAdGroupKeyword`	nouveau mappage de l'API Search Ads 360 Reporting
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`adGroup`	`ad_group.name`
`adGroupId`	`ad_group.id`
`adGroupStatus`	`ad_group.status`
`advertiser`	Voir la section Gestion des comptes
`advertiserId`	Voir la section Gestion des comptes
`agency`	Voir la section Gestion des comptes
`agencyId`	Voir la section Gestion des comptes
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`creationTimestamp`	`ad_group_criterion.creation_time`
`engineStatus`	Nouveau comportement
`lastModifiedTimestamp`	`ad_group_criterion.last_modified_time`
`negativeAdGroupKeywordId`	`ad_group_criterion.criterion_id (filtering with ad_group_criterion.negative)`⁷.
`negativeAdGroupKeywordMatchType`	`ad_group_criterion.keyword.match_type (filtering with ad_group_criterion.negative)`⁷.
`negativeAdGroupKeywordText`	`ad_group_criterion.keyword.text (filtering with ad_group_criterion.negative)`⁷.
`status`	`ad_group_criterion.status (filtering with ad_group_criterion.negative)`⁷.

Rapport KeywordGroupTarget

Noms de colonnes dans le rapport `negativeAdGroupTarget`	nouveau mappage de l'API Search Ads 360 Reporting
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`adGroup`	`ad_group.name`
`adGroupId`	`ad_group.id`
`adGroupStatus`	`ad_group.status`
`advertiser`	Voir la section Gestion des comptes
`advertiserId`	Voir la section Gestion des comptes
`agency`	Voir la section Gestion des comptes
`agencyId`	Voir la section Gestion des comptes
`ageTargetAgeRange`	`ad_group_criterion.age_range.type (filtering with ad_group_criterion.negative)`⁷.
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`creationTimestamp`	`ad_group_criterion.creation_time`
`dynamicSearchAdsTargetConditions`	`ad_group_criterion.webpage.conditions (filtering with ad_group_criterion.negative)`⁷.
`engineRemarketingList`	`ad_group_criterion.user_list.user_list user_list.name (filtering with ad_group_criterion.negative)`⁷.
`genderTargetGenderType`	`ad_group_criterion.gender.type (filtering with ad_group_criterion.negative)`⁷.
`lastModifiedTimestamp`	`ad_group_criterion.last_modified_time`
`locationTargetName`	`ad_group_criterion.location.geo_target_constant (filtering with ad_group_criterion.negative)`⁷.
`negativeAdGroupTargetId`	`ad_group_criterion.criterion_id (filtering with ad_group_criterion.negative)`⁷.
`status`	`ad_group_criterion.status (filtering with ad_group_criterion.negative)`⁷.

Rapport NégativeCampaignKeyword

Noms de colonnes dans le rapport `negativeCampaignKeyword`	nouveau mappage de l'API Search Ads 360 Reporting
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`advertiser`	Voir la section Gestion des comptes
`advertiserId`	Voir la section Gestion des comptes
`agency`	Voir la section Gestion des comptes
`agencyId`	Voir la section Gestion des comptes
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`creationTimestamp`	Nouveau comportement
`engineStatus`	Nouveau comportement
`lastModifiedTimestamp`	`campaign_criterion.last_modified_time`
`negativeCampaignKeywordId`	`campaign_criterion.criterion_id (filtering with campaign_criterion.negative)`⁷.
`negativeCampaignKeywordMatchType`	`campaign_criterion.keyword.match_type (filtering with campaign_criterion.negative)`⁷.
`negativeCampaignKeywordText`	`campaign_criterion.keyword.text (filtering with campaign_criterion.negative)`⁷.
`status`	`campaign_criterion.status (filtering with campaign_criterion.negative)`⁷.

Rapport negativeCampaignTarget

Noms de colonnes dans le rapport `negativeCampaignTarget`	nouveau mappage de l'API Search Ads 360 Reporting
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`advertiser`	Voir la section Gestion des comptes
`advertiserId`	Voir la section Gestion des comptes
`agency`	Voir la section Gestion des comptes
`agencyId`	Voir la section Gestion des comptes
`ageTargetAgeRange`	`campaign_criterion.age_range.type (filtering with campaign_criterion.negative)`⁷.
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`creationTimestamp`	Nouveau comportement
`dynamicSearchAdsTargetConditions`	`campaign_criterion.webpage.conditions (filtering with campaign_criterion.negative)`⁷.
`engineRemarketingList`	`campaign_criterion.user_list.user_list user_list.name (filtering with campaign_criterion.negative)`⁷.
`genderTargetGenderType`	`campaign_criterion.gender.type (filtering with campaign_criterion.negative)`⁷.
`lastModifiedTimestamp`	`campaign_criterion.last_modified_time`
`locationTargetName`	`campaign_criterion.location.geo_target_constant campaign_criterion.negative`⁷.
`negativeCampaignTargetId`	`campaign_criterion.criterion_id (filtering with campaign_criterion.negative)`⁷.
`status`	`campaign_criterion.status (filtering with campaign_criterion.negative)`⁷.

Rapport sur les canaux payants et naturels

Noms de colonnes dans le rapport `paidAndOrganic`	nouveau mappage de l'API Search Ads 360 Reporting
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`adGroup`
`adGroupId`
`advertiser`	Voir la section Gestion des comptes
`advertiserId`	Voir la section Gestion des comptes
`agency`	Voir la section Gestion des comptes
`agencyId`	Voir la section Gestion des comptes
`campaign`
`campaignId`
`date`	`segments.date`
`keywordId`	`segments.keyword.ad_group_criterion`
`keywordMatchType`	`segments.keyword.info.match_type`
`keywordText`	`segments.keyword.info.text`
`monthEnd`	Nouveau comportement
`monthStart`	`segments.month`
`organicAvgPos`	Nouveau comportement
`organicClicks`	`metrics.organic_clicks`
`organicCtr`
`organicQueries`	`metrics.organic_queries`
`paidAndOrganicClicks`	`metrics.combined_clicks`
`paidAndOrganicCtr`	`metrics.ctr`
`paidAndOrganicQueries`	`metrics.combined_queries`
`paidAvgPos`	Nouveau comportement
`paidClicks`
`paidCostPerClick`	`metrics.average_cpc`
`paidCtr`
`paidImpressions`
`quarterEnd`	Nouveau comportement
`quarterStart`	`segments.quarter`
`searchQuery`	`paid_organic_search_term_view.search_term`
`serpType`	`segments.search_engine_results_page_type`
`weekEnd`	Nouveau comportement
`weekStart`	`segments.week`
`yearEnd`	Nouveau comportement
`yearStart`	`segments.year`

Rapport ProductAdvertiserd

Noms de colonnes dans le rapport `productAdvertised`	nouveau mappage de l'API Search Ads 360 Reporting
`accountId`	`customer.id`
`adGroupId`	`ad_group.id`
`advertiser`	Voir la section Gestion des comptes
`advertiserId`	Voir la section Gestion des comptes
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	Nouveau comportement
`agency`	Voir la section Gestion des comptes
`agencyId`	Voir la section Gestion des comptes
`avgCpc`	`metrics.average_cpc`
`avgCpm`	Nouveau comportement
`avgPos`	Nouveau comportement
`campaignId`	`campaign.id`
`clicks`	`metrics.clicks`
`cost`	`metrics.cost_micros`
`creationTimestamp`	Nouveau comportement
`ctr`	`metrics.ctr`
`date`	`segments.date`
`deviceSegment`	`segments.device`
`dfaActions`	`metrics.all_conversions` – `metrics.cross_device_conversions`
`dfaActionsCrossEnv`	`metrics.all_conversions`
`dfaRevenue`	`metrics.all_conversions_value` – `metrics.cross_device_conversions_value`
`dfaRevenueCrossEnv`	`metrics.all_conversions_value`
`dfaTransactions`	`metrics.all_conversions` – `metrics.cross_device_conversions`
`dfaTransactionsCrossEnv`	`metrics.all_conversions`
`dfaWeightedActions`	Nouveau comportement
`dfaWeightedActionsCrossEnv`	Nouveau comportement
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Utiliser `conversion_action`
`floodlightActivityTag`	Utiliser `conversion_action`
`floodlightGroup`	Nouveau comportement
`floodlightGroupId`	Nouveau comportement
`floodlightGroupTag`	Utiliser `conversion_action`
`impr`	`metrics.impressions`
`lastModifiedTimestamp`	Nouveau comportement
`monthEnd`	Nouveau comportement
`monthStart`	`segments.month`
`productAgeGroup`	Nouveau comportement
`productAvailability`	Nouveau comportement
`productBrand`	`segments.product_brand`
`productCategory`	Nouveau comportement
`productCategoryLevel1`	`segments.product_bidding_category_level1`
`productCategoryLevel2`	`segments.product_bidding_category_level2`
`productCategoryLevel3`	`segments.product_bidding_category_level3`
`productCategoryLevel4`	`segments.product_bidding_category_level4`
`productCategoryLevel5`	`segments.product_bidding_category_level5`
`productChannel`	`segments.product_channel`
`productChannelExclusivity`	`segments.product_channel_exclusivity`
`productColor`	Nouveau comportement
`productCondition`	`segments.product_condition`
`productCostOfGoodsSold`	Nouveau comportement
`productCountry`	`segments.product_country`
`productCustomLabel0`	`segments.product_custom_attribute0`
`productCustomLabel1`	`segments.product_custom_attribute1`
`productCustomLabel2`	`segments.product_custom_attribute2`
`productCustomLabel3`	`segments.product_custom_attribute3`
`productCustomLabel4`	`segments.product_custom_attribute4`
`productGender`	Nouveau comportement
`productGtin`	Nouveau comportement
`productId`	`segments.product_item_id`
`productItemGroupId`	Nouveau comportement
`productLandingPageUrl`	Nouveau comportement
`productLanguage`	`segments.product_language`
`productMaterial`	Nouveau comportement
`productMpn`	Nouveau comportement
`productPattern`	Nouveau comportement
`productPrice`	Nouveau comportement
`productSalePrice`	Nouveau comportement
`productSize`	Nouveau comportement
`productStoreId`	`segments.product_store_id`
`productTitle`	`segments.product_title`
`productTypeLevel1`	`segments.product_type_l1`
`productTypeLevel2`	`segments.product_type_l2`
`productTypeLevel3`	`segments.product_type_l3`
`productTypeLevel4`	`segments.product_type_l4`
`productTypeLevel5`	`segments.product_type_l5`
`quarterEnd`	Nouveau comportement
`quarterStart`	`segments.quarter`
`status`	Nouveau comportement
`visits`	`Not available in V0`
`weekEnd`	Nouveau comportement
`weekStart`	`segments.week`
`yearEnd`	Nouveau comportement
`yearStart`	`segments.year`

Rapport ProductGroup

Noms de colonnes dans le rapport `productGroup`	nouveau mappage de l'API Search Ads 360 Reporting
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`adGroup`	`ad_group.name`
`adGroupId`	`ad_group.id`
`adGroupStatus`	`ad_group.status`
`advertiser`	Voir la section Gestion des comptes
`advertiserId`	Voir la section Gestion des comptes
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`
`agency`	Voir la section Gestion des comptes
`agencyId`	Voir la section Gestion des comptes
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Nouveau comportement
`bidStrategyInherited`	Nouveau comportement
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`clicks`	`metrics.clicks`
`cost`	`metrics.cost_micros`
`creationTimestamp`	`ad_group_criterion.creation_time`
`ctr`	`metrics.ctr`
`date`	`segments.date`
`deviceSegment`	`segments.device`
`dfaActions`	`metrics.all_conversions` – `metrics.cross_device_conversions`
`dfaActionsCrossEnv`	`metrics.all_conversions`
`dfaRevenue`	`metrics.all_conversions_value` – `metrics.cross_device_conversions_value`
`dfaRevenueCrossEnv`	`metrics.all_conversions_value`
`dfaTransactions`	`metrics.all_conversions` – `metrics.cross_device_conversions`
`dfaTransactionsCrossEnv`	`metrics.all_conversions`
`dfaWeightedActions`	Nouveau comportement
`dfaWeightedActionsCrossEnv`	Nouveau comportement
`effectiveBidStrategy`	Nouveau comportement
`effectiveBidStrategyId`	Nouveau comportement
`effectiveLabels`	Nouveau comportement
`effectiveProductGroupMaxCpc`	`ad_group_criterion.effective_cpc_bid_micros`
`engineStatus`	`ad_group_criterion.engine_status`
`impr`	`metrics.impressions`
`lastModifiedTimestamp`	`ad_group_criterion.last_modified_time`
`monthEnd`	Nouveau comportement
`monthStart`	`segments.month`
`productGroup`	`product_group_view.resource_name`
`productGroupClickserverUrl`	`ad_group_criterion.tracking_url_template`
`productGroupId`	`ad_group_criterion.criterion_id`
`productGroupLandingPage`	`ad_group_criterion.final_urls`
`productGroupMaxBid`	Nouveau comportement
`productGroupMaxCpc`	`ad_group_criterion.cpc_bid_micros`
`productGroupMinBid`	Nouveau comportement
`productGroupPartitionType`	`ad_group_criterion.listing_group.type`
`quarterEnd`	Nouveau comportement
`quarterStart`	`segments.quarter`
`status`	`ad_group_criterion.status`
`visits`	`Not available in V0`
`weekEnd`	Nouveau comportement
`weekStart`	`segments.week`
`yearEnd`	Nouveau comportement
`yearStart`	`segments.year`

Rapport ProductLeadAndCrossSell

Noms de colonnes dans le rapport `productLeadAndCrossSell`	nouveau mappage de l'API Search Ads 360 Reporting
`accountId`	`customer.id`
`adGroupId`	`ad_group.id`
`advertiser`	Voir la section Gestion des comptes
`advertiserId`	Voir la section Gestion des comptes
`agency`	Voir la section Gestion des comptes
`agencyId`	Voir la section Gestion des comptes
`campaignId`	`campaign.id`
`crossSellAverageUnitPrice`	`metrics.cross_sell_revenue_micros` / `metrics.cross_sell_units_sold`
`crossSellCostOfGoodsSold`	`metrics.cross_sell_cost_of_goods_sold_micros`
`crossSellGrossFromUnitsSold`	`metrics.cross_sell_revenue_micros`
`crossSellGrossProfitMargin`	`metrics.cross_sell_gross_profit_micros`
`crossSellRevenueFromUnitsSold`	`metrics.cross_sell_revenue_micros`
`crossSellUnitsSold`	`metrics.cross_sell_units_sold`
`date`	`segments.date`
`deviceSegment`	`segments.device`
`dfaActions`	Nouveau comportement
`dfaActionsCrossEnv`	Nouveau comportement
`dfaRevenue`	Nouveau comportement
`dfaRevenueCrossEnv`	Nouveau comportement
`dfaTransactions`	Nouveau comportement
`dfaTransactionsCrossEnv`	Nouveau comportement
`dfaWeightedActions`	Nouveau comportement
`dfaWeightedActionsCrossEnv`	Nouveau comportement
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Utiliser `conversion_action`
`floodlightActivityTag`	Utiliser `conversion_action`
`floodlightGroup`	Nouveau comportement
`floodlightGroupId`	Nouveau comportement
`floodlightGroupTag`	Utiliser `conversion_action`
`leadAverageUnitPrice`	`metrics.lead_revenue_micros` / `metrics.lead_units_sold`
`leadCostOfGoodsSold`	`metrics.lead_cost_of_goods_sold_micros`
`leadGrossProfitFromUnitsSold`	`metrics.lead_gross_profit_micros`
`leadGrossProfitMargin`	Nouveau comportement
`leadRevenueFromUnitsSold`	`metrics.lead_revenue_micros`
`leadUnitsSold`	`metrics.lead_units_sold`
`monthEnd`	Nouveau comportement
`monthStart`	`segments.month`
`productAgeGroup`	Nouveau comportement
`productAvailability`	Nouveau comportement
`productAverageUnitPrice`	Nouveau comportement
`productBrand`	`segments.product_brand` `segments.product_sold_brand`
`productCategory`	Nouveau comportement
`productCategoryLevel1`	`segments.product_bidding_category_level1` `segments.product_sold_bidding_category_level1`⁹
`productCategoryLevel2`	`segments.product_bidding_category_level2` `segments.product_sold_bidding_category_level2`
`productCategoryLevel3`	`segments.product_bidding_category_level3` `segments.product_sold_bidding_category_level3`
`productCategoryLevel4`	`segments.product_bidding_category_level4` `segments.product_sold_bidding_category_level4`
`productCategoryLevel5`	`segments.product_bidding_category_level5` `segments.product_sold_bidding_category_level5`
`productChannel`	`segments.product_channel` `segments.product_sold_channel`
`productChannelExclusivity`	`segments.product_channel_exclusivity` `segments.product_sold_channel_exclusivity`
`productColor`	Nouveau comportement
`productCondition`	`segments.product_condition` `segments.product_sold_condition`
`productCostOfGoodsSold`	Nouveau comportement
`productCountry`	`segments.product_country` `segments.product_sold_country`
`productCustomLabel0`	`segments.product_custom_attribute0` `segments.product_sold_custom_attribute0`
`productCustomLabel1`	`segments.product_custom_attribute1` `segments.product_sold_custom_attribute1`
`productCustomLabel2`	`segments.product_custom_attribute2` `segments.product_sold_custom_attribute2`
`productCustomLabel3`	`segments.product_custom_attribute3` `segments.product_sold_custom_attribute3`
`productCustomLabel4`	`segments.product_custom_attribute4` `segments.product_sold_custom_attribute4`
`productGender`	Nouveau comportement
`productGtin`	Nouveau comportement
`productId`	`segments.product_item_id` `segments.product_sold_item_id`
`productItemGroupId`	Nouveau comportement
`productLandingPageUrl`	Nouveau comportement
`productLanguage`	`segments.product_language` `segments.product_sold_language`
`productMaterial`	Nouveau comportement
`productMpn`	Nouveau comportement
`productPattern`	Nouveau comportement
`productPrice`	Nouveau comportement
`productRevenueFromUnitsSold`	Nouveau comportement
`productSalePrice`	Nouveau comportement
`productSize`	Nouveau comportement
`productStoreId`	`segments.product_store_id`
`productTitle`	`segments.product_title` `segments.product_sold_title`
`productTypeLevel1`	`segments.product_type_l1` `segments.product_type_l1`
`productTypeLevel2`	`segments.product_type_l2` `segments.product_type_l2`
`productTypeLevel3`	`segments.product_type_l3` `segments.product_type_l3`
`productTypeLevel4`	`segments.product_type_l4` `segments.product_type_l4`
`productTypeLevel5`	`segments.product_type_l5` `segments.product_type_l5`
`productUnitsSold`	Nouveau comportement
`quarterEnd`	Nouveau comportement
`quarterStart`	`segments.quarter`
`weekEnd`	Nouveau comportement
`weekStart`	`segments.week`
`yearEnd`	Nouveau comportement
`yearStart`	`segments.year`

Rapport sur les visites

Noms de colonnes dans le rapport `visit`	nouveau mappage de l'API Search Ads 360 Reporting
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`ad`	`ad_group_ad.ad.name`⁸.
`adGroup`	`ad_group.name`
`adGroupId`	`ad_group.id`
`adGroupStatus`	`ad_group.status`
`adId`	`visit.ad_id`
`advertiser`	Voir la section Gestion des comptes
`advertiserId`	Voir la section Gestion des comptes
`agency`	Voir la section Gestion des comptes
`agencyId`	Voir la section Gestion des comptes
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`deviceSegment`	`segments.device`
`feedId`	Nouveau comportement
`feedItemId`	Nouveau comportement
`feedType`	Nouveau comportement
`inventoryAccountId`	`visit.merchant_id`
`isUnattributedAd`	Nouveau comportement
`keywordId`	`visit.criterion_id`
`keywordMatchType`	`ad_group_criterion.keyword.match_type`
`keywordText`	`ad_group_criterion.keyword.text`
`productChannel`	`visit.product_channel`
`productCountry`	`visit.product_country_code`
`productGroupId`	`ad_group_criterion.criterion_id`
`productId`	`visit.product_id`
`productLanguage`	`visit.product_language_code`
`productStoreId`	`visit.product_store_id`
`productTargetId`	Nouveau comportement
`status`	Nouveau comportement
`visitDate`	`segments.date`
`visitExternalClickId`	`visit.click_id`
`visitId`	`visit.id`
`visitNetworkType`	`segments.ad_network_type`
`visitReferrer`	Nouveau comportement
`visitSearchQuery`	Nouveau comportement
`visitTimestamp`	`visit.visit_date_time`

Remarques

{ad type} peut être text_ad, expanded_text_ad ou expanded_dynamic_search_ad.
Utilisez ad_group_ad.engine_id pour les comptes Search Ads 360 (par exemple, Microsoft, Yahoo Japan, etc.) et ad_group_ad.ad.id pour les comptes autres que Search Ads 360.
{ad type} peut être text_ad ou expanded_text_ad.
{ad type} peut être expanded_text_ad ou responsive_search_ad.
Interrogez les métriques à l'aide de la ressource appropriée dans la clause FROM (par exemple, gender_view pour les critères de genre). Consultez Mises en correspondance des rapports.
Interrogez les métriques à l'aide de keyword_view dans la clause FROM.
Filtrez à l'aide de negative=true dans la clause WHERE. Par exemple, SELECT campaign_criterion.keyword.match_type, campaign_criterion.keyword.text FROM campaign_criterion WHERE campaign_criterion.negative = true.
Interrogez directement les champs ad_group_ad de la ressource ad_group_ad. Ensuite, interrogez d'autres champs à partir de la ressource appropriée (par exemple, keyword_view), puis utilisez ad_id (pour conversion et visit) ou ad_group_criterion.resource_name (pour keyword_view) pour associer les deux requêtes.
Exemple :
SELECT ad_group_ad.ad.name, segments.keyword.ad_group_criterion FROM ad_group_ad
SELECT keyword_view.resource_name, metrics.clicks FROM keyword_view WHERE ad_group_criterion.resource_name = '(resource name from first query)'
Utilisez les segments product pour identifier le produit dont vous faites la promotion et les segments product_sold pour identifier les produits vendus.