Create Interactive World Map with Mouseover Data for Your Website

How to add interactive world map on your website easily with Google GeoChart

A couple of months ago, while browsing online, I came across a website featuring an interactive world map displaying the organization’s locations all over the world as well as their number of employees in each location. After a little of digging, I’ve found that it’s not so hard to replicate such slick interactive world map on my site. At its core, the world map is powered by Google visualization tool, and all you need to do is do re-use their code and a little bit of tinkering to customize the map fit your purpose.

Note that this is not using the image map/hotspot — when you add a static image (of the map) and slice it into different region then add the mouseover code to create the effect.


Excel – Highlight Cells That Meet Specific Criteria with Conditional Formatting

How to use MS Excel conditional formatting to change text/background colors of cells automatically

Excel conditional formatting

When doing some Excel-based marketing report, whether it’s web analytic report or sales related report, most of the times, I used some conditional formatting to automatically highlight cells that meet certain criteria such as highlighting cells of under-performing or over-performing shops, under/over-performing regions for revenue reports; highlighting cells based on contract value; highlighting cells that have “N/A” or negative numbers; or highlighting cells of web pages that have poor performance in page visits for a certain period of time.


Search Ranking Dropped – Why & How to Be Visible Again

Possible reasons why your website search ranking changes over time or even overnight.

Search ranking sinking

Updated in 2017 – This post was originally posted in 2010 and has been revised / updated in 2017.

Search engine algorithm

Times change, people change and so does search engine algorithm. If algorithm sounds like a big word to you, as it does to me, then consider it as a giant set of complex [mathematic] formula that search engines like Google, Yahoo! or Bing develop to decide which websites are more relevant to what people search, thus will be displayed at the top, compared to all the sites indexed in their database.


Get Your Competitor’s Web Traffic Data

Different tools to help you with your competitive website data analysis

Get your competitor's web traffic data

Updated in 2017 – This post was originally posted in 2012 and has been revised / updated in 2017

In an earlier post SWOT analysis for your website, I mentioned the four elements of your SWOT analysis include identifying your website strength (S), uncovering your its weaknesses (W), identifying opportunities (O) for the site and uncovering threats (T) against it. While a decent web analytics application like Google Analytics can help you get insight into your own website S and W elements, what and how can you know about your competitor’s web performance in order to make your SWOT analysis more complete? I emphasized “web performance” as opposed to other general information that you can obtain by browsing your competitors’ websites. Below are some tools to help you get some idea about your competitors’ website performance.


Make Your Website Visible In Search

Simple but fundamental steps to make your website more search engine friendly and enhance its traffic and visibility.

Increase website traffic

Updated 2016 – This post was originally written in 2010 and has been revised / updated in 2016

Already knew about how search engines work, here are some simple but fundamental ways to make your site more visible with better ranking and more visibility.

If your site has ranked well in the past, but gradually or suddenly lost its ranking, then check out this post Search Ranking Dropped – Why & How to Be Visible Again.