Case Study | Google BigQuery

Interactions Marketing digs into storm data to analyze consumer behavior using Google BigQuery

About Interactions Marketing

Founded in 1988, Interactions provides in-store product demonstrations and outdoor experience marketing programs for retailers and brands worldwide. With over 45,000 associates, the San Diego-based company creates and executes more than 2 million events every year and manages 5,500 events each day. To learn more, visit www.interactionsmarketing.com

At a Glance Google BigQuery Results • 1.3 billion rows of data analyzed • POS and NOAA data • 28 product categories ID’ed with sales significant increases • New insight into consumer behavior patters during bad weather

Data from a snowstorm Interactions Marketing wanted to explore how it could deliver better, highlevel data analytics, such as sales patterns and shopper behavior, that might help retailer and manufacturing clients plan ahead. After considering various solutions, the company focused on Google BigQuery. With previous exposure to transactional and loyalty-card data, Interactions was able to use BigQuery in a study that provided new insights into consumers’ behavior during snowstorms by combining point-of-sale (POS) and government meteorological data. On-demand, scalable resource “Analytics is the foundation of how we assist retailers and manufacturers in remaining relevant,” says Giovanni DeMeo, Interactions vice president of global marketing and analytics. “BigQuery was a newer platform, and the opportunity to do an experimental test with it was very exciting. We wanted to see what we could do with the data.” “Every time you add a new data source to your analysis, there’s a huge capital investment, and it can take a long time to build the traditional infrastructure,” says Abhi Beniwal, Interactions senior vice president of global information technology. “By using Google BigQuery, you can work with a different kind of timeline, cost and capital investment, resulting in significant cost and time savings.” BigQuery lets all kinds of businesses gain real-time insights from massive amounts of data. It’s a pay-per-use service, without the large licensing or support fees typically required by enterprise data warehouses. All data is stored in the cloud, which reduces IT involvement. “We are always looking for ways to maximize return and minimize investment,” DeMeo says. “BigQuery is the perfect combination. It’s an on-demand, scalable resource.”

“We are always looking for ways to maximize return and minimize investment. BigQuery is the perfect combination. It’s an on-demand, scalable resource.” —Giovanni DeMeo, vice president of global marketing and analytics, Interactions Marketing Millions of rows of data Interactions worked closely with Google and software company Tableau while conducting its weather-related shopping project. BigQuery combined with Tableau data-visualization software let the marketing company interactively explore 1.3 billion rows of data, which it received from retailers and the National Oceanic and Atmospheric Administration (NOAA).

About Google BigQuery

Google BigQuery lets businesses and developers gain real-time business insights from massive amounts of data without any up-front hardware or software investments. Accessible via a simple interface, Google BigQuery lets you take advantage of Google’s massive computing power, store as much data as needed, and pay only for what you use. Data is protected with multiple layers of security, replicated across multiple data centers, and can be easily exported. To learn more about Google BigQuery, visit http://cloud.google.com/bigquery

“A similar analysis would have been impossible with traditional methods,” says Markus Dmytrzak, Interactions research and analytics specialist. “Before, every time we set up a business objective, we needed to extract the data, a task that the IT team performed. With BigQuery, we needed to upload the data only once into the cloud. We connect to it, and can create and destroy data sets. It really empowers a business user.” Shoppers’ patterns revealed Interactions launched its weather-data project in the winter of 2012–2013. The company focused on identifying similar storms, classifying them by severity, and measuring their effects on sales before, during, and after their peaks. Using BigQuery and Tableau, the company tracked patterns in sales and shopper behavior. Using a creative and flexible hybrid architecture, Interactions branched data from the underlying Operational Database Systems into BigQuery through an automated extract, transform, load (ETL) process. Weather data was merged with POS data as part of the ETL process. This provided an up-to-date sandbox for analytics projects, with no disruption to daily operations. Connecting Tableau to BigQuery let analysts conduct “create and destroy” analytics, and iterate without burdening IT with constant extraction or query requests.

“With BigQuery, we only need to upload the data once into the cloud. We connect to it, and I can create and destroy data sets. It really empowers me as a business user.” —Markus Dmytrzak, research and analytics specialist, Interactions Marketing A ‘new book’ in every query Interactions determined, for instance, exactly which stocked items saw the sharpest rise or decline in sales, and how shoppers’ behavior varied during similar storms. From millions of lines of data, the company identified 28 product categories with significant increases. Sales in these categories rose from 20 to 261 percent one day before similar storms (including a spike in alcohol sales). Sales then dropped at the storm’s peak and for four days afterward. Interactions saw similar changes in areas where storms were predicted but didn’t actually happen. “There are so many things that we do not know until we ask and the data provides the insight,” DeMeo explains. “That is part of the excitement. It’s like opening up a new book every time we run a query.” In other ways, DeMeo adds, BigQuery more resembles a faucet. “We turn it on and off as we need it. That is incredibly valuable, almost immeasurable. This was not available to us through any other resource that had the capability to provide the same speed with the same quantities of data.”

© 2013 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other company and product names may be trademarks of the respective companies with which they are associated. GCLP-CS-1302

Interactions Marketing Cloud Platform

solutions, the company focused on Google BigQuery. With previous ... Interactions worked closely with Google and software company Tableau while conducting ...

289KB Sizes 1 Downloads 112 Views

Recommend Documents

Untitled Cloud Platform
Page 1. Updated document version now lives in https://developers.google.com/appengine/pdf/HowtofileaGESCsupportcase.pdf.

Gigya Cloud Platform
Gigya enables its customers to integrate social media into their website applications through ... One of Gigya's most popular apps lets customers enhance live.

WebFilings Cloud Platform
The mission is to help companies find new ways to reduce the time, risk, and ... Solution. As the development team worked to create the software they envisioned, ... WebFilings customers say they have filed their quarterly 10-Qs a week earlier.

Certificate Cloud Platform
Apr 15, 2016 - the Information Security Management System as defined and implemented by located in Mountain View, California, United States of America,.

MAG Interactive Cloud Platform
Build Ruzzle for both Android and iOS ... Sell premium Android version through .... Ruzzle saw rapid growth at launch, and is currently handling over 10M.

G Suite Cloud Platform
Barrow Street. Dublin 4. 30 December 2016. Re: Application for a common opinion regarding Google Apps (now G-Suite utilisation of model contract clauses.

SOC 3 Cloud Platform
Jul 29, 2016 - Confidentiality. For the Period 1 May 2015 to 30 April 2016 ... Google Cloud Platform, and Other Google Services System ..... virtual machines on-demand, manage network connectivity using a simple but flexible networking.

D3.3 Cloud Platform v3 - NUBOMEDIA
Apr 5, 2017 - NUBOMEDIA: an elastic PaaS cloud for interactive social multimedia. 2 ..... while the Media Service components are deployed on the IaaS using the NFV layers. ...... defined as Network Service (refer to section 2.3.3 for more details), t

Google Cloud Platform Services
Dec 21, 2017 - Platform, nor have we considered the impact of any security concerns on a specific workflow or piece of software. The assessment ... similar to a traditional file system, including fine-grained access control lists for each object. ...

Google Cloud (updated Jan 2017) Cloud Platform
for web applications) and adhere to .... Google maintains an internal audit program consistent with indusdry best practices and regulatory .... hosting options? X. Google operates a global network of data centers to reduce .... BCR-10 BCR-10.1.