Transactions Reporting

The Transactions Reporting feature allows you to run a sales report by various search criteria. The page has two major sections: the Search Criteria box, which lets you set the parameters of your search, and the Search Report area, which presents your search results in tabular format.

The following subjects are covered in this article:

Running Sales Reports

You can run transaction reports using date, customer, and transaction parameters. The report displays all transactions that meet each of the parameters you specify.

To run sales reports within Transactions Reporting:

  1. Log in to your ClickBank account.
  2. Click the Reporting tab.
  3. Click Transactions.
  4. Enter information for one or more of the following parameters:
    • Receipt Number – Enter the receipt number of the desired transaction. This search parameter is not compatible with other parameters.
    • Date – You can use the Preset option to select a date range, or select a start and end date to search for transactions within that date range.
    • TID – The Transaction ID for the desired transaction.
    • Last Name – A customer's last name or a portion of a customer's last name. You can also search by the customer's last name and first name using the format lastname.firstname.
    • Email – A customer's email address.
    • Item – The item number for one of your products.
    • Role – Your role in the transaction. For example, selecting Vendor only includes transactions where you were the vendor. The available options are Vendor, Affiliate, Upsell JV Contract, Traditional JV Contract, and Affiliate Referral.
    • Results/Page – The number of search results to display per page. Select 50, 100, 500, or 1,000. 100 is the default.
    • Vendor – The vendor for the desired transactions.
    • Affiliate – The affiliate for the desired transactions.
    • Affiliate Characteristics – You can use these checkboxes to include or exclude transactions with these characteristics: sales without an affiliate, sales attributed using a hoplink, sales attributed using email-based attribution, or lifetime commission sales.
    • Credits – You can use these checkboxes to include or exclude sales, rebills, bonuses, or reissues. The default setting displays all credits except for reissues.
    • Debits – You can use these checkboxes to include or exclude refunds, chargebacks, bounced payments, and charges. The default setting displays all debits except for charges.
    • Tests – You can use these checkboxes to include or exclude test sales, refunds, and charges. The default setting excludes all test transactions.
    • Line Item Order Types – You can use these checkboxes to include or exclude the following order types: Initial purchases, purchases made as part of a cart, purchases made as part of an order bump, token purchases, and purchases made as part of an upsell. The default setting includes all order types.
    • Purchase Type – You can use these checkboxes to include or exclude the following purchase types: Standard (non-token) purchases, token purchases, and purchases made using a specific coupon code.
  5. Click Go.
    NOTE – If you are searching by Receipt Number, you must use the Go button beneath the Receipt Number field. If you are searching using other parameters, you must use the Go button beneath the other parameters.

Search Results

Once you make your selections and click Go, the search results for your query appear in a table below the search criteria.

Note – A transaction report can generate the values No Affiliate and No Tracking Code. These are the sum of all transactions that did not contain a value for your requests.

Column Function
Actions
  • Email – Click the envelope icon to send the customer an email.
  • Ticket – Click the T icon to open the ticket for the transaction or to view the ticket details.
  • Details – Click the magnifying glass icon to view details on the transaction.
  • PDF – Click the PDF icon to download a PDF receipt.
  • Contract – Click the people icon to view details of the contract.
Date This is the date the transaction took place.
Time This is the time the transaction took place.
Refund Expiration The date on which the 60-day refund period for the transaction expires.
Receipt

This is the unique ClickBank receipt number for the order.

Vendors can see all eight characters in the receipt, while affiliates can see the first three followed by five Xs.

Rebills have the same receipt number as the initial order, followed by a dash and a four-digit number showing its place in the series of rebills.

Item This is the number that is associated with a specific product. Each product is assigned a unique item number when it is created in the system.
Amount This is the amount of the transaction.
Quantity The quantity of the specified item purchased in the transaction.
Txn Type This is the Transaction Type. The following are valid transaction types:
  • Sale – A sale transaction
  • Sale-RB – A sale transaction for the initial sale of a recurring billing product.
  • Rebill – A sale transaction for a rebill of a recurring billing product.
  • Bounced – The customer’s bank returned the customer’s check to us unpaid. When this happens, the profit you received from the sale is deducted from your account, along with a $1 charge.
  • Refund – ClickBank approved a return of the order either by the vendor’s request or the customer’s request.
  • Chargeback – The customer requested a refund directly from his or her bank. In this case, the profit you earned from the sale is deducted from your account. If you are the vendor of the product, a bank penalty charge is also deducted from your account.
TID The Tracking ID of the transaction (if applicable).
Upsell From The products, if any, that include the purchased product as an upsell
Has Upsells The products, if any, included as an upsell of the purchased product 
Line Item Type

The type of purchase for this line item. The possible line item types are:

  • Original – An initial purchase.
  • Cart – A purchase as part of a cart order.
  • Bump – A purchase made through an order bump.
  • Token – A token purchase.
  • Upsell – A purchase made through an upsell flow.
Pmt This is the method of payment:
  • CARD – This is the brand of credit card such as AMEX (American Express), DISC (Discover), MSTR (MasterCard), or VISA
  • PYPL – PayPal
Currency This is the currency type used for the purchase. The following are valid currency types:
  • AUD – Australian Dollar
  • CAD – Canadian Dollar
  • CHF – Swiss Franc
  • DKK – Danish Krone
  • EUR – Euro
  • GBP – British Pound
Discount The discount amount applied to the transaction.
Code The coupon code used in the transaction, if any.
Vendor The account nickname of the vendor who created the purchased product.
Affiliate The account nickname of the affiliate on the sale, if any.
Commission Attribution

The method used to attribute affiliate credit:

  • Hop – Attribution using a HopLink.
  • Email-Based – Email-based affiliate attribution.
  • Lifetime Commission – A lifetime commission.
CC The Country Code for the nation where the customer is located.
St The code for the state where the customer is located (if applicable).
Last Name The customer's last name.
This information is only available to the vendor.
First Name The customer's first name.
This information is only available to the vendor.
Display Name The customer's full name or preferred name.
This information is only available to the vendor.
Email The customer's email address.
This information is only available to the vendor.
IP Address The customer's IP address.
Zip Code The customer's zip code.
Have more questions? Submit a request

4 Comments

  • 0
    Avatar
    Stephen Davies

    You should probably make it known that this information is mainly for the Vendors and not affiliates. Affiliates do not have access to the IP's, Names, Zip codes, Or email addresses and can only be obtained if you are the vendor. If I am wrong on this, please correct me because I would love to have some of this information for tracking purposes. Thank you!

  • 0
    Avatar
    Owen Allen

    Stephen,

    You are correct that some fields are not available to the affiliate. However, the transaction report as a whole, and any customer information that's not identified as vendor-only, is displayed for affiliates.

  • 0
    Avatar
    Majid Nazir

    Hello 

    how can see All time earning, i want to see my 2014-2015 earning how can i see that.

    [Edited by ClickBank]

  • 0
    Avatar
    Owen Allen

    Majid,

    You can take a look at paychecks reporting to see your past paychecks. Take a look at the How We Pay You article for more information.

Please sign in to leave a comment.
Powered by Zendesk