Now playing: Apps Script for Google Docs

The Google Apps team here in New York City is a hotbed of movie fanatics. But while planning a recent movie night, we realized we spend too much time organizing our events and not enough time discussing, debating and watching movies.

To take the hard work out of planning, we turned to Google Apps Script, which lets you write short programs that automatically perform simple actions within a spreadsheet. For example, our Movie Night script figures out which movies are playing close by and invites everyone to vote on what they’d most like to see.


Google Apps Script has been available to Google Apps customers since January, and today we’re excited to bring it to everyone who uses Google spreadsheets. Apps Script can be helpful for all kinds of things, from customized party invites to sending out holiday letters — in fact Apps Script can be especially helpful for those repetitive, time consuming tasks.

To help you find useful scripts, we’ve also launched a public gallery where you can check out our Movie Night script and browse other available scripts. If you’re feeling adventurous, try your hand at writing your own script and submit it to the gallery for others to use. To see the gallery or install a script in your spreadsheet, click on “Insert” and select “Script.”

Check out the Google Docs blog for more information about Apps Script, and to learn about writing your own scripts, visit the Google Apps Developer Blog.

Posted by Evin Levey, Product Manager, Google Apps

Finding awesome stuff online with Google Reader Play

I use Google Reader a lot — not only to stay on top of the news, but also to find interesting blog posts and articles. I’m always telling my friends about Google Reader, and while some of them love it, others don’t want to take the time to set it up. For those of you who fall into this second category, we’re announcing Google Reader Play, a new product that makes the best stuff in Reader more accessible for everyone. Reader Play is a new way to browse interesting stuff on the web, customized to the topics you’re interested in, with no setup required.


Items in Reader Play are presented one at a time, and images and videos are automatically enlarged to maximize the viewing experience. We use the technology behind Recommended Items in Reader to populate Reader Play with the most interesting content on the web. While you don’t need a Google account to use Reader Play, your experience will be personalized if you sign in. As you browse, you can let us know which items you enjoy by clicking the "like" button, and we'll use that info to show you other content we think you’ll enjoy.

We think Reader Play is a fun way to browse interesting items online that you wouldn’t find otherwise. We designed it especially for people who don’t want to spend time curating their own set of feeds — but folks who already use Reader can easily use it to read their feeds as well. Just click the feed settings menu on any feed in Reader and select “View in Reader Play.” We’re launching Reader Play as an experiment in Google Labs so that we can test it out, get feedback from you and then improve it as quickly as possible. Visit google.com/reader/play to give it a try, and let us know what you think!

Posted by Garrett Wu, Software Engineer

The Internet in America: A YouTube Interview with the FCC

If you're reading this, then you're probably on the Internet — via your laptop, your mobile phone or other handheld device, or maybe even through your television. But in 2010, millions of Americans still do not have access to the wealth of information made available on the Web. Even though the Internet was invented in the U.S. over 20 years ago, many Americans lag behind in both access to the Internet and speed of connections, which is why the Federal Communications Commission (or the FCC, the federal agency that oversees the U.S. communications industry) is launching its much-anticipated National Broadband Plan next Tuesday, to lay out its strategy for connecting all Americans to fast, affordable high-speed Internet.

After this plan is announced, you have the opportunity to interview FCC Chairman Julius Genachowski, in the second of a series of in-person YouTube interviews with government leaders. (Our first, with U.S. President Barack Obama, took place last month.) Go to CitizenTube today to submit your video or text question via Google Moderator, and vote on your favorites; we'll bring a selection of the top-voted questions to Chairman Genachowski in our interview next Tuesday, March 16. The deadline for submission is Sunday night, March 14, at 11:59 p.m. PT.

To help structure our conversation with the Chairman, we've broken the interview down into seven topics. To learn more about what the FCC is doing in each area, click on the links for each topic below. Then submit your question on CitizenTube under one of the topic headings.

• Access and Affordability
• Mobile and Wireless
• Security and Privacy
• Digital Economy
• Internet in Schools
• Open Internet/Network Neutrality
• Others (learn more at Broadband.gov)

Access to the Internet has transformed almost every aspect of our economy and society. This is your chance to press the FCC on how the National Broadband Plan will work, and ask your questions about improving the Internet in America. We're looking forward to seeing your questions and hearing what the Chairman has to say.

Posted by Steve Grove, Head of News and Politics, YouTube

YouTube calling: Now serving ads on the YouTube mobile site

(Cross-posted with the YouTube Biz Blog)

Mobile phones are rapidly becoming essential tools for surfing the web, connecting with friends, and sharing and watching video online, and we're seeing these effects at YouTube. The YouTube mobile site is more popular than ever: site traffic grew by over 160% in 2009, and now millions of people all over the world are streaming tens of millions of videos every day on their mobile phones. The mobile space moves fast, so we've been working hard to roll out new features and functionality quickly, especially as more and more people adopt YouTube-capable phones.

The increased usage of high-end devices like the iPhone and Android is also making mobile advertising easier and more effective for advertisers. So today, we're launching ads on the home, search and browse pages of the American and Japanese YouTube mobile websites (m.youtube.com from your mobile browser). This is a great way for advertisers to reach YouTube viewers across multiple platforms. In fact, at launch YouTube will immediately provide one of the largest audiences for a mobile ad campaign anywhere on the mobile web. And because YouTube mobile attracts early adopters, the site can deliver to advertisers a coveted demographic of tech savvy trendsetters. We've already seen some early campaigns run on YouTube's mobile site by advertisers like Sony (for the DVD release of "District 9") and Kia, both of whom were able to easily reach their target audience, no matter where they were looking for video.



Our first tests of YouTube mobile ads — with brands ranging from L'Oreal to Land Rover — showed strong results related to click-throughs, user experience and brand awareness, and we've learned a lot in the months since then. As a result, ads on the YouTube mobile website will be banner ads sold on a full-day basis (like with the YouTube homepage on the web), making a mobile buy an easy and valuable addition to any YouTube campaign. For example, today Mazda is running a homepage ad on YouTube.com, and extended their campaign to run ads on our mobile site as well.

If you're interested in learning more, reach out to your YouTube or Google sales rep, or visit youtube.com/advertise.

Posted by Taylor Cascino, Strategic Partner Development Manager

Biking directions added to Google Maps

Whenever I meet someone who finds out that I work on the directions team for Google Maps, the first question I'm asked is often "So when's Google Maps going to add biking directions?" We're big biking fans too, so we've been itching to give you a concrete answer. I don't want to keep the good news a secret any longer, so the answer is: right now!

Today we've added biking directions and extensive bike trail data to Google Maps for the U.S. My team has been keeping close tabs on all the public support for biking directions that’s been steadily coming in, but we knew that when we added the feature, we wanted to do it right: we wanted to include as much bike trail data as possible, provide efficient routes, allow riders to customize their trip, make use of bike lanes, calculate rider-friendly routes that avoid big hills and customize the look of the map for cycling to encourage folks to hop on their bikes. So that's exactly what we've done.

Let's say you want to bike to work, or maybe you want to drive less and spend more time outdoors. Biking directions can help you find a convenient and efficient route that makes use of dedicated bike trails or lanes and avoids hills whenever possible. To find biking directions, select "Bicycling" from the drop-down menu when you do a directions search:


So, how does it work? Well, I'm based in Seattle, along with the rest of the biking directions team. The city is notoriously hilly, but also has some great trails and a strong cycling community. Let's say I'm trying to get from Golden Gardens to a friend's house in Montlake:


This route avoids hills (phew!) and puts me on the Burke-Gilman trail for most of the journey. When I need to get off the trail to cross town, biking directions makes sure to keep me on bike-friendly roads and avoid some of the city's busiest intersections. The time estimate for the route is based on a complex set of variables accounting for the type of road, terrain and turns over the course of my ride. If I decide that I want to stop at Woodland Park Zoo along the way, I can click on the blue path and drag it to my desired route — just like with driving directions — and we'll still customize the journey for cycling suitability. Over on the Lat Long Blog, you can read more about all the unique tweaks and calculations factored into our routing algorithm.

We've also added information about bike trails, lanes and recommended roads directly onto the map. This can help you get a better sense of your route, or let you find trails nearby for a recreational ride. When you're zoomed into a city, click on the "More" button at the top of the map to turn on the "Bicycling” layer. You'll see three types of lines appear on the map:

• Dark green indicates a dedicated bike-only trail;
• Light green indicates a dedicated bike lane along a road;
• Dashed green indicates roads that are designated as preferred for bicycling, but without dedicated lanes

Thanks primarily to our partnership with the Rails-to-Trails Conservancy, we now have more than 12,000 miles of trails included in biking directions and outlined directly on the map. We also have data on bike lanes and recommended streets for 150 cities across the country. We'll continue to add new trail information and encourage riders to send feedback (biking directions is in beta, after all) and route information for inclusion via the “Report a Problem” tool. When Map Maker is available in the U.S., all riders will be able to directly contribute their local knowledge about trails, bike lanes and suggested routes.

We know that many of you have been anxiously awaiting this feature, so head over to http://maps.google.com/biking to try it for yourself and then hop on your bike!

Posted by Shannon Guymon, Product Manager

A digital renaissance: partnering with the Italian Ministry of Cultural Heritage

The Renaissance, Europe's period of cultural, political and scientific rebirth, began in Florence around 600 years ago. At Google we're interested in a (small “r”) renaissance of a different kind — a digital one. Since the launch of Google Books, we’ve been working with libraries and publishers around the globe to bring more of the world's books to more readers around the globe. Any school child should be able to access the works of Petrarch, Dante or Vico (or, if they're so inclined, Machiavelli). In the case of these more famous authors, this is already largely possible, but what about the work of Guglielmo il Giuggiola or Coluccio Salutati? We want all of the great literature and writings of Italy to be accessible to the general public.

Today we’re announcing an agreement with the Italian Ministry of Cultural Heritage that will push this vision forward. Working with the National Libraries of Florence and Rome, we’ll digitize up to a million out-of-copyright works. The libraries will select the works to be digitized from their collections, which include a wealth of rare historical books, including scientific works, literature from the period of the founding of Italy and the works of Italy's most famous poets and writers. It marks the first time we’ve ever joined forces with Italian libraries, and the first time we've worked with a ministry of culture.

Around Europe and the rest of the world, we are effectively witnessing a digital renaissance, with an increasing number of organizations running ambitious and promising book digitization projects. We're not the only ones who have seen the need to bring the world's books into digital form. Digitization of books is a tremendous undertaking, requiring the joint effort of a great number of public and private stakeholders. For this reason, we’re supportive of many other efforts at digitization, such as the European Commission's Europeana. We want to see these books have the broadest reach possible — the books we scan are available for inclusion in Europeana, of which the Florence Library is a contributing member, and other digital libraries. The more of the world's historical, cultural treasures we can bring online, the more we can unlock our shared heritage.

We believe today’s announcement is an important step, and we look forward to working with more libraries and other partners. We envision a future in which people will be able to search and access the world's books anywhere, anytime. After all, Antonio Beccadelli and Anastasius Germonius — like Shakespeare and Cervantes — are part of our human cultural history.

Posted by Gino Mattiuzzo, Strategic Partner Development Manager, Italy

Open for business: the Google Apps Marketplace

Every day, thousands of businesses choose the cloud. More than 2 million businesses have adopted Google Apps over the last three years, eliminating the hassles associated with purchasing, installing and maintaining hardware and software themselves.

We've found that when businesses begin to experience the benefits of cloud computing, they want more. We're often asked when we'll offer a wider variety of business applications — from accounting and project management to travel planning and human resources management. But we certainly can't and won't do it all, and there are hundreds of business applications for which we have no particular expertise.

In recent years, many talented software providers have embraced the cloud and delivered a diverse set of features capable of powering almost any business. But too often, customers who adopt applications from multiple vendors end up with a fractured experience, where each particular application exists in its own silo. Users are often forced to create and remember multiple passwords, cut and paste data between applications, and jump between multiple interfaces just to complete a simple task.

Today, we're making it easier for these users and software providers to do business in the cloud with a new online store for integrated business applications. The Google Apps Marketplace allows Google Apps customers to easily discover, deploy and manage cloud applications that integrate with Google Apps. More than 50 companies are now selling applications across a range of businesses, including:

Ode to AdWords

[From time to time we invite guests to blog about initiatives of interest, and are very pleased to have Allison Schwam, Senior Search Analyst at Backcountry, join us here. -Ed.]

When you don’t have to sacrifice your love of the outdoors for your career or vice versa, it’s something special. In fact, my love of both skiing and marketing has grown dramatically since I took my job at Backcountry. Getting to work with Google, specifically managing our AdWords account, is an online marketing geek’s dream come true. Combine that with every skier’s dream of Utah powder, and life is good.

Day traders wake up every morning to check their portfolio — I get up and check my AdWords accounts. Backcountry sells gear and equipment for the outdoor enthusiast from ski boots to tents, and we sell all of it online. My job is to drive valuable, qualified traffic 365 days a year to Backcountry using AdWords. The AdWords platform lets me manage hundreds of campaigns and hundreds of thousands of keywords with relative ease. I have access to huge amounts of data that are revealed as daily ebbs and flows in impressions, clicks and bids. If you do a Google search for [telemark ski gear], you’ll see our ad:


Backcountry was founded in 1996 by two self-proclaimed ski bums, John Bresee and Jim Holland. Since then, the company has grown to hundreds of employees. I’ve been working here for over two years. Ultimately, our goal is to “crush it,” as some ski town folk say: work hard, play hard.

A typical powder day for me is like this one last Friday when Park City got 12 inches of new snow overnight. Here’s how AdWords helps me manage both work and fun.

7 – 7:45am
Roll out of bed.
Get the coffee going.
Fry eggs and bacon.
Check snow totals.

If it looks like a good ski morning, I first check my email and glance over our AdWords campaigns. All I need to do is my daily reporting to see that I’m on target for my revenue and cost goals. As long as things are okay, I email my boss to say I’ll be out slaying the white dragon.

Just as I have the ideal tools to maximize our online campaign performance, I have the tools avid skiers covet for deep days: fat, rockered skis, stiff ski boots, Gore-Tex jacket and pants, helmet, goggles, merino wool layers, etc. After I grab my gear, I’m off.

7:45am – 12noon

My commute to The Canyons Ski Resort takes 10 minutes. My friends and I know how to get the most out of our time on the mountain, balancing chair lift time, snow quality and vertical. Does that sound a bit like cost-per-click, conversion rate and top-line revenue? Take this lift to that lift, ski the trees while we wait for that chair to open, get after our favorite steep lines. Next thing you know:

Photo by Jim Harris

Face shots are invigorating. Hard to explain, best to experience! After a few glances at the time and collecting my thoughts, I make my way off the mountain.

12pm – 5pm

I head a few miles down the road to the office. As the afternoon goes by, co-workers will emerge from their cubicles; sometimes because legs are cramping up but also to share stories about how the morning was. Where did you ski? How was the snow? Smiles all around.

I settle into work knowing what I need to succeed at my job is at my fingertips. AdWords gives me visibility into my programs to prioritize and understand trends. It also makes it easy to add and edit my account without getting bogged down in manual work. I regularly use Keyword Performance Reports to monitor both head terms and tail terms to stay on top of revenue opportunities. I’ll take into account the average order value and also the percentage of clicks that turn into sales (rate of conversion) in order to manage our keyword bids. As I do bid updates, I also check the AdWords Preview Tool to see how our ads are ranked and what is going on with our competition. We don’t really focus on “cost-per-click” but instead on “cost as percentage of revenue,” which means the more people purchase, the more ads we can run. So the higher the return on advertising spend, the more room we have to grow our paid search presence.

5 pm – 8 pm

I like this afternoon time in particular because it’s quiet and I can really focus on data-crunching. Uninterrupted time and a strong cup of coffee are essential for doing long-term analysis.

Campaign Performance Reports are great for identifying long- and short-term trends as seasons shift or for changes in demand by brand. We just wrapped up our winter sale, so this is a great time for me to run an Ad Performance Report to analyze which versions of ad copy had the strongest clickthrough rates for future reference. Finally, Google Insights for Search is a fun tool. It’s a great way to connect with our buyers by discussing big-picture trends with the brands we carry. We can look at AdWords Campaign performance and try to tie it back to general search volume in the marketplace and identify product searches on the rise. In short, given our metrics focus, AdWords gives me the information I need to make decisions about specific keywords, bids, and our overall spend.

There are typically the same few folks hanging out at the office this late. We’ll exchange some pleasantries, and as the lights get turned off I’ll shut down my computer.

When I earned an undergraduate degree in marketing and cultural anthropology, I had only a vague idea how I was going to create a career with behavioral and analytical activities. It turns out online marketing is an exciting mix of real-time data and customer service. AdWords lets me manage campaigns very efficiently, so I have time to dig deeper and do the strategic analysis that makes this job about much more than just meeting revenue goals.

Finally, I picked Park City because it’s more than a ski town. Here fanatical skiers, trail runners, bikers, snowboarders and climbers can live year round and still have a meaningful career. I’ll always be grateful to companies like Backcountry and Google for making this possible: Backcountry for fostering the passions of the outdoor enthusiast, and Google for innovation in creating the forums and tools that really work for us.

Posted by Allison Schwam, Senior Search Analyst at Backcountry

And the searches go to…

The Oscars®: glitz, glamor, gossip, gold statuettes, much fanfare — and for many fans, Google search is increasingly a part of watching this live TV experience. Before and during the Academy Awards® broadcast in the U.S., we saw related queries on Google dominating the hot searches list on Google Trends. People searched for the TV schedule, printable ballots for voting on favorites, streaming video sites, nominee and film information, celebrity chatter and whatever else caught your attention. Here's a snapshot:

Fashion
Everyone knows the red carpet is all about the gowns. So which actresses made the best (or worst!) dressed list in search? Zoe Saldana's purple Givenchy haute couture gown won the day in searches, with just a few more queries than runner up Miley Cyrus, who walked down the carpet in one of Jenny Packham's finest. Both beat searches for Sandra Bullock's dress (Marchesa) by large margins. Sarah Jessica Parker, always the fashionista, ranked a distant fourth in Chanel. Certain designers were also popular in search, thanks to the stars who wore (and name-dropped) them. Elie Saab (worn by Anna Kendrick), Armani Prive (Amanda Seyfried, Jennifer Lopez) and Marchesa (Sandra Bullock, Vera Farmiga) were all rising trends.

Winners
Throughout the night Oscar®-related searches rose and fell as nominations were introduced and winners announced. Avatar had the most searches before the ceremony, but as The Hurt Locker received more awards, searches for that film exceeded all others and peaked when it won Best Picture. Precious also had a good run throughout the night. Its peak matched that of "Avatar" during the ceremony:


The awards for best actor, best actress and best director are some of the most-anticipated in the program. There was a considerable amount of buzz about Jeff Bridges, Sandra Bullock and Kathryn Bigelow before last night, and considerable spikes in search volume when they each won. Here's a look at a few of the star searches last night:


Finally, the evening wasn't all about big wins. The awards help expose more obscure films — shorts, documentaries and foreign-language — to a much larger audience. Searches for these titles typically went up tenfold during the evening, and if they took home a gold statue, search volume spiked as much as 100 times higher. Music by Prudence, Logorama, Food, Inc., The Cove and The Secrets in their Eyes all experienced an exponential explosion of queries.

Gossip and memorable moments
People are always eager for more information about the Hollywood stars — personal stats like age, height, family and dating status. During this year’s Oscar® ceremonies, Kathryn Bigelow's height and Miley Cyrus's mother's tattoos were hot topics. Whose girlfriend was most searched for? Easy. George Clooney's (Elisabetta Canalis).

So what were the most memorable moments of the broadcast? When George Clooney wandered off the red carpet to greet the crowd, queries on [clooney] shot through the roof. Ben Stiller’s appearance as a Na'vi was another draw, and queries on him were high during his spoof. Molly Ringwald and Matthew Broderick’s John Hughes tribute triggered a flood of nostalgia; Sixteen Candles, The Breakfast Club, Ferris Bueller's Day Off and Home Alone all saw huge query spikes as well. During the memorial portion of the show, queries surged for those in the industry who passed away in the last year, including Ron Silver, Natasha Richardson, Patrick Swayze and Brittany Murphy. On a lighter note, Sandra Bullock set off a frenetic amount of searches when she mentioned a Meryl Streep kiss in her acceptance speech.

As we've seen in presidential debates, unusual words also generate great interest. The Oscars led to spikes in searches for [catharsis] (from Robert Downey Jr.'s presentation with Tina Fey) and [spooning] (Colin Farrell talking about Jeremy Renner).

We hope you enjoyed the evening, and want to thank everyone for turning to Google search to see the latest. And our parents deserve huge thanks, and our agent... oh, they're telling me to wrap it up...!

Posted by Qing Wu, Senior Economics Analyst

An update on Google.org and philanthropy @ Google

What do tracking flu, helping consumers monitor their home electricity use, slowing deforestation and perhaps most importantly in 2010, helping the people of Haiti have in common?

While they are all part of the wide-ranging work of Google.org over the last year, they also show what our technical teams can accomplish in critical areas that don't always get the attention they need and deserve.

A year ago we outlined our goals for the next chapter for Google.org. We talked about our vision to use strengths of Google in information and technology to build products and advocate for critical policies that address global challenges. Ideas for projects continue to pour in from Googlers and partners around the globe, and we're incubating several new projects in the areas of economic development, clean energy and access to technology.

This past year, we:

• Ramped up Google PowerMeter to help consumers reduce their electricity use and save money, secured utility and device partners, and launched the API on code.google.com to help expand partner access globally.
• Introduced Earth Engine, a new computational platform we have begun building for global-scale analysis of satellite imagery to monitor changes in key environmental indicators like forest coverage, at COP15 in December.
• Quickly expanded Google Flu Trends to 20 countries and 38 languages as the H1N1 flu virus spread around the world. We also added city-level flu estimates to 121 U.S. cities and developed the Flu Shot Finder to help people find vaccine locations.
• Responded to earthquakes in Haiti and Chile, with maps, updated earth imagery, and networking projects, and built Person Finder to help people find information about their loved ones after a disaster.
• Advocated for policies to spur innovation of renewable energy technologies that are cheaper than coal (RE<C), and our engineers worked on ways to reduce the cost of solar thermal and other RE<C technologies.

We will continue to greenlight large scale engineering projects that build on Google's strengths in technology, our computing infrastructure and global teams.

Overall, our philanthropic mission at Google includes our Google.org projects and a range of other initiatives — from grants, scholarships and other charitable giving programs to in-kind product support for non-profits. Our founders have set a goal of devoting approximately 1% of Google's equity and yearly profits to philanthropy. In 2009, we devoted around $100 million plus in-kind giving to a broad range of philanthropic efforts. Here are some highlights:

• Academic scholarships and awards: We provide scholarships to encourage students of various backgrounds, ethnicities and gender to excel in their studies in hopes that these and other programs will help dismantle barriers that keep women and minorities from entering computing and technology fields.
• Academic grants: We support the next generation of engineers and maintain strong ties with academic institutions worldwide that are pursuing research in core areas relevant to our mission. We fund projects across a variety of subjects, host visiting faculty members at Google, and have launched the Google Fellowship Program to fund graduate students doing innovative research in several fields.
• Holiday charitable gift: We made $22 million in donations in 2009 to a couple of dozen deserving charities around the world to help organizations that have been stretched thin by more requests for help in a year of fewer donations.
• Employee gift matching: Google matches up to $6,000 for each employee's annual charitable contributions and contributes $50 for every five hours an employee volunteers through our "Dollars for Doers" program to encourage employee participation in charitable causes.
• Charitable Giving Council: We support grants for Googler-led partnerships on causes such as K-12 educational initiatives in science, math and technology.
• Community affairs: We invest in communities where Google has a presence around the world, creating opportunities for Googlers to invest time and expertise, engage in local grant making and build partnerships with local stakeholders.


Next Page »