What is the file format of the transaction download file?

The file format of the transaction download file is either text (.txt), which does not include headers, or excel (.xls), which does include headers. It contains the following information:

FieldDefinitionData FormatDelimiter
Event DateThe date the event (transaction) occurred. Date(YYYY-MM-DD)TAB
Posting DateDate that the event (transaction) posts to the transaction download report. Events typically post the day following the event date.Date(YYYY-MM-DD)TAB
Event TypeName of the event (transaction).
Ex: Bid, Bin, ACRU, Winning Bid (Revenue) etc.
VARCHAR(32)TAB
AmountWinning Bid (revenue): This is the amount of eBay Revenue associated with a Winning Bid.
Number (count) of Sales (ex: ACRUs, 1st Bid / BIN, etc.).
Half.com Total Sale Amount.
Please note this column is not your earnings for a transaction. To calculate your earnings for individual events, please apply your tiers for the appropriate Program and Event Type. For information on the tier you are actively earning commissions, please see the Programs tab and click on the "Payment Structure" link associated with that Program. The active tier will be highlighted in yellow
DECIMAL(18,2)TAB
Program IdUnique Identifier for the Program where the event (transaction) occurred (ex: the eBay UK Program ID is 15). For more information, please visit the Programs tab or run a By Program Summary Report on the Reports tab.DECIMAL(18,0)TAB
Program NameName of the Program for where that event (transaction) that event (ex: eBay FR, Half.com, etc). For more information, please visit the Programs tab or run a By Program Summary Report on the Reports tab.VARCHAR(32)TAB
Campaign IdUnique Identifier for the Campaign that drove the event (transaction). For more information, please visit the Campaigns tab or run a By Campaign Summary Report on the Reports tab.DECIMAL(18,0) TAB
Campaign NameName of the Campaign drove the event (transaction). For more information, please visit the Campaigns tab or run a By Campaign Summary Report on the Reports tab.VARCHAR(100)TAB
Tool IdUnique Identifier for the Tool that drove the event (transaction). (ex: Link Generator is Tool Id 10001; eBay_Dynamic Listing_120x600 Banner is Tool Id 56006). For more information, please visit the Tools tab or run a By Tool / Creative Summary Report on the Reports tab.DECIMAL(18,0)TAB
Tool NameName of the Tool that drove the event (transaction). (ex: Link Generator; Editor Kit; eBay_Dynamic Listing_120x600 Banner). For more information, please visit the Tools tab or run a By Tool / Creative Summary Report on the Reports tab.VARCHAR(50)TAB
Custom IdCustom ID is an affiliate defined 256 character flex field that you can leverage to better monitor your marketing efforts. A Custom ID can be appended while creating your links through our Link Generator, Creative Generator or Widgets. This value is associated with each transaction you drive and will be available in your transaction download reports.VARCHAR(256)TAB
Click TimestampThe Date and Time of the Click that drove the event (Transaction).Date(YYYY-MM-DD HH24:MI:SS)TAB
eBay Item IdA unique identifier for an item listing on eBay.VARCHAR(128)TAB
Leaf Category IDThe lowest-level, or most specific, eBay category associated with your transaction.VARCHAR(128)TAB
eBay Quantity SoldThe number of items sold in your transaction.VARCHAR(128)TAB
eBay Total Sale AmountThe total sale amount of your transaction.VARCHAR(128)TAB
Item Site IDThe site ID for the site where your transaction was purchased. VARCHAR(128)TAB
Meta Category IDThe top level, or most general, category that is associated to your transaction VARCHAR(128)TAB
Unique Transaction ID(Revshare transactions only) A unique Transaction ID you can use to track each transaction individually, as well as any associated actions taken against this specific transaction, such as a credit. VARCHAR(128)TAB
FlexField8Reserved for future use. VARCHAR(128)TAB

Do you have a question on this topic? Contact us