Checking in with foursquare at SFO

Posted on June 24, 2010 by Rakesh Agrawal
SFO is a hotbed of foursquare activity

SFO is a hotbed of foursquare activity. Creative Commons image by Håkan Dahlström.

With the increasing use of mobile applications such as Yelp and foursquare, it’s becoming possible to pull ideas from thin air. Users of these apps can leave tips for others to find that are linked to a specific location.

In most places there aren’t enough tips yet to make filtering an issue. San Francisco International Airport, with more than 57,000 checkins on foursquare, is an exception. It offers a glimpse of what we can expect as these services become more popular. The airport is the perfect petri dish for tips: it serves a technically savvy audience and people often find themselves there with plenty of time on their hands.

The SFO tips page contains dozens of notes including places to eat, complaints, ground transportation, wifi and power availability. Mixed in to all of this are ads, other spam and random observations. Some examples:

have a corned beef sandwich at max’s if you’re flying southwest. the best! well, really good

When you enter short term parking do it as far to the right as you can (lvl 2) & then immediately head to lvl 1. There is always parking next to gate and that is the lvl that connects to the terminal

Free wifi at the Continental lounge in Terminal 1- be warned, it’s located outside Security

Smoking hot brunette woman at gate 20. Stop by and smile at her. She is so lovely!

Bart to Millbrae gets you within 1 block of an in n out burger. Great for 3+ hour layover!

Heading to wine country? Take a moment to stop by St. Supery in the heart of Napa on Hwy 29. Mention this to get a 2 for 1 tasting.

Sorting through the volume of tips can be overwhelming. As the volume increases, we’ll need ways to filter them. Among the ways to filter:

  • Timeliness. Some of the tips, such as wifi at the Continental lounge, are evergreen. Others, like the smoking hot brunette are very timely. Tipsters should be able to flag their tips to self destruct. As I wrote earlier, being able to identify tips by timeliness would allow for new applications, such as sharing rides. (“Anyone want to split a cab to Moscone?”)
  • Social network. Among the tips were tips from people I follow on Twitter, including Danny Sullivan and Adam Lasnik. Being able to surface these would increase relevance.
  • Ads vs. not ads. Sometimes people want ads, especially if it can save them money.
  • Keyword search.

Places like airports are especially complex because they’re really collections of places, sometimes with other groupings and physical restrictions. Being able to filter tips by terminal would also be useful. But then maybe that’s best left to GateGuru.

Posted in audio, foursquare, geotagging, lbs, local search, maps, mobile, social networking, twitter | Tagged | 1 Comment

Now we’re going Places

Posted on June 16, 2010 by Rakesh Agrawal

I’ve been writing about Twitter and location since my first post about Twitter in 2007. This week, Twitter launched Places, which allows users to add their location to a tweet.

Here’s a screenshot from 2007:

Twitter location 2007

Embedding location in a tweet the hard way in 2007

and today:

Embedding location in a tweet in 2010

In 2007, I used a third-party application from Where to include my location. Clicking on that link would take you to a map on Where’s site showing the address. (The link in the original post no longer works.)

With the launch of Twitter Places, the search is done within the Web browser (and soon in Twitter’s mobile applications). You can select where you are from a list of nearby places. Clicking on the place name brings up the map above and the option to view tweets about that place.

Although the difference between the two may seem subtle, they are significant:

  • Because the place is metadata, it doesn’t count toward the 140 character limit.
  • Place names are human readable, unlike addresses and latitude/longitude. Knowing the name of a place makes it much easier to find than just a street address, especially in dense metropolitan areas.
  • Places are unique to a specific venue. Doing a pure location-based search would return tweets from surrounding businesses or businesses that have since disappeared.
  • Integration in to the main Twitter experience means broad exposure and eventual standardization of place identifiers. That has been a longstanding challenge in the local space.

Twitter’s geo APIs have been available for several months and third parties like bing have created interesting applications like Twitter Maps. With the availability of places across the Twitter platform, we can expect to see more interesting applications including both real-time applications (ride sharing and ticket exchanges) and historical (restaurant reviews, past events).

