About Dan Larocque

This author has not yet filled in any details.
So far Dan Larocque has created 10 blog entries.

What can you do with Un-Sampled Google Analytics Data?

Download un-sampled google analytics data and store it in a personal or corporate database.  This gives you a full range of options for best-in-class tools that convert raw data into business intelligence. Microsoft, Tableau, Qliktech, IBM, SAP, and many other business intelligence tools. You probably have your favourites, or tools that you already own and are [...]

Dimensional Aggregation and Rollup Made Easy

To get the answers we want, sometimes it's desirable to rolled up or aggregate a overly detailed dimension. This can apply to any data source including Google Analytics, PIWIK, Facebook, Instagram, Twitter, YouTube, SQL Queries and more. To demonstrate the value of rolling up detailed dimensions, a good example would be web site referers. Referers [...]

Unlocking Cohorts in Web and Social Media Analytics

You don’t need to be Houdini to escape the limitations of your Analytics Service. You just need NEXT Analytics Free or PRO Excel Addin. Although this works equally well for PIWIK , consider this example using Google Analytics. NEXT Analytics can create a cohort much more powerful than Google Analytics, even using Google Analytics’ [...]

The Data Behind Defeating DAPL

Wow, did the water protectors ever make a difference in Standing Rock! We mapped out the geo-locations for #NoDAPL on Instagram to show where the posts were coming from across North America, as well as when the largest spikes of interest occurred. As you can see from our gif above, there were major spikes on [...]

The Biggest Surprise of the 2016 LA Auto Show!

People love cars. People love posting about cars on Instagram. Analyzing the Los Angeles Auto Show grams was fun for us because it gave us so much data to work with. Car brands from all over the world touched down in California to show off their brand new vehicles. Porsche, Maserati, Ferrari - the usual [...]

Social Media Masters – Facebook Case Study: Taco Bell part 1

When you’re struggling to optimize your social media strategy one of the best ways to find inspiration is to see what some of the most successful social media juggernauts are doing right. In this Facebook Case Study, I'll be showing you how one of the greats creates reaction-worthy content: With over 10.4 million Facebook fans, [...]