content developer build share monetize content developer logo content developer masthead bottom

Open Source Geo Targeting

Should a member of your audience in see the exact same content as someone viewing from ?

Many times the answer to that question is no, meaning that as the process for globally distributing digital content continues to get faster, cheaper and easier, content developers now have a new challenge —

How do we package and present what we build in a way that maximizes its value to an audience, no matter where on the planet that audience might be located?

are you leveraging your content for a global audience?

One strategy content developers can use to help better serve this global audience is something known as .

In a nutshell, geo targeting is the process of capturing a user’s or other identifying information, checking that info against a database that suggests the likely geographic location of that user, and then serving up targeted, customized content based on those results.

Though used for delivering all types of content, one area where the use of geo targeting is rapidly spreading is in online advertising. If you’ve farmed out the management of your ad inventory to a third party advertising network like , the , , etc… , then in many cases they are taking care of this geo targeting for you by placing ads with not only but geographic value as well.

Make no mistake. Those ad networks provide an awesome service and are playing a major part in empowering emerging content developers to monetize their work without having to worry about selling ads directly. But what if through hard work and good fortune you’ve grown to the point where you now want the ability to control your ad inventory to a much finer degree?

Have the tools to implement an ad delivery platform with geo targeting capabilities progressed to the point where they’re reliable and accessible to the small to mid sized independent content developer?

I was recently involved in building the infrastructure for a project that was looking to have this kind of geo targeting capability integrated into a self managed online advertising delivery platform. And based on what was learned during that experience I’d say the independent content developer and publisher does have some options.

Here’s a quick summary -

First, this project adopted an philosophy from the ground up going with a based running , and . This close cousin of was bundled with as the .

Since we were building on this type of foundation, staying with a MySQL/PHP based solution for the ad delivery component was the preferred option. After considering a couple of different packages out there, was selected to handle advertising delivery and management.

I wasn’t familiar with OpenAds before this project, but am very quickly becoming a fan. The power it gives the publisher who wants to control their ad inventory is pretty impressive for an open source application.

Rather than going into great detail about OpenAds here, the best way to learn about it may be to check out the for yourself. It can provide you with a pretty good idea of what the app is all about.

If you’re accustomed to installing PHP/MySQL based apps like Wordpress, then the OpenAds and will likely be in your comfort zone. But if you need some help, that’s ok too as they offer for large scale needs, and you can find as well.


screenshot of

Ok, so now that your ad delivery platform in place, how exactly do you add geo targeting capability?

Well, one nice thing about OpenAds is that most of the geo targeting groundwork is done for you in the existing code. One item that is left for you to do is acquire one of the GeoIP databases available from . You can choose to either purchase, download and install a database on your own server or to subscribe to a from MaxMind and receive the information from their servers.

Once acquiring the database you plug it into OpenAds via filling out some form fields within your OpenAds admin area.

There are several geo targeting databases available from MaxMind. You can filter by country, region, city, zip code, area code and more. As one might expect, the more detailed your needs the more expensive your database will likely be.


openads table of maxmind geo targeting databases

You can also try before you buy. MaxMind offers lite versions of some of their databases that you can download and install into OpenAds for free. I went this route and installed their , which is similar to their more robust paid version, just not as accurate and with no support. If you decide you need the extra accuracy and/or support a full version provides, then they drop in right on top of the lite versions.

Nice touch.

After downloading and installing the GeoLite City version, I built a down and dirty test ad campaign and designated it to only be delivered to users based in . I then visited the site from a San Antonio ISP and received that ad. Next, I changed the campaign delivery options to not deliver the ad to San Antonio. I visited the site again and this time was not shown that ad and received a default banner instead.

Simple as that.

Further testing since then has proven the lite version of this database to be more accurate than I expected.

openads-states.jpg
screenshot of selecting geo targeting delivery options in openads

Now if this all sounds too easy so far, then let’s balance things out for a moment here.

OpenAds does have a learning curve.

If you’re familiar with the online advertising world and the general concepts and language spoken there, that then that should help you some. But if you don’t know your from your then you may want spend a little time at the . Among other resources, they offer a helpful rundown of that can help get you up to speed quickly.

With OpenAds you’re remarkably free to customize your online ad delivery strategy as you see fit, but if you’re going to be running ads from a wide variety of sources these ad units are the standards many entrenched media buyers look for.

Having spent some time in close proximity to the ad world, this part was familiar to me. Still, the actual step by step process for setting up my first campaign did involve some trial and error learning along the way. From this experience, I’d characterize the OpenAds documentation as adequate, but not exactly exceptional.

Also be aware that there are some scenarios where this approach to geo targeting may not produce the desired results. For example, a user visiting a web site during work from a corporate office on the west coast might be identified by the ip address assigned to the corporate headquarters on the east coast. I’d imagine that just about any user accessing the web via a runs a high risk of being misidentified.

Another scenario where geo targeting may force content on a user they do not want would be say an English speaking user visiting your site from Germany who doesn’t want to see German Language content or ads but actually wants the English version.

There are workarounds to issues like these, but it’s important to keep in mind that geo targeting isn’t foolproof.

Still, considering the extra power to customize what content you can deliver to your audience based on their location, the tradeoffs may be worth it to you.

Another benefit of adopting an ad delivery platform like OpenAds is that you can keep your existing Google Adwords, Yahoo Publisher Network etc… ads and rotate them with your new locally managed inventory.

In other words, if you don’t have an ad sold yourself, you can fill the inventory with an ad from one of the ad networks. This is a great feature that some of the newer ad networks like offer as well.

One final note. The more I worked on this project the more I got to thinking that with a little work a content developer could adopt OpenAds as a vehicle for delivering all types of geo targeted content. Not just ads.

All the power and technology is there. Apply a little of your creativity and OpenAds could be a tool that helps you give your global audience more of what they’re looking for.

———–

A couple related items -

- When this project began, also offered a geo targeting database that worked with OpenAds, but sometime along the way they appear to have stopped selling it to the public.

- While working on this project, OpenAds raised . And they’re .

- The banner insertion code generated by OpenAds didn’t pass the without some tweaking. There are some solutions offered up on the . I tried which involves modifying some of the existing PHP files. It seemed to solve most of the problems, but am still trying to chase down one issue.

- offers a for advertisers. It’s a quick read and may help frame the issue from the advertiser’s perspective.

- If you’re looking for more help in understanding the language of the online ad man , the IAB also offers a . hosts a decent but it appears to be missing some of the interactive and online advertising terminology. As of the date of this post, I did not see geo targeting listed in either.

- You may have seen this strategy referred to as one word GeoTargeting, two words as Geo Targeting, or hyphenated as Geo-Targeting. Not sure which is the best choice, but for this article Geo Targeting got the nod.

UPDATE 02-15-08: OpenAds has rebranded itself as OpenX. The OpenAds urls are being redirected to the new website at .

gray line

Filed under distribution by david cummings on Saturday 30 June 2007 at 6:44 pm

  |   Sphere: Related Content

Comments »

No comments yet.

RSS feed for comments on this post.

Leave a comment

Next article: Is the iPhone Friendly to Content Developers?
Previous article: Using Skype For Podcasting And Production.

spacer

More Fresh Content -- The Latest Activity on the Content Developer Network.

spacer

Content Developer Bookmarks

Partuza
Partuza is an example Open Social site that uses Apache Shindig. Helps open social developers to develop on local, open social compliant servers. Offers example of how to implement open social support using shindig on your own social site. Bookmarked 06/17/2009.

Twilio
Twilio provides a telephony API in the cloud for voice communications that leverages existing web development skills, resources and infrastructure. Bookmarked 06/08/2009.

vi.sualize.us
vi.sualize.us is a social bookmarking website for visual content. Save, tag, organize and share images that you locate around the web. Bookmarked 05/26/2009.

PCI Security Standards Council
The PCI Security Standards Council is an open global forum for the ongoing development, enhancement, storage, dissemination and implementation of security standards for account data protection. Bookmarked 05/14/2009.

Tracer
Tracer helps measure user engagement on your site by tracking copy and paste activity. Automatically highlights and adds a link back to your excerpted content when it is pasted somewhere else. Bookmarked 05/14/2009.

iPlotz
iPlotz helps you rapidly create clickable, navigable mockups and wireframes for prototyping websites and software applications. Invite others to comment on designs and manage tasks for developers and designers to build the project. Bookmarked 05/04/2009.

Visible Measures
Visible Measures is an independent third-party measurement firm for Internet video publishers, advertisers, and viral marketers. Bookmarked 05/03/2009.

more del.icio.us bookmarks...

Content Developer on Twitter

contentdevelopr: Charlie Rose conversation about Cyberwarfare w/ Michael McConnell, James Lewis and David Sanger: http://is.gd/1lHt2
Tweet sent at 02:30 PM on 07/02/2009.

contentdevelopr: Looking at the new Online Publishers Association ad formats. The “Pushdown” will be huge. Literally. http://is.gd/1kS5z
Tweet sent at 01:50 PM on 07/02/2009.

contentdevelopr: RT @copyblogger The Myth of the Tortured Writer - http://is.gd/1k737
Tweet sent at 03:42 PM on 07/01/2009.

contentdevelopr: RT @diamondsf Great article on the 9 ways people respond to your content http://bit.ly/pU9Hq
Tweet sent at 10:03 AM on 07/01/2009.

contentdevelopr: RT @bolora Great article on the visual aesthetics of sites - http://bit.ly/15ZNhQ #userexperience
Tweet sent at 09:34 AM on 07/01/2009.

contentdevelopr: Liked the @rocketboomtech video tour of The Computer History Museum with @elspethjane - http://is.gd/1hw5t
Tweet sent at 02:43 PM on 06/29/2009.

contentdevelopr: Learning about AdSense for Mobile Applications: Targeted ads for Android and iPhone apps: www.google.com/ads/mobileapps/
Tweet sent at 10:45 AM on 06/26/2009.

