Following client requests, we have added one new Table option and three further data points to the previously-existing five table options in the Data Warehouse.
The new table is called EmailAnalytics and it contains the fields as follows:
|
Field Name
|
Content
|
|---|
|
EmailAnalyticsId
|
Unique ID. Not used as a Table link
|
|
EmailHistoryId
|
Link to other Tables
|
|
EmailAddress
|
Address of the contact receiving the email
|
|
EmailOpenedDate
|
Date on which the email was opened
|
|
EmailForwardedDate
|
Date on which the email was forwarded
|
|
EmailPrintedDate
|
Date on which the email was printed
|
|
Client
|
Email client used to open the email. e.g. Microsoft Outlook
|
|
ClientType
|
Specific client type e.g. Outlook
|
|
Version
|
Version of email client type e.g. Outlook 2010
|
In addition, we have added the following new columns to the existing tables listed below:
|
Client Request
|
New Column Added
|
Table Affected
|
Details
|
|---|
|
Mailing List Size
|
TotalContactCount
|
dbo.MailingActivity
|
|
|
Engagement Status
|
EngagementStatus
|
dbo.Contacts
|
ActiveEngaged = 1,
ActiveManuallyWhitelistedByEmail = 2, ActiveManuallyWhitelistedByDomain = 3, InactiveNotEngaged = 4
|
|
External System ID
|
ExternalSystemID
|
dbo.Contacts
|
|
There is no new or additional configuration required, and there is no downtime whilst this is applied. Clients who take the Data Warehouse from Vuture will see the new columns appear in their existing tables as soon as the update is applied.
