Group
Fields
- Id
-
integer
- A system-generated unique identifier for this Group
- Name
-
string
- A descriptive name assigned to the Group by the system
administrator when it was created
- TypeId
-
integer
- References the system-generated value identifying the
Group Type for this Group
- QueryId
-
integer
- References the system-generated value identifying the
Query used to populate this Group
- LastBuildTime
-
dateTime
- Timestamp of when the group was last rebuilt from
the referenced Query in QueryId
- GroupMode
-
integer
- A numeric code representing the type of group this is.
0 = static. 1 = static (query driven), 2 = dynamic, re-buildable (query driven)
3 = marketing group (deprecated), 4 = temporary group (will be deleted during nightly
database task), 5 = virtual group
- SecurityCategoryId
-
nonNegativeInteger
- References a system-generated value
identifying the Security Category, controlling which constituents can see the
record
- CreationDate
-
dateTime
- Timestamp indicating when the record was created
- CreatedBy
-
nonNegativeInteger
- Constituent who created the record
- ModifyDate
-
dateTime
- Timestamp indicating when the record was last
changed
- LastChangeBy
-
nonNegativeInteger
- Constituent who last modified the record
- TotalCount
-
integer
- The number of users in this group
- ActiveCount
-
integer
- The number of active users in the group
- UsableCount
-
integer
- The number of users with valid email
- HardBounceCount
-
integer
- The number of users with an email status of Hard Bounce
- SoftBounceCount
-
integer
- The number of users with an email status of Soft Bounce
- OptedOutCount
-
integer
- The number of users who opted out of email
- DeceasedCount
-
integer
- The number of deceased users in this group
- NoEmailAddressCount
-
integer
- The number of users with no email
- StatsLastUpdated
-
dateTime
- Timestamp of when the stats were last updated for this group.
This indicates when the above counts are valid until.