> ## Documentation Index
> Fetch the complete documentation index at: https://docs.thanx.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Programs

The program models includes basic information for both Thanx marketing
campaigns and other non-campaign Thanx programs, like intro, vip, and points
programs.

<CardGroup cols={2}>
  <Card title="SFTP Exports" href="https://drive.google.com/file/d/178dVjErIywpjMAW0O2TDDveipIEZSe5Z/view?usp=drive_link">
    Sample `programs.csv`
  </Card>

  <Card title="Thanx Connex">
    Table name: `programs`
  </Card>
</CardGroup>

### Attributes

| Column         | Data Type   | Description                                                                                                                    |
| -------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------------ |
| `program_id`   | `string`    | The unique identifier of the program in Thanx.                                                                                 |
| `program_uid`  | `string`    | The unique identifier for the program in Thanx APIs.                                                                           |
| `merchant_id`  | `string`    | The unique identifier of the merchant in Thanx.                                                                                |
| `redeem_title` | `string`    | The title of the reward. This value is defined by the merchant when they create a reward template and visible to the consumer. |
| `program_type` | `string`    | The type of program that issues the reward.                                                                                    |
|                |             | `automated campaign`                                                                                                           |
|                |             | `automated campaign - referral program`                                                                                        |
|                |             | `birthday program`                                                                                                             |
|                |             | `exclusive deals`                                                                                                              |
|                |             | `feedback`                                                                                                                     |
|                |             | `intro offer - premium`                                                                                                        |
|                |             | `intro offer - standard`                                                                                                       |
|                |             | `loyalty - incremental`                                                                                                        |
|                |             | `loyalty - points`                                                                                                             |
|                |             | `loyalty - spend`                                                                                                              |
|                |             | `loyalty - surprise and delight`                                                                                               |
|                |             | `loyalty - visit`                                                                                                              |
|                |             | `one-time campaign`                                                                                                            |
|                |             | `one-time campaign - afternoon shoppers`                                                                                       |
|                |             | `one-time campaign - close a location`                                                                                         |
|                |             | `one-time campaign - evening shoppers`                                                                                         |
|                |             | `one-time campaign - midday shoppers`                                                                                          |
|                |             | `one-time campaign - morning shoppers`                                                                                         |
|                |             | `one-time campaign - promote a location`                                                                                       |
|                |             | `one-time campaign - reopen a location`                                                                                        |
|                |             | `one-time campaign - vips`                                                                                                     |
|                |             | `one-time campaign - weekday shoppers`                                                                                         |
|                |             | `one-time campaign - weekend shoppers`                                                                                         |
|                |             | `reputation manager`                                                                                                           |
|                |             | `special offer`                                                                                                                |
|                |             | `special offer at a location`                                                                                                  |
|                |             | `vip program - spend`                                                                                                          |
|                |             | `vip program - visit based`                                                                                                    |
|                |             | `winback program`                                                                                                              |
| `handle`       | `string`    | The string that is used in the last section of the PROGRAM\_LINK to identify the offer.                                        |
| `program_link` | `string`    | The url that the user must click to sign up for the reward (e.g. `https://thanx.com/merchant_handle/offer_handle`).            |
| `created_at`   | `timestamp` | The date and time the program was created. This is in UTC.                                                                     |