City and Geo targetting in OpenX with maxmind GeoIP
I recently figured out how to do city level Geo targetting with OpenX ad server and spent many hours trying to find documentation on this feature.
I’ve summarized the process below.
First follow these two articles:
http://www.openx.org/en/support/geotargeting
http://www.openx.org/node/119
to get the basic Geo Targetting setup with the MaxMind DB.
Now download additional binary databases (.dat) from Maxmind, like the GeoIP city database. This database is free and contains information regarding US/Canada States, region codes and city.
Unzip these .dat databases to path on your server.
Now for additional Geo Targetting simply go back to the Global Settings -> GeoTargetting page in Open X.
There will be a number of database/path options. Simply fill in the path information with the linux/unix path to the specified database.
On my setup I have:
MaxMind GeoIP City Database Location: /home/usr/my/path/to/the/db/GeoLiteCity.dat
I could continue to insert more databases, or update as needed.
After completing the above steps you will now be able to target to the specified Geo regions and your database will record the information for later analysis if you desire.
AS you’ve probably seen by now, you may also purchase additional databases and more up to date databases. It all depends on how specific you need to get.
Happy Ad Serving!
Related posts: