Optimizing with the Transaction Download Report

Hand drawing a game strategy eBay Partner Network provides a wealth of information through our reporting interface. The Summary Reports allow you to view data in a number of different ways and even dynamically create graphs against two different axes. Reports can be viewed across various timeframes by campaign, tool or program, and even by traffic type (mobile vs. classic). Summary Reports include valuable data to help you track Key Performance Indicators (KPIs) and answer fundamental questions like:

Impressions to Clicks (Click-Through Rate): Are my users interested in what I’m promoting?

Click to Bid/BIN and Bid/BIN to Winning Bid/BIN: Are the items I’m promoting converting into activity for which I’ll be paid?

WBR/GMB:  Which sales are generating the most revenue for eBay, and in turn, for me?

However, if you aren’t already using it, the Transaction Download Report provides complete details of all of the transactions your traffic has generated for any program within the eBay Partner Network. Under our new pricing model, the Transaction Download Report can help optimize your traffic and earnings more than ever before.

Partners are paid a percentage of revenue based on the category of an item that was purchased and earn a bonus if that user is new or reactivated (no purchases in the past 12 months), and the inclusion of earnings by transaction and User Frequency Value allows partners to understand exactly what segments of traffic are most profitable.

An essential step to understanding this data is to create segments. Both the Campaign ID and Custom ID parameters allow you to create a limitless number of segments to help understand how to best optimize. Download the report into a program like Microsoft Excel, and you can sort or create a pivot table to analyze segments at a more granular level.

How can I reconcile my Transaction Download and my Summary Report?

Unlike Summary Reports, the Transaction Download Report is based on the date the transaction is posted to this report, rather than the date the transaction occurred. This ensures the reports downloaded are final for the posting date range specified in the report filters. Transactions are typically posted one day after the transaction date, but ePN can also make corrections to a transaction after its original posting date.

What are the negative amounts that are posted in the Transaction Download Report?

ePN can post daily corrections to previously credited Winning Bid (Revenue) transactions. These corrections can be positive or negative amounts that adjust the revenue and earnings associated with the original transaction to accurately reflect the amount of revenue that eBay receives. All information for these Winning Bid (Revenue) corrections will be identical to the original event other than the Posting Date and Amount columns. Examples of credits or debits to your account include the buyer returning the item to a seller, Unpaid Items (UPI), Seller Credits or delayed Final Value Fee revenue.

What details are included in the Transaction Download Report?

The following fields are included in the Transaction Download Report:

Field name Definition
Event Date The date the event, or transaction, occurred.
Posting Date Date that the transaction posts to the Transaction Download Report. Events typically post the day following the event date.
Event Type Name of the event or transaction. For example: Bid, BIN, ACRU, or Winning Bid (Revenue).
Amount The amount in this column represents various things, depending upon the context of the transaction in the row.

  • Winning Bid - The amount of eBay Revenue associated with the winning bid.
  • Number (count) of Sales - The total number of transactions, such as ACRUs, first bids, or BINs.
  • Half.com - The total sale amount.

Note: This column is not the earnings for a transaction.

Program ID Numeric identifier for the Program where the transaction occurred. For example, the eBay UK Program ID is 15. To identify the Program, use the value in the Program Name field.
Program Name Name of the Program for associated with the transaction — for example, eBay FR or eBay US.
Campaign ID The Campaign ID for the Campaign that drove the transaction.
Campaign Name Name of the Campaign that drove the transaction.
Tool ID The Tool ID for the tool that drove the transaction. For example, the Link Generator is Tool ID 10001, the eBay Dynamic Listing_120x600 Banner is Tool ID 56006.
Tool Name The name of the tool that drove the transaction.
Custom ID Custom ID associated with the transaction. The primary purpose of the Custom ID is for tracking in the Transaction Download Report.
Click Timestamp The date and time of the click that drove the transaction.
eBay Item ID A unique identifier for an item listing on eBay.
Leaf Category ID The lowest-level, or most specific, eBay category associated with transaction.
eBay Quantity Sold The number of items sold in the transaction.
eBay Total Sale Amount The total sale amount of the transaction (GMB)
Item Site ID The site ID for the site where the item was purchased.
Meta Category ID The top level, or most general, category that is associated to the transaction.
Unique Transaction ID 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.
User Frequency ID The types of eBay buyers being attracted, in terms of three categories:   (1 = New/Reactivated, 2 = Infrequent, 3 = Frequent)
Earnings The amount earned from a transaction.
Traffic Type This column indicates the type of device the traffic converted on

  • Mobile - This transaction converted on a Mobile device.
  • Classic - This transaction converted on a PC.
Item Name Name of the eBay item associated with the transaction.