See how to export data from ChurnIQ.
The Gift Report exports a row for every gift purchase made in Cleeng, including details about the gifter, the recipient, and the redemption status.
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 |
| Gift ID | number(38,0) | A unique gift identifier (ID) that each gift has. | Yes |
| Gift Code | varchar(16777216) | Code used to verify and redeem the gift. | Yes |
| Gifter ID | number(38,0) | A unique identifier (ID) of a customer who buys the gift. | Yes |
| Offer ID | varchar(16777216) | 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 Price | decimal(35,6) | Value of the offer price without tax in offer currency. | Yes |
| Expiration Date | timestamp_ntz(9) | The expiration date of the subscription. Filled only after the redemption of the gift. | Yes |
| Recipient Email | varchar(16777216) | Email address of the gift recipient (as provided by the gifter). | Yes |
| Personal Note | varchar(16777216) | (Optional) Note provided by the gifter, delivered via email with the gift. | Yes |
| Delivery At Date | timestamp_ntz(0) | The date on which the recipient receives the email with the gift code. | Yes |
| Sent At Date | timestamp_ntz(0) | The date on which the email with the gift was sent to the gift recipient. | Yes |
| Redeemed At Date | timestamp_ntz(0) | The date on which the user redeemed the gift. | Yes |
| Redeemer ID | number(38,0) | A unique identifier (ID) of a customer who redeems the gift. | Yes |
| Created At Date | timestamp_ntz(9) | The date with the precise time at which the gift was purchased by the gifter. | Yes |