Tag Archives: address

Geolocation Tricks and Techniques

Geolocation tipsIn our last blog post, we talked about assembling an email that uses location-specific data to personalize an email. We showed how you can use content blocks to offer information for specific store locations based on the subscriber’s address. In this article we will talk about how to use geolocation in email to personalize each mailing. We won’t be discussing how to obtain address information for your subscribers. There are plenty of articles on that subject, and most of the techniques (surveys, special offers, etc.) are easy to come up with. For now, we will assume you already have this information and would like to put it to better use. For our example, we’ll be using the address locations for the recipients, to show information about the nearest store.

Finding Geolocations for Email

You may have the street addresses for your recipients, and the physical locations of your stores, but these won’t do you much good as they are. It is hard to compute anything from a street address. After all, 1945 Polaris Place, North St. Paul, MN is a lot harder to use in a formula than 45 and -93. To find the actual geolocations, you’ll need the geographic coordinates—in other words, the latitude and longitude. This may sound a bit daunting, but obtaining this information is relatively easy. There are several online sites, such as Batch Geocode and GPS Visualizer that can generate latitude and longitude numbers from street addresses automatically. Now you have the geolocation data you need for your email marketing campaign, but you still need to convert that data into nearest store location information.

More Than Maps

There are some web sites that will automatically take your store address list and your subscriber list and convert these into maps, with arrows showing the store locations. This is relatively easy to do thanks to the online map features in Google, Bing, Mapquest, and others, but there are surprisingly few sites that will give you the same information as text, and it’s text we want to enter in our subscriber database. Online maps are fine for website use, where you are free to use Javascript in your design, but email affords us no such luxury. We can create our own maps as images to insert in the email, which is exactly what we did in the previous post with the content blocks, but we’ll still need actual data that identifies which map (or content block) to display for each customer.

If you have an IT department with a programmer available, the formula for finding the nearest store locations based on each of your recipient’s location information is a simple one. For those using SQL Server or MySQL, it is easy to compute because the formulas are built into these relational database management systems. For the IT department using other methods to compute these distances, here’s a web page that lists nearly every programming language method of accomplishing this.

Using Excel

For the company with a limited number of stores and/or a minimal IT department, we’ve created an Excel spreadsheet that computes the closest store based on each customer’s geolocation information. It has an area where you enter your store latitudes and longitudes, and another where you enter the latitudes and longitudes of your recipients. These should be simple copy and paste procedures from the data you’ve already obtained using the geocoding applications. The formulas in the spreadsheet then compute the distances between the stores and the addresses, and compare them to find the closest store.

Excel geolocation spreadsheetAside from any adjustments you need to make for additional stores (our sample is set up for three), the only things you need to know are the latitudes and longitudes for your stores and your subscriber addresses. The best thing about this spreadsheet is that you don’t have to figure out the formula to use it. We’ve already entered the basic trigonometric function for finding the nearest location. You can simply plug in the values and let Excel do the rest. Computing the closest location involves several steps. We have broken these steps down in our Excel spreadsheet to make it easier to understand. Download the Excel spreadsheet here.

Once the values are computed, it’s a simple matter to import this data into a column in our original subscriber list. Now we have values we can work with. We can use this data to match the content block with the recipient, as we demonstrated in the previous post:

dynamic content blocksWe can also use the data directly via mail merge or dynamic content to add individual details to the content, or the subject line (example: “Don’t miss the 40% off sale at our Stonestown store, this weekend”).

All The Data You Want

Of course, you don’t have to create a field containing the nearest store location. You can enter the geolocation data into your recipient demographics and work with it directly. With some email marketing software (such as Symphonie), you can create a custom mail merge tag that will run the mathematical logic to calculate the nearest store on-the-fly. This can be useful if you are computing many different distances, or your IT department can’t provide the resources when you need them.

Also keep in mind that it doesn’t have to be store locations. In our last post, we used similar data to compute the favorite teams for various locations. By creating separate fields for favorite teams we were able to use the data both for dynamic content purposes (example: If recipient lives in San Francisco, show the Giants image) and for merge purposes (Inserting the “favorite team” field in the email content).

Fine-tuning the Data

One thing this technique doesn’t take into account is the fact that some people don’t choose to shop at the store nearest to them. They might not like the location, or the personnel, or maybe they are using a mail drop that is located in another part of town. Gathering actual in-store data requires either a POS system that connects to membership information, or the credit card information obtained during purchases. As a rule, this isn’t that critical. Most people will understand why you showed the closest store. If someone does complain, you can always adjust their nearest store information to reflect their preference.

