Google I/O 2013: Turning BigQuery analytics into marketing strategies

Google I/O 2013: Turning BigQuery analytics into marketing strategies

Summary: Google product managers describe how digital photo company Shutterfly is a case study example of turning big data into business without massive hardware and software investments.


SAN FRANCISCO -- If there is one thing that Google has a lot of (besides money), it's data.

Many developers attending Google I/O 2013 this week are learning more and more about using that data to their benefit, whether it be through mobile commerce via Google Wallet or location APIs for Glass.

One of the more complex but logical places to start would be with BigQuery, Google's Web-based service for interactive analysis of massive data sets. The Internet giant boasts that the system can mine and analyze terabytes of data in just one click.

Using digital photo service Shutterfly as a case study, BigQuery product manager Ju-kay Kwek explained during a session for developers on Thursday morning about how businesses -- notably the marketing departments -- can turn this data around into customer and product marketing strategies.

Derek Stevenson, senior director of data strategy and analytics at Shutterfly, acknowledged some of the challenges surrounding big data, quipping that "big" is always relative.

In the simplest terms, those constraints consist of scale, performance, cost, and, well, simplicity.

 Stevenson remarked that data is often seen as a competitive advantage, but that requires owning the data and methodology, an experienced analytics team, and decisive action.

"The basic idea is that marketing often has a particular budget that they can invest in their channels," said Stevenson, adding that the common question often revolves around return on investment.

As of 2012, Shutterfly had more than 19 billion images stored with seven million customers registered. That comes with good amount of data about images, locations, cameras, and the users themselves.

"If they don't have to spend their time preparing data and aggregating and building cubes -- I've been on the IT side, and I can tell you that's not the fun part of the job," Stevenson joked.

Stevenson pointed out that the data isn't "random," meaning that insights require educated interpretation.

But then the challenge becomes scaling that analysis to cover more than 19 billion images, or 80 petabytes of data.

In order to tackle these issues, Stevenson posited that "traditional approaches" require compromise, whether its sampling or aggregation. But Stevenson lamented these approaches drop out some details.

The goal, he continued, is to maintain those details in order to interprets and inform interactions with all customers.

Stevenson admitted that IT departments often bear the brunt of the "multi-dimentional challenge" surrounding big data in sifting through all the details about users, volume, mergers and acquisitions, and more.

To fill that "gap" with BigQuery, Stevenson described that Shutterfly switched to a strategy that consists of the following five steps: data collection, storage (on BigQuery and Google's cloud), preparing the data for analysis, and then acting on the findings through email campaigns, online merchandizing, and retargeting ads.

"If they don't have to spend their time preparing data and aggregating and building cubes -- I've been on the IT side, and I can tell you that's not the fun part of the job," Stevenson joked.

Topics: Big Data, CXO, Data Management, E-Commerce, Google

Kick off your day with ZDNet's daily email newsletter. It's the freshest tech news and opinion, served hot. Get it.


Log in or register to join the discussion
  • Lot's of data

    Google being the biggest spyware network in the world has more data on more people than any other organisation in the world. Just imagine, they have profiles on anyone that runs a Google search. That is probably over 2 billion people. They then can augment the profiles with data collected from anyone using their apps or services. We know that there are over a billion of those who, once they sign in with their Gmail account, are giving Google more detailed information about all aspects of their lives.

    Just wait until Google gets hacked, or management changes, or some employee decides to start selling information. Identity theft will be on everyone's lips. But, it will be too late for all the Google suckers!

    Guess what ?! myERP, the most popular business app for Google Apps was at Google I/O and is actually the 1st to integrate this innovative technology ! I strongly believe that Google fast action button is a major email evolution. This is a huge opportunity for cloud accounting and billing actors like myERP. We know how painful it is to read tons of emails every day and then to leave our inbox to get things done. Google and myERP easy notifications solves this problem by bringing your To-Dos directly into your inbox. The possibilities are endless: receive a payment in a click, re-order items in a snap, pay a bill.. thus fixing the pain of millions of small businesses. This really is an awesome invention which will change how entrepreneurs work. Check out our Blog to find out more !
    Valerie myERP