derekmartinla

/**********************************************************************************************************************
* Amazon Autocomplete Tool 
* Leverage the Amazon Autocomplete feature to find highly commercial keyword opportunities.
* Export the results for efficient importing into Google Adwords 
* Version 1.0
* Created By: Derek Martin
* DerekMartinLA.com or MixedMarketingArtist.com
**********************************************************************************************************************/

 var hashMapResults = {}; 

derekmartinla

// This script reviews your GDN placements for the following conditions:
// 1) Placements that are converting at less than $40
// 2) Placements that have cost more than $50 but haven't converted
// 3) Placements that have more than 5K impressions and less than .10 CTR

function main() {
   
  var body = "<h2>Google Display Network Alert</h2>";
  body += "<h3>Placements that are converting at less than $40:</h3> " ;
  body += "<ul>";

derekmartinla

/**********************************************************************************************************************
* Brand Keyword Analysis Google
* Leverages the Google Autocomplete feature to find potential keyword opportunities and negative keywowrds
* Version 1.0
* Created By: Derek Martin
* DerekMartinLA.com or MixedMarketingArtist.com
**********************************************************************************************************************/

 var hashMapResults = {}; 
 var numOfKeywords = 0; 

derekmartinla

/**************************************************************************************
* AdWords Optimization -- Quality Score Performance Checker 
* This script audits an account's quality score performance and creates a table that shows the
* distribution of CTR, Cost, & Conversins against Quality Score. 
* Version 1.0
* Created By: Derek Martin
* DerekMartinLA.com
**************************************************************************************/

function main() {

derekmartinla

/***************************************************************************************
* AdWords Account Audit  -- Check Ads for disapprovals -- text if there are open issues 
* Version 1.0
* Created By: Derek Martin
* DerekMartinLA.com
****************************************************************************************/

// This script was heavily inspired by Russell Savage so all credit where its due!
// Sign up at Twilio.com and get an API key (sid) and Auth code and place here 
// Url: https://www.twilio.com/

derekmartinla

/***********************************************************************************************
* AdWords Account Optimization - Review Google Display Network Site Placement Quality.  
* Analyze Display Network Placements that have accrued more than $20 of cost MTD against
* Standard SEO metrics (PageAuthority, DomainAuthority, # of Backlinks, Age of Site) and report back 
* Any questionable placements that are strong targets for exclusion.
* Created By: Derek Martin
* DerekMartinLA.com
****************************************************************************************/
// CONSTANTS 

derekmartinla

require 'spidr' # gem install spidr
require 'nokogiri'
require 'google_drive'

GOOGLE_SHEET_ID = "1k26clMVYUX5PLag5K2Ku4osgZcTtWp-wlss1B6CC_KE" # replace with your Google Sheet Id 
CRAWL_SITE = "https://www.mywebsite.com"

OpenSSL::SSL.send(:remove_const, :VERIFY_PEER)
OpenSSL::SSL.const_set(:VERIFY_PEER, OpenSSL::SSL::VERIFY_NONE)

derekmartinla

var GOOGLE_DOC_URL = "URL"; 

function main() {
	
  clicks = runCampaignReport();
  modifySpreadSheet(clicks);
  
}
function runCampaignReport() {

derekmartinla

/**********************************************************************************************
* AdWords Account Management -- Review Search Queries & Post Adjustments via Google Docs. 
* Version 1.0
* Created By: Derek Martin
* DerekMartinLA.com & MixedMarketingArtist.com 
*********************************************************************************************/

var GOOGLE_DOC_URL = "put your url here";
var START_DATE = '20150401';
var END_DATE = '20150415';

derekmartinla

var email_address = 'derek@wpromote.com';

function main() {

var urlList = runUrlReport();
urlList = _.uniq(urlList, function(item, key, url) { 
    return item.url;
});
  
var listOfBrokenUrls = [];