If you’re collecting address data as part of your email marketing effort, the best way to maximize the usefulness of that data is by adding geolocation data to the mix.

Go to Goolara website

Of Senders and Subject Lines

Good email practices start with the sender and subject lines. If you don’t have these in order, nothing else matters. Here are some ideas for improving your deliverability.

dynamic content in subject line

Try this little experiment: Go to your email software, be it Gmail, Outlook, or whatever, and open it. Quick, what do you see? The first thing you’ll notice is the sender. It is usually the first item on the left, or appears above the subject line, often in bolder type than the subject line. Given this fact, it is safe to say that nothing is more important than a good-looking sender address, especially when one looks at the statistics: 64 percent of small businesses executives said they decide whether or not to open an email newsletter based on the sender,1 and over 50 percent of respondents cited knowing and trusting the sender as the primary reason for opening an email in the first place.2 Even more disturbing, 73 percent of people decide to click on the “report spam” or “junk” button based on the sender’s email address alone!3 Ideally, your sender information should be personalized enough so that they see either a name or company, or some other title that has meaning to them (“Advanced Widgets Weekly Newsletter”). Ideally, your Sender name should make sense to the recipient. If the mail is a newsletter, a sender name that contains the company name and the word “news,” or “newsletter” is helpful. If your company is large enough to have different branches with different branding, then it’s a good idea make sure the domain matches the sender information.

The second thing they notice, obviously enough, is the subject line. If the sender’s address has done its job, the subject line won’t have to work quite as hard to catch the reader’s attention, but that doesn’t mean you’re out of the woods yet. 35 percent of email users open messages because of the subject line. A relevant subject line is going to have a better open rate than a generic one, naturally, but what does “relevant” mean exactly? In one sense, it means a subject line that is personalized for the recipient, but when most people think of a personalized subject, the first thing that comes to mind is the dreaded “[First_Name], have we got a deal for you.” The ability to insert merge tags into subject lines has been so thoroughly overused by spammers that doing it at all is a risky proposition. It might be okay for a triggered email, such as a birthday greeting or anniversary, but even here, we caution against making a first name merge tag the first element in the subject line. Several studies report that people react more favorably to this tactic when the name is inserted at the end of the message (e.g., “Here’s a birthday coupon for you, Jim”). Others studies suggest that using the first name in a subject line at all is the kiss of death.

Dynamic Subject Line

A far better approach to subject line personalization is to use dynamic content instead of merge tags. So what’s the difference? A merge tag is simply a piece of information stored in a recipient’s demographics. First and last name, address, city, state, membership level, most recent purchase, age, gender, etc. are all examples of merge tags. Even the most basic email marketing application can insert one of these at any point in the email and the subject line. Dynamic content, on the other hand, is not a fixed piece of information, but is a form of request based on one or several variables. It is often represented in an “If/Then” format (if x is true, then do this). It can take the information in the demographics and break it down further (into age groups for instance), or combine two or more demographics to yield different results (women in California, for example).

Dynamic content requires a bit more advanced planning, but it pays off in the end. For example, if you want to offer people different discount rates based on their membership levels, you could create a logic condition that says if the customer’s membership level is gold, the subject line should read, “Here’s your 20% Gold Member only discount coupon,” while for everyone else it should read, “Here’s your 10% discount coupon for our store.” It is also possible to use more than one block of dynamic content in a subject line, so that, if you wanted to steer people to certain departments based on past purchasing patterns, or other demographics, such as age or gender, you can add these conditionals to the subject line as well. Clever combinations of dynamic content can make a subject line appear hand-typed specifically for a recipient.

Dynamic Sender

An even more powerful feature for email marketing is the ability to change the sender dynamically. As previously mentioned, the sender is the first thing anyone sees. With dynamic content, you could, for example, change the sender based on where a recipient lives. In that case, the mail could come from your West Coast representative for anyone residing in California, Oregon, or Washington; or a department store may want to assign reply duties to whichever department a recipient shops in the most.

Not all email marketing software offers the ability to add dynamic content to the sender and subject lines, but it is a feature you shouldn’t overlook. Marketers are moving away from simple email blasting, and beyond social media connectivity, with a trend toward using data to provide a unique experience for each email recipient. The business that is already doing this is ahead of the game.

To learn more about the dynamic content capabilities available in Goolara Symphonie, click here to visit the Features section of our website.

1Bredin Business Information
3Email Sender and Provider Coalition

Go to Goolara website