As a digital analytics consultant I get the unique perspective of seeing how different companies, from Fortune 500 companies to small non-profit organizations, find and train talent to work in digital analytics. One of the biggest challenges facing companies today is finding talent in the digital analytics space. There is definitely a gap between the number of qualified digital analytics professionals and the amount of jobs available in the market. For recent college graduates I would argue that going into the digital analytics space could be one of the best career paths to follow. Continue reading >
Tableau has a myriad of direct connectors to different data sources, including a convenient Google Analytics connector (it”s still using Core API v2 instead of the new v3 though). However, what Tableau doesn’t have is a direct connection to Adobe Analytics (formerly Adobe SiteCatalyst and Omniture). In this post, I’m going to show you a relatively simple workaround to building an automated SiteCat dashboard using Tableau Online or Server, especially if you are not ready for the full featured data warehouse options.
So let me just say this first: I love the new Google Sheets, I hate the new Add-ons for Google Analytics.
Let me explain.
One of my favorite things about Google Sheets is its ability to retrieve Google Analytics data through the Core Reporting API without any complicated coding. All you need is the Google Analytics Report Automation (Magic Script). The script used to be available under Tools –> Script Gallery; you just need to set up and authorize it to access the Analytics API. It has since been replaced by the new Google Analytics Add-ons, but in this post I’ll show you how you can still use the old script along with its awesome automation options (not available yet in the new Adds-on). I’ll throw in a bonus solution for an execution time error you might run into when calling for a large number of APIs. Continue reading >