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 in along the way.
NOTE: This writeback occurs daily.
User-defined table structure
You must create a user-defined table to work with this writeback. See User-Defined Tables to learn the initial steps to create a user-defined table.
IMPORTANT: The user-defined table is required in iMIS in order for these writebacks to properly function. If the writeback feature is activated but the required table does not exist or is incorrectly formatted, the writeback will not be sent until the setup requirements are met.
Below is the table structure for the INFORMZ_CAMPAIGN table.
WARNING: Name the tables and columns (fields) using the exact names and data types indicated below. If the names are not identical, the writeback will fail.
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 |