See how to export data from ChurnIQ.
The Transactions Report exports a row for every transaction completed in Cleeng, including initial purchases, recurring renewals, and subscription switches.
Note: All dates and times are in CET.
Each column has a source name (used when no formatting is applied during scheduled export) and a display name (used in the formatted version). The names below are the display names.
Fields
| Field | Type | Description | Is Filter |
| Transaction ID | varchar(50) | A unique transaction identifier (ID) that each transaction has. | Yes |
| Transaction Country | varchar(255) | The country assigned to where the transaction was made. | Yes |
| Date | date | The day on which the transaction was completed. | Yes |
| Date / Time | time | The day with the specific time on which the transaction was completed. | Yes |
| Month | int | The month in which the transaction was completed. | No |
| Week | int | The week in which the transaction was completed. | No |
| Customer ID | bigint | Customer identification in Cleeng. A unique reference ID for each customer that has a Cleeng account. | Yes |
| Customer email | varchar(128) | Customer email. | Yes |
| First name | varchar(255) | Customer first name, if provided through Cleeng Capture. | Yes |
| Last name | varchar(255) | Customer last name, if provided through Cleeng Capture. | Yes |
| Customer country | varchar(3) | The country setting of a customer. The initial country setting is automatically selected based on their IP detection. | Yes |
| Customer IP | decimal(35,6) | IP decimal of the last known customer IP address before the transaction was completed. | Yes |
| Customer currency | varchar(3) | Customer currency. | Yes |
| Offer ID | varchar(16) | Cleeng's offer identifier of the transaction. The structure is as follows: the first letter defines the type of offer. It is followed by 9 numbers, underscore, and country code, e.g. S123456789_PL. | Yes |
| Offer title | varchar(255) | The name/title of an offer. | Yes |
| Offer Group ID Title | varchar(255) | The name/title of the whole group of offers in case there are multilingual titles for offers dedicated for particular countries. | Yes |
| Offer type | varchar(16) | A parameter of the transaction offer. The Cleeng framework supports multiple offer types, all accessible via API and integrable with any CMS or platform: Live PPV (Event offer, Live offer), Pass (Season Pass), Subscription offer (deprecated term: subscription plan), and TVOD (Single offer, Rental offer). | Yes |
| Offer period | varchar(10) | Defines how long your customer will have access to your offer after purchase. Applicable to rental offers (exact access period) and subscription offers (recurring period, e.g. monthly, annual). | Yes |
| Offer currency | varchar(3) | The currency in which the offer is set by the broadcaster. | Yes |
| Offer price (excl. TAX) | decimal(35,6) | Value of the offer price without tax in offer currency. | Yes |
| Campaign ID | int | A unique identifier of the specific campaign, if a coupon was applied to discount the transaction. | Yes |
| Campaign name | varchar(255) | The name of the coupon campaign, if a coupon was applied to discount the transaction. | Yes |
| Coupon code | varchar(65) | A code used for promotions or support purposes, generated and distributed by a broadcaster. A customer can enter this to receive free access or a discount. | Yes |
| Discount rate | decimal(35,6) | The percentage of a discount applied on your offer price. | Yes |
| Discount value | decimal(35,6) | Value of the discount applied on an offer price. | Yes |
| Discounted offer price | decimal(35,6) | Price after subtracting the discount (without tax) in offer currency. | Yes |
| Publisher currency | varchar(3) | Broadcaster's currency, usually the same as the 'offer currency' but not necessarily. | Yes |
| Transaction price in publisher currency (excl. TAX) | decimal(35,6) | Value of the transaction in the broadcaster currency without tax. | Yes |
| Payment method | varchar(30) | The method used by a customer to make a purchase: Mastercard, Visa, AMEX, iDEAL, sms, ivr, direct banking, etc. | Yes |
| Payment type | varchar(10) | Type of the payment. Initial for first transactions, recurring for each non-first transaction of a subscription. | Yes |
| Transaction currency | varchar(3) | Currency in which the transaction was completed. | Yes |
| Transaction price (excl. TAX) | decimal(35,6) | Value of the transaction without tax in the transaction currency. | Yes |
| Applicable tax | decimal(35,6) | Value of the tax. | Yes |
| Tax rate | decimal(35,6) | The tax rate applied to the transaction, expressed as a percentage. Calculated as: applicable tax / transaction net price. | No |
| Transaction price (incl. TAX) | decimal(35,6) | Value of the transaction with tax in the transaction currency. | Yes |
| Merchant of Record | varchar(255) | Legal entity that handles all payments and takes on the liability related to a transaction. Either Cleeng or the Broadcaster. | Yes |
| Payment external ID | string | External payment ID, if populated in the payment process through the APIs and webhooks. | Yes |
| Transaction external data | string | Additional information about the transaction delivered by the broadcaster. | Yes |
| Customer External ID | varchar(255) | External Customer unique identifier, if populated in the payment process. | Yes |
| Subscription ID | int | Unique identifier of the subscription. | Yes |
| Subscription Switch Direction | string | Upgrade or Downgrade (based on your switch settings), or Unspecified (for externally-managed subscriptions when the Cleeng system cannot determine the direction). | Yes |
| Subscription Switch From Offer ID | string | ID of the subscription that was changed (switched from). | Yes |
| Subscription Switch ID | string | A unique reference ID for each switch. | Yes |