Once Twitter allows owners to claim their Place and associate it with a Twitter account, we could see official tweets of announcements and offers incorporated into a Place’s search results.

When pictures are tagged to a Place (instead of a lat/long), we’ll have the ability to visually browse a venue in Twitter.

Posted in geotagging, gps, lbs, local search, maps, mobile, social networking, twitter | Tagged | 1 Comment

iPad puts on its business suit

Posted on June 14, 2010 by Rakesh Agrawal
An iPad used in place of a cash register at Sightglass Coffee. Photo courtesy Tony Conrad.

An iPad used in place of a cash register at Sightglass Coffee. Photo courtesy of Tony Conrad.

Most of the discussion around Apple’s iPad has been about what a great consumer device it is. It’s a book reader, movie player, newspaper, photo viewer, RSS reader and more.

But the iPad has a lot to offer businesses as well. Sightglass Coffee in San Francisco is using an iPad, with Square’s payment system as a point-of-sale system. A restaurant in Australia is using iPads in place of printed menus and wine lists. Patrons can drill down on items that interest them for more information. Mercedes Benz is using iPads to allow customers to start their credit application while still intoxicated by the new car smell. The Plaza hotel in NYC will soon use them for concierge services and room service ordering.

As companies like Twitter, Groupon, Living Social, foursquare and Yelp focus on the small business market, it’s easy to see the iPad becoming an essential tool for small businesses.

I cringe every time I go to a business with a Groupon and see the clerk pull out a binder and manually cross out the Groupon on the list. An iPad app would reduce the transaction time and provide the business key metrics such as how many redemptions are outstanding and how much people are spending beyond the Groupon value. It would also reduce mistakes and fraud.

Other possible applications:

  • Reputation management with live feeds from Twitter and Yelp, with the ability to quickly respond to applications.
  • Check in information from sites like foursquare to show who is visiting right now and keep track of frequent customers. An alert could appear when the mayor/duke/etc. checks in.
  • Frequency programs to replace traditional punch cards.
  • Real estate agents could use iPads to show off alternative properties and keep track of reactions from buyers.

iPads could also interact with mobile devices such as iPhones to receive payments.

Of course, all of these things can be done with a computer. But the iPad offers a number of advantages:

  • It takes less space. All of this power takes less space than a computer monitor, much less a PC.
  • It doesn’t create a barrier between you and the customer. The tablet feels more collaborative versus using a laptop.
  • Fewer maintenance headaches due to viruses and malware.
  • It shows innovation and forward thinking.

See also:

Posted in apple, foursquare, ipad, iphone, local search, mobile, social networking | 2 Comments

EVO vs. iPhone

Posted on June 9, 2010 by Rakesh Agrawal

I’ve been using an HTC EVO since last Friday. As an iPhone user for the last two years, this is the first Android phone that has appealed to me.  CrunchGear has a good comparison of the technical specs of the iPhone and the EVO.

The two biggest complaints others have voiced about the EVO are bulk and poor battery life. Yes, it is bulky. It’s the heaviest phone I’ve had in at least 5 years — at 6 ounces, it’s 25% heavier than the iPhone 4G. It’s width makes it more awkward to hold than an iPhone, but not uncomfortably so. But it also has a big, beautiful screen. Life is a tradeoff.

I haven’t had issues with battery life, but then I don’t talk a lot on my phone. Unlike with the iPhone, you can carry around a spare battery.

The other issue that has been mentioned regularly is the on-screen keyboard. The iPhone’s keyboard is less complicated, but the EVO let’s you accomplish more tasks (like entering numbers) without leaving the main keyboard. The one issue I’ve definitely noticed is that some keys on the left side haven’t been registering consistently. (e.g. “A” and “S”)

While others have railed against one or the other, the phones are different enough that they’re likely to appeal to different people. I’ve tried to identify those below.

For typical consumers, my recommendation would be the iPhone, provided that you’re in an area where AT&T’s network isn’t saturated. For me? I’ve got three more weeks to decide.

If you…

… have a lot of music or photos and like iTunes.

