Skip to content

Instantly share code, notes, and snippets.

/**
* @name: nrTimer.js
* @version: 1.0.0
* @author: Alexander Groß
* norisk GmbH
* agross@noriskshop.de
*
* Simple library that allows you to manage your AdWords Scripts easily via a configurable Timer.
*/
/**
* @name: Google Spreadsheet Wrapper
* @version: 1.0.0
* @author: Alexander Groß
* norisk GmbH
* agross@noriskshop.de
*
* Spreadsheet Wrapper that you can use to administrate a database of multiple spreadsheets. This library shows how a wrapper can work.
* IMPORTANT: You will need to implement the abstract method
*
@norisk-marketing
norisk-marketing / ryteApiToGoogleSheetWriter.js
Last active September 27, 2017 10:08
This script uses ryte's JSON-payloads to fetch data from their zoom-API and writes the results to a Google sheet. ryte is a website quality management tool with an in-depth link and source code crawler.
/*
* ryteApiToGoogleSheetWriter
* Version: 1.1.0
* @author: Christopher Gutknecht
* norisk GmbH
* cgutknecht@noriskshop.de
*
* Description: uses ryte JSON-payloads to fetch data from API and writes to Google sheet
*/
/* Docs:
* https://developers.google.com/adwords/scripts/docs/examples/google-bigquery
* https://cloud.google.com/bigquery/docs/reference/rest/v2/
* https://developers.google.com/apps-script/advanced/bigquery
* https://www.googleapis.com/bigquery/v2/projects/projectId/datasets/datasetId/tables/tableId
*/
/**
* API-Doc:
var SCRIPT_NAME = "your-script-name";
@norisk-marketing
norisk-marketing / nrCampaignBulkUpload.js
Last active December 10, 2021 21:43
CampaignCreation Service for AdWords Scripts via BulkUpload
var NEW_CAMPAIGN_CONFIG = {
"autoCreateCampaignsByUpload" : 1, // Set "1" and new campaigns will auto-added, 0 for No
"newcampSettings": { "Budget" : 1, }, // Note: new campaigns will ALWAYS be uploaded as paused
"uploadWithoutPreview" : 1, // With "1", the preview mode will be skipped
"Campaign type" : "Search Only", // Optional, default "Search Only"
"Campaign state" : "paused", // Optional, default "paused"
"Campaign subtype" : "Standard", // Optional
"Bid Strategy Type" : "cpc", // Optional , default "cpc"
"labels" : ["someLabel1","someLabel2"]
@norisk-marketing
norisk-marketing / nrShoppingIdExcludeByRoas.js
Last active April 13, 2018 18:58
nrShoppingIdExcludeByRoas.js
/*
* This norisk script creates and exports a report on product id level to a static URL as Google Spreadsheet.
* You can chose a specific Shopping Campaign to be reported or you select all.
* The URL the report will be available at, has to be chosen.
*/
// ********** START OF CONFIGURATION ***************
// README >> EVERY variable needs to be set specific to the project
// SEE THE MARKDOWN DOCUMENTATION below
@norisk-marketing
norisk-marketing / nrHourlyRevenueChecker.js
Last active March 21, 2018 09:40
The nrHourlyRevenueChecker.js checks the revenue of the last two hours within a business day time frame and sends an alert email if revenue = zero.
/***** START CONFIGURATION ******/
var MONITORED_GA_PROFILES = [[11111111, "Shop 1"],[2222222222, "Shop 2"],[333333333, "Shop 3"]];
var RECIPIENTS = ["name@email.com","name2@email.com"];
var SCRIPT_NAME = "nrHourlyRevenueChecker";
/***** END CONFIGURATION ********/
// IMPORTANT: ENABLE THE GOOGLE ANALYTICS API in the ADVANCED APIs DROPDOWN
function main() {
for(var i=0;i<MONITORED_GA_PROFILES.length;i++){
@norisk-marketing
norisk-marketing / nrHourlyGTMChecker.js
Last active March 21, 2018 12:15
This hourly revenue checker will check your main URL every hour to check for the existence of a gtm.js File and an initialized dataLayer array.
function domainCheckerAndGtmjsPrinter() {
// ********** START OF CONFIGURATION ***************
var homeUrls = [
"https://www.shop1.de",
"https://www.shop2.com",
"https://www.site3.de",
];
var RECIPIENT = ['name@email.de','name2@email.com'];
var MISSING_DATALAYER_EXCEPTION = "https://www.site3.de";
@norisk-marketing
norisk-marketing / nrMerchantCenterMonitoring.js
Last active March 21, 2018 12:16
This Merchant Center Monitoring Script logs ALL levels of important shopping data to a spreadsheet and sends a differential email alert.
/**
* Merchant Center Dashboard
* Version: 2.0.0
* @author: Christopher Gutknecht
* norisk GmbH
* cgutknecht@noriskshop.de
*/
/// CONFIG START ////

norisk GA Challenge

Hallo Zusammen,

Danke fürs Zuhören bei meinem Vortrag zur Analytics Challenge auf der Analytics Summit am 7.11. Schön, dass ihr hier vorbeischaut. Wie versprochen gibts hier die Erklärungen für das Page Speed Dashboard und die Datensammlung. Wenn Ihr Fragen oder Verbesserungsvorschläge habt, schreibt mir gerne eine Mail. Wer Interesse an einem vertieften Austausch hat, sprecht mich gerne auf der Analytics Summit an oder schickt mir gerne Kontaktaufnahme auf Xing, falls sich ein Austausch vor Ort nicht ergibt.

Die Folien vom Vortrag findet ihr auf Slideshare