ryanpraski

#!/usr/bin/python
# -*- coding: utf-8 -*-
#
# Copyright 2012 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

ryanpraski

library(dplyr)
library(ggplot2)
library(lubridate)
library(XML)

#load apple health export.xml file
xml <- xmlParse("C:\\Users\\praskry\\Desktop\\apple_health_data\\export.xml")

#transform xml file to data frame - select the Record rows from the xml file
df <- XML:::xmlAttrsToDataFrame(xml["//Record"])

ryanpraski

<script type="text/javascript"> 
(function(dataLayer) {
    var i = 0;
    var jwpVideoIsPlaying = false;
    //array of percentages at which progress notifications are pushed to the dataLayer
    var markers = [10, 25, 50, 75, 90]; //adjust these values if you want different progress reports
    var playersMarkers = [];

    function findObjectIndexById(haystack, key, needle) {
        for (var i = 0; i < haystack.length; i++) {

ryanpraski

// get time stamp of query run
function setTimeStamp(sheetName) {
SpreadsheetApp.getActive().getSheetByName(sheetName)
.getRange('C2').setValue(new Date())
}

// gaGet data
function gaGet(tableId, metrics, options) {
    // Apply standard options
    options = options || {};

ryanpraski

function connectToCloudSQL() {
  
  var params = {
    ip: "INSERT IP",
    user: "INSERT USER",
    password: "INSERT PASSWORD",
    database: "INSERT DATABASE"
  }
  
  var dbUrl = 'jdbc:mysql://' + params.ip + '/' + params.database;

ryanpraski

//Code to grab s_vi cookie and pass it in a query parameter to bank domain
$('a.aeroplan-card.apply_btn1,a.aeroplan-card.learn_btn1').each(function() {
    function getCookie(name) {
        var v = document.cookie.match('(^|;) ?' + name + '=([^;]*)(;|$)');
        return v ? v[2] : null;
    }
    var s_vi = getCookie("s_vi").slice(7, 40);
    var href = this.href;
    if (href.indexOf('?') != -1) {
        href = href + '&amex_s_vi=' + s_vi;

ryanpraski

## A script to download and archive Google search console analytics (formerly webmaster tools)
##
## searchConsoleR package created by Mark Edmondson (http://markedmondson.me)
##
## This script downloads and writes data to .csv for the most recent day of search console data (3 days ago)

## load the required libraries 
## (Download them with install.packages("googleAuthR") and install.packages("searchConsoleR") if necessary
library(googleAuthR)
library(searchConsoleR)

ryanpraski

library(googleAnalyticsR)
library(tidyr)

#Authorized Google Analytics R- this will open a webpage
#You must be logged into your Google Analytics account on your web browser
ga_auth()

#Use the Google Analytics Management API to see a list of Google Analytics accounts you have access to
my_accounts <- google_analytics_account_list()
View(my_accounts)

ryanpraski

library(googleAnalyticsR)
library(ggplot2)

#Authorize Google Analytics R- this will open a webpage
#You must be logged into your Google Analytics account on your web browser
ga_auth()

#Use the Google Analytics Management API to see a list of Google Analytics accounts you have access to
my_accounts <- google_analytics_account_list()
View(my_accounts)

ryanpraski

function uploadData() {
    var accountId = "xxxxxxxx";
    var webPropertyId = "UA-xxxxxxxx-x";
    var customDataSourceId = "xxxxxxxx";
    var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
    var maxRows = ss.getLastRow();
    var maxColumns = ss.getLastColumn();
    var data = [];
    for (var i = 1; i <= maxRows; i++) {
        data.push(ss.getRange([i], 1, 1, maxColumns).getValues());