Sunday, January 29, 2012

Business Intelligence Related Social and Ethical Issues

Google just modified its Privacy Policy and will be effective on Mar 1, 2012...

They basically "getting rid of over 60 different privacy policies across Google" and use a single version of Privacy Policy instead. Google also made some changes to the categories of information they collected from every user on each day. They divided the information into two categories: "Information you give us" and "Information we get from your use of our services". The first one may include your real name, address, phone number... you provided to them when you register for Google account. The second category may include your IP address, operating system, web browser information, geographical location, the words you typed in. Although Google says they are doing this to improve user experience.

The following video shows exactly how everything happens when you type something in Google search engine.


The questions are obvious:

          "Hey! I didn't register for Google account. Why did you collect my information?"
          "Who gave you the permission to collect data for my location, my operating system and my         keystrokes?"


While Google is clear from the statement: "As you use our services, we want you to be clear how we’re using information and the ways in which you can protect your privacy."

OK. Right now, I think everyone is clear about this:
           If you want to use service from Google, Google will collect your information. Period.

Disagree? You don't use Google, you go back to Jurassic, you go to North Korea.



OK. Here is another question:

           "I just created my personal website and I never use Google service, why Google find my website address and make it visible to everyone?"

Remember Google is a search engine. It is born to search. Google has a program to find new websites or recently updated web pages and bring back to their database. You don't use their service, but they will find you. That's the destiny of a good search engine. You can't escape around it. So,  if you are concerned about your privacy, make sure you don't put your sensitive personal information on your website. Google find the information for your website, not your personal information, which does not violate their privacy policy.


The third question pops up:

             "Google Analtyics is always collecting visitors' data, from location, keywords to time spent on each page, the navigation path, etc."

However, Google can easily defend themselves by say: "We are just doing statistics gathering web traffic information. Such behavior will not identify that visitor is just you."

Yes, that is correct. But think about how many condition clauses in SQL could identify you?


You think 5 conditions may not identify you. That is because you are living in big city. Think about those who live in a small island in Pacific, say Johnston Atoll. The user could be easily  identified by VISITOR_LOCATION AND VISITOR_TIMESTAMP. Because no too many people are using internet at a certain time at this certain website.



This is a big issue for users in small cities. However, think it in another way. No matter how large city you are living in, if Google want to find you, they can use 10 or even 20 conditions to narrow down the query results. They will find you.



Fortunately, privacy for Google is a big concern. They emphasized this point again and again. They want to protect your privacy for you. At least for normal situations...

Saturday, January 28, 2012

The Overwhelmed Data of Google Analytics, really?

Google Analytics is used by many Web Analysts for finding out the website traffic information. However, the data it generated have lots of dimensions, page view, unique page view, landing page, visit, keywords, source, browser info... First time users, like me, usually don't have any clue where to start. 

Maybe you agree with me. However, I am here to point out the fact that many first time users got overwhelmed by data is because they don't know what they really want to do. They don't really know what they want to analyze. They don't know what questions to ask. "The main reason for project failure is unclear project requirements". As a Web Analyst, you should know the exact question to ask. The meaningful questions are like: "What are the keywords people use most to land in this page?", "How did visitors navigate through the entire website?", "Why did some average people leave this page in 10 seconds?"

Although Google Analytics cannot answer some of these questions. It will provide related data from different aspects to help you find the reasonable answer. After you find the answer, Google Analytics also provide data visualization tools to further assist you in generating professional reports.

To summarize, as a Web Analyst, you should have a clear logic in mind. The first step is to have a question. With that question, you login the Google Analtyics account to search for related data. When you get the answer, you could use Google Analytics data visualization tools to help with the report.

Friday, January 13, 2012

Google Analytics Overview

Google Analytics is a free web based BI tool for website traffic analysis. It could be used as a standalone tool or along with Google Adwords.

Google Analytics has the following functions:

  • Use site search data to improve keywords and campaigns
  • For E-Commerce website, a Google Analytics script could enable transaction tracking down to keyword level
  • Geographical market targeting
  • Find out poor performance campaign keywords and focus on profitable keywords
  • Identify high spenders and target that market segment
  • Import referring sites into a placement targeting campaign
  • Use conversion funnels to identify customers' actions towards each page
  • Monitor Google Adwords Traffic
These are the initial findings for Google Analytics from YouTube channel.

Tuesday, January 10, 2012

Created First Post for BI

Never know Blogger is a product of Google...ha

Tomorrow is the first day in Business Intelligence class. Don't know if I could get up that early...after a long and lazy winter holiday.