The purpose of DIM_AUDIENCE_SERVICE_AUDIENCES is to join to BRG_USER_AUDIENCE, many to 1, to establish the names of audiences (and structures) individual users are a part of
🚨 Audience Managers ID, Audience Managers Permissions, People Managers ID and People Managers Permissions are due to be removed from the database, date TBC
COLUMN NAME | DATA TYPE (FIELD SIZE) | DESCRIPTION | CURRENT AVAILABLE VALUES | EXAMPLE |
|---|---|---|---|---|
Audience ID | VARCHAR(16777216) | Identifier for the audience (user group) | 123a12b3cd4e5f67g890h1ij | |
Audience Managers | VARIANT | A list of users and the specific audience manager permissions they have | [ { "permissions": { "assignments": true, "canViewUserAnalytics": false, "manageContent": true, "manageMembers": true }, "userId": "123a12b3cd4e5f67g890h1ij" } ] | |
🚨Audience Managers ID | VARCHAR(16777216) | User ID of the audience manager | 123a12b3cd4e5f67g890h1ij | |
🚨Audience Managers Permissions | VARCHAR(16777216) | Audience manager permissions | null | |
Audience Name | VARCHAR(16777216) | Name of the audience | Sales North East | |
Audience Type | VARCHAR(16) | Flag to show if the audience is either an audience, direct or indirect | Direct Reports, Audiences, Indirect Reports | Direct Reports |
Content Privacy | VARCHAR(16777216) | Content privacy within the audience | private, public, null | private |
Created At | TIMESTAMP_NTZ(9) | Timestamp of audience creation | 2025-01-01T00:00:00.000+0000 | |
Doc Created At | TIMESTAMP_NTZ(9) | Timestamp inherited from parent snowflake object(s) | 2025-01-01T00:00:00.000+0000 | |
Doc Updated At | TIMESTAMP_NTZ(9) | Timestamp inherited from parent snowflake object(s) | 2025-01-01T00:00:00.000+0000 | |
Document Audience Type | VARCHAR(16777216) | Type of audience | smart, manual, null | smart |
Is Audience | BOOLEAN | Boolean indicator for audience) | TRUE, FALSE, null | TRUE |
Legacy Rules | VARIANT | Checklist of rules to be added to a smart audience. Several requirements can be added, with the assumption that all must be met to be added to an audiences | [ { "_id": "123a12b3cd4e5f67g890h1ij", "accountActive": true, "createdAt": "2025-01-01T00:00:00.000+0000", "criteria": "fact", "name": "fc-user-active" }, { "_id": "123a12b3cd4e5f67g890h1ij", "createdAt": "2025-01-01T00:00:000+0000", "criteria": "datetime", "firstLogin": { "datetime": "2025-01-01T00:00:000+0000", "operator": ">" }, "name": "dc-first-login" } ] | |
People Managers | VARIANT | A list of users and the specific people manager permissions they have | [ { "permissions": { "analyticsAndReports": true, "canManageGoals": true, "canViewComplianceReports": true, "canViewLearnPage": true, "insights": true, "manage": true }, "userId": "123a12b3cd4e5f67g890h1ij" } ] | |
🚨People Managers ID | VARCHAR(16777216) | User ID of the people manager | 123a12b3cd4e5f67g890h1ij | |
🚨People Managers Permissions | VARCHAR(16777216) | People manager permissions | null | |
Should Be Structure | BOOLEAN | Boolean indicator for structure (group of audiences = structure) | TRUE, FALSE, null | FALSE |
Smart Rules | VARIANT | Modern version of legacy rules which allows for and/or logic to be incorporated | { "args": [ { "args": [ { "args": [ { "kind": "str", "val": "status" } ], "kind": "func", "val": "ref" }, { "kind": "str", "vals": [ "new", "active" ] } ], "kind": "func", "name": "fc-user-active", "val": "in" }, { "args": [ { "args": [ { "kind": "str", "val": "firstLogin" } ], "kind": "func", "val": "ref" }, { "kind": "date", "val": "2025-01-01T00:00:00" } ], "kind": "func", "name": "dc-first-login", "val": "gt" } ], "kind": "func", "val": "and" } | |
Structure ID | VARCHAR(16777216) | Identifier for the structure (group of audiences) | 123a12b3cd4e5f67g890h1ij | |
Structure Name | VARCHAR(16777216) | Name of the structure | Sales | |
Structure-Audience Name | VARCHAR(16777216) | Concatenation of the structure and audience names | Sales - Sales North East | |
Tenant ID | VARCHAR(16777216) | Identifier for the tenant | eu-west-2_abcdefGh1 | |
Updated At | TIMESTAMP_NTZ(9) | Timestamp of audience updates | 2025-01-01T00:00:00.000+0000 | |
User Sharing | VARCHAR(16777216) | User sharing information within the audience | audience, null, yes, no | yes |