What Makes A Good Data Feed Tips For Merchants - Slides for eComXpo - 28.Jan 2009

100 %
0 %
Information about What Makes A Good Data Feed Tips For Merchants - Slides for eComXpo -...
Business & Mgmt

Published on January 24, 2009

Author: Cumbrowski.com

Source: slideshare.net

Description

This are the slides for my presentation at eComXpo.com Virtual Internet Marketing Trade Show (Jan 28-29, 2009). My presentation is the last presentation on the first day of the show, on Wednesday, January 28, 2009 at 8:20 pm EST.

The presentation (with audio) is about 50 minutes in length and has 43 slides, which you can download here.

Note: If my voice in the actual presentation sounds a bit odd, sorry for that. I recorded the presentation while I had a bronchitis and barely any voice at all :(

I will publish the video recording on the presentation on Google Video after my presentation was first presented at eComXpo.

... and don't forget to check out the datafeed resources at my site Cumbrowski.com/datafeeds
and Cumbrowski.com/datafeeds101

What Makes a Good Data Feed? Tips for Merchants What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Presented by Carsten Cumbrowski Each type of affiliate has different needs and requirements to be able to leverage your product feed and integrate it into their web sites. What are those different types, what are their individual needs and why? Technical best practices and specific actionable tips for how you can make your data feed easily accessible and to work with. How to make them work across different platforms to avoid losing big chunks of affiliates for mere technical reasons. The ingredients for a data feed that is actually useful for your affiliates. Internet Marketing Resources Portal Presentation is available at Slideshare.net/Cumbrowski.com

Each type of affiliate has different needs and requirements to be able to leverage your product feed and integrate it into their web sites.

What are those different types, what are their individual needs and why?

Technical best practices and specific actionable tips for how you can make your data feed easily accessible and to work with.

How to make them work across different platforms to avoid losing big chunks of affiliates for mere technical reasons.

Carsten Cumbrowski - Short Intro What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal Born in (East) Berlin/Germany Came to the United States in May 2000 Affiliate marketer since early 2001 Affiliate manager for BevMo.com 2002-2006 (via CJ) Operated a price-comparison site for several years, where I worked with hundreds of product data feeds; from networks and custom Blogger at ReveNews.com and SearchEngineJournal.com Marketing resources collection at Cumbrowski.com especially http://www.Cumbrowski.com/datafeeds

Born in (East) Berlin/Germany

Came to the United States in May 2000

Affiliate marketer since early 2001

Affiliate manager for BevMo.com 2002-2006 (via CJ)

Operated a price-comparison site for several years, where I worked with hundreds of product data feeds; from networks and custom

Blogger at ReveNews.com and SearchEngineJournal.com

Marketing resources collection at Cumbrowski.com especially http://www.Cumbrowski.com/datafeeds

The Structure of this Presentation What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal The use of Data Feeds and their Content Technical Tips to Format, Deliverability and Structure

The use of Data Feeds and their Content

Technical Tips to Format, Deliverability and Structure

Feed Affiliates are Made Equal What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal

Feed Affiliates are NOT Made Equal What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal

Feed Affiliates are NOT Made Equal What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal

Types of Feed Affiliates (Generalization) What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal Price Comparison Sites Niche Directories Coupon Affiliates/Price Drops Content Affiliates/Specialty Sites Bloggers

Price Comparison Sites

Niche Directories

Coupon Affiliates/Price Drops

Content Affiliates/Specialty Sites

Bloggers

Types of Feed Affiliates (Generalization) What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal Content Affiliates/Specialty Sites Bloggers Should not use raw product data feeds, but sometimes do, due to the lag of alternatives

Content Affiliates/Specialty Sites

Bloggers

Content Affiliates/Bloggers What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal Should not use raw product data feeds, but sometimes do, due to the lag of alternatives Provide tools that are based on product feeds Widgets/Gadgets Product Show-Case Creators

Widgets/Gadgets

Product Show-Case Creators

Content Affiliates/Bloggers What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal Use 3 rd Party Providers and/or Custom and/or Networks Provide tools that are based on product feeds. Widgets/Gadgets Product Show-Case Creators

Widgets/Gadgets

Product Show-Case Creators

Types of Feed Affiliates (Generalization) What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal Price Comparison Sites Niche Directories Coupon Affiliates/Price Drops 3 rd Party Tools Providers

Price Comparison Sites

Niche Directories

Coupon Affiliates/Price Drops

3 rd Party Tools Providers

Examples: Price Comparison Site What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal

Examples: Price Drop/Coupon Site What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal

Examples: Niche Directory What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal

Examples: Content Site (Widgets) What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal

Everybody Likes What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal Unique Identifier of Product within Feed(s)

Unique Identifier of Product within Feed(s)

1. Price Comparison Affiliates What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal Information to match your products with the same product by other merchants BAR Code Information EAN / EAN-13 UPC-A / UPC-C ISBN / ISBN-13 (“Bookland”) and/or Manufacturer Part # / Manufacturer Name

BAR Code Information

EAN / EAN-13

UPC-A / UPC-C

ISBN / ISBN-13 (“Bookland”)

and/or

Manufacturer Part # / Manufacturer Name

1. Price Comparison Affiliates What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal Info to determine/estimate FINAL purchase price Shipping Cost Packaging and other Surcharges Tax Information Usually smaller product images/thumbnails preferred Detailed Description is often appreciated to build info page for “master product”

Info to determine/estimate FINAL purchase price

Shipping Cost

Packaging and other Surcharges

Tax Information

Usually smaller product images/thumbnails preferred

Detailed Description is often appreciated to build info page for “master product”

2. Coupon Affiliates / ”Price Drops” What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal Start/End Date/Time for “ on-Sale ” Price, if available “ Regular-Price” is used for MSRP (SRP or RRP) ?

Start/End Date/Time for “ on-Sale ” Price, if available

“ Regular-Price” is used for MSRP (SRP or RRP) ?

MSRP Problem Illustration What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal

3. Niche Directories What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal Product Categorization that makes sense Don’t “lump” thousands of products into one category Also try to avoid one product = one category

Product Categorization that makes sense

Don’t “lump” thousands of products into one category

Also try to avoid one product = one category

3. Niche Directories / Categorization What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal 1. 2. 3.

What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal

The Basic Elements What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal Format Column Delimiter Row Delimiter Escaping of Special Characters/String Formatting Headers/no Headers Structure Column Names, Order, Types and Defaults Delivery Methods/Access to Feed

Format

Column Delimiter

Row Delimiter

Escaping of Special Characters/String Formatting

Headers/no Headers

Structure

Column Names, Order, Types and Defaults

Delivery Methods/Access to Feed

What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal There is NO Right Format or Delivery Method! Provide as many Options as Possible! Let each Affiliate Choose for Itself!

There is NO Right Format or Delivery Method!

Provide as many Options as Possible!

Let each Affiliate Choose for Itself!

What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal Document it! Affiliates are NO Fortune Tellers! Knowing is ALWAYS better than Assuming!

What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal Whatever you do is entirely your choice and should be controlled by business sense and economics Most Affiliates can work with what you got, if you provide Documentation. One Exception! It must be possible to Access and Process your Feeds without any human interaction! No Login Forms to fill out No Messages that must be acknowledged No Choices that must be made manually every time

No Login Forms to fill out

No Messages that must be acknowledged

No Choices that must be made manually every time

What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal The Power of Know! Practical Example Canon - PowerShot 10.0-Megapixel Digital ELPH Camera – Silver SKU: 8800577 http://.../images/products/ 8800 / 8800577 _sc.jpg http://.../images/products/ 8800 / 8800577 _sb.jpg http://.../images/products/ 8800 / 8800577 _sa.jpg Thumbnail Images (Product Listing) Medium Size Image (Product Detail) Large Image (Pop-Up)

What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal The Power of Know! Practical Example Sony - Cyber-shot 10.1-Megapixel Digital Camera - Green SKU: 8943129 Guess the URLs to the different sized product images for this item!

What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal The Power of Know! Practical Example Sony - Cyber-shot 10.1-Megapixel Digital Camera - Green SKU: 8943129 http://.../images/products/ 8943 / 8943129 _sc.jpg http://.../images/products/ 8943 / 8943129 _sb.jpg http://.../images/products/ 8943 / 8943129 _sa.jpg Thumbnail Images (Product Listing) Medium Size Image (Product Detail) Large Image (Pop-Up) Correct?

What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal The Power of Know! Practical Example Sony - Cyber-shot 10.1-Megapixel Digital Camera - Green SKU: 8943129 http://.../images/products/ 8943 / 8943129 _sc.jpg http://.../images/products/ 8943 / 8943129 _sb.jpg http://.../images/products/ 8943 / 8943129 _sa.jpg Thumbnail Images (Product Listing) Medium Size Image (Product Detail) Large Image (Pop-Up) Oops!

What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal The Power of Know! Practical Example Sony - Cyber-shot 10.1-Megapixel Digital Camera - Green SKU: 8943129 http://.../images/products/ 8943 / 8943129 _ r c.jpg http://.../images/products/ 8943 / 8943129 _ r b.jpg http://.../images/products/ 8943 / 8943129 _ r a.jpg Thumbnail Images (Product Listing) Medium Size Image (Product Detail) Large Image (Pop-Up) Why r and not s ? I have no Idea.

Some Specific Tips Based on my own personal experience and talks with other people who work with data feeds and both end of the process, including: What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal Merchants Networks Third Party Vendors Other Affiliates, including “competitors”

Merchants

Networks

Third Party Vendors

Other Affiliates, including “competitors”

Some Specific Tips What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal Column Delimiter: TAB character (ASCII character code 9) Feed content is used in almost every case for the use on the Internet and rendered in HTML. HTML does not have a TAB character or an equivalent for it. Any TAB character in content of your product catalog should be replaced with something appropriate. You probably do this already on your own web site, where you get the same problem. Ask your webmaster what they do there. Maybe there is no TAB character in the database Anymore already, or they might replace TABs with a fixed number of spaces. Whatever the Case might be, do the same during the export of your feed and include this information In your feed documentation for your affiliates.

Column Delimiter: TAB character (ASCII character code 9)

Some Specific Tips What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal Row Delimiter: Line-Feed (ASCII character 10) The format to indicate a new line in text files (line-break) varies between computer platforms. I strongly recommend to let your affiliates specify the platform they are using to process your feeds, save it with their account and generate feeds for them according to this setting. Microsoft Windows (and MS DOS) uses the character combination of Carriage-Return (CR, ASCII character 13) and Line-Feed (LF, ASCII character 10) Unix and Linux systems only use the Line-Feed character (LF, ASCII character 10) Macintosh uses only the Carriage Return character (CR, ASCII character 13) Most Windows and Macintosh DB applications are capable of handling the Unix line-break.

Row Delimiter: Line-Feed (ASCII character 10)

Some Specific Tips What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal No special enclosure of text values, e.g. using double-quotes There is no need for this special treatment, especially if you replaced all column and row delimiters that appear in the content itself. I did not have the space left in the previous slide, but I strongly suggest replacing any line-breaks that appears in your content with Something else and again include this information in your feed documentation. I suggest using <BR/> , which is the HTML tag to generate a line-break. The advantage of doing this is obvious and publishers who do not like it can easily strip or replace it during the import of your feed, if they want to.

No special enclosure of text values, e.g. using double-quotes

Some Specific Tips What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal Include Column header as the first Row within the feed. Do not use any special characters in the name, including spaces. Use only the characters a-z and/or A-Z, 0-9 If you want to _ as a separator between words for better readability. Make the column titles as descriptive as possible, but also as short as possible. This is not a substitute for a Written documentation of the feed structure. It only supports it, like a reference card only supports a user manual, but not replaces it. Do not make the titles longer than 64 characters Use First Row in the Feed for Column Titles/Headers

Use First Row in the Feed for Column Titles/Headers

Some Specific Tips What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal You want relay hierarchical information within your two-dimensional data feed. For example a product category structure. The semi-standard method of doing this is to include all parents of the node in the column data, which contains the information about the node where the item is attached to in addition to the node itself. The individual levels are usually separated by the character “>”. The value starts with the top parent node in the root and ends with the node itself. Example: Item A is attached to sub-category Z. Sub-category Z is a child node of Category Y, which is right below the root of hierarchy. The content for the category information of Item A would look like this: Category Y>Sub-category Z Transmitting Hierarchy Information

Transmitting Hierarchy Information

Some Specific Tips What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal Initialize cells with no values for the item properly Numeric Values Usually 0, if there is no value. You can use the initial value to relay information about the format of the data in this column, if you actually have data for an item. This is especially helpful, if only few items have a value for it or if the value is seasonal in nature and not used all the time. 0.000 Numeric values with up to 3 digits after the decimal point (e.g. weights) 0.00 Numeric values with up to 2 digits after the digital point (e.g. price values) 0.0 Numeric values with up to 1 digit (e.g. length, dimensions) 0 Numeric values without digital point. Numbers.

Initialize cells with no values for the item properly

Some Specific Tips What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal Initialize cells with no values for the item properly Date/Time Values Often left empty if item has no value for this property. What is the format, if there Is a value? Is it just a date or only a time or date & time? U.S. date format, British? Maybe ISO xxxx or something entirely different . Maybe even just text entered by a human with no rules (oh horror!). There are ways to let publishers know (additionally to spelling it out in the documentation of the feed) via the initial values in the feed data . Examples for some initial date/time values that can “talk” about the format for records that do have real values to watch out for: 01/31/1900 31/01/50 12:00 AM 19001231

Initialize cells with no values for the item properly

Some Specific Tips What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal … There are many more tips like this, but beyond the time limit and scope of this presentation. I included the ones that I consider to be the most important ones and caused me at least the most head-aches and problems with the processing and use of merchants Product data feeds. There is much more. See the resources recommendation at the end of my presentation. … and more; and more… etc.

Recommended Data Feed Resources What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal Article Merchant Product Data Feeds for Affiliates – 101 http://www.Cumbrowski.com/datafeeds101 and Slideshare.net/Cumbrowski.com Collection of Resources http://www.Cumbrowski.com/datafeeds

This Presentation is available at: What Makes a Good Data Feed? Tips for Merchants Jan 28 -29, 2009 Internet Marketing Resources Portal Slideshare.net/Cumbrowski.com Carsten Cumbrowski [email_address] www.Cumbrowski.com/about www.Cumbrowski.com/contact Thank You!

Add a comment

Related presentations

Related pages

Articles about Affiliate Marketing, Product Datafeeds ...

Articles about Affiliate Marketing, Product ... 01/27/2009 What Makes a Good Data Feed? Tips for Merchants ... by Carsten Cumbrowski at eComXpo virtual ...
Read more

eComXpo 2009 - The Virtual Tradeshow for Internet ...

... eComXpo virtual tradeshow for internet marketers, ... What Makes a Good Datafeed? Tips for Merchants ... data feeds. My presentation slides are ...
Read more

Affiliate Product Data Feeds Resources, Affiliate Network ...

Affiliate Product Data Feeds Resources, ... What Makes a Good Datafeed? Tips for Merchants - Video recording ... 2009. The PowerPoint slides of this ...
Read more

Information is Beautiful

What Makes A Good Data Visualization? ... Information is Beautiful. To receive updates in your inbox. About. ... RSS Feed © Information is ...
Read more

For Dummies

The official For Dummies Facebook page. ... Read these tips to get you started. ... 2009. Highlights All Stories. See More Stories.
Read more

inc.com - Small Business Ideas and Resources for Entrepreneurs

Visit Inc.com for the latest issue of Inc. Magazine and get advice, ... Big Data; Money. Bootstrapping; Crowdfunding; Venture Capital; Borrowing; Business ...
Read more

Make: DIY Projects and Ideas for Makers |

Get the Magazine. Make: is the voice of the Maker Movement, empowering, inspiring, and connecting Makers worldwide to tinker and hack. Subscribe to Make ...
Read more

ASP.NET | The ASP.NET Site

ASP.NET is a free web framework for building great Web sites and Web applications using ... Data Access. Entity Framework; More. ... Community spotlight ...
Read more