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

This post was originally posted several years ago and was last 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

This post was originally posted several years ago and was last 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.


SWOT Analysis For Websites

Already had a SWOT analysis for your overall marketing plan and strategy, have you ever done a SWOT analysis for your website?

SWOT analysis thumbnail

It’s that time of the year that I need to do a SWOT analysis for my company’s websites, so maybe it ‘s also time for you to start thinking about renewing or starting a SWOT analysis for your website / online marketing if you haven’t got one yet. The SWOT analysis for your website can be integrated into your overall SWOT analysis; however, it may be better to be separated.


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

This post was originally written several years ago and was last 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.


HEX to RGB Color Converter

HEX RGB color converter

I have another post about the need to have a color converter to convert RGB to HEX colors. However, sometimes we need the opposite, when Marketing receives HEX colors from the web team or from external agencies / designers and wants to get the equivalent RGB values to use in documents or presentations. In that case, a HEX to RGB converter is needed.

Here is a simple and clean tool to convert HEX to RGB color. You can bookmark the page and refer to it later on when needed. Click here if you want to convert RGB to HEX.


RGB to HEX Color Converter

RGB HEX color converter

I don’t remember how many times my co-workers and myself wanted to convert RGB values to HEX value and vice versa but couldn’t find a reliable and clean tool to use. As Marketing professionals, we are more familiar with RGB values since we use RGB in documents, spreadsheets and presentations. However, sometimes we need the HEX color values to send to external agencies / designers, or other times we receive the HEX values from those people but couldn’t tell what are the equivalent RGB values. This tool is first for myself to use, then if it’s helpful to you, just use it!


Create Interactive World Map with Mouseover Data for Your Website

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

A couple of months ago, my friend showed me 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 hard to replicate such 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.