Go with the iPhone. I haven’t been able to find a decent media synchronization experience for EVO. I used my iPhone frequently for podcasts and those are easy to set up and synch with iTunes. I also synch photos from my computer to my iPhone. Again, not something I can do with the stock EVO.

… want to customize your phone experience.

Go with EVO. You can customize a lot of elements of how the phone operates. You can create themes for different uses, e.g. a work theme, play theme and travel theme. Each theme can have different applications, shortcuts and widgets. It’d be even nicer if you could change themes automatically based on time of day or location. (e.g. work theme while at the office)

… don’t want to know what a task manager is.

Go with iPhone. Ordinary users should never have to see things like com.google.android.apps.googlevoice. It’s difficult to figure out what apps are running on the EVO. That’s problematic because you could easily have an unknown app running down your battery.

… want something that looks pretty.

Go with iPhone. It’s hard to top Apple design. The EVO is bulkier and certainly looks more utilitarian than iPhone. The EVO screen also shows fingerprints a lot more than my iPhone 3G.

… give out your Google Voice number to friends, family and colleagues.

Go with EVO. The Google Voice integration is incredible. Calls you make can be routed through GV automatically. Calls are logged correctly in the phone and on the GV site. Voicemail is also seamlessly integrated. Text messages aren’t integrated into the phone’s messages app.

… want a broad selection of apps.

Go with iPhone. Yes, it’s not open and yes, Apple can arbitrarily reject apps. But iOS has many more apps written for it. While many of the major apps are on both platforms, I couldn’t find equivalents for flickr or Zipcar on Android. Google Voice is the key exception of an app that’s on Android but not iPhone.

For gamers, the iPhone advantage is even stronger. With the gyroscope on iPhone 4, gaming will only get better.

…  like flickr, Facebook and Twitter.

Go with iPhone. The Facebook and Twitter apps for iPhone are much more polished than their Android counterparts. For example, on the Facebook app, clicking on a link someone has shared sends you on an infinite loop between the shared item and the person’s wall.  (Google VP Vic Gotundra recently gave a Facebook intern an HTC Evo in hopes of getting a better experience on Android.) I couldn’t find an official flickr app for Android.

HTC includes some tools for all three networks that integrate them into the phone’s UI. For example, contact lists from all three can be integrated with the phone’s main contact list. This sounds great — and is the right direction for phones — but the software isn’t ready for prime time. I often see the same people listed 3 or 4 times. (You can manually consolidate these for each person, but that’s a lot of work.) If you set up favorite people, you’ll see when they’ve updated their social networks. Background downloading of status updates also takes a toll on battery life.

… have terrible AT&T coverage.

Go with EVO. AT&T’s networks in SF and NY are overloaded and getting data connections or making a call can be a real challenge.

I’ve had few issues with Sprint’s network. Sprint also includes roaming on Verizon’s network.

… want something that “just works” out of the box.

Go with iPhone. The stock EVO is much more customizable than a stock iPhone. With customization always comes complexity. When iPod came out, a lot of techies criticized it for being a dumbed down MP3 player. Other MP3 players of the time had FM radios! They didn’t tie you into one company! But by stripping away all those extra features, Apple created something that just worked for the most common tasks for most people.

Same is true with iPhone. Owning the entire stack gives Apple a huge advantage in creating a user experience that just works across its enormous userbase. Video calling will work the same across all iPhone 4s. Not true with Android.

With HTC’s Sense UI, Android, Sprint customizations and apps all playing a part, the EVO experience doesn’t hold together.

Although features like social networking integration will be important, what HTC has done with EVO is too confusing for most people.

… want to be able to connect your laptop, iPad or other devices.

Go with EVO. Although AT&T is now offering tethering, they’re charging an extra $20 a month and the usage still counts against your 2GB data limit. For$30 a month, Sprint offers unlimited data and a wireless hotspot that supports up to 8 devices simultaneously. If you don’t need that, you might be able to use an app like PDANet to tether your laptop without paying the $30 a month.

… talk a lot, text a lot, use a lot of data or use navigation and want to economize.

