> For the complete documentation index, see [llms.txt](https://endash-guidance-docs.gitbook.io/cigro-data-templates/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/iterable-list-user-history.md).

# Iterable: List User History

## Description

* Table that recreates the `list_user_history` source table. Additionally, this table provides an `is_current` field to identify the current lists associated with the user. Additionally, the grain of this table is at the user/list/updated\_at grain.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/iterable/resources/iterable.svg" alt="" data-size="line"> Iterable

## Columns

| Type     | Name                 | Description                                                                                                                                                                                                  |
| -------- | -------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| STRING   | unique\_user\_key    | The unique identifier of the user. With the new schema (Aug 2023), it is the \_fivetran\_user\_id. This is a hash of user\_id and/or email, depending on project type. If using the old schema, it is email. |
| STRING   | \_fivetran\_user\_id | A Fivetran-created unique identifier for the new Iterable schema in Aug 2023, for users, derived from hashing user\_id and/or email, depending on project type.                                              |
| STRING   | user\_id             | User identifier, for userID-based projects.                                                                                                                                                                  |
| STRING   | user\_email          | Email of the user if it exists.                                                                                                                                                                              |
| STRING   | user\_first\_name    | First name of the user                                                                                                                                                                                       |
| STRING   | user\_last\_name     | Last name of the user                                                                                                                                                                                        |
| DATETIME | user\_signup\_date   | Timestamp as epoch time in milliseconds of when the user signed up                                                                                                                                           |
| STRING   | user\_signup\_source | Source where the user signed up                                                                                                                                                                              |
| DATETIME | user\_updated\_at    | Last update timestamp as epoch time in milliseconds                                                                                                                                                          |
| INTEGER  | list\_id             | The list associated with the user                                                                                                                                                                            |
| BOOLEAN  | is\_current          | Boolean indicating if the current list is active                                                                                                                                                             |
| STRING   | list\_name           | Name of the list associated with the user                                                                                                                                                                    |
| STRING   | list\_type           | Type of list associated with the user                                                                                                                                                                        |
| DATETIME | list\_created\_at    | Date the list was created                                                                                                                                                                                    |