No metrics in
Self Joins
- Cross Join example
- Inner Join example
joins can be inefficent - they can require moving lots of data around and increase the data process from n to n * n
oyagurcan
alfhh
/ ga-video.js
Created
July 10, 2017 20:17
— forked from kyleridolfo/ga-video.js
HTML5 Video Tracking for Google Tag Manager
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <script> | |
| // Let's wrap everything inside a function so variables are not defined as globals | |
| (function(){ | |
| // This is gonna our percent buckets ( 10%-90% ) | |
| var divisor = 10; | |
| // We're going to save our players status on this object. | |
| var videos_status = {}; | |
| // This is the funcion that is gonna handle the event sent by the player listeners | |
| function eventHandler(e){ | |
| switch(e.type) { |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <meta charset="UTF-8"> | |
| <title>Logging Test for Google Analytics</title> | |
| <style> | |
| button { | |
| position: relative; |
gondo
/ GA real time users count
Last active
May 6, 2024 01:44
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| /** | |
| * 1. create project at https://console.developers.google.com/project | |
| * 2. enable 'Analytics API' under 'APIs & auth' / APIs | |
| * 3. create 'NEW CLIENT ID' (OAuth client) under 'APIs & auth' / Credentials | |
| * i. select 'Service account' | |
| * ii. save generated key file to 'key.p12' | |
| * iii. remember CLIENT ID | |
| * 4. under GA account add 'Read & Analyze' access to newly generated email (access to GA Account not Property nor View) |