The Gift Report exports one row for each gift purchased in Cleeng. Each row shows who bought the gift, who receives it, what was bought, and whether the gift has been redeemed.
A gift can be bought by a registered customer or by a guest, who buys without creating a Cleeng account. A gift can also cover several billing periods of the same offer, for example 3 months of a monthly subscription. A gift like this is still one row in the report, with one gift code and one recipient.
To learn how to export this report, see How to Export Data from ChurnIQ.
Note: All dates and times are in Central European Time (CET).
Fields
Each column has a source name, used in unformatted scheduled exports, and a display name, used in formatted exports. The table below lists display names.
| Field | Type | Description | Is Filter |
| Gift ID | number(38,0) | Unique identifier of the gift. | Yes |
| Gift Code | varchar(16777216) | Code the recipient uses to redeem the gift. | Yes |
| Created At Date | timestamp_ntz(9) | Date and time the gift was bought. | Yes |
| Buyer Type | varchar | Who bought the gift: customer (a registered account) or guest (bought without creating an account). | Yes |
| Gifter ID | number(38,0) | ID of the customer or guest who bought the gift. | Yes |
| Gifter Email | varchar | Email address of the buyer. | Yes |
| Gifter First Name | varchar | First name of the buyer. | Yes |
| Gifter Last Name | varchar | Last name of the buyer. | Yes |
| Offer ID | varchar(16777216) | ID of the offer bought as a gift: a letter for the offer type, nine digits, an underscore, and a country code. | Yes |
| Offer Title | varchar | Title of the offer bought as a gift. | Yes |
| Offer Price | decimal(35,6) | Price of one billing period of the offer, in Offer Currency. For a gift of several billing periods, this is not the total. See Total Value. | Yes |
| Offer Currency | varchar | Currency of Offer Price. | Yes |
| Offer Billing Period | varchar | Billing period of the gifted offer, for example month or year. | Yes |
| Quantity (periods) | number | Number of billing periods the gift covers. A single-period gift shows 1. | Yes |
| Total Duration | varchar | Quantity (periods) combined with the offer's billing period, for example 3 * month. Empty when the offer has no billing period. | Yes |
| Total Value | number | Total publisher revenue from the gift purchase, in Total Value Currency. | Yes |
| Total Value Currency | varchar | Currency of Total Value. This is your publisher currency, so it can differ from Offer Currency. | Yes |
| Recipient Email | varchar(16777216) | Recipient's email address, as entered by the buyer at checkout. | Yes |
| Recipient First Name | varchar | First name of the gift recipient. Empty until the gift is redeemed by a registered account. | Yes |
| Recipient Last Name | varchar | Last name of the gift recipient. Empty until the gift is redeemed by a registered account. | Yes |
| Personal Note | varchar(16777216) | Optional message from the buyer, sent to the recipient with the gift email. | Yes |
| Delivery At Date | timestamp_ntz(0) | Date the recipient is scheduled to receive the gift email with the gift code. | Yes |
| Sent At Date | timestamp_ntz(0) | Date the gift email was sent to the recipient. | Yes |
| Redeemed At Date | timestamp_ntz(0) | Date the recipient redeemed the gift. | Yes |
| Redeemer ID | number(38,0) | ID of the customer who redeemed the gift. | Yes |
| Expiration Date | timestamp_ntz(9) | Expiration date of the gifted subscription. Filled only after the gift is redeemed. | Yes |
Reading Gifts with Several Billing Periods
- Gift volume: Count rows. A gift of 3 monthly periods is one gift, with one code and one recipient.
- Gift revenue: Sum Total Value. It is always in your publisher currency, so gifts sold in different offer currencies add up correctly. Offer Price covers one billing period only, in the offer's own currency.
- Example: A buyer gifts 3 months of a monthly offer priced at 10 EUR, and your publisher currency is USD. The row shows Quantity (periods) 3, Total Duration 3 * month, Offer Price 10, Offer Currency EUR, and Total Value in USD.
- Recipient names: Empty until the gift is redeemed by a registered account. Before that, use Recipient Email.
- Guest vs. customer purchases: Filter or group by Buyer Type to see how many gifts come from Guest Checkout.
Note: If your saved reports or schedules sum Offer Price to measure gift revenue, switch them to Total Value.