Regarding shopping_performance_view segmenting resources.

[Adithya A S]

Campaign is a part of segmenting resources for shopping_performance_view so when made a query including campaign.optimisation_score in the select clause for a particular segments.product_title we are getting only a single result of campaign.optimisation_score but according to documentation shouldn't it segment based on different optimisation_scores?

[Google Ads API Forum Advisor]

Hi,
 

Thanks for reaching out to the Google Ads API team. I hope you are doing well today.
 

With regards to your concern, yes you are correct that the Campaign resource is a part of segmenting resources for shopping_performance_view. As per this document said, "When selecting from some resources, you may have the option to implicitly join on related resources by selecting their fields alongside the fields of the resource in the FROM clause. These related resources can be found in the Attributed Resources list on the resource in the FROM clause's metadata page. In the case of the ad_group resource, you'll see that you can also select fields from the campaign resource. The resource_name field of any Attributed Resources with at least 1 field in the SELECT clause will automatically be returned, even when the resource_name field is not explicitly included in the query."
 

Regards,

Darwin Google Ads API Team

ref:_00D1U1174p._5004Q2gS1rx:ref