PHP and SQL: Calculate or Query Distance Between Points of Latitude and Longitude

This month I’ve been programming quite a bit in PHP and MySQL with respect to GIS. Snooping around the net, I actually had a hard time finding some of the Geographic calculations to find the distance between two locations so I wanted to share them here. The simple way of calculating a distance between two points is using the Pythagorean formula to calculate the hypotenuse of a triangle (A² + B² = C²). This is

MQLs Are Passé – Are You Generating MQMs?

The MQM is the new marketing currency. Marketing-qualified meetings (MQM) with prospects and customers drive the sales cycle faster and increase revenue pipeline better. If you are not digitizing the last mile of your marketing campaigns that leads to more customer wins, it’s time to consider the latest marketing innovation. We are well into a game-changing transition from the world of MQLs to a world in which conversation-ready leads are the primary marketing currency.  The

What Data-Related Tools Are Marketers Using to Measure and Analyze?

One of the most shared posts we’ve ever written was on what analytics is and the types of analytics tools available to help marketers monitor their performance, analyze opportunities for improvement, and measure response and user behavior. But what tools are marketers using? According to Econsultancy’s latest survey, Marketers utilize web analytics overwhelmingly, then Excel, social analytics, mobile analytics, A/B or multivariate testing, relational databases (SQL), business intelligence platforms, tag management, attribution solutions, campaign automation,

The Playbook for B2B Online Marketing

This is a fantastic infographic on the strategies deployed by just about every successful business-to-business online strategy. As we work with our customers, this is fairly close to the overall look and feel of our engagements. Simply doing B2B online marketing is not going to maximize success and your website isn’t going to just magically generate new business because it’s there and it looks good. You need the right strategies to attract visitors and convert

WordPress and MySQL: What’s Your Word Count?

There’s been some talk on blogs about the average size of a WordPress post. Some light has been shed that Search Engines will only weigh the impact of the first x number of characters, where x is currently unknown. As a result, anything after that is simply a waste of words. Image from Wordle! I’m rather garrulous with my blog posts so I’m going to do some additional analysis and see if the popularity of