Gain advanced insights on your business when you visualize your data analysis. You’re probably swimming in data, in Excel, Salesforce, or another CRM. Understand the story within your data by plotting it on a map. Any geographic information, from full addresses to names of regions can be converted to geo coordinates. Viewed spatially, you’ll get a whole other angle at your customers, leads, or assets data.

View Household income, average clustering in a full screen map

For example, the map above shows the median income for every county in the United States. Better yet, using clustering technology, we can get a summary of the underlying data at any zoom level. Now imagine that this contained your revenue by region or the spending power of your customers. Quickly, you’re able to see the most successful areas, in ways that are difficult or impossible when your data is sitting inside a spreadsheet or CRM.

Ready to map your customers? Let’s get started with the simple two step process.

1. Find Your Customer Locations

Before you can plot your customers on a map, you need to know where they live or work. This can come from many sources, and you likely have it already. If you don’t, you may be able to gather it from the data that you do have. The level of detail for location can vary, yet even non-granular data can provide good insights.

Some of the location data you may have about your customers includes:

• Full address
• Zip code
• City name
• County name
• State name
• Country name

Any of the above can be converted to geo coordinates. If you have none of the above, all is not lost. Here are two additional ideas for finding your customer’s locations:

1. IP address: If they have visited your website, you have their IP address, or Internet Protocol address. This series of numbers identifies their computer, network, or internet service provider. Usually, these can be converted to at least a regional location. BatchGeo automatically detects and geolocates IP addresses in your data.
2. Email address: Many companies collect the email address of customers when they create accounts or to send receipts for purchases. There are data enrichment companies, such as FullContact or Clearbit, that will take a list of email addresses and return name, location, and other data about the person behind the email address.

Once you have some location data, you can easily create a map from it.

2. Map Your Excel Data

Many companies keep customer data in Excel and other spreadsheets. Even if that’s not the “source of truth,” Excel is where many filter and analyze their data. That’s why BatchGeo has chosen spreadsheets as the primary way to get data into our mapping platform.

From within your spreadsheet program, highlight all your data, including the headers. Use Ctrl+C (Cmd+C on Mac) to copy the data. Then go to the Excel mapping tool on the BatchGeo homepage and put the data in the main box using Ctrl+V (Cmd+V on Mac) to paste.

The video above walks through a basic map, or you can find a full Excel mapping tutorial that walks through step by step.

View Example Sales Map in a full screen map

The result is a map with a marker for every row in your spreadsheet. In the case of the map above, we used aggregated state-level data, but you could show individual customers or leads. Any data that has a location is fair game for a map.

Export Data From Your CRM

Many times the source of truth for customer data is in one or more systems, such as customer relationship management (CRM) software. You’ll frequently want to use this data outside of your CRM, such as when you want to create mail/email campaigns, analyze in Excel, or create a map from the data.

Any good CRM should have the ability to export your data. If it doesn’t, you should probably get a new CRM, even though it will take a lot of effort to duplicate your existing data (since you can’t export). You might ask about an API (Application Programmer Interface), which is a more technical option to get your data. Unless you’re a programmer, you’ll need someone else to use it, but an API often means there are existing tools that others have wrote to help you retrieve your data.

The most common file formats when exporting from your CRM are:

• CSV (Comma-separated values)
• Tab-delimited
• Excel

Any of the above will work to create a map using BatchGeo. Excel can read or import any of those file types, then you can copy from the spreadsheet as described above in step 2.

How you export will vary depending on the software you use. For example, in Salesforce you would use the Data Loader export wizard to create a CSV to download. You should be able to search the help section of your CRM or ask for technical support to help export your data.

Make Your Customer Map Today

Start uncovering the story behind your customer data. Create a map now with a simple copy-paste of your spreadsheet or CRM data.

Religion may be a touchy subject, but that’s because it’s filled with a lot of feeling. As much as 80% of the world identifies with a religion, most of which have hundreds or thousands of years of history. Rather than feeling, this post is brimming with data. We’ve mapped every country in the world below, along with the religious demographics of each country. Using the grouping features of BatchGeo, you can explore the rich dataset visually, the best way to understand the details behind the data.

View Religions by Country in a full screen map

For example, click the button in the lower left of the map, currently labeled “Region.” You can choose any of the various fields of data to zero in on a religion, region, or other field. Better yet, you can mix and match, to answer questions like “what religion is most popular in countries with the most people who don’t affiliate with a religion?” You can find the answer by selecting Unaffiliated, choosing the highest range, then looking at the ranges still available as you choose the other fields. You’ll find Buddhism and Folk Religions about equal with unaffiliated in a handful of Asian countries. There are also a number of Christian countries, especially in Europe, with large numbers of unaffiliated people.

There are many ways to go through the data yourself (based on this Wikipedia page). We’ll cover the highlights by religion below.

Christianity Around the World

Christianity is the most widespread religion in the world, with 157 countries with a majority who identify as Christian. There are 2.1 billion Christians, almost one third of the the world population. The United States has the most number of Christians by whole numbers, with nearly 250 million. Brazil (173M), Mexico (107M), and Russia (104M) join the U.S. in the hundreds of millions of Christians.

