|
Category: Social Media
|
Frequency: Monthly
|
Platform: SQL Server
|
Owner: IDS
|
What Does It Do?
The OUD-DS3 best practice is for only one copy of any piece of contact information to be active on a constituent’s record.
This integrity check identifies LinkedIn social media records that appear multiple times on a constituent’s record so that duplicated records can be deleted.
How Is This Done?
This integrity check is run using a SQL Server view called [INTEGRITY_CHECKS].[dbo].[IDS.V-INTEGRITY CHECK-SOCIALMEDIA-Deduplicate LinkedIns(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.
That view queries LinkedIn records that appear multiple times on a constituent record; the URL is standardized before this comparison is done, so “http://linkedin.com/in/my-name” will show as a duplicate of “https://www.linkedin.com/in/my-name/”. The records are prioritized so that the best one is kept: a record with an associated contact name is prioritized first, then the record that was added to DART first is prioritized.
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