MaximizeConversionValueTargetRoas not valid for report type CAMPAIGN_PERFORMANCE_REPORT?

[Gal]

Hello,

I am trying to get the targetROAS target value per campaign - using this query:

var report = AdWordsApp.report(

   " SELECT CampaignName, CampaignStatus, BiddingStrategyName, BiddingStrategyType, MaximizeConversionValueTargetRoas, ConversionValue, Cost " +

   " FROM CAMPAIGN_PERFORMANCE_REPORT " +

   " WHERE " +

       "CampaignStatus = ENABLED" +

       " AND BiddingStrategyType = TARGET_ROAS" +

       " DURING LAST_7_DAYS");

But I am getting this response:

Column 'MaximizeConversionValueTargetRoas' is not valid for report type CAMPAIGN_PERFORMANCE_REPORT. Double-check your SELECT clause. (file Code.gs, line 31)

Can anyone help me with this?

I have checked and double checked typo's, and I am also using the latest report (v201806).

Thanks!

[Dhanya Sundararaju (AdWords API Team)]

Hi Gal,

Your query looks good to me. I was also able to run it successfully against my test account. In order to troubleshoot further, could you reply back with your client customer id? You may opt to reply privately to author.

Regards,
Dhanya, AdWords API Team

[Sreelakshmi Sasidharan (AdWords API Team)]

Hello Gal, 

Thanks for sharing the details offline. On this forum we discuss questions about AdWords API. Since your question is about AdWords Scripts, please post your question and the logs in the AdWords Scripts forum. The experts there are better equipped to address your questions. 

Thanks,
Sreelakshmi, AdWords API Team