See how to export data from ChurnIQ.
The User Report exports a row for every customer in Cleeng, including their account details, contact information, consent settings, and custom registration answers.
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 |
| Customer ID | bigint | A unique reference ID for each customer. | 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 |
| Date of Birth | date | Customer date of birth, if provided through Cleeng Capture. | Yes |
| Customer Country | varchar(3) | Country setting of a customer. The initial country setting is automatically selected based on their IP detection. | Yes |
| Company name | varchar(255) | Customer company name, if provided through Cleeng Capture. | Yes |
| Phone number | varchar(30) | Customer phone number, if provided through Cleeng Capture. | Yes |
| Address line 1 | varchar(155) | Customer address, if provided through Cleeng Capture. | Yes |
| Address line 2 | varchar(155) | Customer address, if provided through Cleeng Capture. | Yes |
| City | varchar(70) | Customer's city, if provided through Cleeng Capture. | Yes |
| State | varchar(100) | Customer's state, if provided through Cleeng Capture. | Yes |
| Postal code | varchar(60) | Customer's postal code, if provided through Cleeng Capture. | Yes |
| Account activation date | date | Date of the account creation. | Yes |
| Last login date | date | Date of the customer's last login. | Yes |
| No. of transactions | number | The number of transactions that a given customer has completed. | Yes |
| Payment method | varchar(30) | The method used by a customer to make the last purchase: Mastercard, Visa, AMEX, iDEAL, sms, ivr, direct banking, etc. | Yes |
| Payment method expires | date | Date of the customer payment method expiration. | Yes |
| Cleeng terms | varchar(10) | Customer consent to Cleeng terms. Binary variable: accepted or declined. | Yes |
| Broadcaster terms | varchar(10) | Customer consent to broadcaster terms. Binary variable: accepted or declined. | Yes |
| Marketing terms | varchar(10) | Customer consent to marketing terms. Takes one of three values: accepted, declined, or not specified (when a customer does not provide an answer). | Yes |
| Custom answer date | time | Date on which customer answered the custom questions. | Yes |
| Custom question 1 | varchar(400) | Question number 1 provided by the broadcaster in the template. Source: Cleeng Capture. | Yes |
| Custom answer 1 | varchar(400) | Customer's answer to question 1 if provided. Source: Cleeng Capture. | Yes |
| Custom question 2 | varchar(400) | Question number 2 provided by the broadcaster in the template. Source: Cleeng Capture. | Yes |
| Custom answer 2 | varchar(400) | Customer's answer to question 2 if provided. Source: Cleeng Capture. | Yes |
| Custom question 3 | varchar(400) | Question number 3 provided by the broadcaster in the template. Source: Cleeng Capture. | Yes |
| Custom answer 3 | varchar(400) | Customer's answer to question 3 if provided. Source: Cleeng Capture. | Yes |
| Custom question 4 | varchar(400) | Question number 4 provided by the broadcaster in the template. Source: Cleeng Capture. | Yes |
| Custom answer 4 | varchar(400) | Customer's answer to question 4 if provided. Source: Cleeng Capture. | Yes |
| Last subscription start date | date | Date on which the last subscription for the particular subscriber started. | Yes |
| Last subscription end date | date | Date on which the last subscription for the particular subscriber ended. | Yes |
| Last Login Formatted | time | Date and time of last login of a customer formatted as YYYY-MM-DD HH24:MI:SS. | Yes |
| Account Activation Formatted | time | Date and time of the customer's account activation formatted as YYYY-MM-DD HH24:MI:SS. | Yes |
| User Updated At | time | Date and time of last update of customer's data formatted as YYYY-MM-DD HH24:MI:SS. Usually this is also the Last Login Date. | Yes |
| Customer External ID | varchar(255) | External Customer unique identifier, if populated in the payment process. | Yes |