Articles in this section

Transactions Reporting

Avatar
Owen Allen
Updated
Follow

The Transactions Reporting feature lets you 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.

By default, before any search criteria are entered, the Search Report area shows all credits and all debits except for charges in which the current account was involved.

NOTE – Transactions in which you earn 0% are not displayed in transactions reporting, but are included in transaction quality metrics and analytics. For example, if you are the affiliate for a product with an initial commission but a 0% recurring commission, the rebills are not displayed here, but their quality is included in your transaction quality reporting.

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. If you have not specified any parameters, the default display shows the most recent transactions.

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 you earned for the transaction.
Since this is a net amount, it will not match the gross transaction amount used in the Transaction Quality Metrics.
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.
Declined Consent The customer's consent selection. An X indicates that the customer does not consent to marketing communications.

Related Articles

  • Analytics Reporting – This article explains the analytics reporting tool, which presents charts and data on sales trends.

Related articles