dustinrecko

function main() {

  var queryReport = AdWordsApp.report(
    "SELECT CampaignName,AdGroupName, AdGroupId, Query, Clicks, Impressions " +
    "FROM SEARCH_QUERY_PERFORMANCE_REPORT " +
    "WHERE Clicks > 0 " +
    "AND CampaignName DOES_NOT_CONTAIN_IGNORE_CASE 'Shopping' " +
    "AND CampaignStatus = ENABLED " +
    "AND AdGroupStatus = ENABLED " +
    "DURING LAST_7_DAYS" ).rows();

dustinrecko

/*
 * Specify the link to your spreadsheet and the name of the relevant sheet here. You can use sheets to manage multiple accounts.
*/
function getSpreadsheet() {
  var spreadsheet = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1vBAiXAb38Fdhwz00B7-sE3HMQJvQnUtc3amgunsvQcM/");
  var sheet = spreadsheet.getSheetByName( "AccountName" );
  return sheet.getRange("A:Z").getValues();
}

function main() {