Allow us to retrieve user-level data of Groups
While the "User Group" object holds GSID and descriptions, it lacks user-level detail, so we can't see who's in a group. Also, the "User Group ID" in the "CTA" object has a GSID that doesn't match the "User Group" object's GSID.
This means:
· We can't identify users within a group.
· We can't reliably know which group a CTA was sent to.
To report on this, we need a way to link users to User Groups; a possible approach is a new "User Group Users" object storing User GSIDs and Group GSIDs, providing a connection like this: User Group > User Group Users > Users. We also need to fix the ID mismatch in the CTA's "Pool Id" or add a proper "User Group GSID" field to the CTA object.
Thanks,