To focus my Google Adwords campaign for promoting lead generator ebook, I found all the unique IPs for the downleads by doing (rails 3.2 webapp):
ips = Download.select('DISTINCT ips')
list = ips.collect(&:ip)
Paste the ip list as a single column on the Convert IP to Country website. Very interesting fact:
50% of the downloads is from USA. So it is better to follow the Google Ad support person's advice of targeting to one or two geographical locations.
