La nuova API Search Ads 360 Reporting è ora disponibile. Unisciti al gruppo Google searchads-api-announcements per non perderti i prossimi miglioramenti e release.

Questa pagina è stata tradotta dall'API Cloud Translation.

Mappature dei campi per l'API Search Ads 360 Reporting

Le seguenti tabelle mappano i campi della precedente API Search Ads 360 alle risorse della nuova API Search Ads 360 Reporting.

Report dell'account

Nomi delle colonne nel report `account`	mappatura dell'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`	Consulta la pagina Gestione account
`advertiserId`	Consulta la pagina Gestione account
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`
`agency`	Consulta la pagina Gestione account
`agencyId`	Consulta la pagina Gestione account
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Modifica del comportamento
`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`	Modifica del comportamento
`dfaWeightedActionsCrossEnv`	Modifica del comportamento
`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`	Utilizza `conversion_action`
`floodlightActivityTag`	Utilizza `conversion_action`
`floodlightGroup`	Modifica del comportamento
`floodlightGroupId`	Modifica del comportamento
`floodlightGroupTag`	Utilizza `conversion_action`
`impr`	`metrics.impressions`
`lastModifiedTimestamp`	`customer.last_modified_time`
`monthEnd`	Modifica del comportamento
`monthStart`	`segments.month`
`qualityScoreAvg`	`metrics.historical_quality_score`
`quarterEnd`	Modifica del comportamento
`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`	Modifica del comportamento
`visits`	`metrics.visits`
`weekEnd`	Modifica del comportamento
`weekStart`	`segments.week`
`yearEnd`	Modifica del comportamento
`yearStart`	`segments.year`

Report sugli annunci

Nomi delle colonne nel report `ad`	mappatura dell'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` o `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`	Modifica del comportamento
`adType`	`ad_group_ad.ad.type`
`advertiser`	Consulta la pagina Gestione account
`advertiserId`	Consulta la pagina Gestione account
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`
`agency`	Consulta la pagina Gestione account
`agencyId`	Consulta la pagina Gestione account
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Modifica del comportamento
`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`	Modifica del comportamento
`dfaWeightedActionsCrossEnv`	Modifica del comportamento
`effectiveLabels`	`Not available in V0`
`engineStatus`	`ad_group_ad.engine_status`
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Utilizza `conversion_action`
`floodlightActivityTag`	Utilizza `conversion_action`
`floodlightGroup`	Modifica del comportamento
`floodlightGroupId`	Modifica del comportamento
`floodlightGroupTag`	Utilizza `conversion_action`
`impr`	`metrics.impressions`
`isUnattributedAd`	`Not available`
`lastModifiedTimestamp`	`ad_group_ad.last_modified_time`
`monthEnd`	Modifica del comportamento
`monthStart`	`segments.month`
`quarterEnd`	Modifica del comportamento
`quarterStart`	`segments.quarter`
`status`	`ad_group_ad.status`
`visits`	`metrics.visits`
`weekEnd`	Modifica del comportamento
`weekStart`	`segments.week`
`yearEnd`	Modifica del comportamento
`yearStart`	`segments.year`

Report sul gruppo di annunci

Nomi delle colonne nel report `adGroup`	mappatura dell'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`	Modifica del comportamento
`adGroupContentMaxCpc`	Modifica del comportamento
`adGroupDesktopBidAdjustment`	`ad_group_bid_modifier`
`adGroupEndDate`	`ad_group.end_date`
`adGroupEngineId`	`ad_group.engine_id`
`adGroupExactMaxCpc`	Modifica del comportamento
`adGroupId`	`ad_group.id`
`adGroupLabels`	`ad_group.labels label.name`
`adGroupMobileBidAdjustment`	`ad_group_bid_modifier`
`adGroupPhraseMaxCpc`	Modifica del comportamento
`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`	Consulta la pagina Gestione account
`advertiserId`	Consulta la pagina Gestione account
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`
`agency`	Consulta la pagina Gestione account
`agencyId`	Consulta la pagina Gestione account
`appId`	`asset.mobile_app_asset.app_id`
`appStore`	`asset.mobile_app_asset.app_store`
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Modifica del comportamento
`bidStrategyInherited`	Modifica del comportamento
`bingAdsAdDistributions`	Modifica del comportamento
`bingAdsLanguage`	`ad_group.language_code`
`callCallOnly`	Modifica del comportamento
`callConversionTracker`	`asset.call_asset.call_conversion_action`
`callConversionTrackerId`	Modifica del comportamento
`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`	Modifica del comportamento
`cost`	`metrics.cost_micros`
`costWithFeedItemShowing`	Modifica del comportamento
`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`	Modifica del comportamento
`dfaWeightedActionsCrossEnv`	Modifica del comportamento
`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`	Utilizza `conversion_action`
`floodlightActivityTag`	Utilizza `conversion_action`
`floodlightGroup`	Modifica del comportamento
`floodlightGroupId`	Modifica del comportamento
`floodlightGroupTag`	Utilizza `conversion_action`
`impr`	`metrics.impressions`
`lastModifiedTimestamp`	`ad_group.last_modified_time`
`locationBusinessName`	`Not available in V0`
`locationCategory`	Modifica del comportamento
`locationDetails`	`Not available in V0`
`locationFilter`	Modifica del comportamento
`metroTargets`	`ad_group_criterion.location.geo_target_constant`
`monthEnd`	Modifica del comportamento
`monthStart`	`segments.month`
`provinceTargets`	`ad_group_criterion.location.geo_target_constant`
`qualityScoreAvg`	`metrics.historical_quality_score`
`quarterEnd`	Modifica del comportamento
`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`	Modifica del comportamento
`visits`	`metrics.visits`
`weekEnd`	Modifica del comportamento
`weekStart`	`segments.week`
`yearEnd`	Modifica del comportamento
`yearStart`	`segments.year`

Report Gruppo di annunci

Nomi delle colonne nel report `adGroupTarget`	mappatura dell'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`	Consulta la pagina Gestione account
`advertiserId`	Consulta la pagina Gestione account
`adWordsConversions`	`metrics.client_account_conversions`⁵
`adWordsConversionValue`	`metrics.client_account_conversions_value`⁵
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`⁵
`agency`	Consulta la pagina Gestione account
`agencyId`	Consulta la pagina Gestione account
`ageTargetAgeRange`	`ad_group_criterion.age_range.type`
`ageTargetBidModifier`	`ad_group_criterion.bid_modifier`
`avgCpc`	`metrics.average_cpc`⁵
`avgCpm`	`metrics.average_cpm`⁵
`avgPos`	Modifica del comportamento
`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`	Modifica del comportamento
`dfaWeightedActionsCrossEnv`	Modifica del comportamento
`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`	Utilizza `conversion_action`
`floodlightActivityTag`	Utilizza `conversion_action`
`floodlightGroup`	Modifica del comportamento
`floodlightGroupId`	Modifica del comportamento
`floodlightGroupTag`	Utilizza `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`	Modifica del comportamento
`monthStart`	`segments.month`
`quarterEnd`	Modifica del comportamento
`quarterStart`	`segments.quarter`
`status`	`ad_group_criterion.status`
`unclassifiedTargetName`	Modifica del comportamento
`unclassifiedTargetType`	Modifica del comportamento
`visits`	`Not available in V0`
`weekEnd`	Modifica del comportamento
`weekStart`	`segments.week`
`yearEnd`	Modifica del comportamento
`yearStart`	`segments.year`

Report sugli inserzionisti

Nomi delle colonne nel report `advertiser`	mappatura dell'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`	Consulta la pagina Gestione account
`agencyId`	Consulta la pagina Gestione account
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Modifica del comportamento
`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`	Modifica del comportamento
`dfaWeightedActionsCrossEnv`	Modifica del comportamento
`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`	Utilizza `conversion_action`
`floodlightActivityTag`	Utilizza `conversion_action`
`floodlightGroup`	Modifica del comportamento
`floodlightGroupId`	Modifica del comportamento
`floodlightGroupTag`	Utilizza `conversion_action`
`googleAnalyticsTimeZone`	`Not available in V0`
`impr`	`metrics.impressions`
`lastModifiedTimestamp`	`customer.last_modified_time`
`monthEnd`	Modifica del comportamento
`monthStart`	`segments.month`
`qualityScoreAvg`	`metrics.historical_quality_score`
`quarterEnd`	Modifica del comportamento
`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`	Modifica del comportamento
`visits`	`Not available in V0`
`weekEnd`	Modifica del comportamento
`weekStart`	`segments.week`
`yearEnd`	Modifica del comportamento
`yearStart`	`segments.year`

