Create a Google Product Search Feed
Elizabeth Marsten May 21 2008
Google Products are listed on the search engine result pages of Google’s Shopping category.
Each listing is a product that was submitted by a merchant. Listing your own products is free, so why not try it out?
Here’s how to set up your very own Google Product Feed.
- Go to www.google.com/base, click on "Data Feed" and login with your Google Account login.
- Click on "create another account to manage" enter the name of your site, display URL and optional description.
Next we’ll create the feed.
- Create a new Excel spreadsheet with these headings:
- Image link
These are the required attributes. After you get comfortable with product feeds you’ll be able to choose from many optional attributes too as well as additional information such as brand names, condition, ISBN or UPC codes.
- If you USE Google Analytics, add a UTM code on the back end of all of the destination URLs. Otherwise, GA will attribute all sales and visits to Google organic search results.
I suggest using &utm_source=google+products. You can create your own tag if you prefer. This tag will also pick up the keywords that the user used while searching Google Shopping.
The easiest wat to add this code is to create a simple Excel formula.
- Go to a cell in your URL + Code column. (I’m using F17)
- Type = and the cell of the destination URL (=E17)
- Add &"&utm_source=google+products"
- Your finished formula will be =E17&"&utm_source=google+products
- Copy the cell with your formula and paste in into to the rest of the cells in the same column.
- You should now have two columns of destination URLs, one without the code and one with the code.
- Select cells in the the column of new destination URLs, copy them then paste special as values on top of the original destination URLs.
- Delete the column with the formulas you just made.
- Save, using File – Save As, your document as a tab delimited text (.txt) file.
Voila! Your product feed is ready to upload into Google Shopping Search.
- Return to your new Google Base account.
- Click New Data Feed.
- Create a name for your file.
- Select the appropriate category for your products.
- Click Register data feed and continue to formatting instructions.
- Now that you have registered your feed you are ready to upload your list of products!
- Click on Manual: upload file.
- Select your .txt file on your computer.
- Click "upload".
Google will now upload and process your list of products. It can take as little as 5 minutes or as long as 48 hours depending on the size and complexity of your file. Wait at least a day before you search for your products and store.
- Troubleshooting If your file is rejected, there will be an error message as to why. One thing to check is your settings. If you followed the above instructions, these should be what your settings look like if you click on "edit" next to the file name:
Next Time: Taking this same file and making it work for MSN Live Search Products!
Vice President of Search Marketing
Elizabeth supervises the overall search division at Portent, which includes PPC, SEO, Social Media and Analytics. If you really want to know more about her check out her bit.ly bundle. Elizabeth has written several ebooks, is a ClickZ columnist, a Lynda.com course author, a Dummies book author and speaks on PPC across the USA at various conferences including the SMX shows, mozCon and Hero Con. Read More