dustinrecko

/*
 * Specify the link to your spreadsheet and the name of the relevant sheet here. You can use sheets to manage multiple accounts.
*/
function getSpreadsheet() {
  var spreadsheet = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1vBAiXAb38Fdhwz00B7-sE3HMQJvQnUtc3amgunsvQcM/");
  var sheet = spreadsheet.getSheetByName( "AccountName" );
  return sheet.getRange("A:Z").getValues();
}

function main() {

dustinrecko

function main() {

  var queryReport = AdWordsApp.report(
    "SELECT CampaignName,AdGroupName, AdGroupId, Query, Clicks, Impressions " +
    "FROM SEARCH_QUERY_PERFORMANCE_REPORT " +
    "WHERE Clicks > 0 " +
    "AND CampaignName DOES_NOT_CONTAIN_IGNORE_CASE 'Shopping' " +
    "AND CampaignStatus = ENABLED " +
    "AND AdGroupStatus = ENABLED " +
    "DURING LAST_7_DAYS" ).rows();

dustinrecko

/**
 * AdWords Performance Monitoring in Slack via Labels
 * @author: Dustin Recko
 *
 */

// Config Section //>

var DB_URL = 'https://...'; // The Firebase Database URL
var DB_AUTH = 'xxx'; // The Firebase Database Secret

dustinrecko

/**
 * Analytics Segment Provision in Tag Manager
 * @author: Dustin Recko
 * 
*/

var TAG_MANAGER_CONFIG = {
  accountId: '',
  containerId: '',
  workspaceId: ''

dustinrecko

<script>
  (function(){
    var xmlhttp = new XMLHttpRequest();
    var db = "https://your-database.firebaseio.com/"+{{Client Id}}.replace(/\./g,"_")+".json";

    xmlhttp.onreadystatechange = function() {
      if (this.readyState == 4 && this.status == 200) {
        window.gaIds = JSON.parse(this.responseText);
      }
    };

dustinrecko

const analyticsId = 'UA-xxxxxxxxx-x'

addEventListener('fetch', event => {
  event.respondWith(handleRequest(event))
})

/**
 * Check request object for Googlebot UA to send tracking data
 * @param {Event} event
 */

dustinrecko

/**
 * Main worker entry point.
 *
 */
addEventListener("fetch", event => {
  // Fail-safe in case of an unhandled exception
  event.passThroughOnException();
  event.respondWith(processRequest(event.request, event));
});

dustinrecko

function () {
  return function (model) {
    var proxyDomain = "https://<yourdomain.com>/collect";
    var proxySendHitTask = function () {
      function pixel(hitPayload) {
        var result = false;
        try {
          document.createElement("img").src = proxyDomain + "?" + hitPayload, result = true
        } catch (e) {}
        return result

dustinrecko

addEventListener('fetch', event => {
  if(event.request.url.indexOf('/collect') > -1)
    event.waitUntil(process(event.request))
  event.respondWith(new Response('',{status:200}))
})

/**
 * CONFIG SECTION
 */
const ANALYTICS_URL = 'https://www.google-analytics.com'

dustinrecko

response.headers.append('Set-Cookie', `_ga=${["GA1", trackingDomain.split('.').length, crypto.getRandomValues(new Uint32Array(1))[0] & 2147483647, Math.round((new Date).getTime() / 1E3)].join(".")}; Domain=.${trackingDomain}; Max-Age=63072000;`);