Report Strategia offerta

Nomi delle colonne nel report `bidStrategy`	mappatura dell'API Search Ads 360 Reporting
`advertiser`	Consulta la pagina Gestione account
`advertiserId`	Consulta la pagina Gestione account
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`
`agency`	Consulta la pagina Gestione account
`agencyId`	Consulta la pagina Gestione account
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Modifica del comportamento
`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`	Modifica del comportamento
`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`	Modifica del comportamento
`dfaWeightedActionsCrossEnv`	Modifica del comportamento
`ersTarget`	`bidding_strategy.target_roas.target_roas`
`floodlightActivityTargetIds`	usa `segments.conversion_action` per ottenere un elenco di informazioni Floodlight
`floodlightOptimizationEnabled`	utilizza `segments.conversion_action` per verificare se è ottimizzato per le conversioni Floodlight
`highPosition`	Modifica del comportamento
`impr`	`metrics.impressions`
`lastModifiedTimestamp`	Modifica del comportamento
`lowPosition`	Modifica del comportamento
`monthEnd`	Modifica del comportamento
`monthlySpendTarget`	`bidding_strategy.target_spend.target_spend_micros`
`monthStart`	`segments.month`
`quarterEnd`	Modifica del comportamento
`quarterStart`	`segments.quarter`
`roasTarget`	`bidding_strategy.target_roas.target_roas`
`status`	`bidding_strategy.status`
`type`	`bidding_strategy.type`
`visits`	`Not available in V0`
`weekEnd`	Modifica del comportamento
`weekStart`	`segments.week`
`yearEnd`	Modifica del comportamento
`yearStart`	`segments.year`

Report sulle campagne

Nomi delle colonne nel report `campaign`	mappatura dell'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`	Consulta la pagina Gestione account
`advertiserId`	Consulta la pagina Gestione account
`adWordsBidStrategy`	`campaign.bidding_strategy_type`
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`
`agency`	Consulta la pagina Gestione account
`agencyId`	Consulta la pagina Gestione account
`appId`	`asset.mobile_app_asset.app_id`
`appStore`	`asset.mobile_app_asset.app_store`
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Modifica del comportamento
`bidStrategyInherited`	Modifica del comportamento
`bingAdsBudgetType`	`campaign_budget.period campaign_budget.delivery_method`
`callCallOnly`	Modifica del comportamento
`callConversionTracker`	`asset.call_asset.call_conversion_action`
`callConversionTrackerId`	Modifica del comportamento
`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`	Modifica del comportamento
`cost`	`metrics.cost_micros`
`costWithFeedItemShowing`	Modifica del comportamento
`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`	Modifica del comportamento
`dfaWeightedActionsCrossEnv`	Modifica del comportamento
`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`	Utilizza `conversion_action`
`floodlightActivityTag`	Utilizza `conversion_action`
`floodlightGroup`	Modifica del comportamento
`floodlightGroupId`	Modifica del comportamento
`floodlightGroupTag`	Utilizza `conversion_action`
`impr`	`metrics.impressions`
`keywordNearMatchEnabled`	Modifica del comportamento
`lastModifiedTimestamp`	`campaign.last_modified_time`
`languageTargets`	`campaign_criterion.language.language_constant`
`locationBusinessName`	`Not available in V0`
`locationCategory`	Modifica del comportamento
`locationDetails`	`Not available in V0`
`locationFilter`	Modifica del comportamento
`metroTargets`	`campaign_criterion.location.geo_target_constant`
`monthEnd`	Modifica del comportamento
`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`	Modifica del comportamento
`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`	Modifica del comportamento
`visits`	`metrics.visits`
`weekEnd`	Modifica del comportamento
`weekStart`	`segments.week`
`yahooGeoTargets`	`campaign_criterion.location.geo_target_constant`
`yahooJapanBidStrategy`	`bidding_strategy.name`
`yearEnd`	Modifica del comportamento
`yearStart`	`segments.year`

Report CampaignTarget

Nomi delle colonne nel report `campaignTarget`	mappatura dell'API Search Ads 360 Reporting
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`advertiser`	Consulta la pagina Gestione account
`advertiserId`	Consulta la pagina Gestione account
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`
`agency`	Consulta la pagina Gestione account
`agencyId`	Consulta la pagina Gestione account
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Modifica del comportamento
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`campaignTargetId`	`campaign_criterion.criterion_id`
`clicks`	`metrics.clicks`
`cost`	`metrics.cost_micros`
`creationTimestamp`	Modifica del comportamento
`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`	Modifica del comportamento
`dfaWeightedActionsCrossEnv`	Modifica del comportamento
`engineRemarketingList`	`campaign_criterion.user_list.user_list user_list.name`
`engineRemarketingListBidModifier`	`campaign_criterion.bid_modifier`
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Utilizza `conversion_action`
`floodlightActivityTag`	Utilizza `conversion_action`
`floodlightGroup`	Modifica del comportamento
`floodlightGroupId`	Modifica del comportamento
`floodlightGroupTag`	Utilizza `conversion_action`
`impr`	`metrics.impressions`
`lastModifiedTimestamp`	`campaign_criterion.last_modified_time`
`locationTargetBidModifier`	`campaign_criterion.bid_modifier`
`locationTargetName`	`campaign_criterion.location.geo_target_constant`
`monthEnd`	Modifica del comportamento
`monthStart`	`segments.month`
`quarterEnd`	Modifica del comportamento
`quarterStart`	`segments.quarter`
`status`	`campaign_criterion.status`
`visits`	`Not available in V0`
`weekEnd`	Modifica del comportamento
`weekStart`	`segments.week`
`yearEnd`	Modifica del comportamento
`yearStart`	`segments.year`

