Help with Search Query Report Script

[Omar Ajmeri]

Hi All,

I'm attempting to write a script to produce keywords that have a higher conversion value than cost, and I'm running into some trouble. I'm using this as a reference, but I can't seem to get it to run - any help would be appreciated!

function main(){
var report = AdsApp.report(
   "SELECT Query " +
   " FROM SEARCH_QUERY_PERFORMANCE_REPORT " +
   " WHERE Cost > 100" +
   " DURING LAST_7_DAYS");
var rows = report.rows();
console.log(rows);
};

[Google Ads Scripts Forum Advisor]

Hi Omar,

Thanks for reaching out. The rows object in your code, is an iterator, so logging the object will not log the actual row data. Please see this reporting example that demonstrates how to loop through the row iterator. 

Regards,

Matt Google Ads Scripts Team

ref:_00D1U1174p._5004Q2dLeJW:ref