Averaging about 30 million users watching over 1 billion videos per day, YouTube is unarguably the world’s most popular online video delivery platform. Given its unparalleled reach and its almost seamless website integration, it’s no wonder so many businesses use YouTube for video content delivery on their own websites (rather than their own native video players).
Google Sheets was not originally created as a data visualization tool, but it has been flexible enough that many people use it for dashboarding. But with recent and ongoing improvements to Data Studio, including unlimited free reports, Data Studio has become a real contender against Google Sheets.
Which tool should your organization use for dashboarding? Each has its own pros and cons. Deciding on which tool to use depends on your role within your organization and your business needs. Are you a marketing executive looking for an intuitive tool to display high-level metrics? Or are you an analyst that will need to incorporate advanced calculated metrics in a dashboard?
The following checklist of benefits can help you make a decision. Continue reading >
Data import is a way to populate data within a Google Analytics custom dimension after data from a user’s session has already been sent to Google.
While any data could be sent (excluding personally identifiable information), this makes the best candidates for data import data that is either too cumbersome to setup with your tag manager, or data that is not available while a user is browsing your website.
If you picture your Google Analytics data as a table with records and fields, the data import allows you to add a new field, whose values are based on the values of some other field. For example, we might want to classify all hits where the state is equal to “Arizona” to populate the value “Southwest” into custom dimension #1. Continue reading >
So how does one go about studying for the Google Analytics IQ test? There are thousands of blogs out there trying to convince you that they have the magic formula. That in three days of intensive studying, you too can be an expert in Google Analytics. Continue reading >
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 >