Report sulle conversioni

Nomi delle colonne nel report `conversion`	mappatura dell'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`	Consulta la pagina Gestione account
`advertiserConversionId`	`conversion.advertiser_conversion_id`
`advertiserId`	Consulta la pagina Gestione account
`agency`	Consulta la pagina Gestione account
`agencyId`	Consulta la pagina Gestione account
`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`	Modifica del comportamento
`conversionTimestamp`	`conversion.conversion_date_time`
`conversionType`	Modifica del comportamento
`conversionVisitExternalClickId`	`conversion.click_id`
`conversionVisitId`	`conversion.visit_id`
`conversionVisitTimestamp`	`conversion.conversion_visit_date_time`
`deviceSegment`	`segments.device`
`feedId`	Modifica del comportamento
`feedItemId`	Modifica del comportamento
`feedType`	Modifica del comportamento
`floodlightActivity`	Utilizza `conversion_action`
`floodlightActivityId`	Utilizza `conversion_action`
`floodlightActivityTag`	Utilizza `conversion_action`
`floodlightEventRequestString`	Modifica del comportamento
`floodlightGroup`	Utilizza `conversion_action`
`floodlightGroupConversionType`	Utilizza `conversion_action`
`floodlightGroupId`	Modifica del comportamento
`floodlightGroupTag`	Utilizza `conversion_action`
`floodlightOrderId`	`conversion.floodlight_order_id`
`floodlightOriginalRevenue`	`conversion.floodlight_original_revenue`
`floodlightReferrer`	Modifica del comportamento
`inventoryAccountId`	`conversion.merchant_id`
`isUnattributedAd`	Modifica del comportamento
`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`	Modifica del comportamento
`status`	`conversion.status`

Report sull'elemento del feed

Nomi delle colonne nel report `feedItem`	mappatura dell'API Search Ads 360 Reporting
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`advertiser`	Consulta la pagina Gestione account
`advertiserId`	Consulta la pagina Gestione account
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`
`agency`	Consulta la pagina Gestione account
`agencyId`	Consulta la pagina Gestione account
`appId`	`asset.mobile_app_asset.app_id`
`appStore`	`asset.mobile_app_asset.app_store`
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Modifica del comportamento
`callCallOnly`	Modifica del comportamento
`callConversionTracker`	`asset.call_asset.call_conversion_action`
`callConversionTrackerId`	Modifica del comportamento
`callCountryCode`	`asset.call_asset.country_code`
`callIsTracked`	`asset.call_asset.call_tracking_enabled`
`callPhoneNumber`	`asset.call_asset.phone_number`
`clicks`	`metrics.clicks`
`clicksWithFeedItemShowing`	Modifica del comportamento
`cost`	`metrics.cost_micros`
`costWithFeedItemShowing`	Modifica del comportamento
`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`	Modifica del comportamento
`dfaWeightedActionsCrossEnv`	Modifica del comportamento
`engineStatus`	`asset.engine_status`
`feedId`	`asset_set.id`
`feedItemId`	`asset.id`
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Utilizza `conversion_action`
`floodlightActivityTag`	Utilizza `conversion_action`
`floodlightGroup`	Modifica del comportamento
`floodlightGroupId`	Modifica del comportamento
`floodlightGroupTag`	Utilizza `conversion_action`
`impr`	`metrics.impressions`
`lastModifiedTimestamp`	`asset.last_modified_time`
`locationBusinessName`	`Not available in V0`
`locationCategory`	Modifica del comportamento
`locationDetails`	`Not available in V0`
`monthEnd`	Modifica del comportamento
`monthStart`	`segments.month`
`quarterEnd`	Modifica del comportamento
`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`	Modifica del comportamento
`weekStart`	`segments.week`
`yearEnd`	Modifica del comportamento
`yearStart`	`segments.year`

Report Attività Floodlight

Nomi delle colonne nel report `floodlightActivity`	mappatura dell'API Search Ads 360 Reporting
`advertiser`	Consulta la pagina Gestione account
`advertiserId`	Consulta la pagina Gestione account
`agency`	Consulta la pagina Gestione account
`agencyId`	Consulta la pagina Gestione account
`creationTimestamp`	`conversion_action.creation_time`
`floodlightActivity`	`conversion_action.name`
`floodlightActivityId`	`conversion_action.floodlight_settings.activity_id`
`floodlightActivityTag`	`conversion_action.floodlight_settings.activity_tag`
`floodlightConfigurationId`	Modifica del comportamento
`floodlightGroup`	Modifica del comportamento
`floodlightGroupConversionType`	`conversion_action.type`
`floodlightGroupId`	Modifica del comportamento
`floodlightGroupTag`	`conversion_action.floodlight_settings.activity_group_tag`
`lastModifiedTimestamp`	Modifica del comportamento
`status`	`conversion_action.status`

Report sulle parole chiave

Nomi delle colonne nel report `keyword`	mappatura dell'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`	Modifica del comportamento
`adType`	`ad_group_ad.ad.type`⁸
`advertiser`	Consulta la pagina Gestione account
`advertiserId`	Consulta la pagina Gestione account
`adWordsConversions`	`metrics.client_account_conversions`⁶
`adWordsConversionValue`	`metrics.client_account_conversions_value`⁶
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`⁶
`agency`	Consulta la pagina Gestione account
`agencyId`	Consulta la pagina Gestione account
`avgCpc`	`metrics.average_cpc`⁶
`avgCpm`	`metrics.average_cpm`⁶
`avgPos`	Modifica del comportamento
`bidStrategyInherited`	Modifica del comportamento
`bingKeywordParam2`	Modifica del comportamento
`bingKeywordParam3`	Modifica del comportamento
`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`	Modifica del comportamento
`dfaWeightedActionsCrossEnv`	Modifica del comportamento
`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`	Utilizza `conversion_action`
`floodlightActivityTag`	Utilizza `conversion_action`
`floodlightGroup`	Modifica del comportamento
`floodlightGroupId`	Modifica del comportamento
`floodlightGroupTag`	Utilizza `conversion_action`
`impr`	`metrics.impressions`⁶
`isDisplayKeyword`	Modifica del comportamento
`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`	Modifica del comportamento
`monthStart`	`segments.month`
`qualityScoreAvg`	`metrics.historical_quality_score`⁶
`qualityScoreCurrent`	`ad_group_criterion.quality_info.quality_score`
`quarterEnd`	Modifica del comportamento
`quarterStart`	`segments.quarter`
`status`	`ad_group_criterion.status`
`topOfPageBidAvg`	Modifica del comportamento
`topOfPageBidCurrent`	`ad_group_criterion.position_estimates.top_of_page_cpc_micros`
`visits`	`metrics.visits`⁶
`weekEnd`	Modifica del comportamento
`weekStart`	`segments.week`
`yearEnd`	Modifica del comportamento
`yearStart`	`segments.year`

Report sulle parole chiave escluse del gruppo di annunci

Nomi delle colonne nel report `negativeAdGroupKeyword`	mappatura dell'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`	Consulta la pagina Gestione account
`advertiserId`	Consulta la pagina Gestione account
`agency`	Consulta la pagina Gestione account
`agencyId`	Consulta la pagina Gestione account
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`creationTimestamp`	`ad_group_criterion.creation_time`
`engineStatus`	Modifica del comportamento
`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)`⁷

