Mailing Activity writebacks are metrics about subscriber interaction with your mailings. This information is sent from Higher Logic Thrive Marketing Professional (Thrive Marketing Professional) to iMIS and includes statistics about delivery, opens, and non-delivery details.
NOTE: A mailing activity writeback is a snapshot in time, so it's important to allow ample time for your subscribers to interact with the mailing. Higher Logic recommends at least 48 hours.
There are two ways that a writeback can be sent from Thrive Marketing Professional to iMIS:
- Manually, after a mailing is sent, or
- Automatically as part of the mailing creation process.
Initiate a manual writeback
After a mailing has been sent, the writeback can be sent to iMIS.
- Navigate to Mailings > View.
- Navigate to the Sent tab.
- Locate the mailing that you wish to writeback to iMIS.
- Hover over the menu icon and select Send Activity.
- Click Yes to the confirmation to send the writeback.
A message displays indicating that an email will be sent to you once the writeback is complete.
Configure an automatic writeback
If moving mailing activity data into iMIS is part of your standard operating procedure, you can take steps to automate the process.
- Navigate to Admin > System Settings.
- In the Remote Database Information area, check the Send Mailing Activity? box.
- In the Default Activity Transfer menu, select the number of days to wait to send the writeback (we recommend 3 days).
This configuration will automatically set the Activity Transfer slider on the Set Up tab in all future mailings to the same number of days.
NOTE: If this default value is not appropriate for a particular mailing, it can be changed to a different number of days or to Don't Send to disable the writeback for that mailing.
Configure a semi-automatic writeback
If moving mailing activity data into iMIS is done often, but it's not part of your standard operating procedure, you can take steps to partially automate the process.
- Navigate to Admin > System Settings.
- In the Remote Database Information area, check the Send Mailing Activity? box.
- In the Default Activity Transfer menu, select Don't Send.
This configuration displays the Activity Transfer slider on the Set Up tab in the mailing but does NOT specify a number of days. Each time a mailing is created, the author decides whether to send a writeback; if so, they select the number of days to send the writeback to iMIS.
NOTE: In the event that there isn't any activity to write back to iMIS, an email notification will be sent from Thrive Marketing Professional letting you know.
User-defined table structure
You need to 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_MAILINGS 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_MAILINGS table details
Field Name | Prompt | Type | Length |
---|---|---|---|
MAILING_ID | Mailing ID | Int | |
MAILING_NAME | Mailing Name | Char | 255 |
PUBLISH_DATE | Publish Date | DateTime | |
DELIVERED | Delivered | Checkbox | |
OPENED | Opened | Checkbox | |
CLICKED | Clicked | Checkbox |