Efficacy

The efficacy package contains a complete record of an eBay listing excluding bid history, listing description, demographics and shipping information. Some listing promotions which are currently on eBay are also not currently available in eBay's Market Data such as adding a border to your listing.

Description
Example Data

Pos	Column	Column Type	Description
1	Item_id	DECIMAL 18,0	The unique ebay item id for the transaction
2	Item_title	VARCHAR 255	Listing Title as entered by the seller.
3	Item_subtitle	VARCHAR 255	Listing Subtitle as entered by the seller.
4	Auct_start_date	TIMESTAMP	The start date and time of the auction in the following format "DD-MON-YY HH24:MI:SS"
5	Auct_end_date	TIMESTAMP	The auction end date and time in the following format "DD-MON-YY HH24:MI:SS"
6	Auct_durtn_days	DECIMAL 18,0	The duration of the auction (end date - start date). Can be different from the value set by the seller in some cases, like BIN.
7	Auct_type_code	DECIMAL 18,0	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	Lstg_curncy_id	DECIMAL 9,0	Currency Id . See values in lookup file : Currencies.
9	Leaf_categ_id	DECIMAL 12,0	Ebay category id associated with the item. See values in lookup file : Categories
10	Leaf_Categ_id2	DECIMAL 12,0	Secondary category id associated with the item. See values in lookup file : Categories
11	Slr_id	DECIMAL 18,0	Unique id of the item's seller (integer).
12	Start_price_usd	DECIMAL 15,2	The price of an item at the start of an auction/fixed price listing. For an auction, sellers have the option to set the initial price. (Price Displayed in USD) For fixed price items, the seller has the ability to change their price throughout the auction duration. In this case, the Start Price of the listing will reflect the most updated price.
13	Reserve_price_flag	CHAR 1	Indicates whether the listing used Reserve price option. Logic : if reserve price > 0.0 then 'Y' else 'N'
14	Curnt_price_usd	DECIMAL 15,2	The price at which the bidder or buyer is entitled to purchase the item. (If the reserve price is met). (in USD).
15	Bin_price_usd	DECIMAL 15,2	Buy It Now Price at which an Item is Listed, (in USD). The item may have been listed with the Buy It Now option, but sold as a regular auction. A positive value indicates that the BIN feature was used. The BIN Price will always be 0 for a Fixed Price Item.
16	GMV_usd	DECIMAL 15,2	Gross Merchandise Volume. The final selling price for all items successfully sold. (Quantity Sold * Final Sales Price) (in USD). Currently not updated for personal offers.
17	Qty_sold	DECIMAL 9,0	Quantity of items sold for a listing. This will always be 1 for Chinese Auctions
18	Qty_avail	DECIMAL 9,0	Quantity of items listed for sale. This will always be 1 for Chinese Auctions. For Fixed Price Auctions, the buyer can change the Qty Available throughout the duration of the Auction. This field will reflect the most updated Qty available.
19	Bidcount	DECIMAL 9,0	Number of bids the item received
20	Bin_sold_flag	VARCHAR 1	Flag to indicate if Auction was sold using BIN (Y/N)
21	Success_yn	VARCHAR 1	Flag to indicate if Auction was successful (Y/N)
22	Bold_fee_flag	VARCHAR 1	Flag (Y, N) indicating whether listing has Bold revenue associated with it.
23	Featured_fee_flag	VARCHAR 1	Flag (Y, N) indicating whether listing has Featured revenue associated with it.
24	Category_featured_fee_flag	VARCHAR 1	Flag (Y, N) indicating whether listing has Category Featured revenue associated with it.
25	Gift_fee_flag	VARCHAR 1	Flag (Y, N) indicating whether listing has Gift revenue associated with it.
26	Gallery_fee_flag	VARCHAR 1	Flag (Y, N) indicating whether listing has Gallery revenue associated with it.
27	Gallery_featured_fee_flag	VARCHAR 1	Flag (Y, N) indicating whether listing has Gallery featured revenue associated with it.
28	Ipix_featured_fee_flag	VARCHAR 1	Flag (Y, N) indicating whether listing has IPIX / EPS revenue associated with it.
29	Reserve_fee_flag	VARCHAR 1	Flag (Y, N) indicating whether listing has Reserve revenue associated with it.
30	Highlight_fee_flag	VARCHAR 1	Flag (Y, N) indicating whether listing has Highlight revenue associated with it.
31	Schedule_fee_flag	VARCHAR 1	Flag (Y, N) indicating whether listing has Scheduled revenue associated with it.

Example Row:

Delimiter: Each field is delimited by character 127, the delete character. Hold alt then type 0,1,2,7 in sequence will type the delete character or use "x7F" in most programming languages.
Example File Name: 20060513_site0_meta1_efficacy.data.gz for meta 1 on eBay.com ending on May 13, 2006.