Report negativeAdGroupTarget

Nomi delle colonne nel report `negativeAdGroupTarget`	mappatura dell'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`	Consulta la pagina Gestione account
`advertiserId`	Consulta la pagina Gestione account
`agency`	Consulta la pagina Gestione account
`agencyId`	Consulta la pagina Gestione account
`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)`⁷

Report sulle parole chiave escluse della campagna

Nomi delle colonne nel report `negativeCampaignKeyword`	mappatura dell'API Search Ads 360 Reporting
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`advertiser`	Consulta la pagina Gestione account
`advertiserId`	Consulta la pagina Gestione account
`agency`	Consulta la pagina Gestione account
`agencyId`	Consulta la pagina Gestione account
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`creationTimestamp`	Modifica del comportamento
`engineStatus`	Modifica del comportamento
`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)`⁷

Report negativeCampaignTarget

Nomi delle colonne nel report `negativeCampaignTarget`	mappatura dell'API Search Ads 360 Reporting
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`advertiser`	Consulta la pagina Gestione account
`advertiserId`	Consulta la pagina Gestione account
`agency`	Consulta la pagina Gestione account
`agencyId`	Consulta la pagina Gestione account
`ageTargetAgeRange`	`campaign_criterion.age_range.type (filtering with campaign_criterion.negative)`⁷
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`creationTimestamp`	Modifica del comportamento
`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)`⁷

