Case Study | Google Analytics Premium

Rooms To Go Improves the Shopper Experience by Integrating Google Analytics Premium With BigQuery

About Rooms To Go

• Google Analytics Premium customer • Home furnishing retailer • www.roomstogo.com

About LunaMetrics

• Google Analytics certified partner • Located in Pittsburgh, Pennsylvania • www.lunametrics.com

Goals

• Understand customers’ online product choices to better tailor customization options on the Rooms To Go website

Approach

• Integrated Google Analytics Premium with BigQuery • Extracted raw, visitor-level data about items purchased online • Performed statistical data mining to find products often purchased together

Results

• Produced actionable insights quickly • Expanded functionality to increase sales of accessory and coordinating products and to improve user experience

Rooms To Go offers the nation’s largest furniture inventory through nearly 150 retail showrooms as well as online. Products are sold as complete room packages—an approach that makes for a simplified shopping experience. Designers coordinate each room’s colors, fabrics and accessories to the last detail so customers don’t have to. Customization counts The Rooms To Go and Rooms To Go Kids websites offer several variations of room packages and add-on options, allowing customers to choose just the products that meet their needs. Due to this variety, Rooms To Go wanted to better understand customers’ online purchase choices to make it easier for them to customize packages. A new view of the data As a Google Analytics Premium customer, Rooms To Go worked with LunaMetrics (a Google Analytics certified partner) to integrate Google Analytics Premium with BigQuery to gain understanding of customers’ online choices. Specifically, BigQuery is designed to help customers in querying massive datasets by enabling super-fast, SQL-like queries—all while using the processing power of Google’s infrastructure. For Rooms To Go, this strategy enabled the extraction of data about items purchased in e-commerce transactions on the site, with the particular goal of discovering which products were often bought together. “BigQuery allowed us to extract and organize large quantities of raw, visitor-level data from Google Analytics to use in this analysis,” says Jonathan Weber, data evangelist at LunaMetrics. Statistical data mining techniques were applied to the data using R, a statistical programming language. Making add-ons easy The analysis—made possible by the Google Analytics Premium and BigQuery integration—produced important findings for Rooms To Go about how customers often combine products in a room. For example, the strategy has allowed Rooms To Go to find common purchase patterns among products. These insights have helped the company offer expanded functionality for customers to add accessory products (such as a nonslip rug pad with a rug) or coordinating pieces (such as extra dining chairs in

© 2014 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.

thinkwithgoogle.com

“Google Analytics Premium provided a statistical data analysis that was beyond our previous limitations. The insights were quickly available and actionable.” — Rob Crigler, VP Digital Marketing, Rooms To Go

a dining room) easily. By making customization smarter and easier, the company expects both increased sales of accessory and coordinating products and a better overall user experience. Rob Crigler, VP of digital marketing at Rooms To Go, shares, “Google Analytics Premium provided a statistical data analysis that was beyond our previous limitations. The insights were quickly available and actionable.” Moving forward, the company is confident these data-driven options will continue to work in concert with the Rooms To Go tradition of giving online customers an easy, convenient way to assemble stylish, coordinating rooms.

About Google Analytics Premium

• Google Analytics Premium is the enterprise-class analytics solution that gives companies rich insights into their digital audiences and marketing effectiveness. With features that are powerful, flexible and easy-to-use, companies large and small can measure engagement to create more effective marketing initiatives, improve user experience and optimize their digital strategies. Sophisticated conversion attribution and experimentation tools help savvy marketers determine the best allocation of media and resources to drive results. • For more information visit: google.com/analytics

© 2014 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.

thinkwithgoogle.com

Rooms To Go Improves the Shopper Experience by ...

datasets by enabling super-fast, SQL-like queries—all while using the processing power of Google's infrastructure. For Rooms To Go, this strategy enabled the extraction of data about items purchased in e-commerce transactions on the site, with the particular goal of discovering which products were often bought together.

356KB Sizes 0 Downloads 279 Views

Recommend Documents

Rooms To Go Improves the Shopper Experience by ...
integration—produced important findings for Rooms To Go about how customers often combine products in a room. For example, the strategy has allowed Rooms To Go to find common purchase patterns among products. ... Google Analytics Premium is the ent

Rooms To Go Improves the Shopper Experience by ...
datasets by enabling super-fast, SQL-like queries—all while using the processing power of Google's ... data using R, a statistical programming language.

