Monday, February 20, 2012

Our First Shipment of Imported Shiroi Koibito

So we did it.   We have shipped our first shipment of the Imported Shiroi Koibito Japanese Cookies!

We are currently selling the items on the eBay, and eBay makes it very easy to mail a package. Any items being sold has a link saying "Ship this item". Simply click on that link, and the label is literary printed in few clicks.  I need to know the weight and size of the box first.  By entering the size it shows all the charges for different options of USPS shipping methods such as Express Mail, Priority Mail Flat Rate, Regular Priority Mail etc.  They make it easy with only one click to pay the shipping cost which gets charged to the linked PayPal account right there. E-Bay allows you to print the label and even print a packing slip with a custom message in just few clicks.

One suggestion to anyone starting to sell items on eBay is to get all the different boxes available from the USPS prior to shipping the items. Office Max started to carry USPS boxes too which happened to be more convenient for me since there office hours are usually more extended than USPS offices if I am simply picking up boxes.  You can also have USPS deliver the boxes online from USPS website, but that took about a week for it to arrive.  

I noticed that based on the size of the material and destination, the charges can be optimized if you have boxes in hand.  For instance, shipping to California was cheaper for me to use the  Regional A Box (which is a kind of box available for free pick-up) rather than the regular Flat Rate Box.  Both services get to the California destination on the same day, but it was $1 cheaper with Regional A Box.   Without having the box in hand, I would not have noticed the differences or even know that the product can be fit in any of those boxes.

Now that we have shipped our first shipment, we have started to expend the items for selling.  With the similar approach to what we have been doing, we have created Japanese Imported DS and Wii Games site.  I will post more experience for this new area as I go along.






Saturday, February 18, 2012

Third Phone Call with Google AdWords

This is the fourth week since I started using Google AdWords to sell Shiroi Koibito, Japanese Chocolate. I have 6 weeks of free support from Google AdWords, and I have made a third phone call to Google to get their input on how I am doing so far.

Please view my first and second phone call with Google AdWords for previous phone call information.

This phone call was more useful than the last phone call.  I was not sure how much more I can get help from them, but since the time is limited, I thought about calling again and see what the had to say.

As always, I did not have to wait at all after calling their toll-free number (1-866-2GOOGLE (246-6453)).

I have told the Google Representative that I have followed all the suggestions they have suggested so far, but I have a concern that now I get more clicks but not enough sales.  In other words, my conversion rate is not good.  Following are the two suggestions they have mentioned to me which I thought was a great tips:

1. Use Match Types to narrow down the audience

Match Types can be defined per key words, and define them so that the ad will show up with more specific type of match.  Google define following four match types:
  • Broad Match - By default this is the selection.  Google will match based on relative term to the keyword specified.  For example, my keyword is "Milk Chocolate Cookies" which could match to "Chocolate Cookie", "Cookies", "Milk Cookies", "Hot Milk" or even mistyped keywords such as "Milk chocorate"
  • Phase Match - By selecting this, exact wording sequence must be in user's keywords in order for the ad to appear.  For example, my keyword is "Milk  Chocolate  Cookies" which matches with "Yummy Milk chocolate Cookies" or "Buy Milk Chocolate Cookies", but it WILL NOT match with "Chocolate Cookies" or 'Milk Cookies" because these terms do not contain phase of my keywords exactly how I spelled it. 
  • Exact Match - By selecting this, ad will only show up when user types exactly what my keywords are being typed. If my keyword is "Milk Chocolate Cookies", the ad only shows up if user types that keywords. 
  • Negative Match - By selecting this, we can restrict the ad to show up when user types the negative keywords.  if my keyword is "Milk chocolate Cookies", and set Negative Keywords as "Hot Chocolate", my ad will not show up "Hot Milk".

In order to set the Match Type to the keywords, do following:

Click on Keywords, and right underneath Keywords is a button of "Columns".  Click Columns->Customize Columns. Select Attributes->Click on "Add" next to Match Type.  Now Match Type shows up at the end of each keywords that I have already defined.  I can set any of the four types of the match types for each keywords.

This helped me greatly because by default Google sets up all the keywords with broad match which is great to get more clicks, but the conversion rate for them to buy my chocolate was lower earlier.  Now I can only attract users who are really specifically wanting my chocolates.  This reduced the number of clicks, but that reduced the cost which in turn increased the conversion rate.

For more information about Match Type, you can also see this link.

2. See What people are really searching for

In order to really narrow down the audience using the #1 method above, I need to know what is really showing my ads when people typed something.  This second suggestion from Google help me find that.

Now that I have been running Google AdWords for last month, I have enough data to really dig down what users are searching when my ads are being clicked.  This information is being "hidden" (I use this term because I didn't see this!) under "See Search Terms".

It is under the keywords tab, under graph you see "See Search Term" button.  You click "All" on this.  Make sure to select the date range that are not limited to only a day or two.  You want to see as far back as possible to get all the data.
Now you see all the "Search Term" relative to which campaign and ad groups users actually used to get the clicks that we paid for.  You will also see "Match Type" that I explained above if it was Exact match or broad match.  You start to see really wired keywords matching with broad match type.  I had a click with "Sushi Chocolate".  I really do not want someone to be even clicking on my link when they are looking for Sushi chocolate.  Yack!    You can check the ones you Don't want and select "Add as negative keyword" button at that top.  Now I just added "Sushi Choclate" and all other keywords as "Negative Keywords" so that when someone searches for these terms, I won't be paying for their clicks.  

You see that green highlight with "Added" wording.  This means that this keyword was already added.  So i am good with those words, but any other keywords that you think that it is relative, I can add those keywords by selecting those keywords, and "Add as Keywords".

I can keep narrowing down and digging down the data to get optimized list of keywords.

I thought this phone call was a worth phone call for me.  I have two more weeks before my free support expire.  Let's see how things go.

For more information about See Search Term report, you can see this link.


Friday, February 10, 2012

Experimenting with Google Merchant Center


Google Merchant Center is one of the Google’s service to sell items online. When you search product on Google, on the left side you can choose “Everything”, “Images”, “Maps”… and there is a link for “Shopping”.  The listing that you post on Google Merchant Center becomes searchable on this link.  I thought that this is little more complicated than other Google services such as AdWords or Analytic, and it is suitable for people who sell many items online.  Since all I am selling right now is JapaneseShiroi Koibito Chocolate, this was a good experiment to try out.

Basically, I had to create a text file to feed into Google Merchant which can be created by excel.  The text file contain the information needed for the Google Merchant to display the information.

The instruction is available  here, but what I found out was that the information posted on this help page is not as helpful as other Google services.  For instance, there are so many videos on Google AdWords to help out on how to use their service, but I had hard time finding information to get the data.

I usually want to just get a sample text, and then modify to my need.  However, I was not able to find a sample file of such.  So if you are looking for a sample file, below is an excel file that I created to feed the data.   You just need to save the file as Tab Delimited.  I have included the tab delimited file format as well.   



Here is the official link for the feed Specification.

The hardest part is creating this feed. Once you have the file, you just need to login and click on “Data Feeds”.  Click on “New Data Feed” button and manually upload the file.  For a small file like mine takes about 10 minutes for them to process them.  Once the file is uploaded, the product must be approved by Google Team where you can see the status by clicking on “Product” link on the left.