Campaigns allow you to send mailings in a sequence based on your subscribers' interactions with those mailings. When you want to learn more about those interactions, you can view data in iMIS via the campaign writeback. This will write back everyone who is in a campaign and note every step they are along the way.
NOTE: This writeback occurs daily.
User-Defined Table Structure
You need to create a user-defined table to work with this writeback. Below is the table structure for the INFORMZ_CAMPAIGN table. See User-Defined Tables to learn the initial steps to create a user-defined table.
WARNING: Make sure to name the tables and columns (fields) using the exact names and data types as specified below. If the names are not identical, the transfers cannot be performed properly.
View INFORMZ_CAMPAIGN Table Details
| Field Name | Prompt | Type | Length |
|---|---|---|---|
| CAMPAIGN_ID | Campaign ID | Int | |
| CAMPAIGN_NAME | Campaign Name | Char | 200 |
| CAMPAIGN_STEP_ID | Campaign Step ID | Int | |
| CAMPAIGN_STEP_NAME | Campaign Step Name | Char | 255 |
| CAMPAIGN_STEP_TYPE | Campaign Step Type | Char | 255 |
| CAMPAIGN_SUBSCRIBER_ID | Campaign Subscriber ID | Int | |
| STEP_START_DATE | Step Start Date | DateTime | |
| CAMPAIGN_START_DATE | Campaign Start Date | DateTime | |
| CAMPAIGN_GOAL_DATE | Campaign Goal Date | DateTime |