Rooms To Go Improves the Shopper Experience by ... .es
The Rooms To Go and Rooms To Go Kids websites offer several variations of ... powerful, flexible and easy-to-use, companies large and small can measure ...

Rooms To Go Improves the Shopper Experience by ...
Specifically, BigQuery is designed to help customers in querying massive datasets by enabling super-fast, SQL-like queries—all while using the processing.

Rooms To Go Improves the Shopper Experience by ...
data from Google Analytics to use in this analysis,” says Jonathan Weber, data evangelist at LunaMetrics. Statistical data mining techniques were applied to the.

Rooms To Go Improves the Shopper Experience by ...
discovering which products were often bought together. “BigQuery allowed us to extract and organize large quantities of raw, visitor-level data from Google Analytics to use in this analysis,” says Jonathan Weber, data evangelist at LunaMetrics. S

Rooms To Go
For Rooms To Go, this strategy enabled the extraction of data about items ... powerful, flexible and easy-to-use, companies large and small can measure ...

Rooms To Go
“BigQuery allowed us to extract and organize large quantities of raw, visitor-level data from Google Analytics to use in this analysis,” says Jonathan Weber, data.

CicekSepeti.com improves user experience and ... Services
narrow results according to their interests. By showing bigger high-quality product images, exposing options rather than using drop-down menus and using prominent call-to-action buttons with contrasting colour improved the user experience on detail p

CicekSepeti.com improves user experience and ... Services
CicekSepeti.com is an ecommerce retailer operating in Turkey. The company delivers flowers, jewellery, gourmet products, toys and other gifts to customers across the country, including same-day deliveries in most metropolitan areas. CicekSepeti.com w

MakeupAlley.com improves user experience, grows ... Services
affiliate programs, and has been using Google AdSense since 2003. Enhancing user experience with a light landing ... of this experiment, the MakeupAlley.com team set up Google Analytics Custom. Variables to track and compare visitor activity, .... a

Go With The Best Brothel In Melbourne To Have Amazing Experience ...
Page 1. Whoops! There was a problem loading this page. Retrying... Whoops! There was a problem loading this page. Retrying... Go With The Best Brothel In Melbourne To Have Amazing Experience.pdf. Go With The Best Brothel In Melbourne To Have Amazing

Multichannel Shopper Segments and Their Covariates (PDF ...
that make shopping more enjoyable, Indeed, this approach views .... nicely with this point of view. That is ...... Profile of the final segments (LCA) (N= 360).

Art Rooms Catalogue.pdf
Page 2 of 42. Foreword. Cockenzie House and Gardens are delighted to welcome the Black Cube. Collective to our historic and charming home. We hope that ...

Elders Real Estate improves client service by ... Services
Each franchise office nominated a champion designated to liaise with head office and assist with the rollout. Broadcast communications to the entire group were supplemented with direct, one-on-one communication through office champions. In tandem, he

Go here to download the PDF packet
Be committed and be consistent. Set a designated time and stick to it. Holding Family Home Evening on a weekly basis takes dedication and planning on the part of all family members. 5. Relax and enjoy it. The most important thing your children will r

have you met the new-car shopper? - Cars.com
and spend more time on-site than used-car .... reviews jump from selling six to nine cars a month to selling 10+.” 10 .... “Social media has been a great way to.

Computer-shopper-April-2014.pdf
Download. Connect more apps... Try one of the apps below to open or edit this item. Computer-shopper-April-2014.pdf. Computer-shopper-April-2014.pdf. Open.

Risk/reward improves for Resi leader; upgrade to ...
Risk/reward improves for Resi leader; upgrade to Neutral. What happened ... to our Sell list on 30 Aug 2013, its share price has declined -2% vs. FSSTI .... Minority interest. 2,365.5. 2,431.9. 2,517.8. 2,629.3. EPS (basic, post-except) (S$). 0.47. 0

pdf-1414\the-underground-shopper-dallas-ft-worth-from-susann ...
pdf-1414\the-underground-shopper-dallas-ft-worth-from-susann-publications.pdf. pdf-1414\the-underground-shopper-dallas-ft-worth-from-susann-publications.

Airbnb improves vendor data collection to 90 ... - Services
and additional tags for an array of vendors measuring different types of conversions. To accommodate the needs of various vendors, many tags had to be replicated several times. At one point, Airbnb was running 88 different audience lists and 100 diff