Yet, percentage-wise, none of those countries even make the top 25 Christian nations in terms of percentages. There are five countries with 99% or higher rate of Christianity, with one country reaching 100%. Once you know it, you won’t be surprised: Vatican City (within Italy, but officially a country), home of the Pope, has 800 residents, every single one a Christian. The other countries with at least 99% Christians are Tokelau (99.8%) in Polynesia, Timor-Leste (99.6%) in Southeastern Asia, Romania (99.5%), and Papua New Guinea (99.2%). While Tokelau has a small population (1,400), the others are over a million each, with Romania at over 20 million.

While Christianity is spread throughout the world more than other religions, there are clumps of high percentage practitioners. Latin America, the South Pacific, Southern Africa, and Europe all have multiple countries with at least 90% Christian residents.

On the flip side, there are many countries with only a very few Christians. Somalia, with a population of over 9 million, is home to 100 Christians, or one-thousandth of a percent of the population. Most of its citizens are Muslim, as are other countries with few Christians, including Morocco, Afghanistan, Tunisia, and Yemen.

Islam Around the World

Islam is the religion practiced by Muslims, and it is second only to Christianity in popularity worldwide. There are 1.5 billion Muslims, accounting for 23% of the world. There are 49 majority Muslim countries, making Islam and Christianity the only religions with more than 10 countries with majority populations.

Indonesia has over 200 million Muslims, more than any other country. Others with 100 million or more are India (176M), Pakistan (167M), and Bangladesh (133M). Only one of these, Pakistan, is top 25 in percentages. It has the 23rd most Muslims by percentage. Nine countries have 99% or more of their population practicing Islam: Morocco (99.9%), Somalia (99.8%), Afghanistan (99.7%), Iran (99.5%), Tunisia (99.5%), Yemen (99.1%), Mauritania (99.1%), Northern Cyprus (99%), and Iraq (99%). With the exception of Northern Cyprus, these countries have populations ranging from 3.4 million to over 70 million.

Unsurprisingly, the countries with the highest number of Muslims are clustered in the Middle East, including Northern Africa and into Central Asia. By contrast, there are 45 countries that apparently have no Muslims. The lowest number reported is Falkland Islands with nine Muslims, which makes up 0.3% of the South American country.

Hinduism Around the World

Though it doesn’t get the television news coverage of Christianity and Islam, Hinduism is the religion of over a billion people, or 15% of the world population. Yet, most of them live in one country.

The vast majority of Hindus live in India, where 973 million people make up almost 80% of the country’s people. The rest of the top five include Nepal (24M), Bangladesh (13M), Indonesia (4M), and Pakistan (3.2M). Among those, Nepal barely tops India in terms of percentage Hindu. Nearly 81% of Nepalese are Hindu. Only one other country is majority Hindu, Mauritius, in Eastern Africa.

Buddhism Around the World

The religion of Buddha is the fourth-most popular religion, the practice of just under 500,000 worldwide. While not in the billions like the others, that’s still 7% of the population. While more than half of Buddhists live in China (244M), there are several other countries with many that follow The Buddha. The top five are rounded out with Thailand (64M), Japan (45M), Burma (38M), and Vietnam (15M).

In terms of percentages, a couple of those same countries make the list. Cambodia is first percentage-wise, at 96.9%. It’s also the sixth-most in total numbers. Thailand (93.2%), Burma (80.1%), Bhutan (74.7%), and Sri Lanka (69.3%) fill out the top five. Only two others, Laos and Mongolia, are majority Buddhist. As is likely obvious from the list, Buddhism is most popular in Southern and Southeast Asia.

Folk Religions Around the World

Unlike the other religions on the map, this group is made up of many small religions based on cultural or ethnic elements. These folk religions, as they are known, are separate from organized religions, though they may borrow some elements of one or more popular religions.

There are about 400,000 people who practice a folk religion. While that’s a small number compared to the major religions, it’s still nearly 6% of the world population. The bulk of the practitioners are in China (293M), where folk religions make up over 20% of its population. There are 5 million or more in four other countries: Vietnam (42M), Taiwan (10M), India (6M), and Brazil (5M). Macau in Eastern Asia is the only country that is a majority folk religion (58.9%). Vietnam (45%) and Taiwan (44%) are nearly so.

Judaism Around the World

The last on the list of affiliated religions is Judaism. There are 13 million Jewish people in the world, accounting for just one-fifth of a percent of the worldwide population. The United States and Israel are home to most of those 13 million, with just over 5 million each. The bottom three countries of the top five are Canada, France, and the United Kingdom, each with around 300,000 followers of Judaism.

Beyond the 75% of Israel that is Jewish, most countries have 2% or fewer. While over 150 countries report no Jewish people, Afghanistan has one. Zablon Simintov lives alone next to the only synagogue in the country and has received special permission to slaughter his own meat since there are no kosher butchers in Afghanistan.

Atheism and Unaffiliated Religions Around the World

