| EMAILCAMPAIGNDIMID |
int |
|
|
Reference key to the email campaign dimension |
| EMAILMESSAGEDIMID |
int |
|
|
Reference key to the email message dimension |
| CONSTITUENTDIMID |
int |
|
|
Reference key to the constituent dimension |
| CONSTITUENTSYSTEMID |
uniqueidentifier |
|
|
System ID for the constituent |
| EMAILSENDDATE |
datetime |
|
|
Date the email was sent (i.e. when target audience was calculated after the LO admin pushed the "send" button -- not when the email was delivered or opened |
| EMAILSENDDATEDIMID |
int |
|
|
Reference key to the date dimension |
| EMAILSENDTIMEDIMID |
int |
|
|
Reference key to the date dimension |
| RECIPIENTOPEN |
bit |
|
|
Did the recipient open the email? |
| RECIPIENTOPENTIME |
datetime |
yes |
|
When did they open the email? |
| RECIPIENTOPENDATEDIMID |
int |
yes |
|
Reference key to the date dimension |
| RECIPIENTOPENTIMEDIMID |
int |
yes |
|
Reference key to the date dimension |
| RECIPIENTCLICK |
bit |
|
|
Did the recipient click on a link within the email? |
| RECIPIENTCLICKTIME |
datetime |
yes |
|
When did they click on a link? |
| RECIPIENTCLICKDATEDIMID |
int |
yes |
|
Reference key to the date dimension |
| RECIPIENTCLICKTIMEDIMID |
int |
yes |
|
Reference key to the date dimension |
| RECIPIENTACTION |
bit |
yes |
|
Did the recipient take an action (donation, advocacy, etc.) after clicking a link on this email? |
| RECIPIENTACTIONTIME |
datetime |
yes |
|
When did the action take place? |
| RECIPIENTACTIONDATEDIMID |
int |
yes |
|
Reference key to the date dimension |
| RECIPIENTACTIONTIMEDIMID |
int |
yes |
|
Reference key to the date dimension |
| RECIPIENTHARDBOUNCE |
bit |
yes |
|
Did the email bounce for permanent reasons? (e.g. bad email address) |
| RECIPIENTSOFTBOUNCE |
bit |
yes |
|
Did the email bounce for temporary reasons? (e.g. mailbox full) |
| RECIPIENTUNSUBSCRIBE |
bit |
yes |
|
Did the recipient unsubscribe when they received this email? |
| FORWARDEDOPENCOUNT |
int |
yes |
|
If the recipient forwarded the message, how many forwardees clicked on a link in it? |
| FORWARDEDACTIONCOUNT |
int |
yes |
|
If the recipient forwarded the message, how many forwardees took an action (donation, advocacy, created an account, etc)? |
| TOTALCLICKCOUNT |
int |
yes |
|
Total number of click-throughs by recipient or forwardees |
| TOTALOPENCOUNT |
int |
yes |
|
Total number of message opens by recipient or forwardees |
| STATSLASTUPDATED |
datetime |
yes |
|
Time this record was last updated in Luminate Online by processing click-through logging information |
| ISINCLUDED |
bit |
yes |
|
Flag indicating when data should be included in results. |
| ETLCONTROLID |
int |
|
|
ID generated through the ETL process. |
| SOURCEDIMID |
int |
yes |
|
Source system used. |