One free geocoding service I like is geocoder.us, and their conversion can be used just by typing the address into the field and hitting the submit button. They return GEO coordinates in a number of flavors, including degrees/minutes/seconds as well as in decimal degrees. When I enter Montparnasse’s street address, “230 East 51st Street, New York, NY” into geocoder.us, it returns GEO coordinates for a 51st Street in Manhattan, and a 51st Street in Brooklyn. The coordinates I’m wanting are for Manhattan, the first map, and I want the decimal version which is: Latitude of 40.756390, Longitude of -73.969789. … [Read more...] about How To Geocode An Address & Optimize Location Pages
Open the new file you created in Excel and delete extra columns you won’t need, such as “Backlinks Count,” “Referring Pages,” “First Seen” and “Last Check Column.” Go to “Insert” > “Table,” and make sure “My table has headers” is checked. Under the drop-down box for the “Domain Rating” column, uncheck “Domain Rating” so that these are filtered out. To get the count of appearances, in cell C2 enter the formula =COUNTIF(B:B,B2), assuming your root domains are in Column B now. Give this time to run, as it can take awhile, and interrupting it will stop processing the count early. Once this has calculated, copy the whole of “Column C” and paste it right over itself — use “Paste Special” as “Values,” and what was once a formula will now be a number. In “Column B” or Root Domains, use the “Remove Duplicates” tool … [Read more...] about Competitive Link Building Analysis For Your Industry
Q. Will This Make Me Millions Tomorrow? It takes time to accrue data because of all of this segmentation. It’s important to stress the long-term value of this strategy. I have explained it in detail to clients. They always have questions, but they always walk away convinced of the benefit and willing to spend the time necessary to build up the data because of the undeniable power in this level of segmentation. … [Read more...] about A Step-By-Step Guide To Query-Level Bidding In Google Shopping
I really hate reading articles where people say “I told you so” or blast someone’s techniques, but the recent crackdown and deindexing of blog networks is a great lesson in what can happen if you rely on any one method in link building. I know people who run these types of networks and I know people who use them, and I also really, really hate to see anything bad happen, regardless of what I think about the techniques used. … [Read more...] about Why A Diverse Link Profile Is More Critical Than Ever
The “last click wins” method of awarding affiliate commissions means that whichever affiliate is responsible for placing the most recent cookie on a user’s machine is awarded 100% commission for the sale. In this model, affiliates responsible for earlier cookies or impressions do not prevail financially—they get nothing. The question is does the “last click wins” method box affiliates in to “clicks only” marketing channels? Could brand holders gain greater reach if, for example, affiliates could take advantage of behavioral retargeting (BR), content channels and post impression cookies (PI)? Lately, I have seen lively blog postings and discussions around behavioral retargeting and its relevance to CPA models. … [Read more...] about Is The “Last Click Wins” Model Best For Your Affiliates?