Google Analytics Announces BigQuery Integration At Google I/O

Today Google announced that Premium users of Google Analytics will be able to access their data via Big Query, Google’s data solution that allows users to make sense of massive data sets.

Google BigQuery Coming to Google Analytics

While the announcement occurred today, users will have to wait until later in the year to be able to use BigQuery to perform analysis that is usually very difficult to perform in traditional environments. For those of us are used to only being able to export tens of thousands of rows of data from Google Analytics this may not be a big deal, but GA premium users will be able to evaluate data that contains trillions of rows! That is an incredible amount of data being made available!

How this Impacts Google Analytics Users?

Google Analytics Big Query Announcement

Most users will not be impacted by this change, only those who have enough page views and business needs to warrant the investment in Google Analytics Premium. The companies who use GA premium will see tremendous benefit in being able to quickly and easily query the information they have stored in Google Analytics and gain insights into their business that were previously unknown or unavailable.

The ability to conduct massive queries and even export data out of Google Analytics creates an opportunity to link GA data with data warehouses, creating analysis opportunities that will make analysts salivate. The best part is that everything is in the cloud, so you do not need to invest in hardware to get the job done.

Speed, scale and reliability are all key parts to timely data analysis, and these are now built directly into the Google Analytics product for premium users.

Seeing this announcement makes me think back to a day when I had to wait an entire day to run a complex query on a data set of 100,000 records in SQL Server. We have come a long way since then!

Apply to Be Among the First BigQuery Google Analytics Users

If you are interested in signing up for BigQuery and you are a GA Premium User, you can use this form to become the first to sign up.

Here is Google’s official announcement of BigQuery in Google Analytics Premium.

Pay Attention to Bing People Search Before Your Face Stops Being YOU

bing-face-recognition-blog-graphic

I admit it, I don't use Bing often. In fact, I usually only go to Bing when someone triggers me to go there through prodding or a blog post. After reading AJ Kohn's excellent blog post from earlier this year on Bing People search I did what anyone … [Continue reading]

Testing Google Analytics Customizations Using Real Time Analytics

Crying-Dawson-Jeffalytics.png

In the past month I have been introduced to several excellent customizations of Google Analytics that can help better distinguish the traffic being pointed to your site. Before implementing these customizations on client websites and recommending … [Continue reading]

How to Create Awesomely Engaging Personalized Email Marketing Messages

Foursquare-Welcome-Back-Email.png

A week ago I arrived back in the United States after a week in Turkey and Greece. Throughout my trip I used Foursquare to check in to the various places I visited, and try to grab as many points as possible as the first of my peer group to check in … [Continue reading]

8 Reasons Why You Need to Establish Yourself as an Authority on Google+

Google+SEOGraphic.jpg

Being an Authority on Google+ Directly Impacts Search Results (Case Study) Note: This post is a summary of the results of an extensive case study on Google+. You may also be interested in reading the entire Google+ Case Study. While we all may … [Continue reading]

Productivity Tips for Travel Bloggers: Making Trip Reports Easier

Organize-Your-Travel-Photos-Using-a-Tool-Like-Aperture.png

Note: While this may not be as targeted of a post on digital marketing as what you're used to seeing on Jeffalytics, I wanted to share a post of tips I have learned to follow for blogging. These tips are particularly useful for travel bloggers, and I … [Continue reading]

Quite Possibly My Favorite PPC Optimization Email Yet

Yahoo-Bad-PPC-Optimization-Email.png

Not long after I posted about PPC Optimization emails and why they should be ignored, I received another optimization email from Yahoo, and this one is too good not to post as a follow up. If you did not have a chance to read the previous post, … [Continue reading]

The Best WordPress Plugin for Social Media Auto Posting Your Content

Jeffalytics-stats-from-Jetpack-Stats.png

If you are like me, you spend a lot of time crafting the perfect blog post. You set down to write the definitive post about a topic, conduct research, and endure several rewrites until you have an article that you feel is worthy of publishing. Great … [Continue reading]

Google Webmaster Tools Sending Traffic Increase Emails

Bodyguards-to-Protect-Lindsey-Vonn.png

Here's a first for me. Last week, Google Webmaster Tools sent me an email saying that one of my websites received a big traffic increase for a particular blog post. The post, written in February, covers Lindsey Vonn's need for bodyguards. Here is the … [Continue reading]

PPC Optimization Emails and Why You Should Ignore Them

ToiletHand

Vitor Sá The other day I received an unsolicited and not very personalized email from Microsoft on behalf of a client of mine. This client is a household name and brings in over a billion dollars a year in revenue, so not a small fry by … [Continue reading]