ContactSegmentData
Retrieve Contact Segment Data. Note: The pseudo column SegmentID must be specified to retrieve the data of this table. This SegmentID can be retrieved from the ContactSegment table's ID column.
Columns
| Name | Type | Description |
| ID [KEY] | Int64 | The unique identifier of the content segment data. |
| AccountName | String | This field is generated dynamically and corresponds to the AccountName field in the API. |
| BouncebackDate | String | This field is generated dynamically and corresponds to the BouncebackDate field in the API. |
| IsBounceback | Boolean | This field is generated dynamically and corresponds to the IsBounceback field in the API. |
| IsSubscribed | Boolean | This field is generated dynamically and corresponds to the IsSubscribed field in the API. |
| SubscriptionDate | Datetime | This field is generated dynamically and corresponds to the SubscriptionDate field in the API. |
| UnsubscriptionDate | Datetime | This field is generated dynamically and corresponds to the UnsubscriptionDate field in the API. |
| CreatedAt | Datetime | This field is generated dynamically and corresponds to the CreatedAt field in the API. |
| CreatedBy | String | This field is generated dynamically and corresponds to the CreatedBy field in the API. |
| AccessedAt | Datetime | This field is generated dynamically and corresponds to the AccessedAt field in the API. |
| CurrentStatus | String | This field is generated dynamically and corresponds to the CurrentStatus field in the API. |
| Depth | String | This field is generated dynamically and corresponds to the Depth field in the API. |
| UpdatedAt | Datetime | This field is generated dynamically and corresponds to the UpdatedAt field in the API. |
| UpdatedBy | String | This field is generated dynamically and corresponds to the UpdatedBy field in the API. |
| Email Address | String | This field is generated dynamically and corresponds to the Email Address field in the API. |
| First Name | String | This field is generated dynamically and corresponds to the First Name field in the API. |
| Last Name | String | This field is generated dynamically and corresponds to the Last Name field in the API. |
| Company | String | This field is generated dynamically and corresponds to the Company field in the API. |
| Email Display Name | String | This field is generated dynamically and corresponds to the Email Display Name field in the API. |
| Address 1 | String | This field is generated dynamically and corresponds to the Address 1 field in the API. |
| Address 2 | String | This field is generated dynamically and corresponds to the Address 2 field in the API. |
| Address 3 | String | This field is generated dynamically and corresponds to the Address 3 field in the API. |
| City | String | This field is generated dynamically and corresponds to the City field in the API. |
| State or Province | String | This field is generated dynamically and corresponds to the State or Province field in the API. |
| Zip or Postal Code | String | This field is generated dynamically and corresponds to the Zip or Postal Code field in the API. |
| Country | String | This field is generated dynamically and corresponds to the Country field in the API. |
| Business Phone | String | This field is generated dynamically and corresponds to the Business Phone field in the API. |
| Mobile Phone | String | This field is generated dynamically and corresponds to the Mobile Phone field in the API. |
| Fax | String | This field is generated dynamically and corresponds to the Fax field in the API. |
| Title | String | This field is generated dynamically and corresponds to the Title field in the API. |
| Salutation | String | This field is generated dynamically and corresponds to the Salutation field in the API. |
| Salesperson | String | This field is generated dynamically and corresponds to the Salesperson field in the API. |
| SFDC Contact ID | String | This field is generated dynamically and corresponds to the SFDC Contact ID field in the API. |
| SFDC Lead ID | String | This field is generated dynamically and corresponds to the SFDC Lead ID field in the API. |
| Date Created | Datetime | This field is generated dynamically and corresponds to the Date Created field in the API. |
| Date Modified | Datetime | This field is generated dynamically and corresponds to the Date Modified field in the API. |
| Eloqua Contact ID | String | This field is generated dynamically and corresponds to the Eloqua Contact ID field in the API. |
| SFDC Account ID | String | This field is generated dynamically and corresponds to the SFDC Account ID field in the API. |
| Last Modified by CRM System | Datetime | This field is generated dynamically and corresponds to the Last Modified by CRM System field in the API. |
| Last SFDC Campaign ID | String | This field is generated dynamically and corresponds to the Last SFDC Campaign ID field in the API. |
| Last SFDC Campaign Status | String | This field is generated dynamically and corresponds to the Last SFDC Campaign Status field in the API. |
| Company Revenue | String | This field is generated dynamically and corresponds to the Company Revenue field in the API. |
| SFDC Email Opt Out | String | This field is generated dynamically and corresponds to the SFDC Email Opt Out field in the API. |
| Lead Source - Most Recent | String | This field is generated dynamically and corresponds to the Lead Source - Most Recent field in the API. |
| Lead Source - Original | String | This field is generated dynamically and corresponds to the Lead Source - Original field in the API. |
| Industry | String | This field is generated dynamically and corresponds to the Industry field in the API. |
| Annual Revenue | String | This field is generated dynamically and corresponds to the Annual Revenue field in the API. |
| Lead Status | String | This field is generated dynamically and corresponds to the Lead Status field in the API. |
| Job Role | String | This field is generated dynamically and corresponds to the Job Role field in the API. |
| Lead Score - High Value Website Content | Double | This field is generated dynamically and corresponds to the Lead Score - High Value Website Content field in the API. |
| Lead Score Date - Engagement - Most Recent | Datetime | This field is generated dynamically and corresponds to the Lead Score Date - Engagement - Most Recent field in the API. |
| Integrated Marketing and Sales Funnel Stage | String | This field is generated dynamically and corresponds to the Integrated Marketing and Sales Funnel Stage field in the API. |
| Product/Solution of Interest | String | This field is generated dynamically and corresponds to the Product/Solution of Interest field in the API. |
| Region | String | This field is generated dynamically and corresponds to the Region field in the API. |
| PURL Name (Default Hypersite) | String | This field is generated dynamically and corresponds to the PURL Name (Default Hypersite) field in the API. |
| Lead Rating - Combined | String | This field is generated dynamically and corresponds to the Lead Rating - Combined field in the API. |
| Email Address Domain | String | This field is generated dynamically and corresponds to the Email Address Domain field in the API. |
| First and Last Name | String | This field is generated dynamically and corresponds to the First and Last Name field in the API. |
| Company Size | String | This field is generated dynamically and corresponds to the Company Size field in the API. |
| Lead Score - Last High Touch Event Date | Datetime | This field is generated dynamically and corresponds to the Lead Score - Last High Touch Event Date field in the API. |
| Lead Rating - Profile (Explicit) | String | This field is generated dynamically and corresponds to the Lead Rating - Profile (Explicit) field in the API. |
| Lead Rating - Engagement (Implicit) | String | This field is generated dynamically and corresponds to the Lead Rating - Engagement (Implicit) field in the API. |
| Lead Score - Profile (Explicit) | Double | This field is generated dynamically and corresponds to the Lead Score - Profile (Explicit) field in the API. |
| Lead Score - Engagement (Implicit) | Double | This field is generated dynamically and corresponds to the Lead Score - Engagement (Implicit) field in the API. |
| Lead Score Date - Profile - Most Recent | Datetime | This field is generated dynamically and corresponds to the Lead Score Date - Profile - Most Recent field in the API. |
| Employees | Double | This field is generated dynamically and corresponds to the Employees field in the API. |
| Territory | String | This field is generated dynamically and corresponds to the Territory field in the API. |
| Lead Score | String | This field is generated dynamically and corresponds to the Lead Score field in the API. |
| PURL Name | String | This field is generated dynamically and corresponds to the PURL Name field in the API. |
| MD5 Hashed Email Address | String | This field is generated dynamically and corresponds to the MD5 Hashed Email Address field in the API. |
| SHA256 Hashed Email Address | String | This field is generated dynamically and corresponds to the SHA256 Hashed Email Address field in the API. |
| MD5 Hashed Business Phone | String | This field is generated dynamically and corresponds to the MD5 Hashed Business Phone field in the API. |
| SHA256 Hashed Business Phone | String | This field is generated dynamically and corresponds to the SHA256 Hashed Business Phone field in the API. |
| MD5 Hashed Mobile Phone | String | This field is generated dynamically and corresponds to the MD5 Hashed Mobile Phone field in the API. |
| SHA256 Hashed Mobile Phone | String | This field is generated dynamically and corresponds to the SHA256 Hashed Mobile Phone field in the API. |
| onlineInsertTest | String | This field is generated dynamically and corresponds to the onlineInsertTest field in the API. |
| Survey Initial Meeting Date & Time | Datetime | This field is generated dynamically and corresponds to the Survey Initial Meeting Date & Time field in the API. |
| TestColumn1 | String | This field is generated dynamically and corresponds to the TestColumn1 field in the API. |
| TestColumn2 | String | This field is generated dynamically and corresponds to the TestColumn2 field in the API. |
| TestColumn3 | String | This field is generated dynamically and corresponds to the TestColumn3 field in the API. |
| TestColumn4 | String | This field is generated dynamically and corresponds to the TestColumn4 field in the API. |
| TestColumn5 | String | This field is generated dynamically and corresponds to the TestColumn5 field in the API. |