Skip to content

Instantly share code, notes, and snippets.

Avatar

mike-seekwell

View GitHub Profile
View bigqueryLogAnalysis.sql
SELECT
httpRequest.remoteIp,
httpRequest.referer,
FORMAT_TIMESTAMP('%Y-%m-%d', timestamp) as visited_on,
httpRequest.requestUrl,
count(1) as ct
FROM
`logs.appengine_googleapis_com_*`
WHERE 1=1
AND httpRequest.referer not like '%.css%'
View appsScriptForBlog.js
/**
* @OnlyCurrentDoc
*/
var MAXROWS = 1000
var SEEKWELL_J_SHORT_DATES = { day: "yyyy-MM-dd", month: "yyyy-MM", year: "yyyy", dayNum: "dd", monthNum: "MM", yearNum: "yyyy", week: "W" }
var SEEKWELL_J_TIMEZONE = "UTC"
var HOST = '35.196.130.133'
var PORT = '3306'
var USERNAME = 'apps_script_demo'
@mike-seekwell
mike-seekwell / html
Last active Dec 4, 2018
instpageAdStuff
View html
<script async src="https://www.googletagmanager.com/gtag/js?id=AW-781982051"></script>
<script>
window.dataLayer = window.dataLayer || [];
function gtag(){dataLayer.push(arguments);}
gtag('js', new Date());
gtag('config', 'AW-781982051');
</script>
<script>
var targetEnv = 'prod'