Report A pagamentoAndorganico

Nomi delle colonne nel report `paidAndOrganic`	mappatura dell'API Search Ads 360 Reporting
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`adGroup`
`adGroupId`
`advertiser`	Consulta la pagina Gestione account
`advertiserId`	Consulta la pagina Gestione account
`agency`	Consulta la pagina Gestione account
`agencyId`	Consulta la pagina Gestione account
`campaign`
`campaignId`
`date`	`segments.date`
`keywordId`	`segments.keyword.ad_group_criterion`
`keywordMatchType`	`segments.keyword.info.match_type`
`keywordText`	`segments.keyword.info.text`
`monthEnd`	Modifica del comportamento
`monthStart`	`segments.month`
`organicAvgPos`	Modifica del comportamento
`organicClicks`	`metrics.organic_clicks`
`organicCtr`
`organicQueries`	`metrics.organic_queries`
`paidAndOrganicClicks`	`metrics.combined_clicks`
`paidAndOrganicCtr`	`metrics.ctr`
`paidAndOrganicQueries`	`metrics.combined_queries`
`paidAvgPos`	Modifica del comportamento
`paidClicks`
`paidCostPerClick`	`metrics.average_cpc`
`paidCtr`
`paidImpressions`
`quarterEnd`	Modifica del comportamento
`quarterStart`	`segments.quarter`
`searchQuery`	`paid_organic_search_term_view.search_term`
`serpType`	`segments.search_engine_results_page_type`
`weekEnd`	Modifica del comportamento
`weekStart`	`segments.week`
`yearEnd`	Modifica del comportamento
`yearStart`	`segments.year`

Report sui prodotti pubblicizzati

