|
Category: Social Media
|
Frequency: Monthly
|
Platform: SQL Server
|
Owner: IDS
|
What Does It Do?
The OUD-DS3 best practice is for active individual constituent social media records to be of type ‘Personal’.
This integrity check identifies LinkedIn social media records that are missing a type so that the Personal type can be added.
How Is This Done?
This integrity check is run using a SQL Server view called [INTEGRITY_CHECKS].[dbo].[IDS.V-INTEGRITY CHECK-SOCIALMEDIA-Add Missing Account Types to LinkedIns(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.
That view queries LinkedIn records that do not have a type so that the value ‘Personal’ can be added.
Resources and References
DART Linkedin URL Best Practices and Audits - OUD, Integrated Data Services
S:\IDS\MES\SQL Scripts\DATA QUALITY\SOCIAL MEDIA
Snapshot GUID: BBDW.USR_DM_CNST_SOCIAL_MEDIA_ACCT.USR_CNST_SOCIAL_MEDIA_ACCT_SYS_KEY