สวัสดีค่ะน้องๆ และเพื่อนๆ ทุกคน ไม่ได้เขียนอะไรลงบล็อกมานานพอสมควรเนื่องจากติดภารกิจมากมายหลายอย่าง แต่อยากจะบอกว่าคิดถึงทุกคนและดีใจที่เห็นเพื่อนๆ และน้องๆ ทั้งในไทยและอเมริกาติดตามอ่านบล็อกทุกวัน ดีใจที่รู้ว่าทุกคนที่แวะเข้ามาอ่านได้ประโยชน์จากเรื่องราวต่างๆ ที่เขียนไว้ และดูเหมือนว่าหัวเรื่องที่ได้รับความนิยมมากที่สุดจะเป็นเรื่อง "คำนี้แปลว่าอะไรเอ่ย?" ฉะนั้นวันนี้ก็อยากจะถือโอกาสเขียนภาคสองต่อ หวังว่าจะช่วยให้น้องๆ นำไปใช้ประโยชน์ได้ตามความเหมาะสมค่ะ
I haven't updated my blog for over a year due to my busy schedule. I do miss my fans very much and am really glad that people still visit my blog everyday. It makes me happy to know what I wrote is helpful and you are able to learn something from it. The most popular post that has consistently showed the highest visits is "How do you say ... in Thai?" So, since today I have a few minutes, I am taking this opportunity to write "How do you say...in Thai? (Part II)". As always, hope it is helpful to you.
so-so (adj) = ก็งั้นๆ แหละ (คือแบบไม่ดีและก็ไม่เลว ปานกลาง)
Example: How was the food at the new Japanese restaurant? It's so-so.
ตัวอย่าง: อาหารที่ร้านญี่ปุ่นที่เปิดใหม่เป็นไงบ้าง? ก้งั้นๆ แหละ รสชาดปานกลาง
So what (adj) (= Who cares? or What does it matter?) = แล้วไงล่ะ (คือแสดงความรู้สึกแบบไม่สนใจ จะเป็นยังไงก็ช่าง ไม่สำคัญ)
So fetch! (= Cool! or Awesome!) = สุดยอด เริ่ดมาก คำนี้เป็นคำแสลงมีความหมายเหมือนกับ Awesome! หรือ Cool! ถ้าใครเคยดูหนังเรื่อง Mean Girls อาจจะจำคำนี้ได้ เป็นคำที่แก็งค์สาวสวยสุดเริ่ดประจำโรงเรียนใช้พูดกัน
Example: That new shoe store, Cool Shoes, is SO fetch!
So be it (= accept it as it is) = ก็ว่าไปตามนั้นแล้วกัน เห็นด้วยตามกัน
Example: If you can't change the airplane ticket, so be it; I will meet you on Sunday.
ตัวอย่าง: ถ้าเปลี่ยนตั๋วไม่ได้ ก็ไม่เป็นไรปล่อยไปตามนั้น แล้วเจอกันวันอาทิตย์นะ
Mean (adj) = ใจร้าย ใจดำ
พูดถึงหนังเรื่อง Mean Girls แล้วไม่พูดถึงคำว่า Mean ไม่ได้ คำนี้ส่วนใหญ่จะรู้จักกันในความหมายทางสถิติแปลว่า ค่าเฉลี่ย ซึ่งเป็นคำนาม ในกรณีที่ Mean ใช้เป็นคำคุณศัพท์ (adj) ขยายคำนาม เช่น Mean girl อันนี้แปลว่า ใจร้าย ใจดำ ไม่น่ารักเลย
Example: Cinderella's stepmother was always so mean to her.
ตัวอย่าง: แม่เลี้ยงของซินเดอเรลล่าใจร้ายใจดำต่อเธอตลอดเวลา
Mean (v) = แปลว่า หมายถึง
นอกจากคำว่า Mean จะใช้เป็นคำคุณศัพท์ (adj) ที่แปลว่า ใจร้าย ใจดำแล้ว สามารถใช้เป็นคำกริยาได้ด้วย
Example: I have never heard this word before. What does it mean?
ตัวอย่าง: ไม่เคยได้ยินคำนี้มาก่อนเลย มันแปลว่าอะไรหรือ
What a coincidence! = ช่างบังเอิญจริงๆ (สิ่งที่เกิดขึ้นโดยไม่คาดคิดมาก่อน หรือไม่ตั้งใจว่าจะเกิดขึ้น)
ก่อนจบฝากนิดหนึ่งเรื่องชื่อเล่นค่ะ คนไทยเรามีชื่อเล่นน่ารักๆ เยอะมากในภาษาไทย แต่พอเขียนเป็นภาษาอังกฤษ ถ้าไม่ระวังแล้ว ชื่อนั้นอาจกลายเป็นชื่อที่มีความหมายน่าตลกขบขันไป เช่น ติ๊ก ถ้าเขียนว่า Tik ก็ดูปกติ แต่ถ้าเกิดเขียนว่า Tick หนึ่งในความหมายของ Tick คือเห็บบนตัวหมา อีกชื่อที่ฟังดูน่ารักมากคือ จัง ถ้าเขียนว่า Jung ในภาษาเกาหลีหมายถึง righteous แต่ถ้าเขียนว่า Junk ภาษาอังกฤษกลับแปลว่า ขยะ หรือภาษาแสลงหมายถึง อวัยวะเพศชายค่ะ
เอาแค่เท่าที่นึกได้ก่อนแล้วกัน และถ้าใครมีคำถามสงสัย หรืออยากรู้คำอื่นๆ ก็ฝากคำถามไว้นะคะ อาจจะตอบช้าบ้าง แต่รับรองว่าตอบแน่นอนค่ะ
Wednesday, June 16, 2010
Thursday, February 26, 2009
When I tried to export more than 500 rows in Google Analytics for the first time
Most Google Analytics users know that all reports in GA are subject to a maximum of the first 500 rows when exporting. The full list of data can’t be seen in the GA interface if the rows are more than 500. It only shows 500 rows on each report page. Also, the data can be downloaded 500 records at a time. However, I didn’t know that until I tried to download more than 500 rows of data to my spreadsheet. Like others, when I am stuck, I google on the internet to find an answer.
Many GA gurus provide the same solution.
Append &limit=x to the end of the URL.
where X = the numbers of rows I need to export. For older Excel (2003), the maximum rows are 63,500.
Some suggests, to make it simple, to append &limit=50000 to the end of the URL. When exporting, I will get back 50000 or whatever rows.
Well, I did follow the direction by changing Show Row option at the bottom of the report to 500 and adding &limit=50000 to the end of the URL. This made my Top Content URL look like below.
https://www.google.com/analytics/reporting/top_content?id=8010242&
pdr=20090126-20090225&cmp=average&trows=500
#lts=1235671650953&limit=50000
Then I clicked Export, selected CSV and downloaded the file...
Wait! It didn’t work! I still got only 500 rows on my spreadsheet. What did I miss? I googled again to check if I missed anything. Seemed like I did everything right. This is not supposed to be complicated!
Finally, I figured out what happened.
It's so simple!
After adding &limit=5000 to the end of the URL. I need to press ENTER before clicking Export to override the URL. Without pressing ENTER, the URL will remain the same.
Now I know… I told you learning by doing is the best way to learn…
Many GA gurus provide the same solution.
Append &limit=x to the end of the URL.
where X = the numbers of rows I need to export. For older Excel (2003), the maximum rows are 63,500.
Some suggests, to make it simple, to append &limit=50000 to the end of the URL. When exporting, I will get back 50000 or whatever rows.
Well, I did follow the direction by changing Show Row option at the bottom of the report to 500 and adding &limit=50000 to the end of the URL. This made my Top Content URL look like below.
https://www.google.com/analytics/reporting/top_content?id=8010242&
pdr=20090126-20090225&cmp=average&trows=500
#lts=1235671650953&limit=50000
Then I clicked Export, selected CSV and downloaded the file...
Wait! It didn’t work! I still got only 500 rows on my spreadsheet. What did I miss? I googled again to check if I missed anything. Seemed like I did everything right. This is not supposed to be complicated!
Finally, I figured out what happened.
It's so simple!
After adding &limit=5000 to the end of the URL. I need to press ENTER before clicking Export to override the URL. Without pressing ENTER, the URL will remain the same.
Now I know… I told you learning by doing is the best way to learn…
Labels:
01 Analytics and Me
Thursday, January 1, 2009
HAPPY NEW YEAR 2009!
Happy New Year, everyone! Hope you had a wonderful time celebrating the New Year with your family and friends.
How did I celebrate New Year’s Eve and New Year?
I did something unusual this New Year since 2008 was kind of not so good year for me. I cooked dumplings, noodle and fish for my family. I have learned from my Chinese friends that dumplings is one of traditional Chinese new year food. It’s supposed to bring good luck and fortune. Besides dumplings, noodle and fish are good food to eat on New Year as well. Long noodle represents long-life and fish means success or abundance.
There are also some other dishes that are supposed to bring prosperity, wealth and happiness but I don’t remember all of them. So I did some research and found the website displaying the list of food and dumpling recipe. Just in case you are interested.
How about you? What did you do? How did you celebrate your New Year?
How did I celebrate New Year’s Eve and New Year?
I did something unusual this New Year since 2008 was kind of not so good year for me. I cooked dumplings, noodle and fish for my family. I have learned from my Chinese friends that dumplings is one of traditional Chinese new year food. It’s supposed to bring good luck and fortune. Besides dumplings, noodle and fish are good food to eat on New Year as well. Long noodle represents long-life and fish means success or abundance.
There are also some other dishes that are supposed to bring prosperity, wealth and happiness but I don’t remember all of them. So I did some research and found the website displaying the list of food and dumpling recipe. Just in case you are interested.
- Dumplings - Good luck, fortune, and family togetherness
- Noodles - When noodles are served, they are never cut because long noodles represent long-life.
- Whole fish - The Chinese word for fish “yu,” is the same word for “success” or “abundance.” Serving the fish whole is a symbol of togetherness of the family.
- Chicken - Like fish, chickens are served whole to symbolizing togetherness of the family
- Oysters - Receptivity to good fortune
- Dried bean curd - Like many of the foods that are served because the Chinese word for it also means something else, dried bean curd (tofu) symbolizes wealth and happiness
- Bamboo shoots - The word for bamboo shoots also sounds like the phrase for “wishing that everything would be well”
- Seaweed - Specifically, the black moss seaweed is the Chinese word for it also means “wealth”
- Turnips - “Cai tou,” the word for turnip, also means “good omen.”
- Meat balls - Symbolize reunion because the Chinese word “rou wan” is the same for both togetherness of the family.
- Lotus seed - Is a symbol (or wish) of having many male offspring
- Ginkgo nuts - Represent wealth
- Lettuce - Prosperity
- Garlic chives - Symbolize “everlasting”
- Prawns - Stand for liveliness and happiness
- Mixed vegetables - Represent family harmony
- Oranges - They stand for abundance and sweetness of the New Year.
How about you? What did you do? How did you celebrate your New Year?
Labels:
05 Living in America
Saturday, November 29, 2008
Sunbathing!
This is something that my dogs do and a dog owner like me finds it very interesting, amusing and cute at the same time, and like to share it with you.
MC & KT love to go outside during the day for sunbathing. They like to spend about 10 – 15 minutes or so in the sun 4 – 5 times a day...
During the fall season, there is not much sun on their favorite spot. However, they try to make themselves to be as small as possible in order to fit into their preferred area. (You know they are not that small :)) I found it very funny, so I sneaked behind a curtain inside the house and took a picture of them.
They saw me taking the picture (They had good eyes). For some reason, they were so excited. They might think I was playing hide-and-seek with them. They both immediately jumped up and ran as fast as they could towards me. If they could talk, they would probably say 'Got you, mama'.
Hope you enjoy the pictures.
MC & KT love to go outside during the day for sunbathing. They like to spend about 10 – 15 minutes or so in the sun 4 – 5 times a day...
During the fall season, there is not much sun on their favorite spot. However, they try to make themselves to be as small as possible in order to fit into their preferred area. (You know they are not that small :)) I found it very funny, so I sneaked behind a curtain inside the house and took a picture of them.
They saw me taking the picture (They had good eyes). For some reason, they were so excited. They might think I was playing hide-and-seek with them. They both immediately jumped up and ran as fast as they could towards me. If they could talk, they would probably say 'Got you, mama'.
Hope you enjoy the pictures.
Labels:
04 All About Pets
Tuesday, November 11, 2008
The Economic Meltdown! -- What should we do? (Part 2)
Under this current economy, my husband and I try to find a way to tighten our belts and save money as much as we can in case of a financial emergency, so we will have money at our expense. I’ve tried to come up with the list of things that we do in order to help us save money on bills. Here are some tips that I would like to share with you.
- Get rid of your bad spending habits. Create a budget so you know where your money goes each month.
- Don’t eat out. Cook all your meals at home. Bring lunch to work. No coffee from Starbucks. :)
- Shop carefully and always have a shopping list when you go grocery shopping. Stick with the list. Don’t buy products that you don’t really need because they are on sale. It’s a good idea to shop at bulk discount stores like Sam's Club and Costco to get the best deals.
- Instead of going out to a movie, get Blockbuster or Netflix online membership. You can get movies delivered to your mailbox with low price.
- Don’t spend a lot of money going on a trip. Consider a staycation instead.
- Know how much money you have in your bank account. Make sure you don’t have a returned check (it costs $25-30 per check) and pay your bills on time to avoid paying a late fee.
- Get rid of your landline phone if you have one. It is unnecessary expense and a waste of your money. Cell phones offer better rates and your can have a special deal by calling your family for free.
- You might be able to get some kind of discount on your monthly bills if you have the payment deducted directly from your checking account electronically. Check with your providers.
- Remove your credit card from your wallet, keep it in a safe place and DON'T use it. Try to pay everything in cash. When you see your cash fly out of your wallet, you will tend to spend less.
- REMEMBER: Although you don't use your credit card, you need to keep it. DON'T CANCEL IT!! Closing down the credit card will hurt your credit score (FICO score). America is a credit based economy. You need to have the credit (i.e. the credit card) in order to get a home mortgage, a car loan, rent an apartment, rent a car, apply for a job (for some jobs), get an insurance, etc. Good credit history will make your life easier financially.
- REMEMBER: Although you don't use your credit card, you need to keep it. DON'T CANCEL IT!! Closing down the credit card will hurt your credit score (FICO score). America is a credit based economy. You need to have the credit (i.e. the credit card) in order to get a home mortgage, a car loan, rent an apartment, rent a car, apply for a job (for some jobs), get an insurance, etc. Good credit history will make your life easier financially.
- Don’t borrow any money for anything. No home equity loan. No new kitchen. No new appliances unless it’s absolutely necessary.
- Get out of debt ASAP. If you have credit card debt, pay it off ASAP. Focus on an interest rate and pay off the card with the highest interest rate first. This is very important if you want to pay down your debt quickly.
- If you are a homeowner, make sure your interest rate is fixed and don’t fall behind on your mortgage payment.
- Try to increase your cash flow. Make sure you have at least 6 months in the bank in case you lose your job (We are still working on it...it’s really hard!) Also, make sure your bank is FDIC insured because if your bank goes under, your money will be saved. Due to FDIC rules, it’s $100,000 for an individual account and $200,000 for a joint account.
Labels:
05 Living in America
Wednesday, October 29, 2008
The Economic Meltdown! -- What should we do? (Part 1)
I apologize for keeping you waiting so long. I know some of you visit my blog to check on my new post regularly. But there is no update for a month. This is terrible! Anyway, I am back now and today I am going to talk about a HOT issue… (I am wearing my economist’s hat today.) :)
As you’ve known, the U.S.has been going towards an economic recession. There have been large layoffs across the board, from auto industry, airline industry to financial industry. According to the Labor Dept’s recent unemployment report released in September, unemployment rate increased to 6.1%, the highest level since 2003, 1.3% higher relative to the rate in February, and it is expected to keep on rising.
Housing market is in bad shape and continues to worsen. Housing inventory has incessantly gone up while the price has decreased. However, a lot of people still can’t afford a house because of not having high credit scores, the credit crunch and the credit freeze. Current foreclosure rate is high (one in every 538 U.S. households were in some stage of foreclosure). At the same time, stock prices have been falling with violent swings. U.S. stocks plunged the most since the crash of 1987.
Due to uncertainty, many companies and businesses try to survive and come up with a strategy and an action plan to cope with the economic meltdown. One of the strategies is to reduce an expense by downsizing the company. As well as other companies, the president of my company just announced the new business plan. 17% of total positions got eliminated last week. It’s very stressful and painful situation for everybody.
The recession is predicted to last about 2 years or so. However, I think it might carry on longer, depending on our new U.S. President’s policies and other internal and external factors. Things don’t look good right now and I expect them to get worse.
I went grocery shopping last week and found the prices of many products have already been raised. For example, I used to spend $2.25 for my favorite TV dinner. Now I pay $2.99. Also, I paid $15.99 for a bag of frozen salmon. Now I pay $21. Surprise! Surprise! Looks like I have to find cheaper food to eat on my next grocery trip. How about you? What do you think about the current economic crisis?
Have you had any plan to deal with the economic downturn? Have you asked yourself about what you can do to spend less and save more during this time? What do you need to do to survive in case you or your significant other gets laid off?
As you’ve known, the U.S.has been going towards an economic recession. There have been large layoffs across the board, from auto industry, airline industry to financial industry. According to the Labor Dept’s recent unemployment report released in September, unemployment rate increased to 6.1%, the highest level since 2003, 1.3% higher relative to the rate in February, and it is expected to keep on rising.
Housing market is in bad shape and continues to worsen. Housing inventory has incessantly gone up while the price has decreased. However, a lot of people still can’t afford a house because of not having high credit scores, the credit crunch and the credit freeze. Current foreclosure rate is high (one in every 538 U.S. households were in some stage of foreclosure). At the same time, stock prices have been falling with violent swings. U.S. stocks plunged the most since the crash of 1987.
Due to uncertainty, many companies and businesses try to survive and come up with a strategy and an action plan to cope with the economic meltdown. One of the strategies is to reduce an expense by downsizing the company. As well as other companies, the president of my company just announced the new business plan. 17% of total positions got eliminated last week. It’s very stressful and painful situation for everybody.
The recession is predicted to last about 2 years or so. However, I think it might carry on longer, depending on our new U.S. President’s policies and other internal and external factors. Things don’t look good right now and I expect them to get worse.
I went grocery shopping last week and found the prices of many products have already been raised. For example, I used to spend $2.25 for my favorite TV dinner. Now I pay $2.99. Also, I paid $15.99 for a bag of frozen salmon. Now I pay $21. Surprise! Surprise! Looks like I have to find cheaper food to eat on my next grocery trip. How about you? What do you think about the current economic crisis?
Have you had any plan to deal with the economic downturn? Have you asked yourself about what you can do to spend less and save more during this time? What do you need to do to survive in case you or your significant other gets laid off?
Labels:
05 Living in America
Saturday, September 27, 2008
คำนี้แปลว่าอะไรเอ่ย --- How do you say .... in Thai?
เมื่ออาทิตย์ที่แล้วน้องแคร์ฝากคำถามไว้ว่า คำว่า เกรงใจ ในภาษาอังกฤษควรจะใช้คำว่าอะไร พออ่านคำถามแล้วก็เกิดความคิดขึ้นมาว่ามีคำในภาษาอังกฤษง่ายๆ หลายคำที่เราเห็นและใช้กันบ่อยๆ แต่ไม่รู้ความหมายเป็นภาษาไทย วันนี้เลยอยากจะเขียนรวบรวมคำเหล่านี้ไว้ เผื่อน้องๆ จะได้เลือกนำไปใช้พูดในชีวิตประจำวันได้ตามความเหมาะสมค่ะ
- awesome = ยอดเยี่ยม หรือแบบคนไทยเราก็คือยอดเยี่ยมกระเทียมดอง
- That's awesome!
- You're awesome!
- cool = เจ๋งเป้ง
- This is so cool! or Cool!
- You rock! = สุดยอด, เริ่ดมาก, ยอดเยี่ยม
- a green thumb = เป็นคนมือเย็น (หมายถึงคนที่ปลูกต้นไม้อะไรก็เจริญงอกงามไปหมด)
- You have a green thumb.
- Chill out! (= calm down) = ใจเย็นๆ ค่า
- Be my guest = เชิญเลยค่ะ เชิญตามสบาย
- Be my guest = Do as you wish; go ahead; go for it; help yourself
- Example: Do you mind if I read your newspaper? Be my guest.
- Example: If you want to give it a try, be my guest!
- Make yourself at home = ตามสบายไม่ต้องเกรงใจ (ทำตัวตามสบายให้เหมือนกับอยู่บ้านตัวเอง)
- What goes around, come around.(อันนี้ได้ยินบ่อยมากๆ) = ให้ทุกข์แก่ท่านทุกข์นั้นถึงตัว, ทำดีได้ดี ทำชั่วได้ชั่ว
- It's not a big deal = เรื่องขี้ปะติ๋ว, ไม่ใช่เรื่องใหญ่
- It's not a big deal! = It's no big deal; don't worry; no problem
- It's a matter of life and death = เรื่องใหญ่มาก, เรื่องสำคัญมากๆ, เรื่องคอขาดบาดตาย
- two-faced = หน้าอย่างใจอย่าง, ใช้บรรยายอาการของคนที่ตีสองหน้าพูดหรือกระทำต่อหน้าเราอย่างหนึ่ง แต่ลับหลังกับคนอื่นกลายเป็นอีกอย่างหนึ่ง
- two-faced = fake (adj.)
- lose face = หมดความน่าเชื่อถือ, เสียหน้า
- Jack refused to admit he made a mistake because he didn't want to lose face.
- save face = รักษาหน้า, รักษาความน่าเชื่อถือ, รักษาศักดิ์ศรี
- Rather than fire him outright, they let him save face by accepting his resignation.
Labels:
02 English and Me
Subscribe to:
Posts (Atom)