Nomi delle colonne nel report `productAdvertised`	mappatura dell'API Search Ads 360 Reporting
`accountId`	`customer.id`
`adGroupId`	`ad_group.id`
`advertiser`	Consulta la pagina Gestione account
`advertiserId`	Consulta la pagina Gestione account
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	Modifica del comportamento
`agency`	Consulta la pagina Gestione account
`agencyId`	Consulta la pagina Gestione account
`avgCpc`	`metrics.average_cpc`
`avgCpm`	Modifica del comportamento
`avgPos`	Modifica del comportamento
`campaignId`	`campaign.id`
`clicks`	`metrics.clicks`
`cost`	`metrics.cost_micros`
`creationTimestamp`	Modifica del comportamento
`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`	Modifica del comportamento
`dfaWeightedActionsCrossEnv`	Modifica del comportamento
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Utilizza `conversion_action`
`floodlightActivityTag`	Utilizza `conversion_action`
`floodlightGroup`	Modifica del comportamento
`floodlightGroupId`	Modifica del comportamento
`floodlightGroupTag`	Utilizza `conversion_action`
`impr`	`metrics.impressions`
`lastModifiedTimestamp`	Modifica del comportamento
`monthEnd`	Modifica del comportamento
`monthStart`	`segments.month`
`productAgeGroup`	Modifica del comportamento
`productAvailability`	Modifica del comportamento
`productBrand`	`segments.product_brand`
`productCategory`	Modifica del comportamento
`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`	Modifica del comportamento
`productCondition`	`segments.product_condition`
`productCostOfGoodsSold`	Modifica del comportamento
`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`	Modifica del comportamento
`productGtin`	Modifica del comportamento
`productId`	`segments.product_item_id`
`productItemGroupId`	Modifica del comportamento
`productLandingPageUrl`	Modifica del comportamento
`productLanguage`	`segments.product_language`
`productMaterial`	Modifica del comportamento
`productMpn`	Modifica del comportamento
`productPattern`	Modifica del comportamento
`productPrice`	Modifica del comportamento
`productSalePrice`	Modifica del comportamento
`productSize`	Modifica del comportamento
`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`	Modifica del comportamento
`quarterStart`	`segments.quarter`
`status`	Modifica del comportamento
`visits`	`Not available in V0`
`weekEnd`	Modifica del comportamento
`weekStart`	`segments.week`
`yearEnd`	Modifica del comportamento
`yearStart`	`segments.year`

Report Gruppo di prodotti

