 Think you are due a refund for bad clicks? You can fill out this form and Google will look into it. It takes a few weeks sometimes to get a response. https://support.google.com/adwords/contact/click_quality
Sample adwords script on how to send the generated spreadsheet of your report to your email.8/9/2017
function main() {
var spreadsheet = SpreadsheetApp.create('INSERT_REPORT_NAME_HERE'); // you may change the report type depending on your preference var report = AdWordsApp.report( 'SELECT CampaignName, Clicks, Impressions, Cost ' + 'FROM CAMPAIGN_PERFORMANCE_REPORT ' + 'WHERE Impressions < 10 ' + 'DURING LAST_30_DAYS'); report.exportToSheet(spreadsheet.getActiveSheet()); Logger.log(spreadsheet.getUrl()); var EMAIL_TO = 'INSERT_EMAIL_HERE'; var subject = 'Report '; var body = [ '<p>Hi,</p>', '<p>Spreadsheet Url:</p>'+spreadsheet.getUrl(), '<p>AdWords Scripts</p>' ]; MailApp.sendEmail({ to: EMAIL_TO, subject: subject, htmlBody: body.join('\n') }); } |