Synchronised Data Extension Vs Data Extension Vs Salesforce Data Extensions

Synchronised Data Extension Vs Data Extension

Data extension

Data extension is like a table with different columns that can hold data in rows. You could use this data extension to store Subscriber information or related information that will be used for sending emails. You have to mark it as Sendable in order to send emails from Data extensions.

Syncrhonized Data extension

This data extension is mainly used to populate Salesforce Standard/custom object data from Sales cloud/service cloud into Marketing cloud. We should integrate Salescloud with Marketing cloud using Marketing cloud connect before creating Syncrhonized Data extension.

Salesforce Data Extensions in Marketing Cloud Connect

A data extension is a table that contains your data. With Marketing Cloud Connect, push tracking data from the Marketing Cloud back to your Sales or Service Cloud orgs using Salesforce data extensions (SFDEs). Push any tracking data for emails sent to SFDE audiences using Marketing Cloud Salesforce Sends to the Salesforce Contact or Lead record in the connected org. SFDEs can use the same Marketing Cloud segmentation and filtering tools as standard data extensions.

Comments

File Drop Automation

There are two different ‘types’ of automations you can make inside of Automation Studio. They are the Scheduled Automation and the File Drop Automation . These automations trigger when a file is dropped in a FTP location. File Drop Automation includes below options - Use File name pattern Similar to LIKE in SQL, the file name pattern looks for string in the file name. Eg. '%abc%' No File name pattern If you set it to run on all files (no filename pattern), this will ‘lock’ that folder and will not allow any other file automations to select this folder. It is not recommended to use the Import or Export folders for this activity, but to instead create custom subdirectories for these automations.

Send Classification, Sender Profile and Delivery Profile Difference

Send classifications include these components: Delivery Profile Sender Profile You create the delivery profile and sender profile separately before you create the send classification. Sender Profile A sender profile within Marketing Cloud Setup specifies the From information for a send in a central location. Marketing Cloud Email reuses that information across multiple sends without requiring selection each time. The sender profile contains the name and address that the message appears to be from in the subscriber's email client. Delivery Profile A delivery profile within Marketing Cloud Setup specifies the delivery information for a message in a central location. Marketing Cloud reuses the information, across multiple sends, without requiring selection of the information each time. When you create a delivery profile, specify the IP address to use. If you do not use a private domain, you select the account default. If you use one or more private domains, you can select the privat...

Data Views in SFMC

Data Views in Salesforce Marketing Cloud (SFMC) are system-generated, read-only data tables that store up to six months of tracking and subscriber data (sends, opens, clicks, bounces). They are accessed via SQL Query Activities in Automation Studio to segment, analyze, and report on campaign performance. Key Data Views to Know _Sent : Records every email sent, including JobID and SubscriberID. _Open : Tracks when a subscriber opens an email. _Click : Contains data on link clicks within emails. _Bounce : Lists hard and soft bounces. _Subscribers : Provides subscriber status (Active, Unsubscribed). _Journey : Details Journey Builder activity. _BusinessUnitUnsubscribes : How to Use Data Views Create a Data Extension to hold the query results. Create a SQL Query Activity in Automation Studio. Write the SQL selecting fields from the Data View (e.g., SELECT * FROM _Sent ). Run the query to populat...

Hello SFMC

Search This Blog