> ## 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. |
| `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. |
| `program_uid` | `string` | The unique identifier for the program in Thanx APIs. |
| `synced_at` | `timestamp` | Timestamp indicating the last update time for the record. |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.