Efficacy (Items Ended)

Here is a description of the columns contained in the Efficacy package, provided in the order they are encountered in the extract file. This document attempts to be database-independent by providing a proper description of the column type, instead of a SQL statement.
  • Each field is delimited by character 127, DEL. Try typing this by holding the alt key, then pressing 0,1,2,7 in sequence. Try representing it with your favourite programming language with "\x7F".
  • Items Ended are split into one file for each meta category, for each auction end date.

PositionNameColumn TypeDescription
1 Item_id Integer, up to 18 digits The unique ebay item id for the transaction. This number is a valid primary key over all of the auctions returned from eBay from all points in time.
2 Item_title String, up to 255 characters. Listing Title as entered by the seller. Listings titles have a 55 character limit.
3 Item_subtitle String, up to 255 characters. Listing subtitle as entered by the seller. See the description of the title for more information.
4 Auction_start_date Date and time, in DD-Mon-YY HH24:MM:SS This is the time that the auction starts. This time is in the Pacific standard time zone.
5 Auction_end_date Date and time, in DD-Mon-YY HH24:MM:SS This is the time that the auction ends. This time is in the Pacific standard time zone.
6 Auction_duration_days Integer, up to 18 digits long The duration of the auction (end date - start date). Can be different from the value set by the seller in some cases, such as when an auction ends with buy it now.
7 Auction_type_code Integer, between 1 - 10. The auction type code:
  • 1= Chinese (listings w/qty = 1)
  • 2= Dutch (listing w/qty >1)
  • 5= Live Auctions
  • 7= Store Fixed Price
  • 8= Personal offer
  • 9= Pure Fixed Price
8 Listing_currency_id Integer, 9 digits The unique identifier of the currency of the auction. Users should download the currency extract file to get a list relating the identifier to the name of the currency.
9 Leaf_category_id Integer, 12 digits The ID of the lowest level category that the item was listed in. See the cateogry extract for more information.
10 Leaf_Category_id2 Integer, 12 digits Secondary category ID associated with the item. This field may or may not be filled in. Use of this field indicates that the listing was listed in two categories; that is, the seller paid for the multi-listing feature. The value here may be a valid category ID, or, to indicate that the feature was not used, an empty string, a 0, or -999. Consider a category valid if it greater than 0 and not a zero-length string.
11 Seller_id Integer, 18 digits Unique ID corresponding to the eBay seller who sold the item.
12 Start_price_usd A decimal field capable of storing monetary values less than 10 trillion dollars. The price of an item at the start of a listing. For an auction, sellers have the option to set the initial price. For fixed price items, the seller has the ability to change the price throughout the listing duration. In this case, the Start Price of the listing will reflect the most recently updated price. This value is in US dollars.
13 Reserve_price_flag Character, either 'Y' or 'N'. Indicates whether the listing has a reserve price. If the auction had a reserve price, this field will contain 'Y,' otherwise, it will contain 'N.'
14 Current_price_usd A decimal field capable of storing monetary values less than 10 trillion dollars. The price at which the bidder or buyer is entitled to purchase the item, if the reserve price has been met. Price is displaced in US dollars.
15 Bin_price_usd A decimal field capable of storing monetary values less than 10 trillion dollars. The buy it now price at which an item is listed, displayed in US dollars. The item may have been listed with the buy it now option, but sold as a regular auction. A positive value indicates that the feature was used. This field will always be 0 for a fixed price listing.
16 GMV_usd A decimal field capable of storing monetary values less than 10 trillion dollars. Gross Merchandise Volume. The final selling price for all items successfully sold. (Quantity Sold * Final Sales Price) Price is displayed in US dollars. This field is currently not updated for personal offers.
17 Quantity_sold Integer, up to 9 digits Quantity of items sold in a listing. This will always be 1 for Chinese auctions
18 Quantity_available Integer, up to 9 digits Quantity of items listed for sale. This will always be 1 for Chinese auctions. For fixed price auctions, the buyer can change the quantity available throughout the duration of the auction. This field will reflect the most updated quantity available.
19 Bidcount Integer, up to 9 digits This shows the number of bids a listing received.
20 Bin_sold_flag Character, either 'Y' or 'N' Flag to indicate if auction was sold using the buy it now feature.
21 Success_flag Character, either 'Y' or 'N' Flag to indicate if a listing was successful. A successful auction sells at least one item.
22 Bold_fee_flag Character, either 'Y' or 'N' Flag used to indicate if an auction used the bold feature.
23 Featured_fee_flag Character, either 'Y' or 'N' Flag used to indicate if a listing is featured on the front page of eBay. eBay refers to this as "Home Page Featured." For more information on types of features, see eBay's site.
24 Category_featured_fee_flag Character, either 'Y' or 'N' Flag used to indicate if a listing used the "Featured Plus!" feature. From eBay:
" Your item will be shown prominently in the Featured Items section of its category list."
"Your Featured Plus! item will appear at the top of the page it naturally falls on in the search results list."
25 Gift_fee_flag Character, either 'Y' or 'N' Flag to indicate whether a seller listed the item with gift services. Gift services allows a seller to show a gift icon beside the listing, as well as indicate support for additional services, such as gift wrapping, shipping to the gift recipient, and express shipping.
26 Gallery_fee_flag Character, either 'Y' or 'N' Indicates whether or not a seller chose to use the gallery feature to sell his or her item. Items listed in the gallery will show up in searches and category browsing with a picture beside them, as well as showing up on gallery pages, also with a picture.
27 Gallery_featured_fee_flag Character, either 'Y' or 'N' Indicates whether or not a seller paid for the item to be featured in the gallery. Gallery featured items show up above the regular picture gallery.
28 Ipix_featured_fee_flag Character, either 'Y' or 'N' Indicates whether or not a listing used eBay Picture Services or IPIX.
29 Reserve_fee_flag Character, either 'Y' or 'N' This flag indicates whether or not a seller chose to set a reserve price.
30 Highlight_fee_flag Character, either 'Y' or 'N' This flag indicates whether or not a seller's auction used the highlighting feature.
31 Schedule_fee_flag Character, either 'Y' or 'N' This flag indicates whether or not a seller paid to schedule the start time (and thereby the end time) of the auction.