Li Lin sloppycoder

A handful of BigQuery SQL queries that you can use to analyze your own Google Analytics for Firebase data. To find out more about how they work, check out our presentation from Cloud Next 2018 (Video link to be added soon)

Please note that these scripts have been updated to make sure of the new Firebase schema, which was rolled out to Analytics products in July of 2018.

Note that none of these scripts will work out of the box -- you'll need to update the values in brackets with the names of your actual datasets, and you'll most likely also need to replace the names of events and event properties with ones that are appropriate for your app.

The contents of this gist are licensed under the Apache License, version 2.0

	# Copyright 2017 Google Inc.
	#
	# 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
	#
	# https://www.apache.org/licenses/LICENSE-2.0
	#
	# Unless required by applicable law or agreed to in writing, software
	# distributed under the License is distributed on an "AS IS" BASIS,

	#!/bin/bash

	if [[ -z "$1" ]]
	then
	ipaname=$(ls . \| grep -i -E '\.ipa$' \| head -1)
	else
	ipaname=$1
	fi

	echo "unzip '$ipaname'";

	" Don't try to be vi compatible
	set nocompatible

	" Helps force plugins to load correctly when it is turned back on below
	filetype off

	" TODO: Load plugins here (pathogen or vundle)

	" Turn on syntax highlighting
	syntax on

	require "active_record"

	namespace :db do

	db_config = YAML::load(File.open('config/database.yml'))
	db_config_admin = db_config.merge({'database' => 'postgres', 'schema_search_path' => 'public'})

	desc "Create the database"
	task :create do
	ActiveRecord::Base.establish_connection(db_config_admin)