Nomi delle colonne nel report `productGroup`	mappatura dell'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`	Consulta la pagina Gestione account
`advertiserId`	Consulta la pagina Gestione account
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`
`agency`	Consulta la pagina Gestione account
`agencyId`	Consulta la pagina Gestione account
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Modifica del comportamento
`bidStrategyInherited`	Modifica del comportamento
`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`	Modifica del comportamento
`dfaWeightedActionsCrossEnv`	Modifica del comportamento
`effectiveBidStrategy`	Modifica del comportamento
`effectiveBidStrategyId`	Modifica del comportamento
`effectiveLabels`	Modifica del comportamento
`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`	Modifica del comportamento
`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`	Modifica del comportamento
`productGroupMaxCpc`	`ad_group_criterion.cpc_bid_micros`
`productGroupMinBid`	Modifica del comportamento
`productGroupPartitionType`	`ad_group_criterion.listing_group.type`
`quarterEnd`	Modifica del comportamento
`quarterStart`	`segments.quarter`
`status`	`ad_group_criterion.status`
`visits`	`Not available in V0`
`weekEnd`	Modifica del comportamento
`weekStart`	`segments.week`
`yearEnd`	Modifica del comportamento
`yearStart`	`segments.year`

Report sui lead e cross-sell del prodotto

Nomi delle colonne nel report `productLeadAndCrossSell`	mappatura dell'API Search Ads 360 Reporting
`accountId`	`customer.id`
`adGroupId`	`ad_group.id`
`advertiser`	Consulta la pagina Gestione account
`advertiserId`	Consulta la pagina Gestione account
`agency`	Consulta la pagina Gestione account
`agencyId`	Consulta la pagina Gestione account
`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`	Modifica del comportamento
`dfaActionsCrossEnv`	Modifica del comportamento
`dfaRevenue`	Modifica del comportamento
`dfaRevenueCrossEnv`	Modifica del comportamento
`dfaTransactions`	Modifica del comportamento
`dfaTransactionsCrossEnv`	Modifica del comportamento
`dfaWeightedActions`	Modifica del comportamento
`dfaWeightedActionsCrossEnv`	Modifica del comportamento
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Utilizza `conversion_action`
`floodlightActivityTag`	Utilizza `conversion_action`
`floodlightGroup`	Modifica del comportamento
`floodlightGroupId`	Modifica del comportamento
`floodlightGroupTag`	Utilizza `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`	Modifica del comportamento
`leadRevenueFromUnitsSold`	`metrics.lead_revenue_micros`
`leadUnitsSold`	`metrics.lead_units_sold`
`monthEnd`	Modifica del comportamento
`monthStart`	`segments.month`
`productAgeGroup`	Modifica del comportamento
`productAvailability`	Modifica del comportamento
`productAverageUnitPrice`	Modifica del comportamento
`productBrand`	`segments.product_brand` `segments.product_sold_brand`
`productCategory`	Modifica del comportamento
`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`	Modifica del comportamento
`productCondition`	`segments.product_condition` `segments.product_sold_condition`
`productCostOfGoodsSold`	Modifica del comportamento
`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`	Modifica del comportamento
`productGtin`	Modifica del comportamento
`productId`	`segments.product_item_id` `segments.product_sold_item_id`
`productItemGroupId`	Modifica del comportamento
`productLandingPageUrl`	Modifica del comportamento
`productLanguage`	`segments.product_language` `segments.product_sold_language`
`productMaterial`	Modifica del comportamento
`productMpn`	Modifica del comportamento
`productPattern`	Modifica del comportamento
`productPrice`	Modifica del comportamento
`productRevenueFromUnitsSold`	Modifica del comportamento
`productSalePrice`	Modifica del comportamento
`productSize`	Modifica del comportamento
`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`	Modifica del comportamento
`quarterEnd`	Modifica del comportamento
`quarterStart`	`segments.quarter`
`weekEnd`	Modifica del comportamento
`weekStart`	`segments.week`
`yearEnd`	Modifica del comportamento
`yearStart`	`segments.year`

Report sulle visite

Nomi delle colonne nel report `visit`	mappatura dell'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`	Consulta la pagina Gestione account
`advertiserId`	Consulta la pagina Gestione account
`agency`	Consulta la pagina Gestione account
`agencyId`	Consulta la pagina Gestione account
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`deviceSegment`	`segments.device`
`feedId`	Modifica del comportamento
`feedItemId`	Modifica del comportamento
`feedType`	Modifica del comportamento
`inventoryAccountId`	`visit.merchant_id`
`isUnattributedAd`	Modifica del comportamento
`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`	Modifica del comportamento
`status`	Modifica del comportamento
`visitDate`	`segments.date`
`visitExternalClickId`	`visit.click_id`
`visitId`	`visit.id`
`visitNetworkType`	`segments.ad_network_type`
`visitReferrer`	Modifica del comportamento
`visitSearchQuery`	Modifica del comportamento
`visitTimestamp`	`visit.visit_date_time`

Note

{ad type} può essere text_ad, expanded_text_ad o expanded_dynamic_search_ad.
Utilizza ad_group_ad.engine_id per gli account Search Ads 360 (ad es. Microsoft, Yahoo Japan e così via) e ad_group_ad.ad.id per gli account non Search Ads 360.
{ad type} può essere text_ad o expanded_text_ad.
{ad type} può essere expanded_text_ad o responsive_search_ad.
Esegui query sulle metriche utilizzando la risorsa appropriata nella clausola FROM (ad es. gender_view per i criteri di genere). Consulta le mappature dei report.
Esegui query sulle metriche utilizzando keyword_view nella clausola FROM.
Filtra utilizzando negative=true nella clausola WHERE. Ad esempio, SELECT campaign_criterion.keyword.match_type, campaign_criterion.keyword.text FROM campaign_criterion WHERE campaign_criterion.negative = true
Esegui una query sui campi ad_group_ad direttamente dalla risorsa ad_group_ad. Poi esegui una query su altri campi dalla risorsa appropriata (ad es. keyword_view) e utilizza ad_id (per conversion e visit) o ad_group_criterion.resource_name (per keyword_view) per collegare le due query.
Ad esempio:
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)'
Utilizza i segmenti product per identificare il prodotto pubblicizzato e product_sold i segmenti per identificare i prodotti venduti