tonkikh

/******************************************
 * Newly Disapproved Products 
 *
 * Google Ads Script for identifying newly disapproved in Google Merchant Center, 
 * if product has clicks before
 *
 * Created by: Dmytro Tonkikh, chiliad & TrueClicks
 *
 * Telegram channel : t.me/adwordsscripts
 * Websites :  https://adsapp.report

tonkikh

var fullReport = [];

function main() {

    // enter your spreadsheet url  and sheet name
    let sheetUrl = ''; // enter spreadsheet URL between the quotes
    let sheetName = 'Sheet1'; // enter sheet name between the quotes
    
    // don't touch code below this line
    // =================================

tonkikh

/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* MCC Quality Score Tracker v3.0.1
* Written by Martin Roettgerding.
* © 2016 Martin Roettgerding, Bloofusion Germany GmbH.
* www.ppc-epiphany.com/qstracker/latest
*
* Modified by Dmytro Tonkikh, chiliad LLC, Ukraine
* https://chiliad.agency
* version for MCC account
*/

tonkikh

/**
 * Convert Excel file to Sheets
 * @param {Blob} excelFile The Excel file blob data; Required
 * @param {String} filename File name on uploading drive; Required
 * @param {Array} arrParents Array of folder ids to put converted file in; Optional, will default to Drive root folder
 * @return {Spreadsheet} Converted Google Spreadsheet instance
 **/
function convertExcel2Sheets(excelFile, filename, arrParents) {
  
  var parents  = arrParents || []; // check if optional arrParents argument was provided, default to empty array if not

tonkikh

var URL_LEVEL = 'Ad'; // Ad or Keyword
var ONLY_ACTIVE = false; // set to false for all ads or keywords
var CAMPAIGN_LABEL = ''; // set this if you want to only check campaigns with this label
var STRIP_QUERY_STRING = true; // set this to false if the stuff that comes after the question mark is important
var WRAPPED_URLS = true; // set this to true if you use a 3rd party like Marin or Kenshoo for managing you account
// This is the specific text to search for 
// on the page that indicates the item 
// is out of stock.
var LABEL_NAMES = ['"test"'];
var OUT_OF_STOCK_TEXT = 'out of stock';

tonkikh

function main() {
  var settings = {'linkedView':"XXXXXXXX",
                  'linkedAccountId':"XXX-XXX-XXXX",
                  'accountId':'XXXXXXX',
                  'propertyID':'UA-XXXXXXX-X'};
 //Example spreadsheet https://goo.gl/4ZAb7Z, make copy and paste instead

  var spreadsheet = SpreadsheetApp.openByUrl('https://goo.gl/4ZAb7Z');
  var sheet = spreadsheet.getSheetByName('Sheet1');
  var range = sheet.getRange(2, 1, sheet.getLastRow(), 3);

tonkikh

/** Highest positive signed 32-bit float value */
const maxInt = 2147483647; // aka. 0x7FFFFFFF or 2^31-1

/** Bootstring parameters */
const base = 36;
const tMin = 1;
const tMax = 26;
const skew = 38;
const damp = 700;
const initialBias = 72;

tonkikh

/******************************************
* Advanced Broken Url Checker
*
* Version 1.1
*
* Created by: Dmytro Tonkikh 
*
* m.me/dmytro.tonkikh
* t.me/dtonkikh
* t.me/adwordsscripts

tonkikh

/**
*
* Campaign Budget Overspend Monitoring
*
* Этот скрипт отмечает ярлыками кампании, которые перетратели свой дневной бюджет.
* Опционально, он также может выключать эти кампании, если они потратили слишком много.
* Вам прийдет оповещение на почту, если будут новые отмеченные ярлыком кампании.
* Когда бюджет более не перерасходуется, кампании возобновяться и удаляться ярлыки.
*
* Version: 1.0

tonkikh

/******************************************
* YouTube Channels Cleaner
*
* Version 2.0 
* Date 25.03.2017
*
* Created by: Dmytro Tonkikh
******************************************/

var dataFile = "videoIds.txt";