contentdevelopr: The name says it all: The “Smells like Facebook” @WordPress theme. http://is.gd/1dwZi
Tweet sent at 09:56 AM on 06/26/2009.

contentdevelopr: Trying out latest release of @twidroid.
Tweet sent at 06:06 PM on 06/23/2009.

follow content developer on twitter...

spacer

Best of the Web -- Recommended Blogs & News for Content Developers.

spacer

The Business of Content

Gannett Memo Lays Out 1400 Layoffs, Restructuring
Editor & Publisher 07/02/2009 05:25 PM

The Infamous 2009 LimeWire Pizza Fiasco
TechCrunch 07/02/2009 05:08 PM

Want People To Look At Your Ad? Run It On TV, Not Online
Paid Content 07/02/2009 05:00 PM

Yahoo Product Head and CTO Ari Balogh Speaks! [BoomTown]
All things D 07/02/2009 04:05 PM

CHART OF THE DAY: Search Ads Aren't As "Helpful" As Google Suggests
Silicon Alley Insider 07/02/2009 03:47 PM

Akamai to Make iPhone Video Streaming Smooth
GigaOm 07/02/2009 03:29 PM

Facebook Rolls Out New Privacy Features
Digital Media Wire 07/02/2009 02:32 PM

Search, Marketing & Social Media

eMusic Users Revolt Over Latest Changes
ReadWriteWeb 07/02/2009 04:06 PM

FriendFeed Adds Real-Time Search Results
Mashable 07/02/2009 02:47 PM

Feedburner Add Customizable Subject Lines to Email Subscriptions
Pro Blogger 07/02/2009 09:38 AM

Facebook’s Awkward Adolescence
Web Strategy by Jeremiah 07/02/2009 08:21 AM

Glynne Soaps- Beer-Flavored Soap and Online Presence
Chris Brogan 07/02/2009 05:41 AM

Refresher Course: BROKEN WINDOWS
Brand Autopsy 07/01/2009 10:17 PM

Pocket Communications Officially Launches Today in Corpus Christi
Alan Weinkrantz 07/01/2009 09:51 AM

Introducing the ClackPoint gadget
Google Social Web Blog 06/30/2009 12:47 PM

Indie Film, Web & Mobile

LG eyes number two phone maker spot for 2012, premium brand in the works
Engadget Mobile 07/02/2009 05:25 PM

Quick App: Rolando 2 Quest for the Golden Orchid for iPhone
The iPhone Blog 07/02/2009 04:10 PM

Cablevision and the Supreme Court
John August 07/02/2009 02:09 PM

Atlanta Motion Graphics Festival, July 10-12
SXSW 07/02/2009 10:16 AM

HIGHSCREEN PP5420 dual-touchscreen Android phone for Russia
Android Community 07/02/2009 05:48 AM

Video: Forecasting the Future of Public Media, from Silverdocs
CinemaTech 07/01/2009 11:29 AM

Webmaster Central YouTube update for June 22nd - 26th
Google Webmaster Central 06/30/2009 12:22 PM

Lunch with Filmmakers @ 2009 SA Film Festival
Film San Antonio 06/25/2009 04:26 PM

spacer

Recent Comments & Questions from Content Developer Users.

spacer

Comment on Open Source SMS Text Messaging Application by Robert Thiele
A Linux SMS virtual appliance management server that is teacher controlled. Wireless Test Administration for K12 and beyond. http://messaging4education.com - Comment left on 06/05/2009.

Comment on Add Video Mime Type for 3gp Video on Apache Server by sherief
actually i would like to know about youtube i want to know what is the server options that needed to make a web site like youtube .. - Comment left on 05/26/2009.

Comment on Open Source SMS Text Messaging Application by tom
Thank you for your post. My workplace is interested in being able to do more with SMS, but, I hear that previous attempts at your approach have seen problems with spam filters blocking the messages. (This could be caused by the fact that we had been an ISP for 10 years, and were the AOL of hte local scene). My question for you is this: Have you had much problem with messages not getting through, because they were rejected as spam? What did oyu have to do to correct it? - Comment left on 03/19/2009.

Comment on Open Source SMS Text Messaging Application by David Johnson
Would you be willing to share the code you wrote so we can use it? - Comment left on 02/16/2009.

Comment on Netflix Watch Now Movie Download Service. by Jane Sanjay
I'm having problems viewing Netflix on my Mac Intel 10.4, and wondering if you have any ideas...I keep getting this error message: "Individualization failed. Unable to play back protect (DRM) content. Error Code 8152." I have re-installed Silverlight 3 times, dealt with damaged fonts on my system, turned off the firewall, all too no avail. Should I be also installing the etflix Movie Player on my Mac? If so, where can it be found? - Comment left on 02/06/2009.

comment feed...

spacer
Content Developer is a San Antonio, Texas web development consultant & online/interactive marketing strategist focused on the creation, distribution and monetization of multi-platform digital content and how sharing knowledge via & can be more effective than traditional advertising for building brands. Learn more.

Content Developer is powered by Wordpress. ContentDeveloper.com and build. share. monetize. are trademarks of Cummings Hatton Corporation.