Go with EVO. Sprint’s pricing plans are generally cheaper than AT&T for heavy users. For $80, Sprint includes unlimited nights (beginning at 7pm vs. 9pm for AT&T) and weekends, unlimited calls to any mobile phone (vs. just AT&T customers), unlimited texting (an additional $20 on AT&T) and navigation (extra $10 on AT&T). Sprint also has generous corporate discounts that can knock up to 25% off the bill. Low volume users who can get by with less than 250MB of data a month are better off with AT&T.

… are a world traveler.

Go with the iPhone. With GSM, you’ll at least have the option of international coverage in most countries, even if you have to pay exorbitant roaming rates. Of course, it’s best to unlock your phone and use local carriers if you’re spending any amount of time outside the country.

… are uncertain.

Try EVO. Sprint offers the most generous return policy in the business. You have 30 days to decide whether you like it. If you don’t, you can take it back and you won’t pay anything. They won’t even charge you for the service you used. AT&T will charge you for the service, plus the activation fee, unless you return within 3 days. Sprint’s early termination fee is also lower, $200 vs. $325.

NOTE: Comparisons here are based on a stock iPhone vs. a stock EVO.

Posted in android, apple, facebook, flickr, google, iphone, mobile | Tagged | 2 Comments

Can Google cross the retail chasm with Google TV?

Posted on May 24, 2010 by Rakesh Agrawal

Sony Dash at Best Buy

Last week, Google announced Google TV, a product that marries the Web with TV. It’s a product category that I’ve been excited about for several years.

But creating new product categories is hard. Retail is hard. Doing both together is really hard.

I was reminded of that today at Best Buy, where I saw a display for Sony’s Dash. As best as I can describe it, it’s a cross between an alarm clock, picture frame and MP3 player. Despite Best Buy having a real Dash, I still couldn’t try it out. The unit seemed to be glued to its stand. The screen said it was looking for a network, which it never found.

I then went over to check out Insignia GPS devices. The connected GPS unit sells for $199. Given that Insignia is Best Buy’s house brand, you’d figure it would get some decent promotion and training. I asked the blue shirt if there was a display unit. Nope. How much is the service? “I think it’s like $10 a month.” (The correct answer is $14.99 a month.) What’s the difference between it and the not connected unit that sells for $69? “I think it lets you connect to Google.”

Like Google TV, these are products that need to be experienced. They are either new products or significant (and premium-priced) variations on existing product categories. If people can’t try them or, at the very least, talk to someone who has in-depth knowledge about them, people won’t buy them. (As an early adopter, I probably will… but that’s not a huge market.)

Contrast this experience with the Apple Store in the same mall. There were two tables, each with about a dozen functioning iPads. You could pick up an iPad and play with it for as long as you wanted. There were employees available who knew the device and could answer questions. The biggest challenge? They were sold out of all but the 16GB WiFi iPad.

As I wrote before the first iPhone was released, Apple’s retail stores give it a huge leg up when it comes to introducing new product categories. The excitement that they create for product launches (read: free media), combined with the opportunity to experience new products is unmatched in retail. If Apple decides to make Apple TV more than a hobby, its store employees will play a big part in shaping user perception.

A big unknown is the price of Google TV. People might pay an extra $50 on a $800 TV for the Google brand, even if they’re not quite sure what it does. It’s unlikely that the price premium will be that small, given the cost of just the Intel Atom processors. I’d expect Google TV to add at least $100 to the price. The other big challenge is that a lot of people have recently replaced their TVs as a result of the digital TV transition. 65% of homes already have at least one HDTV, according to the Consumer Electronics Association.

A standalone box is going to to be an even harder sell to all but the geeks. The market is littered with unsuccessful standalone boxes from hard drive and networking gear manufacturers. They’ve all suffered from poor retail support and complexity of set up.

For Google to succeed, it will have to spend a lot more money on buyer education than it traditionally has.

See also:

More on: Google, television

Posted in apple, apple tv, google, television | 7 Comments

Geo-enabled Twitter comes alive on Twitter Maps