We’re listing unaffiliated religions last, though together this group is 1.1 billion people, about 16% of the world population. However, unaffiliated does not mean atheist, agnostic, or even non-spiritual, though those are all included. Rather, it’s a catch-all for anyone who does not identify with a specific religion.

Nearly 700 million of those who do not affiliate with a religion live in China, which accounts for a narrow majority of its citizens (52%). Japan (72M), France (50M), Vietnam (28M), and Russia (23M) also have high numbers of unaffiliated. Other majority unaffiliated countries include Czech Republic (76%), North Korea (71%), Estonia (59%), Japan (57%), and Hong Kong (56%). Eastern Asia and Europe are the most popular regions for being areligious.

Again, not having a religion is not the same as atheism, which is a disbelief in any God. According to some studies, the most atheist country is France, with 40% claiming there is no “spirit, God, or life force.” Those numbers don’t quite measure up with the unaffiliated data in the map above, which shows France at 28% unaffiliated (63% Christian and 7.5% Muslim). It’s possible someone might affiliate with a religion while not believing its teachings.

---

Nevertheless, the data shown on the map above provides a glimpse into how the seven billion people on earth think about religion. There are many more insights to be had in the large version of the world religion map.

Every September baseball fans all over the US and beyond get excited. As the weather gets cooler, things really heat up for some teams and fans. Finally, by the end of October, some are very happy and others… not so much.

Of course, there are some fans who seem to experience this excitement almost every year. And for others, they’ve waited generations. The Chicago Cubs, for example, waited almost 100 years between their second and third championships. In fact, the Cubbies didn’t even make an appearance in the 70 years between 1946 and 2015.

View World Series Wins and Appearances in a full screen map

Explore the map above to see the most wins, appearances, and winning percentage. Or read on to learn about the insights we’ve pulled from this map of World Series winners and losers.

Most World Series Wins

Even casual baseball observers know that the best team in the MLB, based on historical success, is the New York Yankees. The team has won 27 championships and been to the Fall Classic 40 times. The Yankees are in a class all their own here, with eight more victories than the next-closest team has appearances.

World Series Top 10

Team	Wins	Appearances
New York Yankees	27	40
St. Louis Cardinals	11	19
Boston Red Sox	7	11
New York Giants	5	14
Cincinnati Reds	5	9
Los Angeles Dodgers	5	9
Philadelphia Athletics	5	8
Pittsburgh Pirates	5	7
Detroit Tigers	4	11
Oakland Athletics	4	6

The St. Louis Cardinals consistently fielded competitive teams in the 20s, 30s, and 40s, back at a time when they needed to have the best record in all the National League to earn the right to go against the best American League team. Now, in the age of divisions and wild cards, there are 10 teams each postseason with a shot at the series.

The Red Sox are third on the list, a remarkable feat given the long drought between 1918 and 2004. The team has won three times in this century, with the other four coming between 1912 and 1918. If you count their previous name, the Boston Americans, the Red Sox can claim one more victory. The Americans beat the Pittsburgh Pirates in the very first series in 1903.

Of course, if we’re counting other names of existing teams, the Giants would tie for third place with the Red Sox. While the New York Giants baseball team had five championships, the San Francisco version of the team has added three more in recent years.

Highest Winning Percentage

When you’ve been to the World Series 40 times (or even 19, 14, or 11 times), it’s easier to rack up the wins. There are a handful of teams who have won every single time they went to the Fall Classic.

Team	Wins	Appearances
Toronto Blue Jays	2	2
Miami Marlins	2	2
Boston Americans	1	1
Arizona Diamondbacks	1	1
Anaheim Angels	1	1

While none of these teams has won more than two World Series, they’ve each won every time they’ve appeared. In fact, the Blue Jays did it in back to back seasons, 1992 and 1993.

The more appearances a team has, the harder it is to maintain a high winning percentage. There are nine teams with at least five appearances that have maintained better than a 50/50 record: Pittsburgh Pirates, New York Yankees, Oakland Athletics, Boston Red Sox, Philadelphia Athletics, Chicago White Sox, St. Louis Cardinals, Cincinnati Reds, and the Los Angeles Dodgers.

American League vs National League

These days, the league that wins the All Star Game gets to be the home team in the World Series. Otherwise, outside of the designated hitter rule, there’s really little difference between the two. Yet, the American League has been far more successful than the National. The AL has 64 victories to the NL’s 48.

As you might guess, much of that difference is made up by the Yankee’s many championships. In fact, if you remove the top two from each league (Yankees and Cardinals), the two each have 37 victories as of 2016.

MLB Teams Without a World Series Win

With all this talk of winning, it’s easy to forget that some teams have never won a World Series.

• Texas Rangers (appeared in 2010 and 2011)
• San Diego Padres (1984 and 1998)
• Tampa Bay Rays (2008)
• Colorado Rockies (2007)
• Milwaukee Brewers (1982)
• Houston Astros (2005)
• Washington Nationals (never appeared)
• Seattle Mariners (never appeared)

So, if you’re not a baseball fan, or your team doesn’t have a shot this year… consider rooting for one of these underdogs.

And if you’re more of a basketball fan, check out these NBA Finals Winners and Losers on a Map.