Account Summary Report - Parsing Error

[Sion Jones]

Hi all,

Not sure how, but I've come across this error:

"Parsing error. Please check your selector. (file Code.gs, line 243)"

function getReportRowForDuring(during) {

  var report = AdsApp.report(

      'SELECT ' +

          REPORT_FIELDS

              .map(function(field) {

                return field.columnName;

              })

              .join(',') +

          ' FROM ACCOUNT_PERFORMANCE_REPORT ' +

          'DURING ' + during,

      REPORTING_OPTIONS);

  return report.rows().next();

}

Not sure what's caused this as it passed the preview the other day, but now is showing this.

[Google Ads Scripts Forum Advisor]

Hi Sion,

Thanks for reaching out. Harry here, from the Google Ads Scripts Team.

It's most likely that the your reporting query values are invalid. Kindly provide your Google Ads account ID, script's name and a shareable link to your spreadsheet if available so I can take a look closer at the issue you are encountering. You may send them here and take not of sensitive data or provide details privately via the reply to author option. Note that you may need to join the Google Group for you to use this option. If this option is not available at your end still, you may send it through our email (googleadsscr...@google.com) instead.

Looking forward to your reply.

Thanks,

Harry Cliford Rivera Google Ads Scripts Team

ref:_00D1U1174p._5004Q2PIqu8:ref

[Google Ads Scripts Forum Advisor]

Hi Sion,

Thanks for coming back with the requested details. The column names in the REPORT_FIELDS object on line 58 should match the names in the Account Performance Report and you can instead have another name for these columns in the displayName attributes as you need to. Kindly make changes to the columnName attributes based of the below and let me know how it goes.

• Avg. CPC  >  AverageCpc
• CTR  >  Ctr
• Search Impr. share  >  SearchImpressionShare
• Cost / conv.  >  CostPerConversion
• Conv. rate  >  ConversionRate

[Sion Jones]

Sorry for the delayed reply I did not notice you replied here.

I've made those changes but I'm still getting the same error

[Google Ads Scripts Forum Advisor]

Hi Sion,

I work along with Harry. Allow me to assist you in this.

As per checking, it appears that you've updated the displayName instead of the columnName value which causes the error persists. Kindly update your reports fields with this:

var REPORT_FIELDS = [
   {columnName: 'Cost', displayName: 'Cost'},
   {columnName: 'AverageCpc', displayName: 'AverageCpc'},
   {columnName: 'Ctr', displayName: 'Ctr'},
   {columnName: 'Impressions', displayName: 'Impressions'},
   {columnName: 'Clicks', displayName: 'Clicks'},
   {columnName: 'Conversions', displayName: 'Conversions'},
   {columnName: 'SearchImpressionShare', displayName: 'SearchImpressionShare'},
   {columnName: 'CostPerConversion', displayName: 'CostPerConversion'},
   {columnName: 'ConversionRate', displayName: 'ConversionRate'},
 ];

Regards,

Teejay Wennie Pimentel Google Ads Scripts Team

 

ref:_00D1U1174p._5004Q2PIqu8:ref

[Sion Jones]

It's all good, I changed the columns in my report to match the ones you've set and it works fine now.

thanks for you help both