Basics of Google Analytics – Part 2

In my earlier post, I have discussed some basics of Google Analytics (GA). We’ve gone through some sections of GA and understand how to use them. We went deeper to understand acquisition, behavior & conversion (ABCs) and how to decipher the information.

In this post, I would go a step further. Here is what you’ll learn:

  • Understand that the numbers means nothing until we put them into chronological order to understand the trend
  • How to make investment decision based on a few measurement metrics.

Continue reading Basics of Google Analytics – Part 2

Basics of Google Analytics – Part 1

Have you recently launched a new website or are you being tasked to manage one?

Here is what you’ll learn:

  • Understanding Google Analytics sections
  • Understand Acquisition, Behavior & Conversion (ABCs)
  • Learn how to decipher the information

No matter the case is, I’m sure you need to look into web analytic. I have clients and friends who asked me how to make sense of all the information, and how does it impact their daily job. This gives me the “push” to write this article. I would try to make it as simple as possible, highlighting some of the generic, yet, important information you need to retrieve from web analytic. Continue reading Basics of Google Analytics – Part 1

China’s Hospitality and Tourism Industry

China has always been a mystery to me. Even though I’m a Chinese, but having exposed to Western culture at a young age, trying to understand China would take some effort. Nonetheless, it is still worth the effort; given the massive market it has. Luckily, Singapore’s bilingualism policy has made reading Chinese relatively easy to me.

Understanding China’s Hospitality and Tourism Industry and culture would definitely take some time, and preferably some opportunity to work within China. I guess I would take the first step by doing some research in the industry, from a statistical point of view. The information below is from National Bureau of Statistic of China. Continue reading China’s Hospitality and Tourism Industry

Singaporean Loves Staycation

At least from a Google search point of view.

I was browsing through Think with Google and the featured article “Staycations: The Most Popular Destination This Summer Is in Your Backyard” caught my eye. It is an infographic content and here are a few pointers I have summarized.

  • The data is United States centric.
  • There is an increase in 10% of searches in “Staycations” comparing with last year.
  • The search peaks in July.
  • Americans searched hotels that are near where they stay.

Since it is United States centric, this makes me wonder whether people who live in the Asia-Pacific region would have a similar search pattern. So I went over to Google Trends and start typing in “Staycation” in the search term and limit the data displayed within the past 12 months.

The graph shows somewhat similar pattern as per the article above; the search trend would peak in July. Next, I wanted to find out how it compares with Asia-Pacific but realize there isn’t an option to choose for “Asia-Pacific.” As I could only choose up to five countries, I decided to include United States, Australia, Japan, Hong Kong and Singapore. Just before I added Singapore into the locations, this is what I see.

Apparently, the three Asia-Pacific countries that I’ve added don’t seem to have many searches on the term. Australia wasn’t even included in the graph at all.

When I add Singapore into the locations, the graph gave me a shock. Continue reading Singaporean Loves Staycation

10 Hospitality Industry Terms

I have never been in the hospitality industry. Not until I’ve joined Sabre Hospitality Solution, provider of digital marketing solutions, central reservation systems and global distribution systems for the hospitality industry, just two weeks ago. Here are a list of terms that I have came across often in the industry.

1. Visit to Look and Look to Book ratio
This ratios are to measure the effectiveness of a hotel’s website and online booking engine. What it wanted to measure is the number of visitors who lands on the hotel’s website and eventually look into the room rates, thus the Visit to Look ratio. Look to Book ratio measures the number of visitors looking at the room rates and how many visitors actually make a booking.The higher the ratio means that the website and booking engine has a good conversion rate.

2. Online Travel Agency (OTA)
Agoda, and Expedia are some of the examples of online travel agency. These websites, or the companies operating it, typical have obtained some form of deals, directly or indirectly, with the hotels. The deal would typically allow the OTAs to list hotel room on their website available for visitors to book. Whenever there is a booking, the OTA’s would get a commission from the hotel.

3. Hotel Meta-Search Engine
Basically meta search engine would aggregate all websites to display the best rates available for a particular hotel room. Some example include TripAdvisor, Kayak and Trivago.These websites are getting popular for hotel booking since it would display the different rates of various sources for comparison.

4. Price Disparity
Price disparity means that a specific room in a specific date is showing a different rates on the hotel website and various OTAs. This usually happens when OTAs cut the price of the room to ramp up sales (as they only earn commission from the hotel only when there is a booking).

5. Average Daily Rate (ADR)
From time to time, a hotel would change the price of the room booking for various reasons. But in order not to deviate too much from their typical room rates, they would keep track of their average daily room rate. Even though room booking rates changes over time, it would be fine as long as their average daily room rate remains constant. Due to strategic reason, a hotel might want to slowly increase or decrease their average daily rate.

6. Average Occupancy Rate (AOR)
Similar to average daily rate, average occupancy rate tracks the percentage of room booked at any specific period. Hotels would strive a higher occupancy rate.

7. Global Distribution System (GDS)
Chances when you visit a travel agency, and you see the staff checking rates on the computer, they are using a Global Distribution System. It is a system created by a company to enable bookings or transactions between third parties and travel agents to offer travel-related services to the end consumers.

8. Booking Lead Time
When hoteliers plan their marketing campaign, they might want to know what is the average lead time for their guest to make a booking at their hotels. For example, if they know the average time for guests to make a booking before the stay is about 3 months. If they want to push for Valentine’s day promotion, they should start it 3 months before.

9. Derived Rate
Have you ever wonder how hotels set their price for their rooms over different period? They started off by setting a based rate. Based on the hotel’s occupancy history, occasions and some other factors, decides the room rates by indicating what we call the derived rate. Meaning to say, they might decide that this period would add another 5% or -3% to the room price.

10. Competitive Set
As the hospitality industry is a very competitive industry, very often the hoteliers would like to know how are they performing comparing with their competitors. Of course they can’t compare with any hotels as all has different target audience and unique factors. As such, they would need to craft a competitive set, meaning to define a specific group of competitors to compare.

There are much more to learn in this industry. Do you have anything you would like to add-on or something you would like to correct me?

6 things to note before traveling to America

I am asked to go to the US for a conference at Bethesda, Maryland. It is my virgin trip to the United States of America, and there are plenty of things I learnt from this trip. I thought I should write them down and let those who are also traveling for the first time to gain some basic knowledge.

1. Coins
It was quite confusing at first. There is Dime, Penny, Nickel and Quarter. I have to do some googling to know that a Dime is 10 cents. I still find it weird that the size of a Dime is actually smaller than Nickel (5 cents coin). More information on US coins.

2. Left-hand Drive
Knowing this could prevent you from trouble. Singaporeans are familiar with right-hand drive. When we cross the road, we look to the right side of the road to lookout for traffic. But it is important to look to the left side of the road instead in the US.

3. Tipping
We don’t practice tipping much in Singapore. Or at least we’re not expected to tip. In the US, especially in cafe or restaurant, they expect you to tip. In one incident when I forgot to include a tip, the waiter actually asked, politely, “aren’t you tipping us?” :)

It stands for Electronic System for Travel Authorization. We Singaporeans are lucky as we do not need to apply a VISA to travel to the US, but we need to apply for ESTA. You can apply for ESTA here.

5. Fahrenheit, Miles and Pounds
I know that the US is using a different measuring units than what we’re familiar in Singapore. But I thought I should remind you to familiarize with these before traveling there. It is good to know the difference and get some perspective on the weather, distance and the weight. Download an app into your phone would help before you travel.

6. Bring your own bag
Be ready to bring your own bag when you go shopping. This includes boutique store, 7-11 stores and supermarkets. They normally don’t offer shopping bags unless you ask for it and you might have to pay for it sometimes.

Are there anything else you might want to add to this list? Let me know.

Cost of owning a car in Singapore

A year ago, when I’m pondering whether I could afford a car, I realized there isn’t much concrete information. Yes, I could find some rough estimates but such are too vague.

Today, my ownership of my Mitsubishi Colt turns one year and I actually recorded all the related expenses throughout the year. I would like to share this information so that whoever considering a car could use this as a reference. Of course, use it only as a reference/guide as they doesn’t represent every car and every kind of usage.

Before the information, I thought I should cover some background of my car usage. I bought this car with only 2 year and 8 months left before the COE expires. My work requires me to drive and meet my clients at least 2 – 4 times a week. I paid for my house season parking, and I’m lucky that my company paid for my season parking at my work place.

Once you own a car, there are a few costs that, even if you don’t use the car, you would have to pay for it. Below is a list of them and how much it cost me last year.

Car Depreciation – $6,930
[ (Total cost of the car – the minimum PARF benefits) / total number of months ] x 12 months.
Insurance – $1,634
This cost varies with different cars, owner’s driving experience and many other factors.
Loan Interest – $400.08
Unless you pay the car in full cash, you would definitely incur interest for your car loan.
Road Tax – $570
Again, this costs differs based on the car models.

Next, you would need to prepare for expenditures based on your usage. This car has an average of 400km before the empty tank light/signal appear. In the past one year, I’ve driven 22,943km.

Car Accessories – $56.10
I’m sure you would buy some car accessories to “change” your car. Some might spend thousands but I’m quite easy on this.
Maintenance & Repair – $1,428.05
As the car is rather old, I’ve expected some repair work needed. I have sent my car for two regular maintenance work (each costs around $200-$300) and my air con compressor spoiled which cost me almost $500 to change and repair. This cost also include some car wash expenses.
Parking & ERP – $2,658.08
I joined this two costs together because both uses Cashcard (so recording is easier).
Petrol – $3,544.98
I pump Esso initially but after some experiments with SPC, I realised that I could drive further per tank. Esso was about 380 per refuel but SPC could last me until 400+ per refuel. SPC discount was higher too since it does not have points system like Esso; which I find it troublesome.
Traffic Offence – $119.50
Yes, traffic offence. Unless you don’t drive, but my bet is you’ll bound to break some traffic rules from time to time.

To sum up all the car expenses, I’ve spent $17,340.79 last year. That is $1,445 a month. Are you ready for such expenditure? Think again, and again…

Thinking about car cost in Singapore
© Bandu | Dreamstime Stock Photos