Snowflake Secure Data Sharing + Iterable Integration

The Snowflake Secure Data Sharing integration lets you join user profile and campaign-related data from your Iterable project to your Snowflake account. This gives you another way to analyze your Iterable campaign performance so you can drive better business outcomes with Iterable data.

For example, imagine that you're preparing a new marketing campaign that encourages one-time buyers to make an additional purchase. The campaign takes two approaches: one group of customers receives a standard discount, and another is incentivized by a "mystery gift" if they leave a product review.

Information about your customers' engagement with these campaigns is stored in Iterable as usual. But with Snowflake Secure Data Sharing, that data is also sent to your Snowflake account, where you can connect it with session-related events from your website (or any other data you have stored in Snowflake), to compare how these different campaign approaches affected sign-ins, conversions, etc. You might also use demographic data stored in Snowflake to further analyze your results, or create visualizations and dashboards in your favorite business intelligence tools. Iterable's integration with Snowflake makes all these things possible, and more.

This article looks at how Snowflake Secure Data Sharing works, some of the benefits of using this integration, how to set it up, and some sample queries you can use to inspect your Iterable data in Snowflake. It also provides descriptions of the events and attributes that Iterable supports.

# In this article

# Benefits of sharing Iterable data with Snowflake

Sharing Iterable data with Snowflake supports:

Better business outcomes. Combine Iterable’s AI-powered user insights (for example, from Brand Affinity™ and Predictive Goals) and behavioral data with your product and business data.

Breakdown data silos. Easily and securely share data across your organization with account-to-account shared views and manage governance across your data directly on Snowflake.

Simplify data management. Eliminate the need to move or copy data, rebuild schemas, or manage data pipelines with data populating ready for analysis.

# How does Snowflake Secure Data Sharing work?

Sharing data from Iterable to Snowflake is a straightforward process:

• After you ask your Iterable Account Team to enable the feature, Iterable will share, from its Snowflake account to yours, a database that contains user profile data (including AI insights) and Iterable system event data (for example, sends, email opens, clicks, bounces, and more).
• In your Snowflake account, you'll accept this share and use it to create a read-only database, using standard Snowflake role-based access controls to grant access as needed.

# Setting up Iterable's integration with Snowflake

To share your project's Iterable system event data with Snowflake, follow these steps:

1. Tell your Iterable Account Team that you'd like to use Snowflake Secure Data Sharing and give them your Snowflake URL and Snowflake Account ID. We'll use a portion of the URL to determine where to send the shared data.

   TIP

   To find your Snowflake Account ID, expand the dropdown menu on the top right corner of your Snowflake instance. You'll find the Account ID under your business name, next to "Organization" (Account ID and Organization are the same thing, in this case).

2. When you receive an email stating that we’ve shared data with you, have your Snowflake account administrator sign in to Snowflake and complete these steps:

   • On Snowflake's top navigation bar, click Shares:

     

   • Select the secure share from Iterable.

   • Click Create Database from Secure Share. You'll see this window:

     

3. Give the share a Database Name.

4. In Grant access to, use standard Snowflake role-based access controls to indicate which roles should have access to the shared data.

5. (optional) Leave any comments.

6. Click Create Database

Snowflake users with access to the shared database can now navigate to the Worksheets tab and work with the data.

# Ways to use Iterable data in Snowflake

Once your Iterable data is in Snowflake, you can use it in all sorts of interesting ways. You might already have some ideas you'd like to explore, but for now, let’s consider some common ways to evaluate campaigns:

• Email, push, or SMS bounces. It’s important to know when Iterable sends messages that bounce, or can’t be delivered. For example, with email, a bounce event might indicate that the recipient’s inbox is full, that the message content was perceived to be spam, or even that an email was sent to a misspelled or outdated email address.

• Email, in-app, SMS, or web push clicks. When testing different templates to see which is most effective, you’ll want to be able to determine which template generates the most unique clicks during a certain period of time. This information helps you expand on what’s working and pull back from what’s not.

• Email unsubscribes. Knowing how many unique users have unsubscribed during a certain period of time can be a valuable indicator of a campaign's success, and of any opportunities you may have for improvement.

• Push or SMS sends and bounces. Knowing how many of your push notifications or SMS messages have been successfully delivered (sends minus bounces) can help you identify users to remove from your user lists so you can focus your efforts on those who are actively receiving your messages.

# Querying data in Snowflake

Now, let’s take a look at how to query this Iterable data in your Snowflake account:

1. Sign in to Snowflake, using an account that has permission to see your Iterable data.

2. Navigate to the Worksheets tab, and use the menu in the upper-right corner to select a role, warehouse, database, and schema.

3. Create your first query. We’ll start by evaluating how many email bounces there were in all of your campaigns over the past 30 days, and the most common reasons they happened:

   SELECT RECIPIENT_STATE, COUNT(DISTINCT MESSAGE_ID) AS UNIQUE_BOUNCES
   FROM "EMAIL_BOUNCES_VIEW"
   WHERE CREATED_AT >= dateadd('day', -30, current_date())
   GROUP BY RECIPIENT_STATE
   ORDER BY UNIQUE_BOUNCES DESC;
   

4. Create another query, this time to determine which email template generated the most unique clicks in the past 30 days:

   SELECT TEMPLATE_ID, COUNT(DISTINCT EMAIL) AS UNIQUE_CLICKS
   FROM "EMAIL_CLICKS_VIEW"
   WHERE CREATED_AT >= dateadd('day', -30, current_date())
   GROUP BY TEMPLATE_ID
   ORDER BY UNIQUE_CLICKS DESC;
   

5. Finally, let’s create a query that tells us how many unique email users unsubscribed every day, before a certain date:

   SELECT DATE_TRUNC('DAY',CREATED_AT) AS DD, COUNT(DISTINCT EMAIL) AS TOTAL_USERS_UNSUBCRIBED
   FROM "EMAIL_UNSUBSCRIBES_VIEW"
   WHERE CREATED_AT >= '2021-08-01'
   GROUP BY 1
   ORDER BY 1 DESC;
   

# Events sent from Iterable to Snowflake

These system events are shared by Iterable with Snowflake.

# Email events

# Email blast send

An event that's captured when Iterable sends a blast email campaign to a particular user.

• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CHANNEL_ID - (Integer) ID of the message channel associated with the campaign.
• CHANNEL_NAME - (String) Name of the channel associated with the campaign.
• CONTENT_ID - (Integer) ID of the content associated with the campaign.
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• EMAIL - (String) User's email address.
• EMAIL_SUBJECT - (String) Subject of the email.
• EXPERIMENT_ID - (Integer) ID of the experiment associated with this campaign.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• LABEL_IDS - (Array) IDs for labels associated with this campaign.
• LABELS - (String, to be deprecated) Representation of an array containing IDs for labels associated with the campaign.
• LOCALE - (String) Locale that’s associated with the template that was used.
• MESSAGE_ID - (String) ID associated with a specific send of this campaign to this user.
• MESSAGE_TYPE_ID - (Integer) ID of the message type associated with the campaign.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PROJECT_ID - (Integer) ID of the Iterable project associated with this email.
• PROJECT_NAME - (String) Name of the Iterable project associated with this email.
• TEMPLATE_ID - (Integer) ID of the campaign's template.
• TEMPLATE_NAME - (String) Name of the campaign's template.
• TRANSACTIONAL_DATA - (Variant) dataFields payload from a triggering event or API request.
• WORKFLOW_ID - (Integer) ID of the workflow associated with the campaign (if available).
• WORKFLOW_NAME - (String) Name of the workflow associated with the campaign (if available).

# Email bounce

An event that's captured when Iterable sends an email to a user, but it can't be delivered.

• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CHANNEL_ID - (Integer) ID of the message channel associated with the campaign.
• CONTENT_ID - (Integer) ID of the content associated with the campaign.
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• EMAIL - (String) User's email address.
• EMAIL_SUBJECT - (String) Subject of the email.
• EXPERIMENT_ID - (Integer) ID of the experiment associated with this campaign.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• MESSAGE_ID - (String) ID associated with a specific send of this campaign to this user.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PROJECT_ID - (Integer) ID of the Iterable project associated with this email.
• PROJECT_NAME - (String) Name of the Iterable project associated with this email.
• RECIPIENT_STATE - (String) Reason for the bounce.
• TEMPLATE_ID - (Integer) ID of the campaign's template.
• TEMPLATE_NAME - (String) Name of the campaign's template.
• WORKFLOW_ID - (Integer) ID of the workflow associated with the campaign (if available).
• WORKFLOW_NAME - (String) Name of the workflow associated with the campaign (if available).

# Email click

An event that's captured when a user clicks a link in an email.

• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CHANNEL_ID - (Integer) ID of the message channel associated with the campaign.
• CITY - (String) City associated with the link click (if available).
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• EMAIL - (String) User's email address.
• EMAIL_SUBJECT - (String) Subject of the email.
• EXPERIMENT_ID - (Integer) ID of the experiment associated with this campaign.
• HREF_INDEX - (Integer) Number assigned sequentially to links in an email, used to identify the link a user clicks.
• IP - (String) IP address associated with the link click (if available).
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• LINK_URL - (String) URL of the link that was clicked.
• MESSAGE_ID - (String) ID associated with a specific send of this specific campaign to this specific user.
• MESSAGE_TYPE_ID - (Integer) ID of the message type associated with the campaign.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PROJECT_ID - (Integer) ID of the Iterable project associated with this campaign.
• PROJECT_NAME - (String) Name of the Iterable project associated with this campaign.
• REGION - (String) Region associated with the link click (if available). For example, a state abbreviation.
• TEMPLATE_ID - (Integer) ID of the campaign's template.
• TEMPLATE_NAME - (String) Name of the campaign's template.
• TRANSACTIONAL_DATA - (Variant) dataFields payload from a triggering event or API request.
• URL - (String) URL of the link that was clicked.
• USER_AGENT - (String) User agent string of the device on which the link was clicked.
• USER_AGENT_DEVICE - (String) Type of device on which the link was clicked.
• WORKFLOW_ID - (Integer) ID of the workflow associated with the campaign (if available).
• WORKFLOW_NAME - (String) Name of the workflow associated with the campaign (if available).

# Email complaint

An event that's captured when a user complains about an email (marks it as spam).

• CAMPAIGN_ID - (Integer) ID of the campaign that generated the complaint.
• CAMPAIGN_NAME - (String) Name of the campaign that generated the complaint
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• EMAIL - (String) Email address of the user that complained.
• EMAIL_SUBJECT - (String) Subject of the email.
• EXPERIMENT_ID - (Integer) ID of the experiment associated with this campaign.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• MESSAGE_ID - (String) ID associated with a specific send of the specific campaign to the specific user who complained.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PROJECT_ID - (Integer) ID of the Iterable project associated with the complaint.
• PROJECT_NAME - (String) Name of the Iterable project associated with the complaint.
• RECIPIENT_STATE - (String) "Complaint"
• TEMPLATE_ID - (Integer) ID of the template associated with the campaign that generated the complaint.
• TEMPLATE_NAME - (String) Name of the campaign's template.
• WORKFLOW_ID - (Integer) ID of the workflow associated with the campaign that generated the complaint (if available).
• WORKFLOW_NAME - (String) Name of the workflow associated with the campaign that generated the complaint (if available).

# Email open

An event that's captured when a user opens an email.

• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CHANNEL_ID - (Integer) ID of the message channel associated with the campaign.
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• EMAIL - (String) User's email address.
• EMAIL_SUBJECT - (String) Subject of the email.
• EXPERIMENT_ID - (Integer) ID of the experiment associated with this campaign.
• IP - (String)IP address from which the email was opened (if available).
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• MESSAGE_ID - (String) ID associated with a specific send of this specific campaign to this specific user.
• MESSAGE_TYPE_ID - (Integer) ID of the message type associated with the campaign.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PROJECT_ID - (Integer) ID of the Iterable project associated with the campaign.
• PROJECT_NAME - (String) Name of the Iterable project associated with the campaign.
• TEMPLATE_ID - (Integer) ID of the campaign's template.
• TEMPLATE_NAME - (String) Name of the campaign's template.
• USER_AGENT - (String) User agent string of the device that opened this email.
• WORKFLOW_ID - (Integer) ID of the workflow associated with the campaign (if available).
• WORKFLOW_NAME - (String) Name of the workflow associated with the campaign (if available).

# Email send skip

An event that's captured when Iterable can't send an email to an intended recipient.

• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CREATED_AT - UTC timestamp corresponding to the event's creation in Iterable.
• EMAIL - User's email address.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• MESSAGE_ID - ID associated with a specific send of this campaign to this user.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PROJECT_ID - (Integer) ID of the Iterable project associated with the campaign.
• PROJECT_NAME - (String) Name of the Iterable project associated with the campaign.
• REASON - String corresponding to the reason for the send skip.

# Email subscribe

An event that's captured when a user subscribes to a message channel, message type, or list.

• CHANNEL_ID - (Integer, to be deprecated) ID of the message channel associated with the campaign.
• CHANNEL_IDS - (Array) The IDs of the channels to which the user subscribed (if any).
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• EMAIL - (String) User's email address.
• EMAIL_LIST_IDS - (String representation of an array, to be deprecated) Array containing the IDs of the lists to which the user subscribed (if any).
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• LIST_IDS - An array of static list IDs that the user is subscribed to.
• MESSAGE_TYPE_IDS - (Array) The IDs of the message types to which the user subscribed (if any).
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PROFILE_UPDATED_AT - (Timestamp) - Most recent time at which a user's profile was updated (via CSV upload or API call). This field is a date, and it has the following format: 2016-08-02 18:53:45 +00:00. For more information, read Field Data Types.
• PROJECT_ID - (Integer) ID of the Iterable project associated with this email.
• PROJECT_NAME - (String) Name of the Iterable project associated with this email.
• SIGNUP_SOURCE - (String) How the contact was created in Iterable (for example, API or IMPORT).

# Email triggered send

An event that's captured when Iterable sends a triggered email campaign to a particular user.

• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CHANNEL_ID - (Integer) ID of the message channel associated with the campaign.
• CHANNEL_NAME - (String) Name of the channel associated with the campaign.
• CONTENT_ID - (Integer) ID of the content associated with the campaign.
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• EMAIL - (String) User's email address.
• EMAIL_SUBJECT - (String) Subject of the email.
• EXPERIMENT_ID - (Integer) ID of the experiment associated with this campaign.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• LABEL_IDS - (Array) IDs for labels associated with this campaign.
• LABELS - (String, to be deprecated) String representation of an array containing IDs for labels associated with the campaign.
• LOCALE - (String) Locale that’s associated with the template that was used.
• MESSAGE_ID - (String) ID associated with a specific send of this specific campaign to this specific user.
• MESSAGE_TYPE_ID - (Integer) ID of the message type associated with the campaign.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PROJECT_ID - (Integer) ID of the Iterable project associated with the campaign.
• PROJECT_NAME - (String) Name of the Iterable project associated with the campaign.
• TEMPLATE_ID - (Integer) ID of the campaign's template.
• TEMPLATE_NAME - (String) Name of the campaign's template.
• TRANSACTIONAL_DATA - (Variant) dataFields payload from a triggering event or API request.
• WORKFLOW_ID - (Integer) ID of the workflow associated with the campaign (if available).
• WORKFLOW_NAME - (String) Name of the workflow associated with the campaign (if available).

# Email unsubscribe

An event that's captured when a user is unsubscribed from a message channel, message type, or list.

• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CHANNEL_IDS - (String representation of an array) Array containing the IDs of the channels from which the user was unsubscribed (if any).
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• EMAIL - (String) User's email address.
• EMAIL_LIST_IDS - (String representation of an array, to be deprecated) Array containing the IDs of the lists from which the user was unsubscribed (if any).
• EXPERIMENT_ID - (Integer) ID of the experiment associated with this campaign.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• LABEL_IDS - (Array) IDs for labels associated with this campaign.
• LABELS - (String) String representation of an array containing IDs for labels associated with the campaign.
• LIST_IDS - An array of static list IDs that the user is unsubscribed from.
• LOCALE - (String) Locale that’s associated with the template that was used.
• MESSAGE_ID - (String) ID associated with a specific send of this specific campaign to this specific user.
• MESSAGE_TYPE_IDS - (String representation of an array) Array containing the IDs of the message types from which the user was unsubscribed (if any).
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PROJECT_ID - (Integer) ID of the Iterable project associated with the campaign.
• PROJECT_NAME - (String) Name of the Iterable project associated with the campaign.
• TEMPLATE_ID - (Integer) ID of the campaign's template.
• TEMPLATE_NAME - (String) Name of the campaign's template.
• UNSUB_SOURCE - (String) String that provides more information about the source of the unsubscribe.
• WORKFLOW_ID - (Integer) ID of the workflow associated with the campaign that sent the email (if available).
• WORKFLOW_NAME - (String) Name of the workflow associated with the campaign that sent the email (if available).

# Hosted unsubscribe click

An event that's captured when a user clicks a link to unsubscribe from your service.

• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CHANNEL_ID - (Integer) ID of the message channel associated with the campaign.
• CITY - (String) - City associated with the link click (if available).
• COUNTRY - (String) - Country associated with the link click (if available).
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• EMAIL - (String) User's email address.
• EMAIL_SUBJECT - (String) Subject of the email.
• EXPERIMENT_ID - (Integer) ID of the experiment associated with this campaign.
• IP - (String) - IP address associated with the link click (if available).
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• LABEL_IDS - (Array) IDs for labels associated with this campaign.
• LABELS - (String, to be deprecated) String representation of an array containing IDs for labels associated with the campaign.
• LOCALE - (String) Locale that’s associated with the template that was used.
• MESSAGE_ID - (String) ID associated with a specific send of this campaign to this user.
• MESSAGE_TYPE_ID - (Integer) ID of the message type associated with the campaign.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PROJECT_ID - (Integer) ID of the Iterable project associated with this email.
• PROJECT_NAME - (String) Name of the Iterable project associated with this email.
• REGION - (String) - Region associated with the link click (if available).
• TEMPLATE_ID - (Integer) ID of the campaign's template.
• TEMPLATE_NAME - (String) Name of the campaign's template.
• URL - (String) - URL of the link that was clicked.
• USER_AGENT - (String) - User agent string of the device on which the link was clicked.
• USER_AGENT_DEVICE - (String) - Type of device on which the link was clicked.
• WORKFLOW_ID - (Integer) ID of the workflow associated with the campaign (if available).
• WORKFLOW_NAME - (String) Name of the workflow associated with the campaign (if available).

# In-app events

# In-app click

An event that's captured when a user clicks a link or button in an in-app message.

• APP_PACKAGE_NAME - (String) Package name of the app.
• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CLICKED_URL - (String) URL that was clicked.
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• DEVICE_INFO - (Variant) Object containing various fields that describe the device and app associated with the event (for example, deviceId, platform, or appPackageName).
• DEVICE_ID - (String) Device's unique identifier.
• EMAIL - (String) User's email address.
• INBOX_SESSION_ID - (String) ID of the experiment associated with this SMS campaign.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• MESSAGE_ID - (String) ID associated with a specific send of this specific campaign to this specific user.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PLATFORM - iOS or Android.
• PROJECT_ID - (Integer) ID of the Iterable project associated with the campaign.
• PROJECT_NAME - (String) Name of the Iterable project associated with the campaign.
• SENT_AT - (Timestamp) UTC timestamp corresponding to when the message was sent.
• TEMPLATE_ID - (Integer) ID of the campaign's template.

# In-app close

An event that's captured when a user closed an in-app message by tapping a button or link in the message's content or by tapping a back button.

• APP_PACKAGE_NAME - (String) Package name of the app.
• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CLOSE_ACTION - (String) Type of action that initiated the close: link (for buttons or links), back (for a back button), other or a custom value.
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• DEVICE_INFO - (Variant) Object containing various fields that describe the device and app associated with the event (for example, deviceId, platform, or appPackageName).
• DEVICE_ID - (String) Device's unique identifier.
• EMAIL - (String) User's email address.
• INBOX_SESSION_ID - (String) ID of the experiment associated with this SMS campaign.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• MESSAGE_CONTEXT - (String) Object containing various fields that describe the message associated with the event.
• MESSAGE_ID - (String) ID associated with a specific send of this specific campaign to this specific user.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PLATFORM - iOS or Android.
• PROJECT_ID - (Integer) ID of the Iterable project associated with the campaign.
• PROJECT_NAME - (String) Name of the Iterable project associated with the campaign.
• TEMPLATE_ID - (Integer) ID of the campaign's template.

# In-app deleted

An event that's captured when a user deletes an inbox-enabled in-app message by swiping it in the inbox or clicking a delete button/link (with URL iterable://delete in it).

• APP_PACKAGE_NAME - (String) Package name of the app.
• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• DELETE_ACTION - How the message was deleted: inbox-swipe (the message was deleted with a swipe in the inbox), or delete-button (the user tapped a button or link [URL iterable://delete]) or a custom value.
• DEVICE_INFO - (Variant) Object containing various fields that describe the device and app associated with the event (for example, deviceId, platform, or appPackageName).
• DEVICE_ID - (String) Device's unique identifier.
• EMAIL - (String) User's email address.
• INBOX_SESSION_ID - ID of the inbox session in which this event occurred. Not present if there's not an inbox session associated with the event.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• MESSAGE_CONTEXT - (String) Object containing various fields that describe the message associated with the event.
• MESSAGE_ID - (String) ID associated with a specific send of this specific campaign to this specific user.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PLATFORM - iOS or Android.
• PROJECT_ID - (Integer) ID of the Iterable project associated with the campaign.
• PROJECT_NAME - (String) Name of the Iterable project associated with the campaign.
• TEMPLATE_ID - (Integer) ID of the campaign's template.

# In-app delivered

An event that's captured when an in-app message arrives on a user's device. This doesn’t mean that the user viewed the message.

• APP_PACKAGE_NAME - (String) Package name of the app.
• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• DEVICE_INFO - (Variant) Object containing various fields that describe the device and app associated with the event (for example, deviceId, platform, appPackageName).
• DEVICE_ID - (String) Device's unique identifier.
• EMAIL - (String) User's email address.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• MESSAGE_ID - (String) ID associated with a specific send of this specific campaign to this specific user.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PLATFORM - iOS or Android.
• PROJECT_ID - (Integer) ID of the Iterable project associated with the campaign.
• PROJECT_NAME - (String) Name of the Iterable project associated with the campaign.
• TEMPLATE_ID - (Integer) ID of the campaign's template.
• WORKFLOW_ID - (Integer) ID of the workflow associated with the campaign (if available).
• WORKFLOW_NAME - (String) Name of the workflow associated with the campaign (if available).

# In-app open

An event that's captured when an in-app message is displayed in an app, either because it appeared on arrival or because the user selected it in the inbox.

• APP_PACKAGE_NAME - (String) Package name of the app.
• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• DEVICE_INFO - (Variant) Object containing various fields that describe the device and app associated with the event (for example, deviceId, platform, appPackageName).
• DEVICE_ID - (String) Device's unique identifier.
• EMAIL - (String) User's email address.
• INBOX_SESSION_ID - (String) ID of the inbox session in which this event occurred. Not present if there's not an inbox session associated with the event.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• MESSAGE_ID - (String) ID associated with a specific send of this specific campaign to this specific user.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PLATFORM - iOS or Android.
• PROJECT_ID - (Integer) ID of the Iterable project associated with the campaign.
• PROJECT_NAME - (String) Name of the Iterable project associated with the campaign.
• TEMPLATE_ID - (Integer) ID of the campaign's template.

# In-app send

An event that's captured when Iterable sends an in-app campaign to a particular user. This doesn’t mean that the user received the message.

• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CHANNEL_ID - (Integer) ID of the message channel associated with the campaign.
• CHANNEL_NAME - (String) Name of the channel.
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• EMAIL - (String) User's email address.
• EXPERIMENT_ID - (Integer) ID of the experiment associated with this in-app campaign.
• EXPIRES_AT - Expiration date and time for the message associated with the event.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• LABEL_IDS - (Array) IDs for labels associated with this campaign.
• LABELS - (String, to be deprecated) String representation of an array containing IDs for labels associated with the campaign.
• LOCALE - (String) Locale that’s associated with the template that was used.
• MESSAGE_CONTEXT - (Variant) Object containing various fields (saveToInbox, silentInbox) that describe the message associated with the event.
• MESSAGE_ID - (String) ID associated with a specific send of this specific campaign to this specific user.
• MESSAGE_TYPE_ID - (Integer) ID of the message type associated with the campaign.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PRIORITY_LEVEL - (Float) Message priority, with greater priority messages first (proof= 100.0, critical=100.5, high=200.5, medium=300.5, low=400.5), sorted by send time (first sent, first displayed).
• PROJECT_ID - (Integer) ID of the Iterable project associated with the campaign.
• PROJECT_NAME - (String) Name of the Iterable project associated with the campaign.
• SAVE_TO_INBOX - (Boolean) Whether or not the message associated with the event was configured to use the inbox.
• SILENT_INBOX - (Boolean) Whether or not the message associated with the event was configured to send directly to the inbox.
• TEMPLATE_ID - (Integer) ID of the campaign's template.
• TEMPLATE_NAME - (String) Name of the campaign's template.
• TRANSACTIONAL_DATA - (Variant) dataFields payload from a triggering event or API request.
• WORKFLOW_ID - (Integer) ID of the workflow associated with the campaign (if available).
• WORKFLOW_NAME - (String) Name of the workflow associated with the campaign (if available).

# In-app send skip

An event that's captured when Iterable can’t send a message to an intended recipient.

• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• EMAIL - (String) User's email address.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• MESSAGE_ID - (String) ID associated with a specific send of this specific campaign to this specific user.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PROJECT_ID - (Integer) ID of the Iterable project associated with the campaign.
• PROJECT_NAME - (String) Name of the Iterable project associated with the campaign.
• REASON - (String) Reason Iterable didn't send the message to the intended recipient; for example, DuplicateMarketingMessage.
• TRANSACTIONAL_DATA - (Variant) dataFields payload from a triggering event or API request.

# Push events

# Push bounce

An event that's captured when Iterable sends a push to a user, but it can't be delivered.

• BADGE - (String) Badge count given to the app when the notification was delivered (iOS only).
• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CHANNEL_ID - (Integer) ID of the message channel associated with the campaign.
• CONTENT_AVAILABLE - (Boolean) Specifies whether to wake the app in the background when a notification is delivered (iOS only).
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• DEEPLINK - (String) URL to open when a notification is tapped.
• EMAIL - (String) User's email address.
• EXPERIMENT_ID - (Integer) ID of the experiment associated with this in-app campaign.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• LOCALE - (String) Locale that’s associated with the template that was used.
• MESSAGE_ID - (String) ID associated with a specific send of this campaign to this user.
• MESSAGE_TYPE_ID - (Integer) ID of the message type associated with the campaign.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PAYLOAD - (String) Arbitrary JSON payload that is delivered with the notification and is handled by the app.
• PLATFORM_ENDPOINT - (String) Address Iterable uses to send a push notification to a given device.
• PROJECT_ID - (Integer) ID of the Iterable project associated with this message.
• PROJECT_NAME - (String) Name of the Iterable project associated with this message.
• SOUND - (String) Path to an audio file in the app bundle that plays when the push notification is delivered.
• TEMPLATE_ID - (Integer) ID of the campaign's template.
• TEMPLATE_NAME - (String) Name of the campaign's template.
• WORKFLOW_ID - (Integer) ID of the workflow (journey) associated with the campaign (if available).
• WORKFLOW_NAME - (String) Name of the workflow (journey) associated with the campaign (if available).

# Push open

An event that's captured when a user opens a push message.

• APP_ALREADY_RUNNING - (Boolean) Indicates whether the app was already running when the push notification was received by a user.
• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CHANNEL_ID - (Integer) ID of the message channel associated with the campaign.
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• EMAIL - (String) User's email address.
• EXPERIMENT_ID - (Integer) ID of the experiment associated with this in-app campaign.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• LOCALE - (String) Locale that’s associated with the template that was used.
• MESSAGE_ID - (String) ID associated with a specific send of this specific campaign to this specific user.
• MESSAGE_TYPE_ID - (Integer) ID of the message type associated with the campaign.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PROJECT_ID - (Integer) ID of the Iterable project associated with the campaign.
• PROJECT_NAME - (String) Name of the Iterable project associated with the campaign.
• TEMPLATE_ID - (Integer) ID of the campaign's template.
• TEMPLATE_NAME - (String) Name of the campaign's template.
• WORKFLOW_ID - (Integer) ID of the workflow (journey) associated with the campaign (if available).
• WORKFLOW_NAME - (String) Name of the workflow (journey) associated with the campaign (if available).

# Push send

An event that's captured when Iterable sends a push campaign to a particular user.

• BADGE - (String) The badge count given to the app when the notification was delivered (iOS only).
• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CHANNEL_ID - (Integer) ID of the message channel associated with the campaign.
• CONTENT_AVAILABLE - (Boolean) Specifies whether to wake the app in the background when a notification is delivered (iOS only).
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• DEEPLINK - (String) URL to open when a notification is tapped.
• EMAIL - (String) User's email address.
• EXPERIMENT_ID - (Integer) ID of the experiment associated with this in-app campaign.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• LABEL_IDS - (Array) IDs for labels associated with this campaign.
• LABELS - (String, to be deprecated) String representation of an array containing IDs for labels associated with the campaign.
• LOCALE - (String) Locale that’s associated with the template that was used.
• MESSAGE_ID - (String) ID associated with a specific send of this specific campaign to this specific user.
• MESSAGE_TYPE_ID - (Integer) ID of the message type associated with the campaign.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PAYLOAD - (String) An arbitrary JSON payload that is delivered with the notification and is handled by the app.
• PLATFORM_ENDPOINT - (String) Address Iterable uses to send a push notification to a given device.
• PROJECT_ID - (Integer) ID of the Iterable project associated with the campaign.
• PROJECT_NAME - (String) Name of the Iterable project associated with the campaign.
• SOUND - (String) A path to an audio file in the app bundle that plays when the push notification is delivered.
• TEMPLATE_ID - (Integer) ID of the campaign's template.
• TEMPLATE_NAME - (String) Name of the campaign's template.
• TRANSACTIONAL_DATA - (Variant) dataFields payload from a triggering event or API request.
• WORKFLOW_ID - (Integer) ID of the workflow (journey) associated with the campaign (if available).
• WORKFLOW_NAME - (String) Name of the workflow (journey) associated with the campaign (if available).

# Push send skip

An event that's captured when Iterable can't send a push message to an intended recipient.

• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• EMAIL - (String) User's email address.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• MESSAGE_ID - (String) ID associated with a specific send of this campaign to this user.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PROJECT_ID - (Integer) ID of the Iterable project associated with the campaign.
• PROJECT_NAME - (String) Name of the Iterable project associated with the campaign.
• REASON - (String) String corresponding to the reason for the send skip.
• TRANSACTIONAL_DATA - (Variant) dataFields payload from a triggering event or API request.

# Push uninstall

An event that's captured when a device is assigned an uninstall from a message channel, message type, or list.

• BADGE - (String) Attribute of the push notification that occurred before the uninstall event.
• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CHANNEL_ID - (Integer) ID of the message channel associated with the campaign.
• CONTENT_AVAILABLE - (Boolean) Attribute of the push notification that occurred before the uninstall event.
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• DEEPLINK - (String) Attribute of the push notification that occurred before the uninstall event.
• EXPERIMENT_ID - (Integer) ID of the experiment associated with this in-app campaign.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• LOCALE - (String) Locale that’s associated with the template that was used.
• MESSAGE_ID - (String) ID associated with a specific send of this specific campaign to this specific user.
• MESSAGE_TYPE_IDS - (String representation of an array) Array containing the IDs of the message types from which the user was unsubscribed (if any).
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PLATFORM_ENDPOINT - (String) Address Iterable uses to send a push notification to a given device.
• PROJECT_ID - (Integer) ID of the Iterable project associated with the campaign.
• PROJECT_NAME - (String) Name of the Iterable project associated with the campaign.
• SOUND - (String) Attribute of the push notification that occurred before the uninstall event.
• TEMPLATE_ID - (Integer) ID of the campaign's template.
• TEMPLATE_NAME - (String) Name of the campaign's template.
• WORKFLOW_ID - (Integer) ID of the workflow (journey) associated with the campaign that sent the email (if available).
• WORKFLOW_NAME - (String) Name of the workflow (journey) associated with the campaign that sent the email (if available).

# SMS events

# SMS bounce

An event that's captured when Iterable sends an SMS message to a user, but it can’t be delivered.

• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CHANNEL_ID - (Integer) ID of the message channel associated with the campaign.
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• EMAIL - (String) User's email address.
• ERR_CODE - (String) Error code returned by the SMS sender. Reference this code to learn why a message could not be sent.
• EXPERIMENT_ID - (Integer) ID of the experiment associated with this SMS campaign.
• FROM_SMS_SENDER_ID - (Integer) ID associated with the SMS sender.
• IMAGE_URL - (String) URL of the image that was clicked.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• LOCALE - (String) Locale that’s associated with the template that was used.
• MESSAGE_ID - (String) ID associated with a specific send of this campaign to this user.
• MESSAGE_STATUS - (String) Current status of your message as reported by the SMS sender.
• MESSAGE_TYPE_ID - (Integer) ID of the message type associated with the campaign.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PROJECT_ID - (Integer) ID of the Iterable project associated with this email.
• PROJECT_NAME - (String) Name of the Iterable project associated with this email.
• SMS_MESSAGE - (String) - Message that was sent.
• TEMPLATE_ID - (Integer) ID of the campaign's template.
• TEMPLATE_NAME - (String) Name of the campaign's template.
• WORKFLOW_ID - (Integer) ID of the workflow (journey) associated with the campaign (if available).
• WORKFLOW_NAME - (String) Name of the workflow (journey) associated with
• the campaign (if available).

# SMS click

An event that's captured when a user clicks a link in a message.

• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CHANNEL_ID - (Integer) ID of the message channel associated with the campaign.
• CLICKED_URL - (String) URL that was clicked.
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• EMAIL - (String) User's email address.
• EXPERIMENT_ID - (Integer) ID of the experiment associated with this SMS campaign.
• FROM_PHONE_NUMBER_ID - (Integer) ID associated with the SMS sender.
• IMAGE_URL - (String) URL of the image that was clicked.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• LOCALE - (String) Locale that’s associated with the template that was used.
• MESSAGE_ID - (String) ID associated with a specific send of this specific campaign to this specific user.
• MESSAGE_STATUS - (String) Current status of your message as reported by the SMS sender.
• MESSAGE_TYPE_ID - (Integer) ID of the message type associated with the campaign.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PROJECT_ID - (Integer) ID of the Iterable project associated with this campaign.
• PROJECT_NAME - (String) Name of the Iterable project associated with this campaign.
• SMS_MESSAGE - (String) Message that was sent.
• TEMPLATE_ID - (Integer) ID of the campaign's template.
• TEMPLATE_NAME - (String) Name of the campaign's template.
• WORKFLOW_ID - (Integer) ID of the workflow (journey) associated with the campaign (if available).
• WORKFLOW_NAME - (String) Name of the workflow (journey) associated with the campaign (if available).

# SMS send

An event that's captured when Iterable sends an SMS campaign to a particular user.

• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CHANNEL_ID - (Integer) ID of the message channel associated with the campaign.
• CONTENT_ID - (Integer) ID of the content associated with the campaign.
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• EMAIL - (String) User's email address.
• EXPERIMENT_ID - (Integer) ID of the experiment associated with this SMS campaign.
• FROM_PHONE_NUMBER_ID - (Integer) ID associated with the SMS sender.
• FROM_SMS_SENDER_ID - (Integer) ID associated with the SMS sender.
• IMAGE_URL - (String) URL of the image that was clicked.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• LABEL_IDS - (Array) IDs for labels associated with this campaign.
• LOCALE - (String) Locale that’s associated with the template that was used.
• MESSAGE_ID - (String) ID associated with a specific send of this specific campaign to this specific user.
• MESSAGE_TYPE_ID - (Integer) ID of the message type associated with the campaign.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PROJECT_ID - (Integer) ID of the Iterable project associated with the campaign.
• PROJECT_NAME - (String) Name of the Iterable project associated with this message.
• SMS_MESSAGE - (String) Message that was sent.
• TEMPLATE_ID - (Integer) ID of the campaign's template.
• TEMPLATE_NAME - (String) Name of the campaign's template.
• TO_PHONE_NUMBER - (String) ID associated with the message recipient.
• TRANSACTIONAL_DATA - (Variant) dataFields payload from a triggering event or API request.
• WORKFLOW_ID - (Integer) ID of the workflow (journey) associated with the campaign (if available).
• WORKFLOW_NAME - (String) Name of the workflow (journey) associated with the campaign (if available).

# SMS send skip

An event that's captured when Iterable can’t send a message to an intended recipient.

• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CHANNEL_ID - (Integer) ID of the message channel associated with the campaign.
• CONTENT_ID - (Integer) ID of the content associated with the campaign.
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• EMAIL - (String) User's email address.
• EXPERIMENT_ID - (Integer) ID of the experiment associated with this SMS campaign.
• FROM_SMS_SENDER_ID - (Integer) ID associated with the SMS sender.
• IMAGE_URL - (String) URL of the image that was clicked.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• LOCALE - (String) Locale that’s associated with the template that was used.
• MESSAGE_ID - (String) ID associated with a specific send of this specific campaign to this specific user.
• MESSAGE_TYPE_ID - (Integer) ID of the message type associated with the campaign.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PROJECT_ID - (Integer) ID of the Iterable project associated with the campaign.
• PROJECT_NAME - (String) Name of the Iterable project associated with this message.
• REASON - (String) String corresponding to the reason for the send skip.
• SMS_MESSAGE - (String) Message that was sent.
• TEMPLATE_ID - (Integer) ID of the campaign's template.
• TEMPLATE_NAME - (String) Name of the campaign's template.
• TRANSACTIONAL_DATA - (Variant) dataFields payload from a triggering event or API request.
• WORKFLOW_ID - (Integer) ID of the workflow (journey) associated with the campaign (if available).
• WORKFLOW_NAME - (String) Name of the workflow (journey) associated with the campaign (if available).

# SMS received

An event that's captured when a user responds to an SMS message sent through Iterable.

• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• EMAIL - (String) User's email address.
• FROM_PHONE_NUMBER_ID - (Integer) ID associated with the SMS sender.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PROJECT_ID - (Integer) ID of the Iterable project associated with this campaign.
• PROJECT_NAME - (String) Name of the Iterable project associated with this campaign.
• SMS_MESSAGE - (String) Message that was sent.
• TO_PHONE_NUMBER_ID - (Integer) ID associated with the message recipient.

# Web push events

# Web push click

An event that's captured when a user clicks a link in a web push message.

• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• EMAIL - (String) User's email address.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• MESSAGE_ID - (String) ID associated with a specific send of this specific campaign to this specific user.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PROJECT_ID - (Integer) ID of the Iterable project associated with this campaign.
• PROJECT_NAME - (String) Name of the Iterable project associated with this campaign.

# Web push send

An event that's captured when Iterable sends a web push campaign to a particular user.

• BROWSER_TOKEN - (String) The browser token value for a user who accepts notifications.
• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CHANNEL_ID - (Integer) ID of the message channel associated with the campaign.
• CHANNEL_NAME - (String) Name of the channel associated with the campaign.
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• EMAIL - (String) User's email address.
• EXPERIMENT_ID - (Integer) ID of the experiment associated with this in-app campaign.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• LABEL_IDS - (Array) IDs for labels associated with this campaign.
• LABELS - (String, to be deprecated) String representation of an array containing IDs for labels associated with the campaign.
• LOCALE - (String) Locale that’s associated with the template that was used.
• MESSAGE_ID - (String) ID associated with a specific send of this specific campaign to this specific user.
• MESSAGE_TYPE_ID - (Integer) ID of the message type associated with the campaign.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PROJECT_ID - (Integer) ID of the Iterable project associated with the campaign.
• PROJECT_NAME - (String) Name of the Iterable project associated with the campaign.
• TEMPLATE_ID - (Integer) ID of the campaign's template.
• TEMPLATE_NAME - (String) Name of the campaign's template.
• TRANSACTIONAL_DATA - (Variant) dataFields payload from a triggering event or API request.
• WEB_PUSH_BODY - (String) Text that should display in the body of the notification.
• WEB_PUSH_CLICK_ACTION - (String) URL to which the notification should navigate the user on click.
• WEB_PUSH_ICON - (String) The image to display with the notification.
• WORKFLOW_ID - (Integer) ID of the workflow (journey) associated with the campaign (if available).
• WORKFLOW_NAME - (String) Name of the workflow (journey) associated with the campaign (if available).

# Web push send skip

An event that's captured when Iterable can’t send a message to an intended recipient.

• CAMPAIGN_ID - (Integer) ID of the campaign.
• CAMPAIGN_NAME - (String) Name of the campaign.
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the event's creation in Iterable.
• EMAIL - (String) User's email address.
• ITBL_USER_ID - Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier. In email-based projects, ITBL_USER_ID = null.
• MESSAGE_ID - (String) ID associated with a specific send of this specific campaign to this specific user.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this message.
• PROJECT_ID - (Integer) ID of the Iterable project associated with the campaign.
• PROJECT_NAME - (String) Name of the Iterable project associated with the campaign.
• REASON - (String) String corresponding to the reason for the send skip.
• TRANSACTIONAL_DATA - (Variant) dataFields payload from a triggering event or API request.

# User-related tables

These tables contain user-related information that's supported by Iterable.

# Deleted users and Snowflake

Users who are deleted in Iterable are also deleted from the User and User Identities tables in the data share. In the event that you want to identify users who’ve been deleted, the options that are available to you depend on the type of project you have:

• In hybrid and userID-based projects, you can use the User Identity Deletions table to map ITBL_USER_ID to either email or userId for deleted user profiles.

• The ITBL_USER_ID field is not generated for legacy email projects, so in these types of projects, information about deleted users is not available. However, if users are not represented in Snowflake in the User Identities, Users, or Projects tables, you can assume they’ve been deleted in Iterable.

# User identities

In hybrid and userID-based projects, the ITBL_USER_ID field is used internally by Iterable to identify one user from another. This field must be mapped to the field that you use to manage user identities. Use the values in this table to map ITBL_USER_ID to either email or userId.

• DELETED_AT - (Timestamp) UTC timestamp corresponding to the deletion of the user profile.
• EMAIL - (String) User's email address.
• ITBL_USER_ID - (String) Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier.
• PROJECT_ID - (Integer) Iterable project ID associated with this user.
• USER_ID - (String) Unique identifier that you can manage for this user.
• UPDATED_AT - (Timestamp) UTC timestamp corresponding to the last update to the user identities.

# User identity deletions

In hybrid and userID-based projects, use the fields in this table to map ITBL_USER_ID to either email or userId for deleted user profiles.

• DELETED_AT - (Timestamp) UTC timestamp corresponding to the deletion of the user profile.
• EMAIL - (String) User's email address.
• ITBL_USER_ID - (String) Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier.
• PROJECT_ID - (Integer) Iterable project ID associated with this user.
• USER_ID - (String) Unique identifier that you can manage for this user.

# Users

The following Iterable user profile fields are provided in the Users table.

• CITY - (String) User’s city (requires the Enable user IP to location lookup setting in Iterable project settings).

• COUNTRY - (String) User’s country (requires the Enable user IP to location lookup setting in Iterable project settings).

• DATA_FIELDS - (Variant) A listing of the profile fields in your data that don't have dedicated columns.

• DEVICES - (Array) Each array of objects represents a mobile device/mobile app combination for users to receive push notifications. For more information about the available fields, see User Profile Fields Used by Iterable devices.

• EMAIL - (String) User's email address. This field is validated (see Email Validation in Iterable) and is one of two possible fields that uniquely identify Iterable users, along with userId.

• IP - (String) User’s IP address. Including it on a user profile allows Iterable to send messages with consideration to a user's local time.

• ITBL_USER_ID - (String) Unique identifier used internally by Iterable, which can't be changed. This isn't to be confused with userId, which is a field that you manage and can use as a unique identifier.

• ITBL_DS - (Variant) An object containing information related to Iterable AI, the fields displayed will vary depending on your use of Iterable AI Suite. See User Profile Fields Used by Iterable.

• LIST_IDS - (Array) IDs of the lists to which this user is currently subscribed.

• LOCALE - (String) User's location and/or language preference. If you have multiple locale variants of a template (all with the same templateId), Iterable uses this field to determine which version to send to this user. This field maps to the codes you set up in the Locales section of the Iterable Project Settings page.

• PHONE_NUMBER - (String) String that represents the user's phone number. Iterable uses this number when sending SMS messages. It should have a format such as: +14155550132.

• PROFILE_CREATED_AT - (Timestamp) - Date/time when a user's Iterable profile was created (via CSV upload or API call). This field has the following format: 2023-08-02 18:53:45 +00:00. For more information, read Field Data Types.

• PROFILE_UPDATED_AT - (Timestamp) - Most recent date/time at which a user's Iterable profile was updated (via CSV upload or API call).

• PROJECT_ID - (Integer) Iterable project ID associated with this user.

• REGION - (String) User’s state or the geolocation populated from a standard IP lookup library. This field requires the Enable user IP to location lookup setting in Iterable project settings.

• SHOPPING_CART_ITEMS - (Array) JSON objects for customer shopping events and purchases. See Managing Commerce Events and Shopping Cart Data for information about Iterable's Commerce API endpoints.

• SIGNUP_DATE - (Timestamp) Date when the user's profile was added to the Iterable project. This field is a date, and it has the following format: 2023-08-02 18:53:45 +00:00. For more information, read Field Data Types.

• SIGNUP_SOURCE - (String) How the user was created in Iterable (for example, API or IMPORT).

• SUBSCRIBED_MESSAGE_TYPE_IDS - (Array) In accounts or projects with opt-in message types enabled, integers that represent the message types to which a user has subscribed. Users receive messages associated with opt-in message types only if:

  • They have subscribed to those opt-in message types
  • They haven't unsubscribed from the channels associated with those types

  Contact your Iterable Account Team if you have questions.

• TIME_ZONE - (String) The user’s timezone (requires the Enable user IP to location lookup setting in Iterable project settings).

• UNSUBSCRIBED_CHANNEL_IDS - (Array) Integers that represent the message channels from which a user has unsubscribed. Users won’t receive messages from any message type belonging to a message channel from which they’ve unsubscribed.

• UNSUBSCRIBED_MESSAGE_TYPE_IDS - (Array) Integers that represent the opt-out message types from which a user has unsubscribed. Users receive messages from opt-out message types only if:

  • They haven’t unsubscribed from those opt-out message types
  • They haven’t unsubscribed from the channels associated with those types

• USER_ID - (String) ID of a user. This is always a value that you've either assigned or imported from another source. This is different from ITBL_USER_ID, which is a unique identifier that’s used internally by Iterable, and can't be changed. This field and email are the two fields that you can use to identify users in Iterable.

# Additional information sent from Iterable to Snowflake

This project, campaign, and other related information is shared by Iterable with Snowflake.

# Campaigns

• CAMPAIGN_STATE - (String) State of the campaign at the time of query.
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the creation of this campaign.
• CREATOR_USER_ID - (String) Email address of the user who created this campaign (must be a member of the project).
• DEFAULT_TIME_ZONE - (String) Set when a campaign will be scheduled to send with respect to the recipient's time zone.
• ENDED_AT - (Timestamp) UTC timestamp corresponding to the end of this campaign.
• ID - (Integer) ID of the campaign.
• IS_ARCHIVED - (Boolean) Whether or not this campaign is archived at the time of query.
• LABEL_IDS - (Array) IDs for labels associated with this campaign.
• LIST_IDS - (Array) IDs for lists associated with this campaign.
• MESSAGE_MEDIUM - (String) Medium or channel of this campaign.
• NAME - (String) Name of the campaign.
• PROJECT_ID - (Integer) Iterable project ID.
• RECURRING_CAMPAIGN_ID - (String) ID for the parent campaign for a recurring (child) campaign.
• SEND_SIZE - (Integer) Total size of the selected lists.
• START_AT - (Timestamp) UTC timestamp corresponding to the start of this campaign.
• SUPPRESSION_LIST_IDS - (Array) IDs associated with a suppression list within this campaign.
• TEMPLATE_ID - (Integer) ID of the template used for this campaign.
• TYPE - (String) Campaign type (blast or triggered).
• UPDATED_AT - (Timestamp) UTC timestamp corresponding to the last update to this campaign.
• UPDATED_BY - (String) ID of the user who last updated this campaign.
• WORKFLOW_ID - (Integer) ID of the workflow (journey) associated with this campaign (if applicable).

# Campaign labels

• ID - (Integer) Campaign label ID.
• NAME - (String) Name of this campaign label.
• PROJECT_ID - (Integer) ID of the Iterable project associated with this campaign label.
• PROJECT_NAME - (Integer) Name of the Iterable project associated with this campaign label.

# Channels

• CHANNEL_TYPE - (String) Type of channel, either marketing or transactional.
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the creation of this channel.
• CREATOR_USER_ID - (String) Email address of the user who created this channel (must be a member of the project).
• ID - (Integer) ID of this channel.
• MESSAGE_MEDIUM - (String) email, push, sms, WebPush, or InApp.
• NAME - (String) Name of this channel.
• PROJECT_ID - (Integer) ID of the Iterable project associated with this channel.
• UPDATED_AT - (Timestamp) UTC timestamp corresponding to the last update to the channel.

# Experiments

• ATTRIBUTION_PERIOD_HOURS - (Integer) Period of time during which conversions are attributed to an experiment holdout group, if one exists.
• AUTOMATICALLY_SELECT_WINNER - (Boolean) Indicates whether Iterable selects a winning variant automatically after certain conditions are met (true), or whether a user must manually select a winner (false).
• CONTROL_TEMPLATE_ID - (Integer) ID of the template on which variants of this experiment were based.
• CONVERSION_EVENT_TYPE - (Integer) The success metric chosen for the experiment, where Opens is 0, Clicks is 1, Custom Conversion Event is 2, and Purchases is 3.
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the creation of this experiment.
• CREATOR_USER_ID - (String) Email address of the user who created this experiment (must be a member of the project).
• ENDED_AT - (Timestamp) UTC timestamp corresponding to the end of this experiment.
• EVENLY_SPLIT_VARIATIONS - (Boolean) Indicates that this experiment is sent to a subset of users (false), or is sent to the whole user list (true).
• EXPERIMENT_STATE - (String) Status of this experiment, Draft, Running, or Finished.
• EXPLOITATION_STARTED_AT - (Timestamp) UTC timestamp corresponding to when an experiment enters the exploitation phase.
• HAS_HOLD_OUT_GROUP - (Boolean) Indicates whether this experiment has a users who won't receive any variants.
• HOLD_OUT_GROUP_SIZE - (Integer) Percentage of users in a holdout group (blast campaigns only).
• ID - (Integer) ID of this experiment.
• NAME - (String) Name of this experiment.
• PROJECT_ID - (Integer) ID of the Iterable project associated with this experiment.
• STARTED_AT - (Timestamp) UTC timestamp corresponding to the time this experiment was launched.
• TEST_DURATION_MINUTES - (Integer) Number of minutes this experiment is set to run before a winner is selected (blast campaigns only).
• TEST_SENDS_PER_VARIATION - (Integer) Number of sends allocated for each variant of a triggered campaign.
• TEST_SIZE_PERCENTAGE - (Integer) Percentage of messages to test in a blast campaign.
• TEST_SUBJECT - (String) Representation of the element selected for testing in the experiment, for example, Subject line, Preheader text, Send time.
• UPDATED_AT - (Timestamp) UTC timestamp corresponding to the last update to this experiment.
• WINNING_TEMPLATE_ID - (Integer) Template ID associated with the experiment's winning variant, if one's selected.

# Lists

• CREATED_AT - (Timestamp) UTC timestamp corresponding to the creation of this list.
• CREATOR_USER_ID - (String) Email address of the user who created this list (must be a member of the project).
• DESCRIPTION - (String) Details about this list (max 140 characters).
• EMAIL_LIST_TYPE - (String) Type of list. Standard, Dynamic, Suppression, or Internal.
• ID - (Integer) ID of this list.
• NAME - (String) Name of this list.
• PROJECT_ID - (Integer) ID of the Iterable project associated with this list.
• UPDATED_AT - (Timestamp) UTC timestamp corresponding to the last update to the list.

# Message Types

• CHANNEL_ID - (Integer) ID of the message channel associated with this message type.
• CREATED_AT - (Timestamp) UTC timestamp corresponding to the creation of this message type.
• ID - (Integer) ID of this message type.
• NAME - (String) Name of this message type.
• PROJECT_ID - (Integer) ID of the Iterable project associated with this message type.
• RATE_LIMIT_PER_MIN - (Integer) Maximum number of message sends allowed on this message type, per minute.
• SUBSCRIPTION_POLICY - (String) Subscription policy associated with this message type (OptOut or OptIn).
• UPDATED_AT - (Timestamp) UTC timestamp corresponding to the date last updated.

# Projects

• CREATED_AT - (Timestamp) UTC timestamp corresponding to the creation of the project.
• ID - (Integer) ID of this project.
• NAME - (String) Name of this project.
• ORGANIZATION_ID - (Integer) ID of the organization associated with this project.

# Templates

• CACHE_DATA_FEED - (Boolean) Cache data feed lookups for one hour.
• CAMPAIGN_ID - (Integer) ID of the campaign that uses the template.
• CLIENT_TEMPLATE_ID - (String) Used as a secondary key to reference the template.
• CREATED_AT - (Timestamp) UTC timestamp that corresponds to the creation of this template.
• CREATOR_USER_ID - (String) Email address of the user who created this template (must be a member of the project).
• DATA_FEED_IDS - (Array) IDs for data feeds that are used by this template for dynamic template creation.
• EXPERIMENT_ID - (Integer) IDs for experiments that are associated with this template. If no experiments use this template, null.
• FROM_EMAIL - (String) Address provided in the From Email field for this template.
• FROM_NAME - (String) Text provided in the From Name field for this template, and the text recipients will see in their Inbox.
• GOOGLE_ANALYTICS_CAMPAIGN_NAME - (String) Google Analytics utm_campaign value.
• ID - (Integer) Template ID.
• LINK_PARAMS - (Variant) Parameters to append to each URL in contents.
• MERGE_DATA_FEED_CONTEXT - (Boolean) Merge data feed contents into user context, so fields are referenced by curly braces instead of brackets.
• MESSAGE_TYPE_ID - (Integer) ID of the message type associated with the template.
• NAME - (String) Name of this template.
• PLAIN_TEXT - (String) Plain text contents.
• PREHEADER_TEXT - (String) Text provided in the Preheader field of the template.
• PROJECT_ID - (Integer) Iterable project ID associated with this template.
• SUBJECT - (String) Text provided in the Subject field of the template.
• UPDATED_AT - (Timestamp) UTC timestamp corresponding to the last update to the template.
• UPDATED_BY - (String) Email address of the user who last updated this templates.

# Workflows (journeys)

• CREATED_AT - (Timestamp) UTC timestamp corresponding to the creation of the this workflow (journey).
• CREATOR_USER_ID - (String) Email address of the user who created this workflow (journey), must be a member of the project.
• ID - (Integer) ID of this workflow (journey).
• IS_ARCHIVED - (Boolean) Whether or not this workflow (journey) is archived at the time of query.
• NAME - (String) Name of this workflow (journey).
• PROJECT_ID - (Integer) ID of the Iterable project associated with this workflow (journey).
• START_WORKFLOW_NODE_ID - (Integer) ID for the Start tile.
• UPDATED_AT - (Timestamp) UTC timestamp corresponding to the last update to the workflow (journey).
• UPDATED_BY - (String) ID of the user who last updated this workflow (journey).
• WORKFLOW_LIFETIME_LIMIT - (Integer) Indicates that a user can be entered into this Workflow (journey) multiple times, but not necessarily at the same time.
• WORKFLOW_SIMULTANEOUS_LIMIT - (Integer) Indicates that a user can be in this workflow (journey) multiple times, at the same time.

# Frequently Asked Questions (FAQ)

# Does accepting shared data from Iterable increase my Snowflake costs?

This integration uses Snowflake's Secure Data Sharing feature, which shares data rather than copying it. Because of this, the data doesn't affect your Snowflake data storage costs. However, you will have to pay for compute resources you use to query the shared data. See Snowflake's Introduction to Secure Data Sharing.

# How long does it take Iterable data to appear in Snowflake?

Data appears in Snowflake within 24 hours of its creation in Iterable.

# Does Iterable backfill old system event data to Snowflake?

Iterable does not backfill system event data to Snowflake. Sharing starts with data created close to the creation of the share.

# Does this feature copy Iterable data to my Snowflake account?

No. This feature uses Snowflake's Secure Data Sharing feature, which does not copy data. However, you can copy the data if you need to (this may increase your Snowflake costs).

# Does Iterable's integration with Snowflake support GDPR or CCPA?

Yes. To learn how to respond to GDPR and CCPA requests in Iterable, read Responding to GDPR Requests.

# In Snowflake, can I edit the data that Iterable has shared?

No. Data shared via Secure Data Sharing is read-only. To edit the data, you'll need to make a copy of it (which may increase your Snowflake costs).

# If I update a system event in Iterable, does it re-sync to Snowflake?

It's not possible to manually update a system event in Iterable (by making an API call or otherwise).

# Can I control access to my Iterable data in Snowflake?

To control access to shared data in Snowflake, you can use its role-based access controls.