Posted on May 11, 2010 by Rakesh Agrawal
Bing's Twitter Maps show you what's going on

Bing's Twitter Maps show you what's going on

I’ve been playing with Bing’s Twitter Maps lately and it’s one of the better implementations of Twitter’s geo APIs that were introduced last fall. It shows tweets within the last 7 days plotted on the map. Google Maps recently introduced a similar feature, but it seems to only show items that are fed through Google Buzz (including tweets that people have configured to send to Buzz).

Some future applications of geo-enabled Tweets:

  • Events. For last-minute party goers, a real time view of what’s going on around town, complete with pictures and real-time reactions.
  • Ticket scalping. Rather than walk around for blocks talking to scalpers about what they have, glance at a list of tickets posted. The information transparency would result in a higher price to sellers and a lower price to buyers than what scalpers typically offer. (In my experience at baseball games, scalpers usually ask at least 3x what they paid.)
  • Finding a place to go. When in new cities, it’s often hard to figure out where to go — what are the lively neighborhoods at night. By looking at a map of recent tweets, you could quickly discover where people are still awake.
  • Read reviews from friends. Geo-enabled tweets filtered by those you follow would provide socially relevant recommendations.
  • Offers from local businesses. These could be persistent or distressed inventory. Slow night? Tweet an offer to draw in customers.
  • News. Twitter has long been used for user-generated breaking news. With geo-enabled tweets, breaking news could be aggregated by location in addition to hashtags. The biggest stories could be identified by an increase of tweets from a location (versus normal) and retweet frequency. News from media outlets could also be plotted.
  • Construction and accident information. Avoid bottlenecks by seeing tweets from fellow drivers, DOTs and news sites.
  • Trip sharing. Find others at the airport headed your way, cutting costs and reducing pollution.

And, of course, there’s friend finding, which is the most talked about use of geo-enabled tweets.

So far, the percentage of tweets I see with geo information is tiny (>1% of those I follow). But as more and more geotagged data is put into Twitter, the key will be applications providing the right tools to filter all of that data. At a minimum, we’ll need the ability to filter by time of tweet, people we’re following, hashtag and application (e.g. foursquare).

Unfortunately, bing’s Twitter Maps doesn’t seem to be available where real-time information would be most useful — on mobile devices.

More on: geotagging, social networking, Twitter

Posted in bing, geotagging, lbs, local search, maps, mobile, social networking, twitter | 3 Comments

Chart of the day: journalistic innumeracy illustrated

Posted on February 4, 2010 by Rakesh Agrawal

This Bloomberg graphic and its interpretation in the accompanying story is full of errors.

What would readers conclude after looking at the graph above?

  1. Best Buy sales have gone up at least 10 fold in the last 2 years. (Recession, what recession?)
  2. Best Buy’s monthly sales at the end of 2009 were roughly $22 million, at the peak of holiday season.
  3. Newegg is the #2 electronics retailer, after Best Buy. Amazon, buy.com, Walmart and Target aren’t players in electronics.

That’s what the graph says, but all of those conclusions are wrong.

In reality, Best Buy did $8.5 billion in revenue in December. In fiscal year 2009, Best Buy did $45 billion in revenue. $22 million in revenue is a rounding error.

What the graph really shows is how useless these Mint.com data are for analyzing consumer spending by category.

The reporter apparently didn’t understand the methodology behind Mint’s data. Mint allows consumers to track their credit and debit transactions. Consumers enter their account information and mint pulls transaction data from their banks and presents it online. Here’s how that methodology leads to the above erroneous conclusions:

  1. The enormous growth in the graph likely represents the growth in mint.com’s user base. Mint launched in September 2007 and has grown to 1.8 million users. (Mint was recently acquired by personal-finance software maker Intuit for $170 million.) Best Buy’s comparable store sales were down for fiscal year 2009 and up marginally for fiscal 2008.
  2. Only transactions by Mint’s users are included in this number, accounting for the multibillion-dollar difference. Even then, those numbers may not be complete as not all users import all accounts.
  3. Newegg is the #2 dedicated electronics player as classified by Mint. Because Mint collects transaction level data, not item level data, it doesn’t know what to do with purchases from diversified retailers like Amazon, buy.com and Walmart. (Amazon wouldn’t even show up as a leading bookseller; on my Mint account, it shows up as “Shopping”.) By Best Buy’s own definitions, consumer electronics only account for 36% of its revenue.

There’s also zero justification in the Mint data to support the chart’s caption that Best Buy generated these huge returns by “offering discounts on laptops and flat-panel televisions.”

These kind of errors are rampant in our business news because many reporters don’t understand numbers or methodology. When I was in school at the Medill School of Journalism, most classmates took the minimal math and economics classes they could and still get a journalism degree.

One of the most frequent numerical mistakes by journalists is confusing percent increases with percentage point increases. If your credit card’s interest rate goes from 10% to 15%, it’s a 5 percentage point increase, but a 50% increase.

This journalistic innumeracy hurts us all. We can’t make informed decisions about what government is doing if people don’t understand the numbers. Even basics get confused: journalists frequently confuse millions with billions (via Paul Kedrosky).

Journalists are at least partly to blame for the dot com bubble and the housing crash. Not understanding the economics, they repeated the lines of “experts,” such as investment bank analysts and real estate agents — most of whom had clear incentives to keep pumping air into the bubbles. I read many stories about how exotic mortgages were making housing more affordable. What was actually happening was that the easy availability of credit and flood of otherwise unqualified buyers in the marketplace drove up price. Basic supply and demand.

Unfortunately this problem is only going to get worse. Many of the sharpest minds I know from the journalism business have left to go on to other careers for many reasons — the difference in pay (often 2x or more), instability and constant layoffs and backward thinking management.

Additional analysis of the data also takes time, which is becoming harder to come by as newsrooms across the nation shrink. The pressure to do more “quick hits” like charts of the day will lead to more sloppiness and misinformation.

More on: journalism, newspapers

See also:

Posted in journalism, media, newspapers | 1 Comment

Plowing through the middleman

Posted on February 3, 2010 by Rakesh Agrawal
Snow plow in Arlington County

Snow plow in Arlington County. Creative Commons image by Ron Barber.

The snow day. Growing up in Michigan, it was always a treat. Whenever a significant amount of snow was in the forecast, I’d wake up early to see if I got the day off. I’d listen to the radio as the DJ went through the school closings or watch the crawl on the local morning news. It took some patience as they went through the list, but once in a while that patience was rewarded with a day off.

Kids today don’t have that level of suspense. As a fan of Arlington County on Facebook, my newsfeed showed that school is closed today. A quick check of the Arlington Public Schools Web site also provides that information. No more listening through “Angelus Academy, Anne Arundel Community College, Anne Arundel County Schools, Apple Montessori School, Aquinas and Old Town Montessori School…” (In a large metro area, this is killer.)

It’s yet another example of how media consumers can cut out the middle man and go directly to the source.

In much of the discussion about aggregators such as Google News and digg, what’s left out is that much of the media are themselves aggregators — compiling data from school districts, local businesses, funeral homes, police and fire agencies, etc.

Newspapers didn’t really get to play in the school closing game, but compilations of local events, lunch menus, high school sports scores, police blotters and obituaries have been a key part of the newspaper content mix. Such content is an even greater proportion of What People Care About. Many of these needs are now being better served online as easy-to-use tools such as Facebook, Twitter and flickr get adopted by these news sources.

Instead of reading about promotions and awards in the newspaper, I can get that information delivered to me through LinkedIn or Facebook status updates. Sadly, I’ve found out about the death of a high school classmate through Facebook.

And it’s a much better experience than what fits in a newspaper:

  • The filter is personal. It doesn’t matter whether that person was important enough in the eyes of a newspaper’s editor. I also don’t have to read through long lists of people I’m not interested in.
  • The content is richer. Clay Reid’s Facebook page is filled with photos and remembrances from friends.
  • It’s interactive. With promotions and job changes, I can quickly reach out to friends and congratulate them.

