Body
|
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 as concise as possible (i.e., exclude UTM information, search data, etc.).
This integrity check identifies LinkedIn social media records that contain extra information in the URL so that the extraneous information at the end of the URL can be removed.
How Is This Done?
This integrity check is run using a SQL Server view called [INTEGRITY_CHECKS].[dbo].[IDS.V-INTEGRITY CHECK-SOCIALMEDIA-Standardize LinkedIn URLs(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.
That view queries LinkedIn records with extraneous information at the end of the URL so that it can be removed; only the root and username are needed (e.g., “https://www.linkedin.com/in/my-name-123?utm_source=share&utm_campaign=share_via&utm_content=profile&utm_medium=ios_app” will be changed to “https://www.linkedin.com/in/my-name-123/”).
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