# Iterable: User Campaign
## Description
* Table that provides total and unique metrics for a user associated with particular campaigns.
## Supported Data Sources
* 
Iterable
## Columns
| Type | Name | Description |
| -------- | ------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| 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 | 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 | user\_id | User identifier, for userID-based projects. |
| STRING | campaign\_id | The unique identifier of the campaign which the user metrics are associated |
| STRING | experiment\_id | The unique experiment variation of the campaign |
| STRING | user\_email | Email of the user if it exists. |
| STRING | user\_full\_name | The users first and last name |
| STRING | campaign\_name | The name of the campaign which the user metrics are associated |
| STRING | template\_id | The unique identifier of the template used within the campaign |
| STRING | template\_name | The name of the template used for the campaign |
| STRING | recurring\_campaign\_id | The unique identifier of the recurring campaign which the campaign is tied to |
| STRING | recurring\_campaign\_name | The name of the recurring campaign which the campaign is tied to |
| DATETIME | first\_event\_at | Timestamp of the first campaign/experiment event associated with the user |
| DATETIME | last\_event\_at | Timestamp of the most recent campaign/experiment event associated with the user |
| INTEGER | total\_emailclick | Total email clicks events the user took within the campaign/experiment |
| INTEGER | total\_emailunsubscribe | Total email unsubscription events the user performed within the campaign/experiment |
| INTEGER | total\_emailcomplaint | Total email complaint events the user performed within the campaign/experiment |
| INTEGER | total\_customevent | Total custom events associated with the user within the campaign/experiment |
| INTEGER | total\_emailsubscribe | Total email subscription events associate with the user within the campaign/experiment |
| INTEGER | total\_emailopen | Total email open events the user performed within the campaign/experiment |
| INTEGER | total\_pushsend | Total push send events the user performed within the campaign/experiment |
| INTEGER | total\_smsbounce | Total sms bounce events associated with the user within the campaign/experiment |
| INTEGER | total\_pushbounce | Total push bounce events associated with the user within the campaign/experiment |
| INTEGER | total\_inappsendskip | Total in app send skip events the user performed within the campaign/experiment |
| INTEGER | total\_smssend | Total sms send events associated with the user within the campaign/experiment |
| INTEGER | total\_inappsend | Total in app send events associated with the user within the campaign/experiment |
| INTEGER | total\_pushopen | Total push open events the user performed within the campaign/experiment |
| INTEGER | total\_emailsend | Total email send event associated with the user within the campaign/experiment |
| INTEGER | total\_pushsendskip | Total push send skip events associated with the user within the campaign/experiment |
| INTEGER | total\_inappopen | Total in app open events associated with the user within the campaign/experiment |
| INTEGER | total\_emailsendskip | Total email send skip events associated with the user within the campaign/experiment |
| INTEGER | total\_emailbounce | Total email bounce events associated with the user within the campaign/experiment |
| INTEGER | total\_inappclick | Total in app click events associated with the user within the campaign/experiment |
| INTEGER | total\_pushuninstall | Total push uninstall events associated with the user within the campaign/experiment |
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/iterable-user-campaign.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.