Google Ads Scripts: SMART SHOPPING campaigns listing?

[Gerald Buchgraber]

Smart shopping campaigns are not accessable with one of the following approaches:

• AdsApp.shoppingCampaigns()
  
• AdsApp.campaigns()
  

Is there something wrong or how can I retrieve SMART SHOPPING campaigns?

Apart form that shopping performance reports DO SHOW metrics even form certain SMART SHOPPING campaigns like:

AdWordsApp.report("SELECT OfferId, Impressions, Clicks, Ctr, AverageCpc, Cost FROM SHOPPING_PERFORMANCE_REPORT WHERE CampaignId = " + $campaignId);

but there's another issue here!

It is allowed to select the OfferId of a product, but it is not possible to use the product's title (ProductTitle field) in combination with conversion metrics:

AdWordsApp.report("SELECT OfferId, Impressions, Clicks, Ctr, AverageCpc, Cost FROM SHOPPING_PERFORMANCE_REPORT WHERE CampaignId = " + $campaignId);

Results in: "Invalid reporting query: Cannot select a combination of ProductTitle and AllConversionRate,AllConversionValue,AllConversions,ConversionRate,ConversionValue,Conversions,CostPerAllConversion,CostPerConversion,CrossDeviceConversions,ValuePerAllConversion,ValuePerConversion."

Why that? Both attributes have the same orign (Merchant Center)

[Google Ads API Forum Advisor Prod]

Hi Gerald,

Since this forum is for AdWords API / Google Ads API, could you create a new thread in Google Ads Scripts Forum with all the details of the issue that you are encountering? 

Feel free to reach us when you have  AdWords API / Google Ads API related inquiries or concerns.

Regards,
Hiroyuki
Google Ads API Team

ref:_00D1U1174p._5001UAqSzD:ref