Skip to content

Instantly share code, notes, and snippets.

@RitwikGA
Last active January 4, 2017 10:43
Show Gist options
  • Save RitwikGA/a6d1ceb01e6b176cd8f9ff3e794e5499 to your computer and use it in GitHub Desktop.
Save RitwikGA/a6d1ceb01e6b176cd8f9ff3e794e5499 to your computer and use it in GitHub Desktop.
Adwords Scripts - Daily Stats - Clicks>80
/////////////////////////////////////////////////////////////////////
function main(){
var report = AdWordsApp.report(
'SELECT Date, Clicks, Impressions, Cost, CostPerConversion ' +
'FROM CAMPAIGN_PERFORMANCE_REPORT ' +
'WHERE Clicks > 80 ' +
'DURING LAST_7_DAYS');
Logger.log("Date "+"Clicks "+"Impressions "+"Cost "+"CostPerConversion")
var rows = report.rows();
while (rows.hasNext()) {
var row = rows.next();
var Date = row['Date'];
var clicks = row['Clicks'];
var impressions = row['Impressions'];
var cost = row['Cost'];
var CPA = row['CostPerConversion']
Logger.log(Date+" "+clicks+" "+impressions+" "+cost+" "+CPA)}
}
///////////////////////////////////////////////////////////////////////////////////
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment