Salesforce Marketing Cloud Data Views: Synchronized Data Extensions – User_Salesforce

Salesforce Marketing Cloud (SFMC) offers powerful Data Views and Synchronized Data Extensions (SDEs) that allow marketers to access and leverage CRM data for targeted, personalized, and data-driven campaigns. One such SDE is User_Salesforce, which stores data from the Salesforce User object. This blog explains each data field in the User_Salesforce SDE, its benefits, use cases, and real-world query examples.

What is User_Salesforce Data View?

The User_Salesforce Data Extension is a Synchronized Data Extension that pulls user records from the Salesforce CRM User object into SFMC. These records typically include employees, system users, or internal stakeholders who create or manage records within the Salesforce environment.

Key Benefits of User_Salesforce SDE

Visibility into Data Origin: Track who created or modified leads, contacts, or other records.
Enhanced Reporting: Attribute actions and ownership to specific users.
Campaign Targeting: Filter and group data by internal user responsibilities.
Cross-Team Collaboration: Enables coordination between Marketing and Sales teams.

Common Fields in User_Salesforce Data View & Their Uses

Field	Type	Description & Use Case
_ContactKey	Text(254)	Unique identifier for the user in SFMC. Helps identify associated users.
Email	Email(80)	User’s email address. Can be used for internal notifications or routing.
FirstName	Text(40)	First name of the user. Useful for personalization in internal alerts.
LastName	Text(80)	Last name of the user. Helps identify users across business functions.
IsActive	Boolean	Indicates whether the user is currently active. Useful for filtering current users.
UserRoleId	Text(18)	ID of the user’s assigned role. Can be used for role-based reporting.
CreatedDate	DateTime	The date the user record was created. Useful for tracking onboarding.
LastLoginDate	DateTime	The last login timestamp. Useful for identifying engaged users.

When and Why to Use User_Salesforce Data View?

When to Use?

To track who created or modified Salesforce records.
For internal alerting or workflows based on record ownership.
To segment CRM data by User Role or Activity.
To monitor User login activity and engagement with the platform.

Why Use It?

Improve internal communication by targeting users with specific roles.
Analyze performance by connecting marketing outcomes to user activity.
Increase data governance by knowing who owns and updates CRM data.

10 Example Scenarios and Queries

1. Retrieve All Active Users

SELECT _ContactKey, FirstName, LastName, Email 
FROM User_Salesforce 
WHERE IsActive = 'true'

Use Case: Create a list of active users for internal campaigns or system updates.

2. Identify Inactive Users

SELECT _ContactKey, FirstName, LastName 
FROM User_Salesforce 
WHERE IsActive = 'false'

Use Case: Clean up or review inactive users for security purposes.

3. Users by Role ID

SELECT _ContactKey, FirstName, LastName, UserRoleId 
FROM User_Salesforce 
WHERE UserRoleId = '00EXXXXXXXX1234'

Use Case: Segment internal reports by user roles.

4. Recently Created Users

SELECT _ContactKey, FirstName, LastName, CreatedDate 
FROM User_Salesforce 
WHERE CreatedDate > DATEADD(DAY, -30, GETDATE())

Use Case: Target onboarding resources or communications.

5. Users Who Have Not Logged In Recently

SELECT _ContactKey, FirstName, LastName, LastLoginDate 
FROM User_Salesforce 
WHERE LastLoginDate < DATEADD(DAY, -90, GETDATE())

Use Case: Identify disengaged users for follow-up.

6. Retrieve All Users for a Team Notification

SELECT _ContactKey, Email 
FROM User_Salesforce 
WHERE IsActive = 'true'

Use Case: Notify active users of an internal process update.

7. Identify User Record Creators for New Leads

SELECT u.FirstName, u.LastName, u.Email, l.Id AS LeadId 
FROM User_Salesforce u 
JOIN Lead_Salesforce l 
ON u._ContactKey = l.CreatedById

Use Case: Attribute new lead creation to specific users.

8. Group Users by Last Login Activity

SELECT FirstName, LastName, LastLoginDate 
FROM User_Salesforce 
ORDER BY LastLoginDate DESC

Use Case: Generate engagement reports based on activity.

9. Match Users with Specific Record Ownership

SELECT u.FirstName, u.LastName, c.Email 
FROM User_Salesforce u 
JOIN Contact_Salesforce c 
ON u._ContactKey = c.CreatedById

Use Case: Link contact creation to CRM users.

10. Complete User Info for Reporting

SELECT _ContactKey, FirstName, LastName, Email, UserRoleId, LastLoginDate 
FROM User_Salesforce 
WHERE IsActive = 'true'

Use Case: Build a dashboard or report with complete user details.

Conclusion

The User_Salesforce Data View is a valuable resource within SFMC for leveraging internal Salesforce user data. Whether you need to track user behavior, manage access, or personalize internal communications, this SDE provides the transparency and structure needed for effective marketing operations.

By using this Data View alongside others like Lead_Salesforce or Contact_Salesforce, you can build more intelligent, targeted, and compliant marketing strategies.