In the case of a snow day, you can make plans with your other friends who suddenly have the day free right on Facebook. And then upload the video of you snow blading down the hill.

More on: newspapers, facebook

Posted in facebook, journalism, media, newspapers, twitter | Comments Off on Plowing through the middleman

Twitter and foursquare: the tipping point to getting local business online

Posted on August 27, 2009 by Rakesh Agrawal
Crepe cart in Seattle

Crepe cart in Seattle

Getting small local businesses to go online has been the holy grail of the Internet. I’ve written before about some of the reasons local business don’t go online and suggested several ways that they could use emerging technologies to get online with minimal effort.

That finally seems to be happening. Whether it’s a crepe cart in Seattle, ice cream store in San Francisco or a restaurant in Sedona, businesses are using the simplicity of Twitter for their virtual presence.

Most local businesses are too busy running their business to exert a lot of effort maintaining an online presence. If it’s not easy, it won’t get done. My favorite example of a small business reusing their existing work is the Webcam pointed at the wall of Beachwood BBQ where they list the pints on tap.

The challenge is that these businesses are only announcing their presence to existing customers or passersby. While this can help drive repeat visits through specials, notices of new arrivals, etc. it does little to bring in new customers.

That’s where foursquare comes in. This location-based social game allows users to “check in” to places they visit. Check in often enough and you become the “mayor” of that place. Savvy businesses have latched on to this and begun offering discounts to their mayors.

It has also been incorporated into the foursquare check in process. When I checked in at a restaurant in Seattle, I was presented with an offer at a nearby bar: happy hour all day for the mayor or $1 off well drinks for anyone else who checked in. (Checking in updates your social network status, providing further exposure for the business.) It’s one of the first examples of location-based mobile advertising that works. The process is a bit cumbersome now, but it provides a glimpse into where the technology is headed.

In addition to providing exposure to businesses, it solves a user problem that local search has long failed at: discovery. People often don’t know what they’re looking for when they’re out. Suggestions, even if they’re sponsored, help fill the discovery gap.

Foursquare offer

foursquare mayor offer

Posted in foursquare, lbs, social networking, twitter | Comments Off on Twitter and foursquare: the tipping point to getting local business online

Building sandcastles on the Web

Posted on August 16, 2009 by Rakesh Agrawal
North American Sandsculpting Championship

2007 North American Sandsculpting Championship, Virgina Beach, Va.

As I’ve been figuring out what to do next, I’ve also spent a lot of time thinking about what I’ve done in the past. The sad reality of building Web products is that your work quickly disappears. Just as waves and winds tear down sandcastles, the rapid pace of innovation on the Web means that your best accomplishments get wiped away.

Despite all of the talk about newspapers having failed to innovate these are some of the things we did at the Star Tribune:

  • Created one of the first dynamic publishing systems.
  • Launched a local Yellow Pages product, complete with maps and driving directions.
  • Launched a home search with full MLS listings. Someone actually ran a tape over to the building from the MLS offices to make this work. It even had Google Street View-type pictures of all the homes in a neighborhood.
  • Created a searchable entertainment guide.

We even tried to get people to pay for news! (It didn’t work in the mid-’90s, it won’t work now.)

That work has been washed away, as has most of my other work. My work at Tellme still exists, but experiencing that requires buying a new Ford.

Sure, I have screenshots of some of the products I’ve created. But they don’t capture the essence of  the work. If a Web site can be captured in a screenshot, its creator didn’t do a good job.

My longest lasting legacy is partnering with genius designer Jamie Hutt to create the weather mascot for startribune.com. Someone had pointed out that there was a thermometer on the roof of the Star Tribune building that was recording the temperature for the Strib’s audiotext system. We decided to incorporate that reading on to the front page. To capture some local flavor, we made the weather icon a snowman. He appears differently depending on the weather. This a typical summer look:

Star Tribune Snowman

My favorite is when it gets really hot — you see a puddle with glasses and a carrot. The snowman’s look and placement have changed over the years but the essence of the idea remains.

Posted in journalism, newspapers, product management | Comments Off on Building sandcastles on the Web