mike-seekwell

/**
 * @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

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%'

mike-seekwell

<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'