themacmarketer

/**
*
* Search Query Mining Tool
*
* This script calculates the contribution of each word or phrase found in the 
* search query report and outputs a report into a Google Doc spreadsheet.
*
* Version: October 2021
* 
* original author brainlabsdigital

themacmarketer

// ID: 5a92f7fa7a689734ad71adb3579baff8
/**
 *
 * Make Exact Match Exact
 *
 * Adds negatives for any search query that doesn't actually exactly match an exact
 * match keyword.
 *
 * Version: 2.0
 * Google AdWords Script maintained on brainlabsdigital.com

themacmarketer

/* @version: 1.5
*
* Close variant report
*/
 
var SPREADSHEET_URL = "https://docs.google.com/spreadsheets/YOUR-SHEET-URL-HERE";  //insert a new blank spreadsheet url
var CAMPAIGNLABEL = ""; // Leave blank for all campaigns 
 
var DATE_RANGE = 'LAST_30_DAYS';
var MATCH_TYPE = '[EXACT, NEAR_EXACT]';

themacmarketer

// Copyright 2015, Google Inc. All Rights Reserved.
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
//     http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,