Skip to content

Instantly share code, notes, and snippets.

View zdenekzed's full-sized avatar

Zdeněk Hejnák zdenekzed

0 followers · 3 following
  • Livesport
  • Prague
  • 23:59 (UTC +01:00)
View GitHub Profile
@zdenekzed
zdenekzed / 0_BigQuery_Recipes.md
Created August 27, 2019 17:04 — forked from ToddKerpelman/0_BigQuery_Recipes.md

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

@zdenekzed
zdenekzed / gist:ca4846a40e242fb7c746e5f7c873c9e1
Created November 23, 2016 10:44 — forked from mhawksey/gist:9199459
Google Apps Script snippet to send tracking data to Google Analytics using the Measurement Protocol
function onOpen(){
// example send for Sheets
sendGAMP("UA-XXXX-1", SpreadsheetApp.getActiveSpreadsheet().getUrl());
// example send for Documents
//sendGAMP("UA-XXXX-1", DocumentApp.getActiveDocument().getUrl());
// example send for Forms *NOTE* getUrl not implemented yet in New Sheets
//sendGAMP("UA-XXXX-1", FormApp.getActiveForm().getUrl());
}