FACT_EMAILACTIVITY_STAGE
Email sent to constituents through Luminate Online.
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| EMAILCAMPAIGNID | int | The email campaign Id | ||
| MSGID | int | The message Id of the email message | ||
| VARIANTID | int | The variant of the email message | ||
| CONSID | int | The constituent Id in the CRM database | ||
| DELIVERYID | int | The delivery Id for the message | ||
| RECIPIENTOPEN | bit | yes | Did the recipient open the email? | |
| RECIPIENTOPENTIME | datetime | yes | When did they open the email? | |
| RECIPIENTCLICK | bit | yes | Did the recipient click on a link within the email? | |
| RECIPIENTCLICKTIME | datetime | yes | When did they click on a link? | |
| 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? | |
| 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? | |
| FORWARDEDCLICKCOUNT | 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)? | |
| TAFFORWARDCOUNT | int | yes | If the recipient forwarded the message, how many forwardees clicked on a link in it? | |
| TAFFORWARDSSENTCOUNT | int | yes | If the recipient forwarded the message, how many forwardees clicked on a link in it? | |
| 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 | |
| CREATIONDATE | datetime | yes | The date the email activity record was created | |
| QUEUED | bit | yes | Is the message queued? | |
| DOMAIN | nvarchar(255) | yes | The domain of the email address |