russorat

/***********
 * Find all the keywords that were active daysAgo
 * Return those Ids in a mapping so we can easily filter other
 * queries.
 ***********/
function getKeywordsActiveDaysAgo(daysAgo) {
  // This will be a mapping of Ids we will return
  var keyword_ids = {};
  // We are only concerned with the Ids, so let's
  // make this as small as possible.

russorat

/***********
 * Helper function to create the labels in the account
 * that will be used to keep track of Keywords in limbo.
 ***********/
function createLabelsIfNeeded(days_in_limbo) {
  for(var i = 1; i<=days_in_limbo; i++) {
    var label_name = 'Deleting in '+i+' days';
    if(!AdWordsApp.labels().withCondition("Name = '"+label_name+"'").get().hasNext()) {
      AdWordsApp.createLabel(label_name, 
                             'These entities will be deleted in '+i+

russorat

function main() {
  var config_options = {
    'default' : {
      metric : 'Conversions', // This metric will be used for determining duds
      threshold : 0, // Duds are less than or equal to this threshold
      days_ago : 90, // The timeframe of the data to consider, days ago to yesterday
      days_in_limbo : 5 // The script will warn you for this many days before deleting something
    }
    // If you want, you can add account specific configurations too. If an account specific config
    // is not found, the default one from above is used.

russorat

/************************************
* Store Account, Campaign, and AdGroup Level Quality Score
* Version 2.3
* ChangeLog v2.3
*  - Solved #NUM! issue by filtering out -- values
* ChangeLog v2.2
*  - Updated KeywordText to Criteria
* ChangeLog v2.1
*  - Ignore negatives
* ChangeLog v2.0

russorat

// If you are running this from a spreadsheet, you can leave this blank and 
// it will pick up the active spreadsheet. If you are running this from a 
// new script.google.com project, you should put the url of the google sheet here.
var SPREADSHEET_URL = '';
var ES_HOST = {
  host : '', // for found.io, something.loc.aws.found.io
  port : 9243, // the port, usually 9200 or 9243
  username : '',
  password : '',
  use_ssl : true // set to false to use http

russorat

/******************************************
* Monitor Broken Links Using MCC Level Scripts
* Version 1.5-alt
* Changelog v1.5-alt
*   - Added ability to pause and enable keywords/ads
* Changelog v1.4
*   - Fixed INVALID_QUERY error
* Changelog v1.3
*   - Added previous version of report api to script until
*     I update my urls.

russorat

/*******************************
 * Automatically adds any new keywords in your
 * Alpha campaigns as exact match negatives in
 * the corresponding Beta campaign. Also handles
 * pausing or removing keywords in your Alpha campaign
 * and removing the corresponding negative in your Beta.
 *******************************/
// Just as before, these strings will be
// used to identify your Alpha and Beta campaigns.
// This script assumes that your Alpha campaigns are

russorat

#import <Foundation/Foundation.h>
#import <Cocoa/Cocoa.h>
#import <unistd.h>
BOOL copy_to_clipboard(NSString *path)
{
  // http://stackoverflow.com/questions/2681630/how-to-read-png-image-to-nsimage
  NSImage * image;
  if([path isEqualToString:@"-"])
  {
    // http://caiustheory.com/read-standard-input-using-objective-c 

russorat

/********************************************************************************
* This script will run through all your AdWords accounts and look for Ads that 
* have been disapproved
*
* @author Russell Savage <russellsavage@gmail.com>
* @version 1.0
* FreeAdWordsScripts.com
*
* THIS SOFTWARE IS PROVIDED BY Russell Savage ''AS IS'' AND ANY
* EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED

russorat

/********************************************************************************
* This script will run through all your AdWords accounts and store your data in
* a Google Spreadsheet. 
*
* @author Russell Savage <russellsavage@gmail.com>
* @version 1.0
*
* THIS SOFTWARE IS PROVIDED BY Russell Savage ''AS IS'' AND ANY
* EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
* WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE