Opening Google Docs to users and developers via Gadgets and Visualization API

<span class="byline-author">Posted by Jonathan Rochelle & Nir Bar-Lev, Product Managers</span><br /><br />Whenever we're asked "how do people use Google spreadsheets?", we always struggle with where to start. It's not that we can't think of examples, it's just that the examples are all so different, so unique. Sure, there are definitely favorite themes -- sports, finance and, yes, <a href="http://spreadsheets.google.com/pub?key=psOu1MxOSLMOrN6GBsmAUGA" id="ocpt" title="knitting">knitting</a> -- but then the examples become so particular to the people and groups who are using them: The <a href="http://spreadsheets.google.com/pub?key=pD0NlEE-rv7zcUYxvGlpHOA" id="b2tt" title="beer taster's">beer taster's results</a>. The nursery school class schedule. The <a href="http://spreadsheets.google.com/pub?key=poRB3Tn-uVkEIuh4pU-OpAg&gid=4" id="d2b7" title="biker's riding log">biker's riding log</a>. The family reunion plan. The ski-trip sign-up form. Endless examples, all of which, to spreadsheet junkies like us, are interesting.<br /><br />But while we've always wanted to give people more options to view and use their information in Google Docs, we knew that trying to build all of these one at a time would simply serve too few people, given all the different ways people use and share spreadsheets.<br /><br />So today we're starting a new path to better enable developers to customize and build on top of Google Docs with two new tools we are releasing today: Gadgets-in-Docs and the <a href="http://code.google.com/apis/visualization" id="w:te" title="Visualization API">Visualization API</a>.<br /><br />Instead of delivering just one or two new types of reports, or a new visual map mashup (can you ever get enough of those?), we decided to deliver a platform on which anyone, not just Google, could build the next best thing. We even invited a few developers to try this with us, and they join us in this launch by featuring just a few of their creations, like Panorama's pivot table, or Viewpath's Gantt Chart, or InfoSoft's Funnel Charts -- all great tools for the student and enterprise user alike. We also built a few early gadgets ourselves which you might find useful.<br /><br /><div style="text-align: center;"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-ycfndZNCbjN2zJkYPhpV1Zb8sUPEN9i0bq3ZiYsyvaDm6jrB9E0Kr3VUMR4k3hBxtt447G5WG5MePGmuXTvYikcbPsC4qLxAPY3rcFDtuTg6asLvCPCHyF65xRddgMmmO4PHx9oU2-xK/s1600-h/Gadgets_spreadsheets.gif"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5179471964771836274" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-ycfndZNCbjN2zJkYPhpV1Zb8sUPEN9i0bq3ZiYsyvaDm6jrB9E0Kr3VUMR4k3hBxtt447G5WG5MePGmuXTvYikcbPsC4qLxAPY3rcFDtuTg6asLvCPCHyF65xRddgMmmO4PHx9oU2-xK/s320/Gadgets_spreadsheets.gif" style="cursor: pointer;" /></a><br /></div><br />We borrowed the Gadgets-in-Docs concept from the iGoogle team, so it's only fitting that you can also publish your spreadsheet gadgets to iGoogle, where you can see your data-based-Gadget right next to all that other stuff that's important to you (even if it is just a picture of your dog).<br /><br />To try it out, go into <a href="http://docs.google.com/" id="fc31" title="Google Docs">Google Docs</a> and open up a spreadsheet. Click on the chart icon, and click 'Gadget...'. Pick your gadget, customize it to fit your data, and then publish it out to iGoogle or to any webpage.<br /><br />If you're a developer and want to reach millions of people with your latest creation, check out the <a href="http://code.google.com/apis/visualization/">Google Visualization API</a>, courtesy of our visualization team engineers. The Visualization API provides a platform that can be used to create, share and reuse visualizations written by the developer community. It provides a common way (an API) to access structured data sources, the first being Google spreadsheets.

Opening Google Docs to users and developers via Gadgets and Visualization API

Posted by Jonathan Rochelle & Nir Bar-Lev, Product Managers Whenever we're asked "how do people use Google spreadsheets?",...

Đọc thêm »

Add your business to Local Search in India

<span class="byline-author">Posted by Ravi Yadavilli, Geo Content Operations Manager, and Alok Goel, Product Manager</span><br /><br />- Do you own a restaurant in Delhi and wish more people knew about your delicacies?<br />- Are you an insurance agent seeking new clientele?<br />- Would you like more tourists for your travel agency in Goa?<br />- Are you a custom apparel merchandiser in Bangalore seeking to expand your customer base?<br /><br />Every day several lakhs of people search the Internet seeking firms like yours. It will help you to be listed in <a title="Google local search" href="http://local.google.co.in/" id="v8il">Google local search</a>. It's really simple to add your business, and it's free. Call us at 1-800-419-4444 (in India only, for your Indian-based business), SMS "register" to 09900800000<span>,</span> or just <a href="http://www.google.co.in/local/add">add your listing</a>.<br /><br />Spending a few minutes on this can make all the difference to your business - why not do it now?

Add your business to Local Search in India

Posted by Ravi Yadavilli, Geo Content Operations Manager, and Alok Goel, Product Manager - Do you own a restaurant in Delhi and wish more pe...

Đọc thêm »

Google for Non-Profits

<span class="byline-author">Posted by Chris Busselle, Investments Manager, Google.org</span><br /><br />Many of you spend your days making this world a better place, and we want to do our part to help. Today, we're excited to launch <a href="http://www.google.com/nonprofits/" id="mjkh" title="Google For Non-Profits">Google For Non-Profits</a>, a one-stop shop for tools to help advance your organization's mission in a smart, cost-efficient way.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4XFxw9mc-tZF9-7lMPqGAw3pAG8fiVQAzpWFQqckWG7SKkjQr_lAXYCuAlxxl-d5bxA_R2vG7fR6hl3YNABpxSB2-9mLC2nSqaPwPnC9j2zY7gy8g1chP-6foR8r197yEdswuHk1tgpar/s1600-h/screenshot.jpg"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5179157324254151458" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4XFxw9mc-tZF9-7lMPqGAw3pAG8fiVQAzpWFQqckWG7SKkjQr_lAXYCuAlxxl-d5bxA_R2vG7fR6hl3YNABpxSB2-9mLC2nSqaPwPnC9j2zY7gy8g1chP-6foR8r197yEdswuHk1tgpar/s320/screenshot.jpg" style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer;" /></a>This site features ideas and tutorials for how you can use Google tools to promote your work, raise money and operate more efficiently. And to get inspired, you'll also find examples of innovative ways other non-profits are using our products to further their causes. Here are some of the ideas covered:<br /><ul><li>When you're writing a grant application, don't get stuck emailing drafts back and forth. <a href="http://www.google.com/nonprofits/docstutorial.html" id="hdy0" title="link to toturial">Try Google Docs</a> to collaborate on documents with your colleagues.</li></ul><ul><li>Cut costs and save time with <a title="Google-hosted email" href="http://www.google.com/nonprofits/gmailtutorial.html" id="kmkv">Google-hosted email</a> at your own domain. Access your e-mail from any computer with an Internet connection.</li></ul><ul><li>Accept online donations without hassle and with no transaction fees until 2009 with <a title="Google Checkout" href="http://www.google.com/nonprofits/checkouttutorial.html" id="q:s4">Google Checkout</a>.</li></ul><ul><li>Apply for free online advertising through our <span style="color: rgb(0, 0, 0);"><a href="http://www.google.com/nonprofits/grantstutorial.html" id="niqx" title="Google Grants">Google Grants</a></span> program to raise awareness and drive traffic to your website.<br /></li></ul><ul><li>Start a <a title="blog" href="http://www.google.com/nonprofits/bloggertutorial.html" id="tqhg">blog</a> to keep your supporters informed and engaged.</li></ul>We'd also love to <a title="hear your own stories" href="http://services.google.com/feedback/nonprofits_story" id="s2d3">hear your own stories</a> about how Google tools have made a difference in your organization's work.

Google for Non-Profits

Posted by Chris Busselle, Investments Manager, Google.org Many of you spend your days making this world a better place, and we want to do ou...

Đọc thêm »

Using data to help prevent fraud

<span class="byline-author">Posted by Shuman Ghosemajumder, Business Product Manager for Trust & Safety</span><br /><br /><span style="font-style: italic;">We recently began a series of posts on how we harness the power of data</span><span style="font-style: italic;">. <a title="Earlier" href="http://googleblog.blogspot.com/2008/03/why-data-matters.html" target="_blank">Earlier</a> we told you </span><i style="font-style: italic;">how data has been critical to the advancement of search technology</i><span style="font-style: italic;">. <a title="Then" href="http://googleblog.blogspot.com/2008/03/using-log-data-to-help-keep-you-safe.html" target="_blank">Then</a> we shared how we use log data to help make Google products safer for users. This post is the newest in the series. -Ed.</span><br /><br />Protecting our advertisers against click fraud is a lot like solving a crime: the more clues we have, the better we can determine <a href="http://adwords.blogspot.com/2007/02/invalid-clicks-googles-overall-numbers.html" id="v4:f" title="which clicks to mark as invalid">which clicks to mark as invalid</a>, so advertisers are not charged for them.<br /><br />As we've mentioned before, our <a href="http://adwords.blogspot.com/2007/02/meet-click-quality-team.html" id="v3:6" title="Click Quality team">Ad Traffic Quality team</a> built, and is constantly adding to, our <a href="http://adwords.blogspot.com/2007/02/invalid-clicks-googles-overall-numbers.html" id="uta7" title="three-stage system">three-stage system</a> for detecting invalid clicks. The three stages are: (1) proactive real-time filters, (2) proactive offline analysis, and (3) reactive investigations.<br /><br />So how do we use logs information for click fraud detection? Our logs are where we get the clues for the detective work. Logs provide us with the repository of data which are used to detect patterns, anomalous behavior, and other signals indicative of click fraud.<br /><br />Millions of users click on AdWords ads every day. Every single one of those clicks -- and the even more numerous impressions associated with them -- is analyzed by our filters (stage 1), which operate in real-time. This stage certainly utilizes our logs data, but it is stages 2 and 3 which rely even more heavily on deeper analysis of the data in our logs. For example, in stage 2, our team pores over the millions of impressions and clicks -- as well as conversions -- over a longer time period. In combing through all this information, our team is looking for unusual behavior in hundreds of different data points. <a href="https://adwords.google.com/support/bin/answer.py?answer=6322" id="r4u0" title="IP addresses"><br /></a><br /><a href="https://adwords.google.com/support/bin/answer.py?answer=6322" id="r4u0" title="IP addresses">IP addresses</a> of computers clicking on ads are very useful data points. A simple use of IP addresses is determining the source location for traffic. That is, for a given publisher or advertiser, where are their clicks coming from? Are they all coming from one country or city? Is that normal for an ad of this type? Although we don't use this information to identify individuals, we look at these in aggregate and study patterns. This information is imperfect, but by analyzing a large volume of this data it is very helpful in helping to prevent fraud. For example, examining an IP address usually tells us which ISP that person is using. It is easy for people on most home Internet connections to get a new IP address by simply rebooting their DSL or cable modem. However, that new IP address will still be registered to their ISP, so additional ad clicks from that machine will still have something in common. Seeing an abnormally high number of clicks on a single publisher from the same ISP isn't necessarily proof of fraud, but it does look suspicious and raises a flag for us to investigate. Other information contained in our logs, such as the browser type and operating system of machines associated with ad clicks, are analyzed in similar ways.<br /><br />These data points are just a few examples of hundreds of different factors we take into account in click fraud detection. Without this information, and enough of it to identify fraud attempted over a longer time period, it would be extremely difficult to detect invalid clicks with a high degree of confidence, and proactively create filters that help optimize advertiser ROI. Of course, we don't need this information forever; last year we started <a href="http://googleblog.blogspot.com/2007/03/taking-steps-to-further-improve-our.html" id="yu6a" title="anonymizing server logs">anonymizing server logs</a> after 18 months. As always, our goal is to balance the utility of this information (as we try to improve Google’s services for you) with the best privacy practices for our users.<br /><br />If you want to learn more about how we collect information to better detect click fraud, visit our <a href="http://www.google.com/adwords/adtrafficquality/" id="bwg:" title="Ad Traffic Quality Resource Center">Ad Traffic Quality Resource Center</a>.

Using data to help prevent fraud

Posted by Shuman Ghosemajumder, Business Product Manager for Trust & Safety We recently began a series of posts on how we harness the po...

Đọc thêm »

Vote for the YouTube Awards

<span class="byline-author">Posted by Mia Quagliarello, YouTube Team</span><br /><br />We're thrilled to say that the second annual YouTube Awards are now live and ready for your vote. This year we've added five new categories: Short Film, Political, Sports, Eyewitness, and Instructional, for a total of 12. So head over to our <a href="http://www.youtube.com/ytawards07">YouTube Video Awards channel</a> to start watching and voting for some of the videos that defined '07.<br /><br />You can vote once per day (though you may not change your vote on the same day) and you have until 11:59pm PT this coming Wednesday, March 19th, to do so. We'll announce the winners on Friday, March 21st, at which point we'll feature them on <a href="http://www.youtube.com/ytawards07">this page</a> and invite them to a special YouTube gathering later this year.<br /><br />There are more <a href="http://www.youtube.com/blog?entry=YXJYpx0EKEs">details on the YouTube Blog</a>. Have fun voting!

Vote for the YouTube Awards

Posted by Mia Quagliarello, YouTube Team We're thrilled to say that the second annual YouTube Awards are now live and ready for your vot...

Đọc thêm »

Keeping up with Google Apps

<span class="byline-author">Posted by Jeremy Milo, Marketing Manager</span><br /><br />During 2007, we introduced 40 significant improvements to <a href="http://www.google.com/a/help/intl/en/business/applications.html" id="a4g:" title="Google Apps">Google Apps</a>, which is our suite of communication, collaboration, and security apps for businesses, schools, and organizations. Feedback from many of you, and even our own employees, inspired these changes. And there are many more in store -- the count this year is already up to 11.<br /><br />Since we introduced Google Apps a little more than a year ago, many of these features have been of particular benefit to businesses, like tools to migrate mail from an old email system to Google Apps; integration of Postini's security and compliance services; support for IMAP in Gmail; syncing tools for Google Calendar; support for dozens of new languages; new mobile access options; and just weeks ago, Google Sites.<br /><br />We're able to release these sorts of things quickly because all of our apps live "in the cloud." That means updates are continuous: you get improvements without having to wait for new versions, as you do with traditional software. Of course, it may also mean that IT administrators get a little dizzy from the pace of these changes.<br /><br />The latest improvement will help technology departments and those of you who already use Google Apps keep up with every change, no matter how often they appear: Now we're documenting all updates in an <a href="http://feeds.feedburner.com/GoogleAppsUpdates" id="ze6y" title="RSS feed">RSS feed</a>, so you can get notified as they happen.<br /><br />To subscribe to new updates and see details about past improvements, click this "Add to Google" button:<br /><div style="text-align: center;"><a href="http://fusion.google.com/add?source=atgs&feedurl=http://feeds.feedburner.com/GoogleAppsUpdates"><img alt="Add to Google" border="0" src="http://buttons.googlesyndication.com/fusion/add.gif" /></a><br /></div><br />If there's something you'd like to see in Google Apps, <a href="http://google.com/support/a/bin/request.py?contact_type=suggest">let us know</a>. Feedback like yours shapes its future development.

Keeping up with Google Apps

Posted by Jeremy Milo, Marketing Manager During 2007, we introduced 40 significant improvements to Google Apps , which is our suite of commu...

Đọc thêm »

Space Jam

<span class="byline-author">Posted by Lior Ron, Product Manager</span><br /><br /><a title="Code Jam" href="http://www.google.com/codejam/" id="tfny">Code Jam</a> is one of our most famous traditions. Programmers compete to hack and solve complex programming challenges in a very short time, and the winners are awarded fame, cash prizes and the opportunity to intern at Google.<br /><br />Diego Gavinowich from Buenos Aires was a finalist in our Latin America Code Jam, and joined us for a winter internship three months ago (missing summer break in Argentina!). Since he loves astronomy and web hacking, we gave Diego a new Code Jam challenge: code a web version of <a title="Google Sky" href="http://earth.google.com/sky/skyedu.html" id="iw.m">Google Sky</a> by the end of his time with us.<br /><br />Well, he did it... with the help of other engineers jamming along on their 20% time. We're very pleased to tell you that Google Sky is now available on the web at <a title="sky.google.com" href="http://sky.google.com/" id="fwfb">sky.google.com</a>. You can <a title="now search for planets" href="http://www.google.com/sky/#latitude=27.4491&longitude=-108.082107&zoom=8&Spitzer=0.00&ChandraXO=0.00&Galex=0.00&IRAS=0.00&WMAP=0.00&Cassini=0.00&slide=2&mI=1&oI=0&by=1" id="n_4f">search for planets</a>, listen to <a title="Earth & Sky podcasts" href="http://www.google.com/sky/#latitude=-2.410787363563224&longitude=8.301544189453125&zoom=10&Spitzer=0.00&ChandraXO=0.00&Galex=0.00&IRAS=0.00&WMAP=0.00&Cassini=0.00&slide=6&mI=1&oI=7&by=1" id="dj5j">Earth & Sky podcasts</a>, watch some beautiful <a title="Hubble telescope images" href="http://www.google.com/sky/#latitude=22.01276918882111&longitude=-96.36571884155273&zoom=13&Spitzer=0.00&ChandraXO=0.00&Galex=0.00&IRAS=0.00&WMAP=0.00&Cassini=0.00&slide=16&mI=1&oI=2&by=1" id="yxpw">Hubble telescope images</a>, or <a title="explore historical maps of the sky" href="http://www.google.com/sky/#latitude=-3.337953961416472&longitude=-54.140625&zoom=4&Spitzer=0.00&ChandraXO=0.00&Galex=0.00&IRAS=0.00&WMAP=0.00&Cassini=68.00&slide=1&mI=1&oI=2&by=1" id="mjun">explore historical maps of the sky</a> from the comfort of your browser.<br /><br />Sky in Google Earth, which <a href="http://google-latlong.blogspot.com/2007/08/sky-final-frontier.html">launched last August</a>, was originally available to our 350 million Google Earth users. This release brings the universe to every browser and makes Sky accessible to just about anyone with an Internet connection — from school children to professional astronomers — in 26 different languages.<br /><br />To learn more about Google Sky web edition, watch this short video, and read the full story on the <a href="http://google-latlong.blogspot.com/2008/03/organizing-more-than-one-worlds.html">Google Lat Long blog</a>.<br /><br />We'll miss you, Diego!<br /><br /><object height="355" width="425"><param name="movie" value="http://www.youtube.com/v/gX9MeF2Au9c&hl=en"><param name="wmode" value="transparent"><embed src="http://www.youtube.com/v/gX9MeF2Au9c&hl=en" type="application/x-shockwave-flash" wmode="transparent" height="355" width="425"></embed></object>

Space Jam

Posted by Lior Ron, Product Manager Code Jam is one of our most famous traditions. Programmers compete to hack and solve complex programmin...

Đọc thêm »