How to query the GA realtime dataset using standard SQL

If you’re using GA360 and have setup the automated export to BiqQuery – you’ve probably noticed the realtime streaming option. Although it would outwardly seem like you can query these (.ga_realtime_sessions_yyyymmdd) tables like the regular (.ga_sessions_yyyymmdd) tables using standard or legacy sql – its not that simple. If you do – you will note data…

3 Crucial Tips for optimizing Google Analytics with Microsoft Power BI

Background It’s estimated that 55% of all the worlds websites have Google Analytics [GA] installed on them. This number dwarfs the next largest competitor, Adobe. Due to its sheer size, scale, ease of use, and robust API’s – pretty much everyone supports it, including Microsoft PowerBI. PowerBI’s integration with GA is longstanding, pretty solid, and…

Implementing Environmental Dashboards in your workplace

  We’ve all seen them – those big, flat-panel televisions – colorfully beaming with real-time data points. Pure eye-candy! I am a big proponent of environmental dashboards in the office space. Dashboards serve a vital purpose as a communication hub – providing quick access to metrics the whole organization should be aware of. However, they should not over-extend their…