Wednesday, 30 July 2014

Facilitating Genomics Research with Google Cloud Platform



The understanding of the origin and progression of cancer remains in its infancy. However, due to rapid advances in the ability to accurately read and identify (i.e. sequence) the DNA of cancerous cells, the knowledge in this field is growing rapidly. Several comprehensive sequencing studies have shown that alterations of single base pairs within the DNA, known as Single Nucleotide Variants (SNVs), or duplications, deletions and rearrangements of larger segments of the genome, known as Structural Variations (SVs), are the primary causes of cancer and can influence what drugs will be effective against an individual tumor.

However, one of the major roadblocks hampering progress is the availability of accurate methods for interpreting genome sequence data. Due to the sheer volume of genomics data (the entire genome of just one person produces more than 100 gigabytes of raw data!), the ability to precisely localize a genomic alteration (SNV or SV) and resolve its association with cancer remains a considerable research challenge. Furthermore, preliminary benchmark studies conducted by the International Cancer Genome Consortium (ICGC) and The Cancer Genome Atlas (TCGA) have discovered that different mutation calling software run on the same data can result in detection of different sets of mutations. Clearly, optimization and standardization of mutation detection methods is a prerequisite for realizing personalized medicine applications based on a patient’s own genome.

The ICGC and TCGA are working to address this issue through an open community-based collaborative competition, run in conjunction with leading research institutions: the Ontario Institute for Cancer Research, University of California Santa Cruz, Sage Bionetworks, IBM-DREAM, and Oregon Health and Sciences University. Together, they are running the DREAM Somatic Mutation Calling Challenge, in which researchers from across the world “compete” to find the most accurate SNV and SV detection algorithms. By creating a living benchmark for mutation detection, the DREAM Challenge aims to improve standard methods for identifying cancer-associated mutations and rearrangements in tumor and normal samples from whole-genome sequencing data.

Given Google’s recent partnership with the Global Alliance for Genomics and Health, we are excited to provide cloud computing resources on Google Cloud Platform for competitors in the DREAM Challenge, enabling scientists who do not have ready access to large local computer clusters to participate with open access to contest data as well as credits that can be used for Google Compute Engine virtual machines. By leveraging the power of cloud technologies for genomics computing, contestants have access to powerful computational resources and a platform that allows the sharing of data. We hope to democratize research, foster the open access of data, and spur collaboration.

In addition to the core Google Cloud Platform infrastructure, the Google Genomics team has implemented a simple web-based API to store, process, explore, and share genomic data at scale. We have made the Challenge datasets available through the Google Genomics API. The challenge includes both simulated tumor data for which the correct answers are known and real tumor data for which the correct answers are not known.
Genomics API Browser showing a particular cancer variant position (highlighted) in dataset in silico #1 that was missed by many challenge participants.
Although submissions for the simulated data can be scored immediately, the winners on the real tumor data will not immediately be known when the challenge closes. This is a consequence of the fact that current DNA sequencing technology does not provide 100% accurate data, which adds to the complexity of the problem these algorithms are attempting to tackle. Therefore, to identify the winners, researchers must turn to alternative laboratory technologies to verify if a particular mutation that was found in sequencing data is actually (or likely) to be true. As such, additional data will be collected after the Challenge is complete in order to determine the winner. The organizers will re-sequence DNA from the cells of the real tumor using an independent sequencing technology (Ion Torrent), specifically examining regions overlapping the positions of the cancer mutations submitted by the contest participants.

As an analogy, a "scratched magnifying glass" is used to examine the genome the first time around. The second time around, a "stronger magnifying glass with scratches in different places" is used to look at the specific locations in the genome reported by the challenge participants. By combining the data collected by those two different "magnifying glasses", and then comparing that against the cancer mutations submitted by the contest participants, the winner will then be determined.

We believe we are at the beginning of a transformation in medicine and basic research, driven by advances in genome sequencing and computing at scale. With the DREAM Challenge, we are all excited to be part of bringing researchers around the world to focus on this particular cancer research problem. To learn more about how to participate in the challenge register here.

Thursday, 24 July 2014

Focus Areas for Policy & Standards Research Proposals



Twice a year, Google’s Faculty Research Awards program seeks and reviews proposals in 23 research areas, assigning to each area a group of experienced Googlers who assess and deliberate over which proposals we should and can fund. With each call for proposals, we receive a wide array of research ideas in fields that fall within the realm of Internet policy.

We would like to share with you the areas of Internet policy in which we are particularly interested to see progress and stimulate further research:
  • Accessibility: Google is committed to supporting research that generates insights about what helps make technology a usable reality for everyone, regardless of cognitive, physical, sensory, or other form of impairment.
  • Access: What policies help bring open, robust, competitive and affordable Internet access to everyone in the world? What are the economic and social impacts of improved Internet access? In particular, what are the emerging impacts of gigabit access networks?
  • Intellectual property (IP) in the digital era: The growth of digital industries has meant that IP law is an increasingly important policy tool governing innovation and economic growth. We would like to better understand how IP legislation can enable new technologies, and what effect different national or regional IP regimes have on innovation, such as the effect of patent litigation on invention, and how copyright exceptions affect the creation of online technologies.
  • Freedom of Expression: As an advocate of freedom of expression on the Internet, Google is interested in research that produces insights into how discourse and expression in the global online (public) sphere happens, and how stakeholders best allow freedom of expression, balance it with other rights and resolve conflicts or interest/disputes.
  • Internet Governance: The Internet is a universal space that many expect to remain open, free, and borderless. Multiple stakeholders (internet companies, governments and civil society) work together to design the governance practices and institutions to maintain order and innovation in the global Internet ecosystem. We are interested in supporting top researchers who analyze and contribute insights into which practices and institutional structures work and which don’t.
  • Open Standards and Interoperability: Open Standards and interoperability of services are at the core of the Internet’s successful international propagation and usefulness. Google is interested in research that contributes analysis and best practices for standardization and interoperability. Among them we see resource management, access control and authorities for the Internet of Things, as well as questions regarding convergence and security. Also, cloud computing and storage could benefit from open standards that enable interoperability.
Additionally, there are several important research areas like Privacy, Economics and market algorithms, and Security, which have a significant policy component but are dealt with as research topics distinct from policy & standards.

Researchers who are interested in applying for a Faculty Research Award can do so twice a year following the instructions laid out on the Google Faculty Research Awards website. Additional information about Internet Policy research support from Google, including the Google Policy Fellowship program, can be found in the recent post on the Google Europe Blog.

We look forward to your proposals.

Wednesday, 23 July 2014

U.S. Cellular reveals true impact of digital media on sales with Google Analytics Premium

With 10.6 million cell phone customers and retail stores in 400+ markets, U.S. Cellular needs to reach a lot of people with marketing messages. That's why U.S. Cellular uses many marketing channels -- online, in-store and telesales -- to drive mobile phone activations.


U.S. Cellular was challenged though. They didn’t know how many of their offline sales were driven by their digital marketing. This made it harder to adjust their media mix accordingly and also to forecast sales. To fix that situation, U.S. Cellular and its digital-analytics firm, Cardinal Path, turned to Google Analytics Premium and its integration with BigQuery

Part of Google Cloud Platform, BigQuery allows for highly flexible analysis of large datasets. The U.S. Cellular team used it to integrate and analyze terabytes of data from Google Analytics Premium and other systems. Then they mapped consumer behavior across online and offline marketing channels. Each transaction was attributed to the consumer touchpoints that the buyer had made across various sales channels. 

The result: U.S. Cellular got real insight into digital’s role in their sales. They were surprised to find that they could reclassify nearly half of all their offline activations to online marketing channels.

U.S. Cellular now uses this complete (and fully automatic) analytics framework to really see the consumer journey and forecast sales for each channel. Their team has the data they need to make better business decisions. 

“We’re now in the enviable position of having an accurate view at each stage of our customer journey," says Katie Birmingham, a digital & e-commerce analyst for the company. "The Google Analytics Premium solution not only gives us a business advantage, but helps us shape a great customer experience, and ultimately ties in to our values of industry-leading innovation and world-class customer service.”


Posted by: Suzanne Mumford, Google Analytics Premium Marketing

Tuesday, 22 July 2014

Academics and the Little Box Challenge




Think shrink! Min it to win it! Smaller is baller! That's what the Little Box Challenge is all about: developing a high power density inverter. It’s a competition presented by Google and the Institute of Electrical and Electronics Engineers Power Electronics Society (IEEE PELS) -- not only a grand engineering challenge, but your chance to make a big impact on the future of renewables and electricity.

With the rise of solar photovoltaic panels, electric vehicles (EV) and large format batteries, we’ve seen a resurgence in the over-a-century-long feud between Thomas Edison’s direct current (DC) and Nikola Tesla’s alternating current (AC). The electric grid and most higher power household and commercial devices use AC; batteries, photovoltaics, and electric vehicles work in DC. So the power electronics that convert between the two -- rectifiers (AC->DC), and inverters (DC->AC) -- are also gaining increased prominence, as well as the DC/DC and AC/AC converters that switch between different voltages or frequencies.

While different flavors of these devices have been around for well over a century, some of them are starting to show their age and limitations versus newer technologies. For example, conventional string inverters have power densities around 0.5-3 Watts/Inch3, and microinverters around 5 Watts/Inch3 -- but lithium ion batteries can now get 4-10 Watt Hours/Inch3. So for a 1-2 hour battery pack, your inverter could end up being bigger than your battery -- a lot to carry around.

Some recent advances may change what’s possible in power electronics. For example, Wide-bandgap (WBG) semiconductors -- such as gallium-nitride (GaN) and silicon-carbide (SiC) -- not only enable higher power densities than conventional silicon-based devices do, but can also convert between DC and AC at higher temperatures, using higher switching frequencies, and with greater efficiency.

But even WBG materials and other new technologies for power electronics run into limits on the power density of inverters. Photovoltaic power and batteries suffer when they see oscillations on their power output and thus require some form of energy storage -- electrolytic capacitors store that energy and bridge the power differential between the DC input and the AC output, but that makes the devices much larger. Household and consumer devices also need to add filters to prevent electromagnetic interference, so that’s even more bulk.

When it comes to shrinking these devices, inverters may have the most potential. And because inverters are so common in household applications, we hope The Little Box Challenge may lead to improvements not only in power density, but also in reliability, efficiency, safety, and cost. Furthermore, it is our hope that some of these advances can also improve the other types of power electronics listed above. If these devices can be made very small, reliable and inexpensive, we could see all kinds of useful applications to the electric grid, consumer devices and beyond, maybe including some we have yet to imagine.

To recognize the role academics have played in pushing the forefront of new technologies, Google has taken a couple of special steps to help them participate:

  • Research at Google will provide unrestricted gifts to to academics pursuing the prize. This funding can be used for research equipment and to support students. Visit the Little Box Challenge awards for academics page for more info -- proposals are due September 30, 2014.
  • Academics often have trouble getting the latest technology from device manufacturers to tinker on. So Google has reached out to a number of WBG manufacturers who’ve put up dedicated pages detailing their devices. Check out the Little Box Challenge site to get started.

We hope you’ll consider entering, and please tell your colleagues, professors, students and dreamers -- you can print and post these posters on your campus to spread the word.

Tuesday, 15 July 2014

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

Rooms To Go, a home furnishing retailer, simplifies the shopping experience by offering completely designed room packages. When the company wanted to better understand how its customers purchase its different furniture and decor variations and add-ons to streamline online customization options, it turned to its agency -  LunaMetrics - who integrated Google Analytics Premium and BigQuery. This approach helped to identify which items customers commonly buy together, leading to smarter and easier customization for its users.

The Google Analytics Premium integration allowed Rooms To Go to:
  • Better understand what their site visitors were purchasing
  • Organize the data and isolate the products that were frequently purchased together in order to discover customer buying patterns
  • Expand functionalities of the website to accommodate these customer patterns—for example, making it easier for users to add extra dining chairs when purchasing a dining room set

Overall, this strategy helped Rooms To Go create a better user experience for its customers, and the company expects an increase in sales because of it. Read the full case study on Think with Google, and learn about being a Google Analytics Premium customer here.

Monday, 14 July 2014

Simple is better - Making your web forms easy to use pays off




Imagine yourself filling out a long and cumbersome form on a website to register for a service. After several minutes of filling out fields, coming up with a password, and handling captchas, you click the submit button to encounter your form filled with red error messages. Suddenly the “close tab” button seems much more tempting than before.

Despite the rapid evolution of the Internet, web forms, with their limited and unilateral way of interaction, remain one of the core barriers between users and website owners. Any kind of obstacle or difficulty in filling in online forms can lead to increased frustration by the user, resulting in drop-outs and information loss.

In 2010, a set of 20 guidelines to optimize web forms was published by researchers from the University of Basel in Switzerland, including best practices aimed to improve web forms and reduce frustration, errors and drop-outs. For instance, guideline no. 13 states that if answers are required in a specific format, the imposed rule should communicated in advance; or no. 15 that states that forms should never clear already completed fields after an error occurs.

To investigate the impact of applying these rules, we conducted a study and presented our results at CHI 2014Designing usable web forms: empirical evaluation of web form improvement guidelines. In the study, we examined a sample of high traffic online forms and rated them based on how well they followed the form guidelines outlined by the 2010 publication. We then selected three different online forms of varying qualities (low, medium and high), and improved them by applying the guidelines, with the high quality form needing less modification than the medium and low quality forms. We then tested both the original and improved forms extensively with 65 participants in a controlled lab environment.

In our study, the modified forms showed significant improvements over the original forms in the time users needed to complete a form, an increase in successful first-trial submissions and higher user satisfaction. As expected, the impact was highest when the original form was of low quality, but even high quality forms showed improved metrics.

Furthermore, user interviews with participants in the study revealed which guidelines were most impactful in improving the forms:

  • Format specifications (e.g., requiring a minimum password length) should be stated in the form, prior to submission. The application of this guideline had a large positive impact on user performance, subjective user ratings and was also mentioned frequently in user interviews.
  • Error messages must be placed next to the erroneous field and designed in a way users are easily able to fix the problem. Doing this reduced form-filling time and increased subjective ratings.
  • Most frequently users mentioned that it was key to be able to tell apart optional and mandatory fields.

Example Guideline: State format specification in advance
 Example Guideline :Place error message next to erroneous fields
Example Guideline: Distinguish optional and mandatory fields
Putting field labels above rather than adjacent to the fields in the form led also to improvements in the way users scanned the form. Using eye-tracking technology, our study shows that users needed less number of fixations, less fixation time and fewer saccades before submitting the form for the first time.


Figure 4.png
Scan path for an original and improved form
From our study, we conclude that optimizing online forms is well worth the resource investment. With easy to implement actions, you can improve your forms, increase the number of successful transactions, and end up with more satisfied users. Google is currently working on implementing these findings on our own forms.

We wish to thank our co-authors at the University of Basel, Switzerland for their collaboration in this work: Silvia Heinz, Klaus Opwis and Alexandre Tuch.

Wednesday, 2 July 2014

The Real Meaning of the Fire Phone

People have been asking my opinion of the new Amazon Fire Phone, but I’ve had a lot of trouble answering. My first reaction was overwhelmingly blah. I’ll be curious to try it, and maybe then I’ll feel better about it. But right now it seems to me like a bag of interesting features rather than a coherent product. (Quick, what do faux 3D imaging and a year of free mail order shipping have in common? Absolutely nothing.) Plus it’s available from only one mobile operator, and the pricing isn’t low enough to get anyone excited. I’m delighted anytime a major company tries to innovate, but I can’t imagine this phone having a huge impact on the market.

Many others are neutral to downright hostile. BGR wrote, “Amazon innovated in all the wrong places.” (link). And CNN said, “if you're happy with your iPhone 5s or Galaxy S5, there's no compelling reason to change” (link).

So why did Amazon build this product?  Ben Thompson made a good case that the phone is designed to strengthen Amazon’s relationship with its lucrative Prime customers (link). I’m sure that’s part of the motivation. But if that’s the only goal, wouldn’t you price the phone very low to grab more customers, the way you did Kindle? And as Ben himself noted, there are many other things you could do to more directly recruit Prime customers. For example, many of the Fire Phone apps could have been released separately for Android and iOS. Wouldn’t that be a better way to serve Prime customers? Rather than trying to rip people away from their iPhones and Galaxies, why not just co-opt them through some apps that run on their current phones? What Amazon’s doing is like selling your own line of sofas as a way to distribute slipcovers.

And so I go back to wondering why Amazon did it. Imagine you’re Jeff Bezos. You have a fairly stable relationship with Apple and many other phone companies at the moment; why turn yourself into their blood enemy for a product that that won’t move the needle in sales?

To me, the Fire Phone reeks of experiment. I think Amazon’s testing something, and the experiment is important enough to spend a ton of money and create a lot of competitive hostility. After thinking about it a lot and trying to look at the world through Amazon’s eyes, I think I can guess why the Fire Phone would be strategically important to Amazon. I believe it’s not about the phone market; it’s about the evolution of mobile commerce and the future of Amazon itself.

To explain why, I have to give a bit of background on mobile commerce. For online retailers, the single most frustrating thing about mobile technology, especially smartphones, is that it people using it don’t buy a lot of stuff. They’ll browse in your web store and use your shopping app, but when it comes time to buy they often don’t purchase. The industry rule of thumb is that a good commerce site on a personal computer will convert about 3% of shoppers to buyers (in other words, for every 100 online shoppers you make three sales). The conversion rate for smartphones is a third of that, about 1%.

In an industry that would kill to improve conversion by a tenth of a point, that drop from 3% to 1% is horrifying. Many commerce companies have spent years trying to fix it, and through incredible effort and careful experimentation it is indeed possible to increase the mobile conversion rate. In my day job at UserTesting that’s one of the things I help companies do. But it’s a slow process of incremental fixes, and in the meantime mobile web use is growing explosively. Here’s the nightmare scenario for an online retailer:

—What if the next generation of internet users moves to smartphones and wearables faster than we can figure out how to fix mobile shopping?

—What if, as people move to mobile, the conversion rate for our whole business drops from 3% to 1%?

—And most disturbing for a category leader like Amazon, what if the low conversion rate on mobile is a sign that the online store itself is not a good fit for smartphones? What if some new mobile technology or app makes online shopping obsolete, just as online stores have been making traditional retail stores obsolete? What if Amazon itself is the next big tech dinosaur?

Don’t laugh. Platform transitions in tech usually make the old category leaders obsolete. Read about Lotus Development or Digital Equipment Corporation if you don’t believe it.

That existential threat is the kind of thing I’d expect Jeff Bezos to worry about. It’s a huge change that comes from an unexpected direction and could cut the heart out of his business. What’s worse, by the time the threat becomes obvious it’ll probably be too late to respond to it.

So the time to act is now. Amazon needs to dive into mobile and figure out what the shopping experience would look like if you built it into a phone from the ground up.

If that’s Amazon’s motivation, then the Fire Phone is really all about Firefly, Amazon’s instant-buying technology. I think the question being tested is whether you can completely replace a web store with a properly configured phone. What if, instead of going to an online store to buy something, your phone itself became the store? What if, instead of searching for the thing you want to buy, you could just take a picture of it, or scan its barcode, or say its name? 

Amazon everywhere. Futurist Paul Saffo put it this way: “Firefly allows Amazon to invade every store in every mall on the planet and turn it into a de facto showroom for Amazon” (link). I’d go even further. I’d say Firefly is an effort to turn the entire world into an Amazon store.

If Amazon makes that phone first, it takes another big chunk out of Walmart and Target and eBay and every other retailer out there, physical or virtual. If someone else makes it first, Amazon itself is in mortal danger.

I think that’s why Amazon had to make a phone. It needs to test and tune the integration of mobile hardware and software in the purchasing process, and that would not be possible on someone else’s phone. It also doesn’t want to share the data it’ll collect with any other phone vendor (especially not one allied with Google), since that could be the key to the future of the whole company. 

From this perspective, the rest of the Fire Phone announcement makes more sense. You need to toss in a few sexy features, like the semi-3D screen, to attract some users. The price doesn’t have to be low because Amazon doesn’t want to sell a gazillion phones. One carrier in one country is enough because Amazon’s not pushing for world domination yet. It needs just enough users to give it a robust experimental base. Then it’ll observe, and it’ll learn, and it’ll tweak the experiment, and it’ll learn some more.

And then, when it gets the formula right, we’ll see the real Amazon phone. I’d expect it to be more aggressively priced and much more broadly available. I wouldn’t be surprised to see Amazon also release Firefly apps for other phones at the same time. By that point Amazon’s priority won’t be secrecy, it’ll be rapid domination.

Or maybe the experiment will fail. Maybe Amazon will learn that there is no magic way to turn a smartphone into a store. In that case it’ll quietly make the phone disappear, write off the losses, and move on to other priorities. Hey, it’s just money, and we all know how Jeff Bezos feels about that.


What it means for the rest of us

Do you remember back when Google was just getting started in smartphones, and there was widespread speculation that Google would give away a phone with free wireless service? The idea was that the things Google would learn from the user were worth more than the cost of a phone service plan. That idea faded away as Google focused on co-opting rather than destroying the mobile industry, and as it realized that it couldn’t make enough money from phone users to pay for the service.

It might be time to revisit that scenario. If anyone can figure out how to make a free phone pay for itself, it would probably be Amazon. Even if it can’t give away a phone for free, it might be able to offer steep discounts, putting the rest of the phone industry at a huge disadvantage. If you’re Google or Apple, you don’t have the sort of retail back end that Amazon does, so you can’t directly match that strategy (although Google might try). A better option is to team up with the other companies threatened by Firefly. Perhaps you create a Firefly-equivalent app and open it to connectivity with anyone else’s online store in exchange for some sort of revenue sharing.

That approach requires heavy skills in alliance building. Apple might be able to pull it off, but they tend to work exclusively with a small number of subservient partners. Google could try for a broad alliance -- it likes to do everything big -- but I doubt it has the focus and consistency to create a lasting partnership of equals with large numbers of companies. (In that vein, it’s meaningful that Google started on a path similar to Firefly back in 2010 with Google Goggles, but killed the product a few weeks before the Fire Phone announcement because it was “a fun feature, but also a feature of no clear use to too many people” link).

So Amazon’s potential strategy plays to the weaknesses of its biggest competitors.

I wonder if Apple might be willing to build a long-term partnership with Amazon, instead of competing against it. In addition to cooperating on mobile commerce, Amazon could help Apple with its portfolio of online services, a constant weakness of the company. Steve Jobs would not have done it; I think Tim Cook might.

If you’re an e-commerce company, you should investigate the Firefly APIs. It looks like you can plug into the Firefly system to make your own offers when a user scans an object. You’ll still need to convince users to install your plugin, but at least this will give you options. Besides, you need to learn how this new shopping paradigm works.

If you’re a bricks-and-mortar retailer, I think you shouldn’t waste time worrying about people using your store as a showroom for Amazon. You can’t stop that anyway. Instead, look at how you can enhance the shopping experience by embracing smartphones. To give one example, what if every product in your store had a QR code that took a smartphone user to your page for that product, with additional information, FAQs, and special offers? I’d love to have that in one of the box box retail stores where you can never find a sales rep. You’d enhance the shopping experience and maybe intercept shoppers before they turn to Amazon. Plus you’d get data on what people actually do inside your store.

I’m kind of surprised that Apple and Google haven’t already built a QR scanning app into their mobile platforms. It’d be a logical way to partner with retailers and get leverage against Amazon.

If you’re another mobile phone vendor, such as Samsung, you should talk with Amazon about integrating Firefly into your phones in exchange for a cut of the revenue. Better to embrace the company now than to risk competing against a heavily-subsidized Amazon phone in the future.

And for anybody who deals with mobile, the Fire Phone is a reminder that we’re just getting started. Although we talk of smartphones as a maturing market, we’re barely beginning to learn how mobile devices will change our lives. We stand in the foothills of the Himalayas. The biggest mobile opportunities, and the biggest disruptions to today’s businesses, are still ahead of us.

http://www.gettyimages.com/detail/187768233

Tuesday, 1 July 2014

Analytics Pros helps Avvo Gain New Insights with Data Import

Companies use many systems to run their business. These may include multiple web advertising networks, CRM and content publishing systems, point of sale systems, inventory databases, etc. Integrating the data from these systems with Google Analytics provides a better understanding for how your customers behave on the web. 

At the 2014 Analytics Summit we announced the new Data Import. Data Import helps unify data from your different business systems, allowing you to organize your data the same way your business is organized. This will allow for more accurate analysis and bringing together previously disparate datasets into one complete picture. Using Data Import, you can upload your brand’s existing data into Google Analytics and join it with GA data for reporting, segmentation and remarketing.

By using the Data Import functionality in Google Analytics Premium and with the help of Analytics Pros, consumer legal services brand Avvo created clear, accurate data, which continues to impact decisions across their organization. While Avvo already had a successful and fast-growing business, the lack of visibility into advertising success made it hard to align key revenue opportunities with actual site usage. Read the full case study here.


“We’ve been very pleased with the results that were realized using Data Import in Google Analytics to analyze client behavior on our website. This exercise has given us better insight into valuable data that will ultimately impact how we segment the market for legal services.” 
- Sendi Widjaja, Co-Founder & CTO, Avvo, Inc.

Data Import also now supports a new Query Time mode that allows you to join your data with historical GA data. With this mode you can:
  • Enhance existing, already processed GA data with imported dimensions and metrics.
  • Upload calculated values after a transaction occurs, like total customer spend, last transaction date, or a loyalty score.
  • Correct any errors in data you have uploaded to GA in the past.
Query Time mode is currently in whitelist release for Premium users. For more information, contact your Premium account manager. You can learn more about Premium here.

Illustration of a new Google Analytics report with data from multiple sources 

We are also introducing a new version of Cost Data import that provides more versatile support for importing historical data. Additionally, cost data  can now be uploaded directly  through the Google Analytics web interface (previously, data import  required using the GA API). Note: Users of the original cost data import  must migrate to the new version. Details can be found in the cost data migration guide.

How to get started using Data Import
For more information, read Data Import on the Google Analytics Help Center. Also check our new developer Data Import guides that will get you up and running in no time. Some features are currently not rolled out to all users. If you’d like to join the beta for full-access, sign-up here.

Posted by Nick Mihailovski, Jieyan Fan, Richard Maher, Rick Elliott and the Google Analytics Team